Google Sheets
Integrate your application with the Google Sheets API
🚀 Quickstart
Connect to Google Sheets with Tenklo and see data flow in 2 minutes.
In Tenklo (free signup), go to Integrations -> Configure New Integration -> Google Sheets.
Tenklo has credentials you can use for testing. Activate them in the dashboard.
Go to Connections -> Add Test Connection -> Authorize, then log in to Google Sheets. Later, you'll let your users do the same directly from your app.
Let's make your first request to the Google Sheets API (fetch a specific spreadsheet). Replace the placeholders below with your Environment API key, integration ID, and connection ID:
curl "https://api.tenklo.dev/proxy/v4/spreadsheets/{sheetId}" \
-H "Authorization: Bearer <NANGO-API-KEY>" \
-H "Provider-Config-Key: <INTEGRATION-ID>" \
-H "Connection-Id: <CONNECTION-ID>"Or fetch credentials with the Node SDK or API.
The {sheetId} in the URL represents the ID of the spreadsheet to retrieve.
✅ You're connected! Check the Logs tab in Tenklo to inspect requests.
Follow our Auth implementation guide to integrate Tenklo in your app.
To obtain your own production credentials, follow the setup guide linked below.
📚 Google Sheets Integration Guides
Tenklo maintained guides for common use cases.
-
How to register your own Google Sheets OAuth app
Register an OAuth app with Google and obtain credentials to connect it to Tenklo -
Google App & Security Review Pass Google's OAuth app verification to go to production
Official docs: Google Sheets API
🧩 Pre-built syncs & actions for Google Sheets
Explore Nango-provided actions in your dashboard. Extend and customize them to fit your needs.
Sheets
Worksheets
| Function name | Description | Type | Source code |
|---|---|---|---|
worksheets | Sync worksheets from a Google Sheets spreadsheet | Sync | 🔗 Github |
Others
| Function name | Description | Type | Source code |
|---|---|---|---|
append-values-to-spreadsheet | Append values to the end of a spreadsheet table | Action | 🔗 Github |
batch-clear-values-by-data-filter | Clear values from ranges matching data filters, preserving formatting | Action | 🔗 Github |
batch-clear-values | Clear values from one or more ranges in a spreadsheet, preserving formatting | Action | 🔗 Github |
batch-get-values-by-data-filter | Get values from ranges matching data filters | Action | 🔗 Github |
batch-get-values | Get values from multiple ranges | Action | 🔗 Github |
batch-update-spreadsheet | Apply multiple updates to a spreadsheet in a single request | Action | 🔗 Github |
clear-values | Clear values from a range, preserving formatting | Action | 🔗 Github |
copy-sheet | Copy a sheet to another spreadsheet | Action | 🔗 Github |
create-column | Insert a new column into a sheet | Action | 🔗 Github |
create-spreadsheet-row | Insert a new row at a given index in a Google Sheet | Action | 🔗 Github |
create-spreadsheet | Create a new spreadsheet | Action | 🔗 Github |
delete-worksheet | Delete a worksheet by name from a Google Spreadsheet | Action | 🔗 Github |
get-spreadsheet-by-data-filter | Get spreadsheet data matching data filters | Action | 🔗 Github |
get-values | Get values from a spreadsheet range | Action | 🔗 Github |
search-developer-metadata | Search developer metadata by criteria | Action | 🔗 Github |
update-conditional-format-rule | Update or move a conditional format rule | Action | 🔗 Github |
update-values | Update values in a spreadsheet range | Action | 🔗 Github |
upsert-row | Append or update a row of values in a Google Sheet | Action | 🔗 Github |