Skip to main content
The fastest way to connect Google Sheets is with Fi. Say “Create a Google Sheets integration”. See the video tutorial below.

Quick setup with Fi

You can set up Google Sheets in under a minute using Fi. Just ask Fi to connect your Google Sheets account and it will guide you through the OAuth process.

Manual setup

For manual setup, follow the steps below.
1
Go to this link to add Google Sheets.
2
Configure your integration with the following fields:
Google Sheets integration configuration
FieldRequiredDescription
NameYesA name for your integration
Sheet IDYesThe ID of your Google Sheet (found in the sheet’s URL)
Key PropertiesNoFields to use as unique identifiers
Child Sheet NameNoSpecific tab within the spreadsheet
Stream NameNoCustom name for the data stream
Destination IntegrationYesWhere to send the extracted data
Dest SchemaYesThe destination schema for your data
Cron ScheduleYesHow often to sync the data
Partition FieldsNoFields to partition the data by
3
Click Authorize and sign in with your Google account to grant access.

Querying Google Sheets

Once connected, you can query your Google Sheets data using SQL. See Google Sheet Querying for details on how to use DuckDB to query your sheets.