Docs Navigation

Blocks

Google Sheets

Read, write, and update data

Integrate Google Sheets functionality to manage spreadsheet data. Read data from specific ranges, write new data, update existing cells, and append data to the end of sheets using OAuth authentication. Supports various input and output formats for flexible data handling.

Back to Catalog

Toolsgoogle_sheets

Block Preview

Google Sheets

Read, write, and update data

Usage

Add the block to your workflow and connect it to the upstream step.
Connect the required credentials or OAuth provider before running.
Fill in required inputs and optional parameters for the run.
Run a test execution, inspect outputs, and iterate before deploying.
Deploy the google_sheets block with monitoring enabled in production.

Inputs (UI)

Operation

dropdown

Layout: full

Options: Read Data, Write Data, Update Data, Append Data

Google Account

oauth-input

Placeholder: Select Google account

Layout: full

Provider: google-sheets

Select Sheet

file-selector

Placeholder: Select a spreadsheet

Layout: full

Provider: google-drive

Or Enter Spreadsheet ID Manually

short-input

Placeholder: ID of the spreadsheet (from URL)

Layout: full

Condition: spreadsheetId = ""

Range

short-input

Placeholder: Sheet name and cell range (e.g., Sheet1!A1:D10)

Layout: full

Values

long-input

Placeholder: Enter values as JSON array of arrays (e.g., [["A1", "B1"], ["A2", "B2"]]) or an array of objects (e.g., [{"name":"John", "age":30}, {"name":"Jane", "age":25}])

Layout: full

Condition: operation = "write"

Value Input Option

dropdown

Layout: full

Condition: operation = "write"

Options: User Entered (Parse formulas), Raw (Don't parse formulas)

Values

long-input

Placeholder: Enter values as JSON array of arrays (e.g., [["A1", "B1"], ["A2", "B2"]]) or an array of objects (e.g., [{"name":"John", "age":30}, {"name":"Jane", "age":25}])

Layout: full

Condition: operation = "update"

Value Input Option

dropdown

Layout: full

Condition: operation = "update"

Options: User Entered (Parse formulas), Raw (Don't parse formulas)

Values

long-input

Placeholder: Enter values as JSON array of arrays (e.g., [["A1", "B1"], ["A2", "B2"]]) or an array of objects (e.g., [{"name":"John", "age":30}, {"name":"Jane", "age":25}])

Layout: full

Condition: operation = "append"

Value Input Option

dropdown

Layout: full

Condition: operation = "append"

Options: User Entered (Parse formulas), Raw (Don't parse formulas)

Insert Data Option

dropdown

Layout: full

Condition: operation = "append"

Options: Insert Rows (Add new rows), Overwrite (Add to existing data)

Inputs (API)

operation

string

Required

credential

string

Required

spreadsheetId

string

Optional

manualSpreadsheetId

string

Optional

range

string

Optional

values

string

Optional

valueInputOption

string

Optional

insertDataOption

string

Optional

Outputs

Primary response type:

{
  "data": "json",
  "metadata": "json",
  "updatedRange": "string",
  "updatedRows": "number",
  "updatedColumns": "number",
  "updatedCells": "number",
  "tableRange": "string"
}

Tool Access

google_sheets_readgoogle_sheets_writegoogle_sheets_updategoogle_sheets_append