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. Google Sheets is part of Google Workspace: where teams of any size can chat, create, and collaborate. Google Workspace subscribers have access to additional Google Sheets features, including: - Easily add collaborators to projects, see changes as they occur, receive notifications for edits that happen while you’re away, and chat with.
-->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 |
|---|---|---|---|---|
| dataset | True | string | Pick a file. | |
Worksheet | table | True | string | Pick a worksheet. |
| 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 |
|---|---|---|---|---|
| dataset | True | string | Pick a file. | |
Worksheet | table | True | string | Pick a worksheet. |
| 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 |
|---|---|---|---|---|
| dataset | True | string | Pick the file. | |
Worksheet | table | True | string | Pick a worksheet. |
| $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 |
|---|---|---|---|---|
| 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 |
|---|---|---|---|---|
| dataset | True | string | Pick a file. | |
Worksheet | table | True | string | Pick a worksheet. |
| 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 |
|---|---|---|---|---|
| dataset | True | string | Pick a file. | |
Worksheet | table | True | string | Pick a worksheet. |
| 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 | array of Table |
Google Sheets Sign In My Account
Table
Google Sheets
Properties of a specific table.
Google Sheets Download
| Name | Path | Type | Description |
|---|---|---|---|
| Name | string | Summary of the table. | |
Display Name | DisplayName | string | Display name of the table. |