Google Sheets will correctly convert formats between locales when importing from one spreadsheet to another. To ask a question about the add-on or to report a bug, post a message the google-analytics-spreadsheet-add-on Google group. Search the group before posting as your question may have already been answered.
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 |
- Google Spreadsheets is a Web-based application that allows users to create, update and modify spreadsheet s and share the data live online. The Ajax -based program is compatible with Microsoft Excel and CSV (comma-separated values) files. Spreadsheets can also be saved as HTML.
- 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.
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
Google Sheets Formulas
Update row
Google Sheets Templates
This operation updates a row in a Google Sheet.
Google Sheets Budget Template
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
Google Drive
Definitions
TablesList
List of one or multiple tables.
| Name | Path | Type | Description |
|---|---|---|---|
| value | array of Table |
Table
Properties of a specific table.
| Name | Path | Type | Description |
|---|---|---|---|
| Name | string | Summary of the table. | |
Display Name | DisplayName | string | Display name of the table. |