Skip to content
Documentation
Contact
← Back to documentation
Technical Reference

Google Sheets

Connect Google Sheets with Flows360 to automate spreadsheet data workflows.

CategoryProductivity
AuthenticationOAuth 2.0, custom
Version0.17.0
Published scopes4 published scopes
Last updatedSeptember 19, 2026

Overview

Connect Google Sheets with Flows360

Connect Google Sheets with Flows360 to automate spreadsheet data workflows.

Use the Google Sheets connector to include its declared actions and events in Flows360 workflows without duplicating the integration logic inside each consuming system. This pinned connector version currently exposes 61 actions and 4 triggers.

Available actions

  • Add Row
  • Add Row at Top
  • Add Multiple Rows
  • Update Row
  • Update Multiple Rows
  • Delete Row
  • Delete Multiple Rows
  • Find Rows
  • Plus 53 additional declared actions.

Available triggers

  • New or Updated Row
  • New Row Added
  • New Spreadsheet
  • New Worksheet

The capability list above is generated from the exact reviewed connector package so the public description stays aligned with the version Flows360 operates.

Technical guide

Technical reference

Package identity

  • Connector: Google Sheets
  • Package: @activepieces/piece-google-sheets@0.17.0
  • Exact artifact digest: sha256:17d2287cf81c5e0d02ab1149549a5afb23e037ed7dbc71c8bdc46109fbcc6705
  • Runtime: Activepieces-compatible deterministic worker
  • Source: the exact reviewed Activepieces source

Authentication

OAUTH2, CUSTOM AUTH. Connection values are tenant-specific and remain in the consuming Studio instance; CDK stores definitions and field metadata, not customer credential values.

Action contracts

  • Add Row (insert_row), Add a new row of data to a specific spreadsheet. Classification: read.
  • Add Row at Top (insert-row-at-top), Inserts a new row at the top of a worksheet, just below the header row. Classification: read.
  • Add Multiple Rows (google-sheets-insert-multiple-rows), Add multiple rows of data at once to a specific spreadsheet. Classification: read.
  • Update Row (update_row), Update the data in an existing row. Classification: read.
  • Update Multiple Rows (update-multiple-rows), Updates multiple rows in a specific spreadsheet. Classification: read.
  • Delete Row (delete_row), Delete a specific row from the selected sheet. Classification: read.
  • Delete Multiple Rows (delete-multiple-rows), Deletes a contiguous range of rows, or a list of specific row numbers. Row numbers are 1-based. Classification: read.
  • Find Rows (find_rows), Look up rows in a worksheet based on a column value. Classification: read.
  • Find or Create Row (find-or-create-row), Look up a row by column value; if no match is found, create a new row with the provided values. Classification: read.
  • Create Spreadsheet (create-spreadsheet), Creates a blank spreadsheet. Classification: read.
  • Create Worksheet (create-worksheet), Create a new blank worksheet with a title. Classification: read.
  • Find or Create Worksheet (find-or-create-worksheet), Look up a worksheet by title in a spreadsheet; if not found, create it with optional headers. Classification: read.
  • Clear Sheet (clear_sheet), Clear every row on a worksheet, keeping the worksheet itself. Classification: read.
  • Clear Row(s) (clear-rows), Clears the contents of one or more rows without removing the rows themselves. Useful when you want to keep formatting and references stable. Classification: read.
  • Delete Worksheet (delete-worksheet), Permanently delete a specific worksheet. Classification: read.
  • Rename Worksheet (rename-worksheet), Give an existing worksheet a new title. Classification: read.
  • Format Row(s) (format-row), Apply colour and text styling to one or more rows. Classification: read.
  • Get Row by Number (find_row_by_num), Retrieve one row by its row number. Classification: read.
  • Get Next Rows (get_next_rows), Read the next batch of rows from a worksheet, continuing where the last run left off. Classification: read.
  • Get All Rows (get-many-rows), Read every row from a worksheet. Classification: read.
  • Read Data Range (read-data-range), Read cells from a range using A1 notation (e.g. A1:D10). Returns rows and the resolved range. Classification: read.
  • Find Spreadsheet(s) (find_spreadsheets), Find spreadsheet(s) by name. Classification: read.
  • Find Worksheet(s) (find-worksheet), Find worksheets in a spreadsheet by title. Classification: read.
  • Copy Worksheet (copy-worksheet), Creates a new worksheet by copying an existing one. Classification: read.
  • Create Column (create-column), Add a new column to a worksheet. Classification: read.
  • Export Worksheet (export_sheet), Download a worksheet as a CSV or TSV file. Classification: read.
  • Add Column (sheets_add_column), Create a new column in a worksheet. Classification: read.
  • Add Multiple Rows (sheets_add_multiple_rows), Add multiple rows of data at once to a worksheet. Classification: read.
  • Add Row at Top (sheets_add_row_at_top), Insert a new row near the top of a worksheet, just below the header row. Classification: read.
  • Add Row (sheets_add_row), Append a single new row to the end of a worksheet. Classification: read.
  • Add Worksheet (sheets_add_worksheet), Create a new blank worksheet with a title. Classification: read.
  • Append Rows/Columns (sheets_append_dimension), Append blank rows or columns to the end of a worksheet's grid. Classification: read.
  • Append Values (Raw) (sheets_append_values), Append rows of values after the last row with data in a worksheet. Classification: read.
  • Auto-Resize Columns/Rows (sheets_auto_resize_dimensions), Auto-fit the width of columns or height of rows to their content. Classification: read.
  • Clear Cell Range (sheets_clear_values), Clear the contents of one or more rows without removing the rows themselves. Classification: read.
  • Copy Worksheet (sheets_copy_worksheet), Create a new worksheet by copying an existing one. Classification: read.
  • Create Spreadsheet (sheets_create_spreadsheet), Create a new, empty Google Sheets spreadsheet. Classification: read.
  • Delete Rows/Columns (sheets_delete_dimension), Delete a range of rows or columns, shifting the rest. Classification: read.
  • Delete Multiple Rows (sheets_delete_multiple_rows), Delete a contiguous range of rows, or a list of specific row numbers. Classification: read.
  • Delete Row (sheets_delete_row), Delete a single row by its row number. Classification: read.
  • Delete Worksheet (sheets_delete_worksheet), Permanently delete a specific worksheet. Classification: read.
  • Export Worksheet (CSV/TSV) (sheets_export_worksheet), Download a worksheet as a CSV or TSV file. Classification: read.
  • Find or Create Row (sheets_find_or_create_row), Look up a row by column value; if no match is found, create a new row with the provided values. Classification: read.
  • Find or Create Worksheet (sheets_find_or_create_worksheet), Look up a worksheet by title in a spreadsheet; if not found, create it with optional headers. Classification: read.
  • Find Rows (sheets_find_rows), Look up rows in a worksheet based on a column value. Classification: read.
  • Find Worksheets (sheets_find_worksheet), Find a worksheet(s) by title. Classification: read.
  • Format Cells (sheets_format_cells), Apply formatting to a range of rows in a worksheet. Classification: read.
  • Get All Rows (sheets_get_all_rows), Read every row from a worksheet in a single call. Classification: read.
  • Get Next Rows (Paginated) (sheets_get_next_rows), Get the next group of rows from a worksheet, advancing a stored cursor. Classification: read.
  • Get Row by Number (sheets_get_row), Retrieve a single row by its row number. Classification: read.
  • Get Spreadsheet Info (sheets_get_spreadsheet), Fetch a spreadsheet's title and the list of its worksheets (tabs). Classification: read.
  • Read Cell Range (sheets_get_values), Read cell values from a worksheet using A1 notation. Classification: read.
  • Insert Rows/Columns (sheets_insert_dimension), Insert blank rows or columns at a position, shifting existing data. Classification: read.
  • Rename Worksheet (sheets_rename_worksheet), Rename a specific worksheet. Classification: read.
  • Find Spreadsheets (sheets_search_spreadsheets), Find spreadsheet(s) by name. Classification: read.
  • Resize / Hide Rows or Columns (sheets_update_dimension_properties), Set a fixed pixel size for rows/columns, or hide/unhide them. Classification: read.
  • Update Multiple Rows (sheets_update_multiple_rows), Update several existing rows in one batch call. Classification: read.
  • Update Row (sheets_update_row), Update the data in an existing row, identified by its row number. Classification: read.
  • Update Worksheet Properties (sheets_update_sheet_properties), Update a worksheet's frozen rows/columns, tab color, or hidden state. Classification: read.
  • Write Cell Range (sheets_update_values), Write a 2D array of values into a worksheet at a specific A1 range. Classification: read.
  • Custom API Call (custom_api_call), Make a custom API call to a specific endpoint Classification: read.

Trigger contracts

  • New or Updated Row, webhook.
  • New Row Added, webhook.
  • New Spreadsheet, polling.
  • New Worksheet, polling.

Verification

Deterministic execution evidence is recorded for the pinned artifact, including 1 exercised action entrypoint and 0 exercised trigger entrypoints.

Capability summary

AuthenticationOAuth 2.0, custom
Supported objects65
Supported actionsNot published
Triggers4

Authentication

Authentication method: OAuth 2.0, custom

Required scopes

https://www.googleapis.com/auth/spreadsheetshttps://www.googleapis.com/auth/drive.readonlyhttps://www.googleapis.com/auth/driveemail

Authentication profiles

connection · oauth2

OAuth scopes: https://www.googleapis.com/auth/spreadsheets, https://www.googleapis.com/auth/drive.readonly, https://www.googleapis.com/auth/drive, email

connection_2 · custom
  • Service Account JSON Key Required
  • User Email Optional

Supported objects

ObjectReadWriteNotes
Add Row Yes No Add a new row of data to a specific spreadsheet.
Add Row at Top Yes No Inserts a new row at the top of a worksheet, just below the header row.
Add Multiple Rows Yes No Add multiple rows of data at once to a specific spreadsheet.
Update Row Yes No Update the data in an existing row.
Update Multiple Rows Yes No Updates multiple rows in a specific spreadsheet.
Delete Row Yes No Delete a specific row from the selected sheet.
Delete Multiple Rows Yes No Deletes a contiguous range of rows, or a list of specific row numbers. Row numbers are 1-based.
Find Rows Yes No Look up rows in a worksheet based on a column value.
Find or Create Row Yes No Look up a row by column value; if no match is found, create a new row with the provided values.
Create Spreadsheet Yes No Creates a blank spreadsheet.
Create Worksheet Yes No Create a new blank worksheet with a title.
Find or Create Worksheet Yes No Look up a worksheet by title in a spreadsheet; if not found, create it with optional headers.
Clear Sheet Yes No Clear every row on a worksheet, keeping the worksheet itself.
Clear Row(s) Yes No Clears the contents of one or more rows without removing the rows themselves. Useful when you want to keep formatting and references stable.
Delete Worksheet Yes No Permanently delete a specific worksheet.
Rename Worksheet Yes No Give an existing worksheet a new title.
Format Row(s) Yes No Apply colour and text styling to one or more rows.
Get Row by Number Yes No Retrieve one row by its row number.
Get Next Rows Yes No Read the next batch of rows from a worksheet, continuing where the last run left off.
Get All Rows Yes No Read every row from a worksheet.
Read Data Range Yes No Read cells from a range using A1 notation (e.g. A1:D10). Returns rows and the resolved range.
Find Spreadsheet(s) Yes No Find spreadsheet(s) by name.
Find Worksheet(s) Yes No Find worksheets in a spreadsheet by title.
Copy Worksheet Yes No Creates a new worksheet by copying an existing one.
Create Column Yes No Add a new column to a worksheet.
Export Worksheet Yes No Download a worksheet as a CSV or TSV file.
Add Column Yes No Create a new column in a worksheet.
Add Multiple Rows Yes No Add multiple rows of data at once to a worksheet.
Add Row at Top Yes No Insert a new row near the top of a worksheet, just below the header row.
Add Row Yes No Append a single new row to the end of a worksheet.
Add Worksheet Yes No Create a new blank worksheet with a title.
Append Rows/Columns Yes No Append blank rows or columns to the end of a worksheet's grid.
Append Values (Raw) Yes No Append rows of values after the last row with data in a worksheet.
Auto-Resize Columns/Rows Yes No Auto-fit the width of columns or height of rows to their content.
Clear Cell Range Yes No Clear the contents of one or more rows without removing the rows themselves.
Copy Worksheet Yes No Create a new worksheet by copying an existing one.
Create Spreadsheet Yes No Create a new, empty Google Sheets spreadsheet.
Delete Rows/Columns Yes No Delete a range of rows or columns, shifting the rest.
Delete Multiple Rows Yes No Delete a contiguous range of rows, or a list of specific row numbers.
Delete Row Yes No Delete a single row by its row number.
Delete Worksheet Yes No Permanently delete a specific worksheet.
Export Worksheet (CSV/TSV) Yes No Download a worksheet as a CSV or TSV file.
Find or Create Row Yes No Look up a row by column value; if no match is found, create a new row with the provided values.
Find or Create Worksheet Yes No Look up a worksheet by title in a spreadsheet; if not found, create it with optional headers.
Find Rows Yes No Look up rows in a worksheet based on a column value.
Find Worksheets Yes No Find a worksheet(s) by title.
Format Cells Yes No Apply formatting to a range of rows in a worksheet.
Get All Rows Yes No Read every row from a worksheet in a single call.
Get Next Rows (Paginated) Yes No Get the next group of rows from a worksheet, advancing a stored cursor.
Get Row by Number Yes No Retrieve a single row by its row number.
Get Spreadsheet Info Yes No Fetch a spreadsheet's title and the list of its worksheets (tabs).
Read Cell Range Yes No Read cell values from a worksheet using A1 notation.
Insert Rows/Columns Yes No Insert blank rows or columns at a position, shifting existing data.
Rename Worksheet Yes No Rename a specific worksheet.
Find Spreadsheets Yes No Find spreadsheet(s) by name.
Resize / Hide Rows or Columns Yes No Set a fixed pixel size for rows/columns, or hide/unhide them.
Update Multiple Rows Yes No Update several existing rows in one batch call.
Update Row Yes No Update the data in an existing row, identified by its row number.
Update Worksheet Properties Yes No Update a worksheet's frozen rows/columns, tab color, or hidden state.
Write Cell Range Yes No Write a 2D array of values into a worksheet at a specific A1 range.
Custom API Call Yes No Make a custom API call to a specific endpoint
New or Updated Row Yes No webhook trigger declared by the pinned package.
New Row Added Yes No webhook trigger declared by the pinned package.
New Spreadsheet Yes No polling trigger declared by the pinned package.
New Worksheet Yes No polling trigger declared by the pinned package.

Triggers

New or Updated Row · Webhook

Triggers when a new row is added or modified in a spreadsheet.

Inputs

  • info · string
  • spreadsheetId · string
  • sheetId · string
  • includeTeamDrives · boolean
  • trigger_column · string
New Row Added · Webhook

Triggers when a new row is added to the bottom of a worksheet.

Inputs

  • info · string
  • spreadsheetId · string
  • sheetId · string
  • includeTeamDrives · boolean
New Spreadsheet · Poll

Triggers when a new spreadsheet is created.

Inputs

  • includeTeamDrives · boolean
New Worksheet · Poll

Triggers when a worksheet is created in a spreadsheet.

Inputs

  • includeTeamDrives · boolean
  • spreadsheetId · string

Setup

Setup

  1. Add the Google Sheets connector to the workflow in the target Flows360 Studio instance.
  2. Create or select the tenant-specific connection required by the connector. Connection secrets remain in the Studio connection boundary and are not copied into CDK documentation.
  3. Provide the connection fields declared by the pinned package:
  • Service Account JSON Key (serviceAccount), required.
  • User Email (userEmail), optional.

OAuth scopes

  • https://www.googleapis.com/auth/spreadsheets
  • https://www.googleapis.com/auth/drive.readonly
  • https://www.googleapis.com/auth/drive
  • email
  1. Select the required action or trigger and complete its declared input fields. Required and optional inputs are defined by the exact package schema.
  2. Test the workflow in the appropriate environment before enabling production scheduling or event delivery.

Limitations

Limitations and operational notes

  • This content describes @activepieces/piece-google-sheets@0.17.0; provider behaviour can change independently and should be revalidated when the provider or connector version changes.
  • Only the 61 actions and 4 triggers declared by this pinned package are represented here.
  • Tenant credentials and connection values are not stored in the public connector record.
  • Provider-side permissions, account entitlements, quotas and rate limits remain subject to the connected provider account and are not inferred when the package does not declare them.
  • Deterministic execution evidence is recorded for the pinned artifact, including 1 exercised action entrypoint and 0 exercised trigger entrypoints.

Troubleshooting

Why canu2019t the connector authenticate?

Check the tenant connection in Studio and confirm every required Google Sheets connection field is present. Re-authorise OAuth-based connections if the provider token or consent has expired. Do not place credential values in CDK content or logs.

Why is an action or trigger unavailable?

Confirm that the workflow is using @activepieces/piece-google-sheets@0.17.0 and compare the requested capability with the declared action and trigger list for this version. A capability that is not declared by the pinned package should not be presented as supported.

What should I check after a provider-side change?

Revalidate authentication, required fields, action/trigger behaviour and provider documentation before publishing refreshed connector content or moving a new package version into production.

github.com