Google Sheets Integration Details. Being able to collect, track, and analyze your data is essential for any business. Using Google Sheets with Zapier, you can automatically create and edit spreadsheets with data from other apps you use. Zapier can monitor changes in your Google Sheets and quickly share your important data with stakeholders. No expensive software required — Google Sheets is always 100% free. It works across devices. Modern marketers switch between devices throughout the day — and Google Sheets accommodates that behavior. You can access and edit Google Sheet data from a wide variety of devices (like your smartphone, tablet, and computer). Add-ons are available.
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.
Google Sheets App
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
Google Sheets Login
| 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 |
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. |