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 - US Department of Defense (DoD) |
| Power Automate | Standard | All Power Automate regions except the following: - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Power Apps | Standard | All Power Apps regions except the following: - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Contact | |
|---|---|
| Name | Microsoft |
| URL | Microsoft LogicApps Support Microsoft Power Automate Support Microsoft Power Apps Support |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
| Website | https://www.google.com/sheets/about/ |
| Privacy policy | https://policies.google.com/privacy |
Known Issues and Limitations
- Simultaneous file modifications made by other flow runs, parallel foreach executions, and manual edits are not supported.
- Shared spreadsheets are not visible through the file picker UI component in Power Automate/Logic Apps. As a workaround you can provide shared spreadsheet ID as custom value input. This ID is the value between 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 can use a workaround mentioned in the previous step in case of Power Automate/Logic Apps.
Column names handling
Please note that column names in the action'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.g. Column [one]#1 -> Column_x0020_[one]_x0023_1
Characters wrapped into brackets at the end (only) of a column name will be excluded, please see example:
Column [group] -> Column
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. |
| 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
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
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
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
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. |