Reference · built on requestConnectorFiles, documents & spreadsheets

Google Sheets

Cell values, ranges, and sheets in Google Sheets, read and written through the Sheets API v4.

Request accessPricing ↗

About

Google Sheets is the spreadsheet in Google Workspace. A spreadsheet has an ID, holds one or more sheets, each with an integer sheet ID, and each sheet holds cells addressed in A1 or R1C1 notation. The Sheets API v4 reads and writes cell values through the spreadsheets.values resource and changes structure and formatting through spreadsheets.batchUpdate.

Through Fibric, an operator reads the ranges you name, compares them with the systems they mirror, and proposes an appended row or an updated cell. You see the exact range before it is written. Each write leaves a receipt: what changed, why, and how to undo it.

This is a reference listing. It documents what Fibric would read from Google Sheets and what it could propose, based on the vendor's published interfaces. Fibric builds it under a managed deployment when you request it; selecting it here installs nothing.

Inputs

  • Cell values in one range through spreadsheets.values.get, or several ranges at once through spreadsheets.values.batchGet
  • Values rendered as FORMATTED_VALUE by default, with valueRenderOption to request unformatted values or formulas
  • Rows or columns as the major dimension, chosen with majorDimension
  • Spreadsheet structure through spreadsheets.get: sheets, their integer sheet IDs, and named ranges
  • Where a table ends inside a range, as spreadsheets.values.append detects it before adding a row

Proposed actions

  • Target capability: propose a write to one range through spreadsheets.values.update, or several through spreadsheets.values.batchUpdate
  • Target capability: propose appended rows through spreadsheets.values.append, parsed as RAW or USER_ENTERED
  • Target capability: propose clearing ranges through spreadsheets.values.batchClear
  • Target capability: propose a structural change through spreadsheets.batchUpdate, such as AddSheetRequest or RepeatCellRequest, applied all or nothing

Proposed actions are target capabilities. Every action runs propose-first and needs a validated deployment and the appropriate permissions.

What you can build

  • Reconcile a labor budget kept in a sheet

    The operator reads the budget range each morning, compares it with hours from your scheduling system, and proposes an appended variance row for your approval.

    With Labor Budget, Timesheet Signoff

  • Keep a cycle count sheet current

    The operator reads the count plan range, marks which locations were counted in your inventory system, and proposes a values.update to the status column.

    With Cycle Count Plan, Count Variance

  • Catch a metric that drifts from its source

    The operator compares a KPI cell with the figure in your warehouse and, when they disagree, proposes a corrected value with the source named.

    With Metric Reconciliation, Price List Drift

Requirements

  • A Google Cloud project with the Sheets API enabled and an OAuth 2.0 client
  • The spreadsheets scope for writes, or spreadsheets.readonly for reads; both are sensitive scopes that need app verification
  • The spreadsheet ID and the sheet names or IDs of the ranges you want read
Authentication
An OAuth 2.0 app with the spreadsheets or spreadsheets.readonly scope, or the drive.file scope for spreadsheets your users open with the app.

Limits

  • Quota is 300 read and 300 write requests per minute per project, and 60 of each per minute per user; exceeding it returns 429
  • There is no daily cap while you stay inside the per-minute quotas; Google recommends a 2 MB maximum payload
  • The Sheets API has no push notifications; a spreadsheet is a Drive file, so change alerts come from the Drive API's files.watch
  • Writes need a valueInputOption; RAW stores strings as given and USER_ENTERED parses them as if typed in the Sheets UI

Access and pricing

Reference listing. Fibric builds the connector under a managed deployment when you request it. Your quote covers the build, capabilities, usage, and support.

Request Google Sheets ↗

Questions and answers

What is the difference between spreadsheets.values.update and spreadsheets.values.append?
update writes to the exact range you give. append searches the range for existing data, finds a table, and adds values to the next row after it. Both take valueInputOption, either RAW or USER_ENTERED.
Does the Sheets API send webhooks?
No. The Sheets API reads and writes on request. A spreadsheet is a file in Google Drive, so the Drive API's files.watch can open a notification channel on it and post an empty request to your HTTPS endpoint when the file changes.
What are the Sheets API quotas?
Per project: 300 read requests and 300 write requests per minute. Per user per project: 60 of each per minute. Exceeding a quota returns HTTP 429, and Google recommends truncated exponential backoff. There is no per-day limit while the per-minute quotas hold.
Ask about Google Sheets

Ask about the capabilities and requirements in this listing.

For project-specific requirements, contact Fibric.

This connector listing is developed, published, and supported by Fibric. It describes integration with Google Sheets through published interfaces. Third-party names and logos identify the systems an integration connects to; they are the property of their respective owners, who are not affiliated with Fibric and do not sponsor or endorse this listing. Trademark policy