Prerequisites
An approved robot that has extracted data
A Google account
Optional: a Google sheet where you want the data to go (i.e. the target Google Sheet)
Note: you can sync the data you've captured to an existing Google Sheet or create a new Google Sheet when you set up this integration.
How to set up the Google Sheets integration
Select your Robot from the dashboard, then click on the Integrate tab.
Click on Google Sheets.
Click Enable Syncing to Google Sheet.
Under Choose authorized account, click on Authorize new account and add the Google Account.
Select where you want the data to sync. You can either select:
An existing spreadsheet from your Google Drive or,
Create a new spreadsheet.
Note: in order to sync to an existing Google Sheet you'll need to ensure the account you selected has Edit access to the target Google Sheet.
Choose which data you'd like to sync to your Google sheet.
Changed or added data
Only changed data
Only added data
Run your task on the Overview tab to start syncing. Make sure the extracted texts appear in your Google Sheet in a new tab.
Every time you run your task or it runs to do a monitoring check, it will append the newly captured data to your Google sheet.
NOTE: If you opt to create a new robot and select the existing integrated Google sheet as the integration option for your new robot, the information for your new robot will appear on a fresh worksheet in the same Google sheet.
Combining data from multiple robots into a single worksheet
Want to see data from multiple robots in one worksheet? You can use Google Sheets formulas to combine data from different tabs.
I can't remember which Google Sheet I've connected with my robot.
You can quickly get to the Google Sheet that's connected to your robot, from the Integrate tab.
