User guidesDeveloper platformLatest updatesSlack Community
User guides

Google Spreadsheets

Use Dust assistants directly within your Google Spreadsheets

Suggest Edits

📘

Beta Disclaimer: This integration is currently in beta.

Features and functionality are subject to change as we continue to improve the product based on user feedback and testing.

1. Introduction

The Dust Assistant for Google Spreadsheets is an App Script that allows users to interact with a Dust AI assistant directly from their Google Spreadsheet. This integration brings the power of Dust's AI capabilities to your spreadsheet workflows, enabling more efficient data analysis and task automation.

Note: The App Script needs to be manually added to each spreadsheet where you want to use the Dust Assistant

2. How to Add the App Script to Your Google Spreadsheet

To add the Dust Assistant App Script to your Google Spreadsheet, follow these steps:

  1. Open your Google Spreadsheet.
  2. Click on the "Extensions" menu at the top of the page.
  3. Select "Apps Script" from the dropdown menu.
  4. In the Apps Script editor, click on "Add a file" (usually a plus icon).
  5. Choose "Script" from the options.
  6. Name the file "dust" (or any name you prefer).
  7. Replace all the content in the placeholder script with the provided script from the dust-app-script.js file.
  8. Save the script.

3. Setup

Before using the script for the first time, you need to configure your Dust credentials:

  1. Click on the new "Dust" menu item at the top of your spreadsheet
  2. Select "Setup"
  3. Enter your:
    1. Dust Workspace ID
    2. Dust API Key

To obtain the necessary values:

1. Workspace ID:

2. API Key:

  • Log in to your Dust account as an admin or a builder.
  • Navigate to Build > Developer Tools > API Keys.
  • Click on "Create an API Key" to generate a new key.

Note: The API Key needs to be generated by an admin or a builder.


4. Using the Dust Assistant in Your Spreadsheet

Once you've set up the App Script and configured it with your Workspace ID and API Key, you can start using the Dust Assistant directly in your spreadsheet. The general steps for calling a Dust Assistant are:

  1. Select the cells you want to process
  2. Click Dust > Call an Assistant
  3. In the sidebar that appears
    1. Select your Dust assistant
    2. Verify the input cell range (or use the "Use Selection" button)
    3. Specify the target column where results should appear (e.g, 'B')
    4. Optionally add specific instructions
  4. Click "Process"

Here's an example of how you might use it:

Example: Market Analysis Assistant

Let's say you have a Dust Assistant named "MarketGuru" that specializes in market analysis. You can use it to analyze data in your spreadsheet:

  1. In cells A1-A10, you have a list of product names.
  2. In cells B1-B10, you want to get a brief market analysis for each product.
  3. You would select cells A1-A10
  4. Click Dust > Call an Assistant
  5. Select "MarketGuru" as an Assistant
  6. Specify "B" as the target column
  7. Add your instructions - ex: "Provide a brief market analysis for this product, including current trends and potential growth opportunities"
  8. Click "Process"

This would prompt MarketGuru to analyze the product names in A1-A10 and provide insights in B1- B10.

The assistant might respond with something like:

"Based on current market trends, [Product Name] shows strong potential for growth. Recent consumer behavior indicates increasing demand in this sector, particularly among millennials. Key opportunities include expanding into e-commerce channels and developing eco-friendly variants to capture the growing sustainability-conscious market segment."

Remember, you can customize the prompt and assistant name based on your specific needs and the assistants you've set up in your Dust workspace.

5. Limitations

Please be aware of the following limitations when using the Dust Assistant in Google Spreadsheets:

  1. Response Time: The assistant must respond within 30 seconds, or the spreadsheet will return an error. Ensure your queries are concise and specific to avoid timeouts.
  2. Daily Message Limit: Each interaction with a Dust Assistant counts towards the daily message limit of 100 messages per user per day. For example, if your workspace has 100 users, your total daily capacity is 10,000 messages (100 users * 100 messages).

Example: If your workspace has 100 users, you have a total capacity of 100 * 100 = 10,000 messages per day.

By keeping these limitations in mind, you can optimize your use of the Dust Assistant in Google Spreadsheets and ensure a smooth experience for all users in your workspace.

Updated 19 days ago