An integral part of a data notebook is identifying the data that needs to go through your workflow. However, your data can be stored in many places - local CSV files, PostgreSQL database, Amazon Redshift warehouse, Shopify store, and more. To make it easy to import your data, Intersect supports native integrations with commonly used tools and platforms. The list is constantly updated, and new options are added weekly to help companies streamline their data operations.
In this guide:
- Connecting integrations
- Using integrations
- Sample integration
- Connecting Google Sheets
- Pulling data from Google Sheets
To connect an integration, you'll need to navigate to the Integrations page, from Dashboard > Integrations > Add integrations > Integrations page.
After clicking on a particular integration, you will be taken to a portal where you will be prompted to fill in several required fields. These fields are specific to each integration, but the detailed integration documentation includes step-by-step guides on how to link them together.
To use your integrations, you’ll first need to create a data notebook. Then, you can add your integration by clicking on the “Import data” block.
After you select the integration, a specific data block to that integration will show in your data app. By filling in the right properties, you will be able to pull data. You can find guides on how to pull data from each of the integrations on the Integrations page.
To understand how integrations are set up and used in Intersect, we’ll show you a sample example where we integrate Google Sheets. However, you can always check the full documentation on the Integrations page.
Connecting Google Sheets
You can add your Google Sheet 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 on your Integrations page.
Pulling data from Google Sheets
To use your integration, you’ll need to create a new data notebook, and add an Import Data Block.
To start pulling data from our previously set Google Sheets integration, click on the Import Data Block then add the Read from Google Sheets block.
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.