Google Sheets

Google drive

The screenshots are from the Google Sheets app for iOS, but instructions are the same on all platforms. How to Write a SUM Function Adding up rows or columns of numbers is a common operation carried out in all spreadsheet programs. Google Sheets is a marketer’s best friend. We recommend the following resources to find excellent marketing spreadsheet tools. Even better, most of them are free. 100+ Google Sheets Templates for Marketers. From Sheets for Marketers, here are templates for audits, competitor research, Google analytics, content planning, and much more. Step 2: Select data from the Google Sheet. We need to identify the specific cells that we want to grab data from within our spreadsheet. In this Sheet, the shifts are in column A-C, rows 8-12. We use this code to port over the data: var signups = spreadsheet.getRange ('A8:C12').getValues. The formula I use to do this is: =GOOGLEFINANCE (“AAPL”,”Price”,date (2016,6,1),date (2016,12,31),”Weekly”) From here, it’s easy to create a chart of the weekly closing price using the charting function in Google Sheets. By using the GOOGLEFINANCE formula to call up different attributes over different time periods and intervals.

-->Login

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:

ServiceClassRegions
Logic AppsStandardAll Logic Apps regions except the following:
- Azure China regions
- US Department of Defense (DoD)
Power AutomateStandardAll Power Automate regions except the following:
- US Government (GCC High)
- China Cloud operated by 21Vianet
- US Department of Defense (DoD)
Power AppsStandardAll Power Apps regions except the following:
- US Government (GCC High)
- China Cloud operated by 21Vianet
- US Department of Defense (DoD)
Contact
NameMicrosoft
URLMicrosoft LogicApps Support
Microsoft Power Automate Support
Microsoft Power Apps Support
Connector Metadata
PublisherMicrosoft
Websitehttps://www.google.com/sheets/about/
Privacy policyhttps://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:

CharacterEncoded value
._x002e_
@_x0040_
:_x003a_
+_x002b_
#_x0023_
/_x002f_
?_x003f_
%_x0025_
&_x0026_
' '_x0020_
~_x007e_
`_x0060_
Sheets

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

NameCallsRenewal Period
API calls per connection100300 seconds
Google sheets online

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

NameKeyRequiredTypeDescription
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

NameKeyRequiredTypeDescription
dataset True string

Pick a file.

Worksheet
table True string

Pick a worksheet.

id True string

Unique identifier of the row to retrieve.

Returns

The outputs of this operation are dynamic.

Google Sheets Sign In My Account

Get rows

This operation retrieves the records from a specific Google Sheet.

Parameters

NameKeyRequiredTypeDescription
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

NameKeyRequiredTypeDescription
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

NameKeyRequiredTypeDescription
dataset True string

Pick a file.

Worksheet
table True string

Pick a worksheet.

item True dynamic

Row to insert into the specified sheet.

Returns

The outputs of this operation are dynamic.

Update row

This operation updates a row in a Google Sheet.

Parameters

NameKeyRequiredTypeDescription
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.

NamePathTypeDescription
value array of Table

Table

Google Sheets Multiselect

Properties of a specific table.

Google Docs

NamePathTypeDescription
Name string

Summary of the table.

Display Name
DisplayName string

Display name of the table.