Google Sheets
Real-time meetings by Google. Using your browser, share your video, desktop, and presentations with teammates and customers. New to Google Sheets? Watch our fresh tutorial for beginners!Start using Google Sheets just in 14 minutes (timestamps below):- use basic Google Sheets formul.
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:
- 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.
- Make it count Google Sheets makes your data pop with colorful charts and graphs. Built-in formulas, pivot tables and conditional formatting options save time and simplify common spreadsheet tasks.
| 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 Forms
Table
Properties of a specific table.
Google Sheets Online
| Name | Path | Type | Description |
|---|---|---|---|
| Name | string | Summary of the table. | |
Display Name | DisplayName | string | Display name of the table. |