--- title: Google Sheets API Integration on Truto slug: googlesheets category: Knowledge Management canonical: "https://truto.one/integrations/detail/googlesheets/" --- # Google Sheets API Integration on Truto **Category:** Knowledge Management **Status:** Generally available ## MCP-ready AI tools Truto exposes 15 tools for Google Sheets that AI agents can call directly. - **list_all_googlesheets_spreadsheets** — List files in Google Sheets integration. Returns files array with file metadata including id, name, mimeType, and modifiedTime. Use q parameter for filtering and trashed=false to exclude trashed files. - **get_single_googlesheets_spreadsheet_by_id** — Get spreadsheet by id in Google Sheets. Returns spreadsheet metadata including properties, sheets, and optionally grid data or specified ranges. - **create_a_googlesheets_spreadsheet** — Create a new spreadsheet in Google Sheets. Returns the newly created spreadsheet including its spreadsheetId, properties, sheets, and spreadsheetUrl. - **create_a_googlesheets_spreadsheets_value** — Append values to a spreadsheet in Google Sheets using spreadsheet_id and range. Returns spreadsheetId, tableRange, and updates with details of the applied changes. - **list_all_googlesheets_spreadsheets_values** — Get one or more ranges of values from a spreadsheet in Google Sheets. Requires spreadsheet_id and ranges. Returns valueRanges array with requested values in the order of requested ranges. - **update_a_googlesheets_spreadsheets_value_by_id** — Set values in a range of a spreadsheet in Google Sheets. Requires spreadsheet_id, range, and valueInputOption. Returns updated cell range, updated rows, columns, and values if includeValuesInResponse is true. - **googlesheets_spreadsheets_values_clear** — Clear values from a spreadsheet in Google Sheets using spreadsheet_id and range. Returns spreadsheetId and clearedRange showing the actual cleared range in A1 notation. - **create_a_googlesheets_spreadsheets_sheets_copy_to** — Copy a sheet identified by id from spreadsheet with spreadsheet_id to another spreadsheet. Returns properties of the newly created sheet including sheetId, title, index, and sheetType. - **get_single_googlesheets_spreadsheets_developer_metadatum_by_id** — Get developer metadata by spreadsheetId and id in Google Sheets. Returns the DeveloperMetadata object containing metadataId, metadataKey, metadataValue, location, and visibility fields. - **list_all_googlesheets_spreadsheets_developer_metadata_search** — Search developer metadata in Google Sheets for the spreadsheet identified by spreadsheetId using specified dataFilters. Returns matchedDeveloperMetadata including developerMetadata and matching dataFilters. - **update_a_googlesheets_spreadsheets_values_batch_by_id** — Set values in one or more ranges of a spreadsheet in Google Sheets. Requires spreadsheet_id and data. Returns spreadsheetId, totalUpdatedRows, totalUpdatedColumns, totalUpdatedCells, totalUpdatedSheets, and responses with update details. - **googlesheets_spreadsheets_values_batch_clear** — Clear one or more ranges of values from a spreadsheet in Google Sheets. Requires spreadsheet_id and ranges. Returns spreadsheetId and clearedRanges showing the actual cleared ranges in A1 notation. - **list_all_googlesheets_spreadsheets_values_batch_data_filter** — Get one or more ranges of values from a spreadsheet in Google Sheets by specifying spreadsheet_id and dataFilters. Returns matched valueRanges and their corresponding dataFilters. - **update_a_googlesheets_spreadsheets_values_batch_data_filter_by_id** — Update values in one or more ranges of a spreadsheet by specifying spreadsheet_id, valueInputOption, and data filter value ranges. Returns spreadsheetId, total updated rows, columns, cells, sheets, and detailed responses for each range updated. - **googlesheets_spreadsheets_values_batch_data_filter_clear** — Clear values in ranges matching dataFilters in a spreadsheet in Google Sheets. Requires spreadsheet_id and dataFilters. Returns spreadsheetId and clearedRanges in A1 notation. ## How it works 1. **Link your customer's Google Sheets account.** Use Truto's frontend SDK; we handle every OAuth and API key flow so you don't need to create the OAuth app. 2. **Authentication is automatic.** Truto refreshes tokens, stores credentials securely, and injects them into every API request. 3. **Call Truto's API to reach Google Sheets.** The Proxy API is a 1-to-1 mapping of the Google Sheets API. 4. **Get a unified response format.** Every response uses a single shape, with cursor-based pagination and data in the `result` field. ## Use cases - **Replace CSV exports with live Google Sheets sync** — Instead of forcing users to repeatedly download and re-import CSV files, your SaaS product can push data directly into a Google Sheet that stays current. Finance teams, marketers, and ops managers get a living spreadsheet they can build charts and pivot tables on top of. - **Ingest data from user-managed spreadsheets** — Many users already maintain prospect lists, inventory trackers, or contact databases in Google Sheets. Your product can read from these sheets to import records, detect new rows, and keep your system in sync — replacing clunky file upload flows with a seamless connected experience. - **Log events and activity in real time** — Every time something meaningful happens in your product — a form submission, a payment failure, a deal closing — your integration can append a row to a user's Google Sheet. This gives operations teams an always-up-to-date audit trail without leaving their spreadsheet. - **Enable two-way sync with stateful row tracking** — Using Developer Metadata, your integration can tag individual rows and columns with internal record IDs. This means even if a user sorts, reorders, or renames columns, your product can find and update the right cells — enabling robust two-way synchronization between your app and Sheets. - **Provision pre-built reporting templates for new users** — Maintain a master template spreadsheet with pre-configured formatting, formulas, and charts. When a user activates the integration, clone the template into their Drive and populate it with their data — delivering a polished reporting experience out of the box. ## What you can build - **One-click live data export to Sheets** — Let users create a Google Sheet directly from your app and continuously push analytics, transactions, or pipeline data into it using batch value updates. - **Spreadsheet-based data import and onboarding** — Replace your CSV upload flow by letting users connect a Google Sheet, then read their data via range-based value retrieval to create records in your product. - **Real-time event logging via row append** — Automatically append a new row to a user's designated Sheet every time a key event fires in your product — new sign-ups, failed charges, completed tasks — with no user intervention needed. - **Two-way record sync with Developer Metadata** — Attach hidden metadata to Sheet rows linking them to your internal record IDs, then search and update specific cells when records change — even if the user has reorganized the spreadsheet. - **Template-based report provisioning** — Clone a pre-formatted template sheet with charts and pivot tables into a user's Drive on integration setup, then populate it with their live data on a recurring schedule. - **Bulk data refresh with clear-and-rewrite** — Clear an existing data range and rewrite it with fresh data on a daily or hourly cadence, so users' custom formulas and charts always reference up-to-date information without accumulating stale rows. ## FAQs ### What authentication method does the Google Sheets integration use? Truto handles OAuth 2.0 authentication with Google on behalf of your end users. Your users go through a standard Google consent flow to grant access to their Sheets, and Truto manages token storage, refresh, and expiry so you never deal with auth plumbing directly. ### Can I read and write data in bulk across multiple ranges or sheets? Yes. The integration supports batch operations including batch value updates, batch clears, and batch reads with data filters. This lets you pull from or write to multiple ranges in a single API call, reducing latency and API overhead significantly. ### How does the integration handle users reorganizing their spreadsheets? The Developer Metadata endpoints let you attach hidden metadata (like your internal record IDs) to specific rows, columns, or cells. You can then search for this metadata to locate the correct cells regardless of how the user has sorted, filtered, or restructured the sheet — making your sync resilient to layout changes. ### Is there a Unified API for Google Sheets through Truto? There is no Unified API for Google Sheets yet. The integration is available through Truto's native API proxy, giving you direct access to all supported Google Sheets API operations — including spreadsheet CRUD, value reads and writes, batch operations, developer metadata, and sheet copying. ### What specific operations are supported on spreadsheet data? You can list and retrieve spreadsheets, create new spreadsheets, read values from ranges, append new values, update existing values (single and batch), clear values (single, batch, and filtered batch), copy sheets between spreadsheets, and read/search developer metadata. All operations are accessible through Truto's tools. ### How do I handle appending rows without overwriting existing data? The create_a_googlesheets_spreadsheets_value tool appends data after the last row in a specified range. You don't need to calculate the next empty row — the API handles this safely, making it ideal for event logging and incremental data export workflows.