Overview
The Google Sheets connector syncs your spreadsheet data into analytics-ready tables in your data warehouse. Pull spreadsheets, sheets, and values from the Google Sheets API, with Ingest handling auth, pagination, and retries so the tables stay current.
What you can sync
Ingest syncs the following Google Sheets data into your data warehouse, each as its own table refreshed on your schedule:
- Spreadsheets
- Sheets
- Values
Authentication
OAuth2
Enable the Sheets API in Google Cloud Console and create an OAuth2 Client ID for user-authorized access.
You enter credentials in a secure form, never in chat. Ingest stores and rotates them for you.
Resources
Google Sheets API docs ↗
Official provider documentation.
Authentication
How Ingest stores and rotates credentials.
Request access
Tell us you want this connector and we will get you set up.
Don't see the endpoint you need? Tell us and we will add it.