How can I use the Google Sheets addon?

Browse AI for Sheets lets you run up to 1,000 tasks for rows in your Google Sheets with a couple of clicks.

Browse AI Google Sheet Add-on lets you run your robots with your spreadsheet rows as inputs without using an API or running them manually. It is also an alternative to the Bulk Run feature which, for example, lets you extract data from detail pages associated with list items.

Example Use Case

Let's imagine that you want to create a robot to extract the newest and shiniest software products from ProductHunt. Your robot takes “Search Keyword” and “Max Products” as input and extracts products related to that specific search keyword.

With the Google Sheets add-on, you can create a Google Sheet with 2 columns for your robot input parameters ("Search Keyword" and "Max Products") and run tasks to scrape all of them at once.

Browse AI for Sheets is a Google Sheets add-on published on Google Workspace Marketplace. It can be downloaded by clicking the button below:

Demo Video:

 

 

Step-by-step instructions to get started with Browse AI Google Sheets Add-on

  1. Go to Google Workspace Marketplace to install Browse AI for Sheets add-on.
  2. Click the Install button to install the add-on on your Google account.
  3. Once you have installed it, open a Google Sheet to start. 
  4. Click on Extensions in the top menu, Select Browse AI for Sheets, and click on Login.
    Screen Shot 2022-07-14 at 5.53.19 PM
  5. After clicking on Login, click on Authorize.
  6. A new window will open, and you’ll be asked to grant the add-on access to your Browse AI account, as the image shows below. Click on Accept to proceed.Screen Shot 2022-07-14 at 5.55.54 PM
  7. A small window will show you that you’re authorized and logged in. 
  8. Once the login and installation process is successful, open the robot on your Browse AI dashboard. On the “Run” tab, you will see all the input parameters. Notice the names of each parameter. 
    Screen Shot 2022-07-14 at 6.01.05 PM
  9. In your newly created Google Sheet, create columns based on the parameters you obtained from your Browse AI dashboard. Your Google Sheet should look like this:Screen Shot 2022-07-14 at 6.03.43 PM
  10. Now enter your desired inputs as new rows under your columns and select the rows you want the robot to run tasks for. Just highlight them with your mouse. 
    Screen Shot 2022-07-14 at 6.10.31 PM
  11. Click on Extensions from top bar, then Browse AI for Sheets, then click on your robot (the exact one we chose in the previous steps).
  12. Congratulations! You will get a success message, and your robot will run a task for each selected row. Screen Shot 2022-07-14 at 6.12.28 PM
  13. If you head to your Robot's History tab in your Browse AI dashboard, you can see the tasks running or already finished.
    Screen Shot 2022-07-14 at 6.13.47 PM
  14. Last, an optional step you can take is to integrate your robot with the same Google Sheet so that whenever it extracts data, it adds the data to another tab in the same Google Sheet. This way, all your inputs and outputs will be in the same spreadsheet in one place. For that, you just need to go to the robot's Integrate tab, pick Google Sheets, and choose the same spreadsheet as the one you used the add-on on.