Google Sheets
The Google Sheets Destination sends data to one Google Sheets spreadsheet, using multiple Worksheets as streams. To replicate data to multiple spreadsheets, create multiple Google Sheets Destination instances in your Airbyte instance.
:::warning
Google Sheets limits request rates and the amount of data it can receive. These limits can cause syncs to fail. Only use Google Sheets as a destination for small, non-production use cases. It isn’t designed for large-scale data operations.
Read more about the limitations of using Google Sheets below.
:::
Supported sync modes
| Sync mode | Supported? |
|---|---|
| Full Refresh - Overwrite | Yes |
| Full Refresh - Append | Yes |
| Full Refresh - Overwrite + Deduped | Yes |
| Incremental Sync - Append | Yes |
| Incremental Sync - Append + Deduped | Yes |
Prerequisites
- A Google Account or GCP Service Account for authentication
- A Google Spreadsheet URL
Step 1: Set up Google Sheets
Google Account
Visit Google to create a Google Account.
Google Sheets (Google Spreadsheets)
- After signing in to your Google account, create a new Google Sheet. Select Follow this guide to create one. You can also use an existing Google Sheet.
- You’ll need the link for the Google Sheet you want to sync. Select “Share” in the interface’s top-right corner. Then select Copy Link in the dialog.
Step 2: Set up the Google Sheets destination connector in Airbyte
For Airbyte Cloud:
- Select Google Sheets from the Source type dropdown, then enter a name for this connector.
- Select
Sign in with Google. - Sign in and Authorize the Google account, then select
Set up source. - Copy the Google Sheet link to Spreadsheet Link.
For Airbyte Open Source:
You can authenticate with Google Sheets using OAuth or a GCP Service Account token.
Using OAuth
- Create a new Google Cloud project.
- Enable the Google Sheets API.
- Create a new OAuth client ID. Select
Web applicationas the Application type and give it aname. Addhttps://developers.google.com/oauthplaygroundas an Authorized redirect URI. - Add a
Client Secret(Add secret). Note both theClient SecretandClient ID. - Go to Google OAuth Playground.
- Select the cog in the top-right corner, then select
Use your own OAuth credentials. Enter theOAuth Client IDandOAuth Client secretfrom the previous step. - Find and select
Google Sheets API v4in the left sidebar, then choose thehttps://www.googleapis.com/auth/spreadsheetsscope. SelectAuthorize APIs. - In step 2, select
Exchange authorization code for tokens. Note theRefresh token. - Set up a new destination in Airbyte and select
Google Sheets. Enter theClient ID,Client Secret,Refresh TokenandSpreadsheet Linkfrom the previous steps.
Using GCP Service Account:
- In the Google Cloud console, go to the Service accounts page.
- Select a project.
- Select the email address of the service account you want to create a key for.
- Select the Keys tab.
- Select the Add key drop-down menu, then select Create new key.
- Select JSON as the Key type, then select Create. Selecting Create downloads a service account key file. You can’t download the key file again after downloading it.
The key should look like this:
{
"type": "service_account",
"project_id": "PROJECT_ID",
"private_key_id": "KEY_ID",
"private_key": "-----BEGIN PRIVATE KEY-----\nPRIVATE_KEY\n-----END PRIVATE KEY-----\n",
"client_email": "SERVICE_ACCOUNT_EMAIL",
"client_id": "CLIENT_ID",
"auth_uri": "https://accounts.google.com/o/oauth2/auth",
"token_uri": "https://accounts.google.com/o/oauth2/token",
"auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
"client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/SERVICE_ACCOUNT_EMAIL"
}
Output schema
Each worksheet in the selected spreadsheet becomes a separate source-connector stream in the output.
Output columns are reordered alphabetically. You should not reorder them manually after syncing because this could cause future syncs to fail.
Google Sheets coerces all data into a string format.
Nested lists and objects are formatted as strings instead of standard lists and objects. You’ll need further processing for downstream analysis.
Airbyte only replicates Grid Sheets, so only text is replicated. Objects such as charts or images can’t be synced. See the Google Sheets API docs for more information about all available sheet types.
Rate limits and performance
The Google API rate limit is 60 requests per 60 seconds per user and 300 requests per 60 seconds per project. These limits result in slow sync speeds. Airbyte batches API requests to pull data efficiently while respecting these limits.
Limitations {#limitations}
Google Sheets limits the amount of data you can sync. Exceeding these limits may cause the sync to fail. In some cases, data is truncated to meet the limits.
Maximum of 10 Million Cells
A Google Sheets document can contain up to 10 million cells across one or multiple worksheets. After reaching this limit, you can’t add more columns. You also can’t add rows if the existing rows reach the limit.
Maximum of 50,000 characters per cell
A single cell can contain up to 50,000 characters. Airbyte automatically truncates longer values and appends ...[TRUNCATED]. Don’t use Google Sheets if your source contains fields with long text.
Maximum of 18,278 Columns
A Google Sheets worksheet can contain up to 18,278 columns.
Maximum of 200 Worksheets in a Spreadsheet
A single spreadsheet can contain up to 200 worksheets.
Note
- Record normalisation prevents data corruption during the write process. It handles two scenarios:
- UnderSetting: the record has fewer keys (columns) than the catalogue declares
- OverSetting: the record has more keys (columns) than the catalogue declares
EXAMPLE:
- UnderSetting:
* Catalog:
- has 3 entities:
[ 'id', 'key1', 'key2' ]
^
* Input record:
- missing 1 entity, compare to catalog
{ 'id': 123, 'key2': 'value' }
^
* Result:
- 'key1' has been added to the record, because it was declared in catalog, to keep the data structure.
{'id': 123, 'key1': '', {'key2': 'value'} }
^
- OverSetting:
* Catalog:
- has 3 entities:
[ 'id', 'key1', 'key2', ]
^
* Input record:
- doesn't have entity 'key1'
- has 1 more enitity, compare to catalog 'key3'
{ 'id': 123, ,'key2': 'value', 'key3': 'value' }
^ ^
* Result:
- 'key1' was added, because it expected be the part of the record, to keep the data structure
- 'key3' was dropped, because it was not declared in catalog, to keep the data structure
{ 'id': 123, 'key1': '', 'key2': 'value', }
^ ^
Data type mapping
| Integration Type | Airbyte Type |
|---|---|
| Any Type | string |
Namespace support
This destination doesn’t support namespaces.
Changelog
Expand to review
| Version | Date | Pull Request | Subject |
|---|---|---|---|
| 0.3.5 | 2025-04-30 | 59647 | Truncate cell values exceeding 50,000 characters with warning |
| 0.3.4 | 2025-04-26 | 58280 | Update dependencies |
| 0.3.3 | 2025-04-12 | 57636 | Update dependencies |
| 0.3.2 | 2025-04-05 | 57166 | Update dependencies |
| 0.3.1 | 2025-03-29 | 56600 | Update dependencies |
| 0.3.0 | 2025-02-27 | 54689 | Support service account authentication |
| 0.2.42 | 2025-03-22 | 56149 | Update dependencies |
| 0.2.41 | 2025-03-08 | 55374 | Update dependencies |
| 0.2.40 | 2025-03-01 | 54847 | Update dependencies |
| 0.2.39 | 2025-02-22 | 54248 | Update dependencies |
| 0.2.38 | 2025-02-15 | 53892 | Update dependencies |
| 0.2.37 | 2025-02-01 | 52194 | Update dependencies |
| 0.2.36 | 2025-01-18 | 51748 | Update dependencies |
| 0.2.35 | 2025-01-11 | 51262 | Update dependencies |
| 0.2.34 | 2025-01-04 | 50912 | Update dependencies |
| 0.2.33 | 2024-12-28 | 50492 | Update dependencies |
| 0.2.32 | 2024-12-21 | 50168 | Update dependencies |
| 0.2.31 | 2024-12-14 | 48915 | Update dependencies |
| 0.2.30 | 2024-11-25 | 48678 | Update dependencies |
| 0.2.29 | 2024-11-04 | 48281 | Update dependencies |
| 0.2.28 | 2024-10-28 | 47042 | Update dependencies |
| 0.2.27 | 2024-10-12 | 46772 | Update dependencies |
| 0.2.26 | 2024-10-05 | 46464 | Update dependencies |
| 0.2.25 | 2024-09-28 | 46204 | Update dependencies |
| 0.2.24 | 2024-09-21 | 45772 | Update dependencies |
| 0.2.23 | 2024-09-14 | 45577 | Update dependencies |
| 0.2.22 | 2024-09-07 | 45325 | Update dependencies |
| 0.2.21 | 2024-08-31 | 44989 | Update dependencies |
| 0.2.20 | 2024-08-24 | 44736 | Update dependencies |
| 0.2.19 | 2024-08-22 | 44530 | Update test dependencies |
| 0.2.18 | 2024-08-17 | 44259 | Update dependencies |
| 0.2.17 | 2024-08-10 | 43603 | Update dependencies |
| 0.2.16 | 2024-08-03 | 43066 | Update dependencies |
| 0.2.15 | 2024-07-27 | 42819 | Update dependencies |
| 0.2.14 | 2024-07-20 | 42368 | Update dependencies |
| 0.2.13 | 2024-07-13 | 41721 | Update dependencies |
| 0.2.12 | 2024-07-10 | 41520 | Update dependencies |
| 0.2.11 | 2024-07-09 | 41076 | Update dependencies |
| 0.2.10 | 2024-07-06 | 40999 | Update dependencies |
| 0.2.9 | 2024-06-26 | 40529 | Update dependencies |
| 0.2.8 | 2024-06-25 | 40353 | Update dependencies |
| 0.2.7 | 2024-06-22 | 40172 | Update dependencies |
| 0.2.6 | 2024-06-04 | 39011 | [autopull] Upgrade base image to v1.2.1 |
| 0.2.5 | 2024-05-22 | 38516 | [autopull] base image + poetry + up_to_date |
| 0.2.4 | 2024-05-21 | 38516 | [autopull] base image + poetry + up_to_date |
| 0.2.3 | 2023-09-25 | 30748 | Performance testing - include socat binary in docker image |
| 0.2.2 | 2023-07-06 | 28035 | Migrate from authSpecification to advancedAuth |
| 0.2.1 | 2023-06-26 | 27782 | Only allow HTTPS urls |
| 0.2.0 | 2023-06-26 | 27780 | License Update: Elv2 |
| 0.1.2 | 2022-10-31 | 18729 | Fix empty headers list |
| 0.1.1 | 2022-06-15 | 14751 | Yield state only when records saved |
| 0.1.0 | 2022-04-26 | 12135 | Initial Release |