Spreadsheets

Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Explore tons of pre-built templates

Start automating common business processes immediately with tons of prebuilt templates.
You can use them as they are or customize them to suit your needs

Supported
Triggers, Searches, Filters, and Actions

Search

Search Rows (Advanced)

Returns results matching the given criteria. This module doesn't return a row number.

Search

Search Rows

Returns results matching the given criteria.

Search

Get Range Values

Gets a range content.

Search

Get Many Spreadsheet Rows (Advanced, With Line Item Support)

Returns many rows (20 max.) as a single JSON value and flat rows (line items).

Search

Find Many Spreadsheet Rows (With Line Item Support)

Finds many matched rows (10 max.) by a column and value.

Search

Lookup Spreadsheet Row

Finds a row by a column and value. Returns the entire row if one is found.

Trigger

Watch Rows

Watches for new rows.

Trigger

Watch Changes INSTANT

Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.

Action

Perform a Function INSTANT

Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.

Trigger

New Spreadsheet

Triggered when you create a new spreadsheet.

Trigger

New Worksheet

Triggered when you create a new worksheet in a spreadsheet.

Trigger

New or Updated Spreadsheet Row (Team Drive)

Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.

Trigger

New Spreadsheet Row (Team Drive)

Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.

Action

New or Updated Spreadsheet Row

Triggered when a new row is added or modified in a spreadsheet.

Action

New Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

Action

Update a Row

Updates a row.

Action

Update a Cell

Updates a specific cell.

Action

Perform a Function

Responder Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.

Action

Get a Cell

Gets a specific cell.

Action

Delete a Row

Deletes a specific row.

Action

Create a Spreadsheet

Creates a new spreadsheet.

Action

Clear a Row

Clears values from a specific row.

Action

Clear a Cell

Cleares a specific cell.

Action

Add a Sheet

Adds a new sheet.

Action

Add a Row

Appends a new row to the bottom of the table.

Action

Create Spreadsheet

Create a blank spreadsheet with a title. Optionally, provide headers.

Action

Delete Spreadsheet Row

Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.

Action

Create Spreadsheet Column

Create a new column in a specific spreadsheet.

Action

Create Spreadsheet Row(s)

Create one or more new rows in a specific spreadsheet (with line item support).

Action

Update Spreadsheet Row

Update a row in a specific spreadsheet.

Action

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

Action

Create Worksheet

Create a blank worksheet with a title. Optionally, provide headers.

Available Datasets

No items found.

Frequently Asked Questions

What kind of credentials do I need to power up the Google Sheets connector?

You need Google username and password.

How do I know my Google account credentials are secure?

Domo's Google Sheets connector uses OAuth, which authenticates the account with Google without Domo ever having access to your Google account credentials.

How frequently will my data update?

As often as needed.

Are there any API limits that I need to be aware of?

Google enforces total and concurrent call rate limits. To prevent rate limiting, reduce the number of datasets scheduled to run at the same time.

Why does the connector seem to be pulling in unwanted data?

Confirm if you have selected the correct Google Sheet worksheet. If you are using advanced options, make sure you have selected the correct range of data.

Alternative Connectors

Ready to start automating?

Getting started with Easyflow is simple, secure and there's no installation required.

1. Choose your apps

Select and authorize the apps you want to sync.

2. Connect

Hundreds of prebuilt templates

3. Let it start!

Set it and forget it, Easyflow will take over from here!