Google Sheets allows you to create, edit, and collaborate with others in real time. Google Sheets is available on all your devices and has all the features you come to expect from spreadsheet software.
Changelog
26 versions
v4.3.0
Latest
- Added MakeApiCall component for performing arbitrary authorized API calls to the Google Sheets API.
v4.2.0
- Added test() (Flow Test Mode) to polling triggers: NewRow, UpdatedRow.
v4.1.0
- Flexible header matching: headers are now normalized before matching (line breaks replaced with spaces, repeated whitespace collapsed, leading/trailing whitespace trimmed). This makes integrations resilient to minor Google Form edits that alter column header formatting in the linked sheet. Affects: CreateRow, CreateRows, FindRow, GetRows, ListColumns, NewRow, UpdatedRow.
v4.0.3
- Create Rows: handle empty sheets - create header row if the sheet is empty.
v4.0.2
- Handled the case in Count Rows if there are no rows in the spreadsheet.
v4.0.1
- Create Row, Create Rows, Delete Rows: Added `spreadsheets.readonly` scope, as it is necessary for obtaining dynamic input values for the 'Worksheet' field.
v4.0.0
- Breaking Change: The `drive.metadata.readonly` scope has been changed to `drive.readonly`. Affected components: CountRows, CreateRow, DeleteRow, FindRow, GetRows, NewRow, UpdatedRow. Migration: you need to re-authenticate affected components mentioned above.
v3.1.4
- Bug Fix: CountRows, CreateRow, FindRow, GetRows, NewRow, and UpdatedRow - encode worksheet names to support sheets with special characters in the sheet name.
v3.1.2
- Bug Fix: CreateRow action throws an error when the spreadsheet is empty.
v3.0.1
- (Breaking Change): The `drive.metadata.readonly` scope has been added wherever it was previously missing. Affected components: CountRows, CreateRow, DeleteRow, FindRow, GetRows, NewRow, UpdatedRow. Migration: you need to re-authenticate affected components mentioned above.
- (Breaking Change): Updated the NewRow trigger to include a required input field, Index Column, used to monitor a specific column for detecting new rows in the spreadsheet.
v2.0.2
- Updated the CreateRow action to append new row at the end of the spreadsheet, removing the need to fetch all range of rows.
v2.0.1
- Replace the legacy scope of v3, https://spreadsheets.google.com/feeds, with the updated scope `auth/spreadsheets`. For read-only operations, is the `auth/spreadsheets.readonly` used as an alternative.
- Migration steps: re-authenticate all Google spreadsheets components in your flows.
v1.2.8
- Added quotas for all components.
v1.2.7
- Updated the `ListColumns` to fetch only first row.
v1.2.6
- Fixed the issue of column mismatch in CreateRow.
v1.2.5
- CreateRows when a 'New column' is already in the Spreadsheet, it won't be created again.
v1.2.4
- Added missing dependency getAuthLibraryOAuth2Client.
v1.2.3
- CreateRows File ID tooltip changed.
v1.2.2
- CreateRows remove cells from error message.
v1.2.1
- CreateRows connector fixed.
v1.2.0
- CreateRows connector added.
v1.1.0
- Add Google branded sign-in button.
v1.0.4
- Add column indexes to ListColumns to correct ordering when rendering inspector.
v1.0.3
- ListSheets supports paging.
v1.0.2
- CreateRow - package.json removed.
v1.0.0
- Initial version
Authentication
| Type | Details |
|---|---|
| OAuth 2 |
Scopes:
profile
email
|
Triggers
2
New Row
This trigger fires whenever a new row is added to your Google Spreadsheet. It works by monitoring a specific column (chosen by you) as the 'Index Column'. The worksheet must have a header row for proper operation. Note: The trigger is optimized for detecting rows added at the bottom of the sheet. If rows are added in between existing rows, or if there are non-unique values in the index column, the trigger may not function as expected.
Additional Scopes:
...oogleapis.com/auth/spreadsheets.readonly
...//www.googleapis.com/auth/drive.readonly
Updated Row
This trigger fires any time a row is updated to your spreadsheet.
Additional Scopes:
...oogleapis.com/auth/spreadsheets.readonly
...//www.googleapis.com/auth/drive.readonly
Actions
7
Count Rows
This component creates a new project.
Additional Scopes:
...oogleapis.com/auth/spreadsheets.readonly
...//www.googleapis.com/auth/drive.readonly
Create Row
Create a new row in your spreadsheet. There has to be a header row in your worksheet before a row can be added.
Additional Scopes:
...s://www.googleapis.com/auth/spreadsheets
...oogleapis.com/auth/spreadsheets.readonly
...//www.googleapis.com/auth/drive.readonly
Create Rows
Add rows to Google Spreadsheet from a file. This allows you to add millions of rows in the Spreadsheet.
Additional Scopes:
...s://www.googleapis.com/auth/spreadsheets
...oogleapis.com/auth/spreadsheets.readonly
...//www.googleapis.com/auth/drive.readonly
Delete Rows
This component deletes rows in worksheet.
Additional Scopes:
...s://www.googleapis.com/auth/spreadsheets
...oogleapis.com/auth/spreadsheets.readonly
...//www.googleapis.com/auth/drive.readonly
Find Row
This component finds row in a sheet.
Additional Scopes:
...oogleapis.com/auth/spreadsheets.readonly
...//www.googleapis.com/auth/drive.readonly
Get Rows
This component retrieves rows from a spreadsheet.
Additional Scopes:
...oogleapis.com/auth/spreadsheets.readonly
...//www.googleapis.com/auth/drive.readonly
Make Api Call
Generic method for making API calls to a 3rd party service.
Additional Scopes:
...s://www.googleapis.com/auth/spreadsheets
...//www.googleapis.com/auth/drive.readonly