Read and write spreadsheet cells with a named Google account.
Explore 17 workflow actions for Google Sheets, including account permissions and operation limits.
4 read actions13 write actions
WORKFLOW ACTIONS
What you can configure.
Choose an action in the workflow builder, connect an account, and map its inputs. These actions are available in the catalog; your account access and a successful test determine whether they work for your setup.
Add sheet
Write
Create a named sheet within an authorized spreadsheet.
Permissions and limits
Account permissions
https://www.googleapis.com/auth/spreadsheets
Operation limits
Google rejects duplicate sheet titles. A lost write receipt is uncertain and NodeHub does not retry the create.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Append a row by column name
Write
Read the current header and append one row by matching its column names.
Permissions and limits
Account permissions
https://www.googleapis.com/auth/spreadsheets
Operation limits
Reads the header immediately before the append. It refuses missing, duplicate or changed column names. Google chooses the table within the specified range; concurrent header edits can race with the write.
Reconnect older read-only Google OAuth accounts before writing. Temporary access-token connections cannot prove their granted scopes.
A write is sent once. If Google's answer is lost, the workflow marks it uncertain and does not send it again.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Append or update row
Write
Find one exact value in a bounded column and update its row, or append a new row when no match exists.
Permissions and limits
Account permissions
https://www.googleapis.com/auth/spreadsheets
Operation limits
The range must be an explicit A1 rectangle within one sheet (quote titles with spaces or punctuation), with at most 1,000 rows and 50 columns. Matching uses the first exact formatted cell value in the chosen column. Duplicate matches are refused. Read then write is not atomic; concurrent writers can append duplicates.
Reconnect older read-only Google OAuth accounts before writing. Temporary access-token connections cannot prove their granted scopes.
A write is sent once. If Google's answer is lost, the workflow marks it uncertain and does not send it again.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Append rows
Write
Append rows after the existing table in an authorized spreadsheet range.
Permissions and limits
Account permissions
https://www.googleapis.com/auth/spreadsheets
Operation limits
Google finds the table inside the supplied range and appends below it, which may differ from the range's last row.
Reconnect older read-only Google OAuth accounts before writing. Temporary access-token connections cannot prove their granted scopes.
A write is sent once. If Google's answer is lost, the workflow marks it uncertain and does not send it again.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Clear a range
Write
Remove values from an explicit range while keeping formatting and validation.
Permissions and limits
Account permissions
https://www.googleapis.com/auth/spreadsheets
Operation limits
This removes cell values but keeps formatting and validation. A broad range may clear more cells than expected.
Reconnect older read-only Google OAuth accounts before writing. Temporary access-token connections cannot prove their granted scopes.
A write is sent once. If Google's answer is lost, the workflow marks it uncertain and does not send it again.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Create spreadsheet
Write
Create a new spreadsheet in the authorized Google account.
Permissions and limits
Account permissions
https://www.googleapis.com/auth/spreadsheets
Operation limits
Creates a new spreadsheet in the connected Google account. It does not move the file to a Drive folder or share it.
Reconnect older read-only Google OAuth accounts before writing. Temporary access-token connections cannot prove their granted scopes.
A write is sent once. If Google's answer is lost, the workflow marks it uncertain and does not send it again.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Delete rows or columns
Write
Permanently remove one explicit zero-based row or column range from a sheet.
Permissions and limits
Account permissions
https://www.googleapis.com/auth/spreadsheets
Operation limits
Start is inclusive and end is exclusive, both zero-based. Google validates that end is greater than start and within the selected sheet. Rows or columns shift after deletion. A lost reply remains uncertain and is not retried.
Reconnect older read-only Google OAuth accounts before writing. Temporary access-token connections cannot prove their granted scopes.
A write is sent once. If Google's answer is lost, the workflow marks it uncertain and does not send it again.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Delete sheet
Write
Permanently remove one sheet from an authorized spreadsheet.
Permissions and limits
Account permissions
https://www.googleapis.com/auth/spreadsheets
Operation limits
Permanently deletes the sheet and its cells. Google refuses to delete the final remaining sheet. A lost reply is uncertain and NodeHub does not retry.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Get rows
Read
Read and filter named sheet rows across one or more bounded pages. Use nextPage to resume.
The first range row supplies unique text headers. Use an explicit A1 rectangle with at most 1,000 data rows and 50 columns. Up to ten pages can be scanned per run. Use nextPage to resume larger sheets; scans are not transactional snapshots.
Filters run inside NodeHub after each bounded page read. Numeric comparisons require numeric cells, usually UNFORMATTED_VALUE. Missing cells become empty strings. Result limiting and the 2 MB workflow artifact cap are explicit.
List sheets
Read
Read sheet IDs and titles from an authorized spreadsheet.
Returns sheet metadata, not cell values. This includes all sheets visible in the selected spreadsheet.
Permanently delete spreadsheet
Write
Permanently delete one spreadsheet accessible to the connected Google account.
Permissions and limits
Account permissions
https://www.googleapis.com/auth/drive.file
Operation limits
Permanently deletes the entire spreadsheet without moving it to trash. The connection must have per-file access and Google must confirm it is a spreadsheet the account can delete. Older Sheets connections require reconnection for Drive file access. A lost delete reply is uncertain and is not retried.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Read cells
Read
Read an authorized spreadsheet range using the selected Google account.
One bounded request reads at most ten ranges. Google omits trailing empty rows and columns.
Update a row by column name
Write
Find one row by a named column, then update only the supplied named columns.
Permissions and limits
Account permissions
https://www.googleapis.com/auth/spreadsheets
Operation limits
Reads at most 1,000 data rows and 50 columns. Column names must be unique. Missing and duplicate matches are refused. Only supplied columns are written. Read then write is not atomic; concurrent row moves can target the wrong row.
Reconnect older read-only Google OAuth accounts before writing. Temporary access-token connections cannot prove their granted scopes.
A write is sent once. If Google's answer is lost, the workflow marks it uncertain and does not send it again.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Update cells
Write
Replace values in an explicit A1 range of an authorized spreadsheet.
Permissions and limits
Account permissions
https://www.googleapis.com/auth/spreadsheets
Operation limits
Only the supplied range changes, but every supplied cell can overwrite an existing value.
Reconnect older read-only Google OAuth accounts before writing. Temporary access-token connections cannot prove their granted scopes.
A write is sent once. If Google's answer is lost, the workflow marks it uncertain and does not send it again.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Update matching row
Write
Update one existing row identified by an exact column value. Missing and duplicate matches are refused.
Permissions and limits
Account permissions
https://www.googleapis.com/auth/spreadsheets
Operation limits
The range must be an explicit A1 rectangle within one sheet (quote titles with spaces or punctuation), with at most 1,000 rows and 50 columns. Exactly one formatted cell must match in the chosen column. Missing or duplicate matches are refused, never appended. Read then write is not atomic; concurrent sheet edits can move or change the selected row.
Reconnect older read-only Google OAuth accounts before writing. Temporary access-token connections cannot prove their granted scopes.
A write is sent once. If Google's answer is lost, the workflow marks it uncertain and does not send it again.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Write multiple ranges
Write
Write up to ten separate rectangular ranges in one Google Sheets request.
Permissions and limits
Account permissions
https://www.googleapis.com/auth/spreadsheets
Operation limits
Every input must fill its exact A1 rectangle. The ranges must not overlap. A lost response is uncertain and is not retried.
Reconnect older read-only Google OAuth accounts before writing. Temporary access-token connections cannot prove their granted scopes.
A write is sent once. If Google's answer is lost, the workflow marks it uncertain and does not send it again.
A repeated request may repeat the external action. Review the previous result before retrying a write.
SETUP
Start with a controlled test.
01Connect the intended account
Use the account and permissions required for your process. Review the connection check before configuring a workflow action.
02Review inputs and access
Select a listed operation and map its required inputs. Use test records and add a human approval before writes that need review.
03Confirm the result
Inspect step outputs and confirm the result in Google Sheets. A saved workflow is not a completed provider action.
Data & Docs ยท CONNECTION
