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
After you configure your Google Sheet integration, you can import your spreadsheet data into your notebook. To do that, click 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 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.
After you fill in all the 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.