How to Add a New Sheet in Google Sheets
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
- Feedback
- Edit
Google Sheets
- Reference
Thank you.

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.
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. |
Thank you.
Feedback
How to Add a New Sheet in Google Sheets
Source: https://docs.microsoft.com/en-us/connectors/googlesheet/
0 Response to "How to Add a New Sheet in Google Sheets"
Post a Comment