Connect Smartsheet with the Microsoft Office 365 tools your teams use to get work done, so they can be even more productive. Smartsheet seamlessly integrates with Microsoft Office 365. This is a great example of how (the) interoperability of. Hence bug feedback here. Bug #2: Microsoft Compatability mode: all my spreadsheets have dates in the default format xx/xx/xxxx which depends on operating system settings. ChromeOS Settings Set date shows dd/mm/yyyy which is correct for me. But all dates in Sheets are showing mm/dd/yyyy; ie: Sheets does not respect the locale's date format.
If you are looking for a free Microsoft Excel® templates, below you will find a comprehensive list of excel spreadsheet templates and calculators created by Spreadsheet123.com. Vast majority of spreadsheet templates on this page are created with purpose to become a solution for practically any occasion in your life, whether your are moving home or placing kids to college, getting ready for your retirement or simply trying to figure out ways to save money, sorting out your personal finance or taking care of your growing business paperwork, spreadsheets always were and will still be, by far the best and most affordable to start.
-->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 |
| Power Automate | Standard | All Power Automate regions except the following: - US Government (GCC High) - China Cloud operated by 21Vianet |
| Power Apps | Standard | All Power Apps regions except the following: - US Government (GCC High) - China Cloud operated by 21Vianet |
| 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
HPageBreaks
Definitions
TablesList
List of one or multiple tables.
Fax Covers - Office.com
| Name | Path | Type | Description |
|---|---|---|---|
| value | array of Table |
Microsoft Sheets Definition
Table
Properties of a specific table.
Delete
| Name | Path | Type | Description |
|---|---|---|---|
| Name | string | Summary of the table. | |
Display Name | DisplayName | string | Display name of the table. |