Connect Google Sheets data with any data source.

Write data from any Airbyte source to Google Sheets on your schedule.

Load data into Google Sheets Read the docs

Sources: 590+
Standard support: 0.3.5

Overview

What is the Airbyte Google Sheets connector?

The Airbyte Google Sheets connector loads data from 590+ Airbyte sources into Google Sheets, with full refresh and incremental sync on a schedule you control.

01
Load from any source
Move data into Google Sheets from 590+ Airbyte sources on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
Cloud or self-hosted
Run the Google Sheets connector on Cloud, OSS, Hybrid.

Setup

Live in twelve steps

Select Google Sheets from the Source type dropdown and enter a name for this connector.
Select Sign in with Google.
Log in and Authorize to the Google account and click Set up source.
Copy the Google Sheet link to Spreadsheet Link
Create a new Google Cloud project.
Enable the Google Sheets API.
Create a new OAuth client ID. Select Web application as the Application type, give it a name and add https://developers.google.com/oauthplayground as an Authorized redirect URI.
Add a Client Secret (Add secret), and take note of both the Client Secret and Client ID.
Go to Google OAuth Playground
Click the cog in the top-right corner, select Use your own OAuth credentials and enter the OAuth Client ID and OAuth Client secret from the previous step.
In the left sidebar, find and select Google Sheets API v4, then choose the https://www.googleapis.com/auth/spreadsheets scope. Click Authorize APIs.
In step 2, click Exchange authorization code for tokens. Take note of the Refresh token.

Configuration fields

Google Sheets configuration fields
Field	Type	Description
credentials*	object	Authentication method to access Google Sheets
spreadsheet_id*	string	The link to your spreadsheet. See this guide for more details.

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

Cloud
OSS
Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

Google Sheets connector questions

What data can I load into Google Sheets with Airbyte?

Airbyte moves data from any supported source into Google Sheets on a schedule you control, with full refresh and incremental sync where the destination supports it.

Does the Google Sheets connector support incremental sync?

Yes. The Google Sheets destination supports full refresh and incremental sync, so Airbyte can load only the records that changed since the last sync.

Where can I run the Google Sheets connector?

Run the Google Sheets connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales