This integration allows you to connect and pull data from Google Sheets into your data notebooks.
In this guide:
To connect Google Sheets with your data notebooks you need to have the following:
- Authorization to use your Google spreadsheets
- Intersect account and owner access level
Connecting Google Sheets
You can add your Google Sheets integration from the Dashboard > Integrations > Add integrations > Add Google Sheets section.
One-click on the Google Sheets box and the connection portal will open. To authorize the connection with your Google Sheet account click on the "Authorise Intersect Labs". Then, you'll see a new window where you will be asked to Sign in with your desired Google account.
If the authorization is successful, you should be able to see your new Google Sheet integration in your Integrations page.
Pull from Google Sheets
Open your data app where you wish to pull data from your newly connected Google Sheets integration. Then, you can add a Google Sheet step from Import data > Google Sheets > Read from Google Sheets (Add).
Once you select the integration, a new “Read from Google Sheets” step will be added to your data app. To successfully pull data you will need to select your previously set Google Account from the first dropdown (in our case is: firstname.lastname@example.org's Google Drive).
Then, to pull from the right spreadsheet, you will click on the "Choose Google Spreadsheet" button, which will lead you to a new prompt where you will be able to select your spreadsheet file from your Google Drive.
After you fill all fields, you can add your step. If the step is successfully configured you will see an output with your sourced table.
If you wish to preview the table you can expand the Output step, which will preview the table that was sourced.