Google Sheets

Google Sheets

Connect to Google Sheets to manage your spreadsheets. You can create, edit, and collaborate with others on spreadsheets.

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 300 seconds

Actions

Delete Row

This operation is used to retrieve a row from a Google Sheet.

Required Parameters

File
string
Pick a file.
Worksheet
string
Pick a worksheet.
Row id
string
Unique identifier of the row to delete.

Get row

This operation retrieves a single row from a Google Sheet.

Required Parameters

File
string
Pick a file.
Worksheet
string
Pick a worksheet.
Row id
string
Unique identifier of the row to retrieve.

Returns

The outputs of this operation are dynamic.

Get rows

This operation retrieves the records from a specific Google Sheet.

Required Parameters

File
string
Pick the file.
Worksheet
string
Pick a worksheet.

Optional Parameters

Top Count
integer
Total number of entries to retrieve (default = 256).
Skip Count
integer
Number of entries to skip (default = 0).

Returns

The outputs of this operation are dynamic.

Get sheets

Retrieves sheet names from a Google Sheet file

Required Parameters

File
string
Specify the file

Returns

Tables List
TablesList

List of one or multiple tables.

Insert row

This operation is used to insert a new row in a Google Sheet.

Required Parameters

File
string
Pick a file.
Worksheet
string
Pick a worksheet.
Row
dynamic
Row to insert into the specified sheet.

Returns

The outputs of this operation are dynamic.

Update row

This operation updates a row in a Google Sheet.

Required Parameters

File
string
Pick a file.
Worksheet
string
Pick a worksheet.
Row id
string
Unique identifier of the row to update.
Row
dynamic
Row with updated values.

Returns

The outputs of this operation are dynamic.

Definitions

TablesList

List of one or multiple tables.

value
array of Table
List of one or multiple tables.

Table

Properties of a specific table.

Display Name
string
Display name of the table.
Name
string
Summary of the table.