Google Sheets

Google Sheets

Create, edit, and collaborate on spreadsheets online

Productivity4 triggers21 actions

Triggers

(4)

New or Updated Row

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

New Row Added

Triggers when a new row is added to bottom of a spreadsheet.

New Spreadsheet

Triggers when a new spreadsheet is created.

New Worksheet

Triggers when a worksheet is created in a spreadsheet.

Actions

(21)

Add Row

Add a new row of data to a specific spreadsheet.

Add Multiple Rows

Add multiple rows of data at once to a specific spreadsheet.

Update Row

Update the data in an existing row.

Update Multiple Rows

Updates multiple rows in a specific spreadsheet.

Delete Row

Delete a specific row from the selected sheet.

Find Rows

Look up rows in a worksheet based on a column value.

Create Spreadsheet

Creates a blank spreadsheet.

Create Worksheet

Create a new blank worksheet with a title.

Clear Sheet

Clears all rows on an existing sheet.

Delete Worksheet

Permanently delete a specific worksheet.

Rename Worksheet

Rename specific worksheet.

Format Row(s)

Format one or multiple rows in specific spreadsheet.

Get Single Row by ID

Retrieve a specific row using its unique ID.

Get next row(s)

Get next group of rows from a specifiec workheet

Get All Rows

Get all the rows from a specific sheet.

Find Spreadsheet(s)

Find spreadsheet(s) by name.

Find Worksheet(s)

Finds a worksheet(s) by title.

Copy Worksheet

Creates a new worksheet by copying an existing one.

Create Spreadsheet Column

Creates a new column in a specific spreadsheet.

Export Worksheet

Download a worksheet as a CSV or TSV file.

Custom API Call

Make a custom API call to a specific endpoint

Example automation

Trigger

Event received

from Google Sheets

Action

Create Module Record

in Coherence

Ready to connect Google Sheets?

Start automating in minutes. No credit card required.