Google Sheets

Spreadsheets: read, write, and append rows, and react to sheet changes

Google Sheets API reference Google Sheets overview

Signs in with: OAuth 2.0 sign-in
Runs on: Cloud or On-Prem Worker
Operations: 17
Ready-made triggers: 0

Connect Google Sheets

In Neblex open Connect › Connections and click Connect a Service.
Choose Google Sheets and whether the connection is shared across the workspace or used in one project.
Click Authorize and approve access in the window that opens. The connection is created.

For services offered under Connect a Service you only sign in and approve access. Otherwise use Connect with OAuth2 with your own OAuth app. See Authorize with OAuth.

There are no fields to fill in: you sign in to Google Sheets and approve access.

Use it in a flow

Open a flow, open the node library and search for Google Sheets.
Drag it onto the canvas and choose an Operation and your connection.
Map the operation's fields from earlier steps, or click Map with Matt.
Use Test this step to see what it returns, then save.

To start a flow from Google Sheets without a ready-made trigger: a Poll for changes trigger can check one of its list operations on a schedule and pass on only what is new; if Google Sheets can send webhooks, a Webhook trigger receives them at its own URL.

Operations

17 operations in 1 groups. Each one is a step you can add to a flow.

Spreadsheet17

Create spreadsheet`sheets_spreadsheets_batchUpdate`	POST	Applies one or more updates to the spreadsheet.
Create spreadsheet`sheets_spreadsheets_create`	POST	Creates a spreadsheet, returning the newly created spreadsheet.
Create spreadsheet`sheets_spreadsheets_getByDataFilter`	POST	Returns the spreadsheet at the given ID.
Create spreadsheet`sheets_spreadsheets_sheets_copyTo`	POST	Copies a single sheet from a spreadsheet to another spreadsheet.
Create spreadsheet`sheets_spreadsheets_values_append`	POST	Appends values to a spreadsheet.
Create spreadsheet`sheets_spreadsheets_values_clear`	POST	Clears values from a spreadsheet.
DeveloperMetadata:search spreadsheet`sheets_spreadsheets_developerMetadata_search`	POST	Returns all developer metadata matching the specified DataFilter.
Get spreadsheet`sheets_spreadsheets_developerMetadata_get`	GET	Returns the developer metadata with the specified ID.
Get spreadsheet`sheets_spreadsheets_get`	GET	Returns the spreadsheet at the given ID.
Get spreadsheet`sheets_spreadsheets_values_get`	GET	Returns a range of values from a spreadsheet.
Replace spreadsheet`sheets_spreadsheets_values_update`	PUT	Sets values in a range of a spreadsheet.
Values:batchClear spreadsheet`sheets_spreadsheets_values_batchClear`	POST	Clears one or more ranges of values from a spreadsheet.
Values:batchClearByDataFilter spreadsheet`sheets_spreadsheets_values_batchClearByDataFilter`	POST	Clears one or more ranges of values from a spreadsheet.
Values:batchGet spreadsheet`sheets_spreadsheets_values_batchGet`	GET	Returns one or more ranges of values from a spreadsheet.
Values:batchGetByDataFilter spreadsheet`sheets_spreadsheets_values_batchGetByDataFilter`	POST	Returns one or more ranges of values that match the specified data filters.
Values:batchUpdate spreadsheet`sheets_spreadsheets_values_batchUpdate`	POST	Sets values in one or more ranges of a spreadsheet.
Values:batchUpdateByDataFilter spreadsheet`sheets_spreadsheets_values_batchUpdateByDataFilter`	POST	Sets values in one or more ranges of a spreadsheet.