Google Sheets

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

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure China regions
Flow Standard All Flow regions
PowerApps Standard All PowerApps regions

Throttling Limits

Name Calls Renewal Period
API calls per connection100300 seconds

Actions

Delete Row

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

Get row

This operation retrieves a single row from a Google Sheet.

Get rows

This operation retrieves the records from a specific Google Sheet.

Get sheets

Retrieves sheet names from a Google Sheet file

Insert row

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

Update row

This operation updates a row in a Google Sheet.

Delete Row

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

Parameters

Name Key Required Type Description
File
dataset True string

Pick a file.

Worksheet
table True string

Pick a worksheet.

Row id
id True string

Unique identifier of the row to delete.

Get row

This operation retrieves a single row from a Google Sheet.

Parameters

Name Key Required Type Description
File
dataset True string

Pick a file.

Worksheet
table True string

Pick a worksheet.

Row id
id True 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.

Parameters

Name Key Required Type Description
File
dataset True string

Pick the file.

Worksheet
table True string

Pick a worksheet.

Top Count
$top integer

Total number of entries to retrieve (default = 256).

Skip Count
$skip 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

Parameters

Name Key Required Type Description
File
dataset True string

Specify the file

Returns

List of one or multiple tables.

Tables List
TablesList

Insert row

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

Parameters

Name Key Required Type Description
File
dataset True string

Pick a file.

Worksheet
table True string

Pick a worksheet.

Row
item True 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.

Parameters

Name Key Required Type Description
File
dataset True string

Pick a file.

Worksheet
table True string

Pick a worksheet.

Row id
id True string

Unique identifier of the row to update.

Row
item True dynamic

Row with updated values.

Returns

The outputs of this operation are dynamic.

Definitions

TablesList

List of one or multiple tables.

Name Path Type Description
value
value array of Table

Table

Properties of a specific table.

Name Path Type Description
Name
Name string

Summary of the table.

Display Name
DisplayName string

Display name of the table.