Google Sheets (OAuth)

Google Sheets (OAuth) node reference - all 60 operations, the credential it needs, and a worked example.

Google Sheets via a connected Google account (OAuth). Read, write, clear and search values; manage spreadsheets, tabs, rows and columns; sort, filter, format, protect and validate ranges.

Credential: Google (OAuth) - see Credentials.

Scopes

Each operation below lists the scope it needs. Scopes are ticked as a scope preset when you connect the Google account, then consented to on Google's screen. If a run fails with a permission error, the node names the missing scope in the error - grant it and re-run; you do not need to rebuild the workflow.

Operations (60)

Read values

Operation	What it does	Scope
`readRange`	Read range	`spreadsheets.readonly`
`batchGet`	Read multiple ranges	`spreadsheets.readonly`
`batchGetByDataFilter`	Read ranges by data filter	`spreadsheets.readonly`
`findRow`	Find row by value	`spreadsheets.readonly`
`getLastRow`	Get last row	`spreadsheets.readonly`

Write values

Operation	What it does	Scope
`appendRow`	Append row	`spreadsheets`
`batchAppend`	Append rows	`spreadsheets`
`updateRange`	Update range	`spreadsheets`
`batchUpdateValues`	Update multiple ranges	`spreadsheets`
`batchUpdateValuesByDataFilter`	Update ranges by data filter	`spreadsheets`

Clear values

Operation	What it does	Scope
`clearRange`	Clear range	`spreadsheets`
`batchClear`	Clear multiple ranges	`spreadsheets`
`batchClearByDataFilter`	Clear ranges by data filter	`spreadsheets`

Spreadsheet

Operation	What it does	Scope
`createSpreadsheet`	Create spreadsheet	`spreadsheets + drive`
`getSheetMetadata`	Get spreadsheet metadata	`spreadsheets.readonly`
`getSpreadsheetByDataFilter`	Get spreadsheet by data filter	`spreadsheets.readonly`
`updateSpreadsheetProperties`	Update spreadsheet properties	`spreadsheets`

Sheets (tabs)

Operation	What it does	Scope
`addSheet`	Add sheet (tab)	`spreadsheets`
`deleteSheet`	Delete sheet	`spreadsheets`
`duplicateSheet`	Duplicate sheet	`spreadsheets`
`renameSheet`	Rename / update sheet	`spreadsheets`
`copySheetToSpreadsheet`	Copy sheet to another spreadsheet	`spreadsheets`

Rows & columns

Operation	What it does	Scope
`deleteRow`	Delete row	`spreadsheets`
`deleteDimension`	Delete rows or columns	`spreadsheets`
`insertDimension`	Insert rows or columns	`spreadsheets`
`appendDimension`	Append rows or columns	`spreadsheets`
`moveDimension`	Move rows or columns	`spreadsheets`
`updateDimensionProperties`	Resize or hide rows/columns	`spreadsheets`
`autoResizeDimensions`	Auto-resize columns	`spreadsheets`

Cells & ranges

Operation	What it does	Scope
`mergeCells`	Merge cells	`spreadsheets`
`unmergeCells`	Unmerge cells	`spreadsheets`
`insertRange`	Insert cells	`spreadsheets`
`deleteRange`	Delete cells	`spreadsheets`
`copyPaste`	Copy & paste range	`spreadsheets`
`cutPaste`	Cut & paste range	`spreadsheets`
`pasteData`	Paste delimited data	`spreadsheets`
`trimWhitespace`	Trim whitespace	`spreadsheets`
`randomizeRange`	Randomize rows	`spreadsheets`
`autoFill`	Auto-fill range	`spreadsheets`

Data tools

Operation	What it does	Scope
`findReplace`	Find & replace	`spreadsheets`
`sortRange`	Sort range	`spreadsheets`
`deleteDuplicates`	Remove duplicate rows	`spreadsheets`
`textToColumns`	Split text to columns	`spreadsheets`
`setBasicFilter`	Set filter	`spreadsheets`
`clearBasicFilter`	Clear filter	`spreadsheets`

Formatting & rules

Operation	What it does	Scope
`formatCells`	Format cells	`spreadsheets`
`setDataValidation`	Set data validation	`spreadsheets`
`clearDataValidation`	Clear data validation	`spreadsheets`
`addConditionalFormatRule`	Add conditional format rule	`spreadsheets`
`deleteConditionalFormatRule`	Delete conditional format rule	`spreadsheets`
`addProtectedRange`	Protect range	`spreadsheets`
`deleteProtectedRange`	Remove range protection	`spreadsheets`
`addNamedRange`	Add named range	`spreadsheets`
`deleteNamedRange`	Delete named range	`spreadsheets`

Developer metadata

Operation	What it does	Scope
`createDeveloperMetadata`	Create developer metadata	`spreadsheets`
`updateDeveloperMetadata`	Update developer metadata	`spreadsheets`
`deleteDeveloperMetadata`	Delete developer metadata	`spreadsheets`
`getDeveloperMetadata`	Get developer metadata	`spreadsheets.readonly`
`searchDeveloperMetadata`	Search developer metadata	`spreadsheets.readonly`

Advanced

Operation	What it does	Scope
`batchUpdateRaw`	Run raw batchUpdate requests	`spreadsheets`

Example

Create this month's report spreadsheet in your own Drive

A monthly schedule trigger kicks off the reporting run, and the first node creates a brand-new spreadsheet in the connected account's Drive. This is where the OAuth node earns its keep: creating a spreadsheet creates a Drive file, and a service account owns no personal Drive storage, so the service-account twin can 403 on quota unless the file lands in a Shared Drive. Here the file is simply owned by the signed-in user.

Set Operation to createSpreadsheet, then fill in:

Field	Value	Notes
`newSpreadsheetTitle`	`Revenue report {{trigger.month}}`	Supports expressions
`requestJson`	`{"sheets":[{"properties":{"title":"Summary"}}]}`	Optional: merged into the create request, so the file starts with the tab you want

Sets {{report.spreadsheetId}}, {{report.spreadsheetUrl}} and {{report.title}}. The next Google Sheets node pastes {{report.spreadsheetId}} into its own Spreadsheet ID field.

Google Sheets (OAuth)

On this page