Google Sheets

  • Reference

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

This connector is available in the post-obit products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
-   Azure China regions
-   US Department of Defense (DoD)
Power Automate Standard All Power Automate regions except the post-obit:
-   United states Authorities (GCC High)
-   People's republic of china Deject operated by 21Vianet
-   US Department of Defense (DoD)
Ability Apps Standard All Power Apps regions except the following:
-   The states Government (GCC High)
-   China Cloud operated by 21Vianet
-   US Department of Defense (DoD)
Contact
Name Microsoft
URL Microsoft LogicApps Support
Microsoft Power Automate Back up
Microsoft Power Apps Support
Connector Metadata
Publisher Microsoft
Website https://world wide web.google.com/sheets/virtually/
Privacy policy https://policies.google.com/privacy

Known Issues and Limitations

  • Simultaneous file modifications made past other flow runs, parallel foreach executions, and manual edits are non supported.
  • Shared spreadsheets are not visible through the file picker UI component in Power Automate/Logic Apps. As a workaround yous tin provide shared spreadsheet ID equally custom value input. This ID is the value betwixt the "/d/" and the "/edit" in the URL of your spreadsheet. For example, consider the following URL that references a Google Sheets spreadsheet: https://docs.google.com/spreadsheets/d/ spreadsheetId /edit#gid=0
  • Spreadsheets located in shared drives cannot be selected in any platform. You lot can use a workaround mentioned in the previous step in case of Power Automate/Logic Apps.

Cavalcade names handling

Please note that cavalcade names in the activity's response results may be transformed in order to be compatible with OData format:

Character Encoded value
. _x002e_
@ _x0040_
: _x003a_
+ _x002b_
# _x0023_
/ _x002f_
? _x003f_
% _x0025_
& _x0026_
' ' _x0020_
~ _x007e_
` _x0060_

E.one thousand. Column [one]#1 -> Column_x0020_[one]_x0023_1

Characters wrapped into brackets at the end (only) of a column proper noun will be excluded, please run into example: Cavalcade [group] -> Cavalcade

Throttling Limits

Proper noun Calls Renewal Flow
API calls per connection 100 300 seconds

Actions

Delete Row

This functioning is used to call back a row from a Google Sheet.
Go row

This operation retrieves a single row from a Google Sheet.
Become rows

This functioning retrieves the records from a specific Google Sheet.
Get sheets

Retrieves sheet names from a Google Sheet file
Insert row

This functioning 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 call back a row from a Google Canvas.

Parameters

Proper name Primal 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.

Go row

This operation retrieves a single row from a Google Sheet.

Parameters

Proper noun Cardinal Required Blazon Description
File
 dataset True string

Pick a file.
Worksheet
 table True string

Option 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 functioning retrieves the records from a specific Google Sheet.

Parameters

Name Key Required Type Description
File
 dataset True string

Selection the file.
Worksheet
 table Truthful string

Pick a worksheet.
Top Count
 $height integer

Full 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.

Become 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.

Insert row

This functioning is used to insert a new row in a Google Sail.

Parameters

Name Key Required Type Description
File
 dataset True string

Pick a file.
Worksheet
 table True string

Pick a worksheet.
Row
 particular True dynamic

Row to insert into the specified sail.

Returns

The outputs of this performance are dynamic.

Update row

This operation updates a row in a Google Sail.

Parameters

Name Key Required Type Description
File
 dataset True string

Pick a file.
Worksheet
 table True cord

Choice a worksheet.
Row id
 id True string

Unique identifier of the row to update.
Row
 item Truthful dynamic

Row with updated values.

Returns

The outputs of this operation are dynamic.

Definitions

TablesList

Listing of 1 or multiple tables.

Name Path Blazon Description
value
 value array of Table

Table

Backdrop of a specific table.

Proper noun Path Type Description
Name
 Name string

Summary of the table.
Brandish Proper noun
 DisplayName string

Display name of the tabular array.