Productivity
Google Sheets integration for your workflows.
Connect Google Sheets to Collabase once and use 27 actions and 4 triggers in your workflows. No code needed, hosted in Switzerland.
Google Sheets in Collabase
Connect Google Sheets to Collabase once and use 27 actions and 4 triggers in your workflows. No code needed, hosted in Switzerland.
About the service
Create, edit, and collaborate on spreadsheets online
How to connect it
- Open the integrations in the workspace settings.
- Choose Google Sheets and connect your account.
- Add a trigger or an action to the workflow.
Google Sheets triggers
| Name | Description | Fields |
|---|---|---|
| New or Updated RowInstant via webhook | Triggers when a new row is added or modified in a spreadsheet. |
|
| New Row AddedInstant via webhook | Triggers when a new row is added to the bottom of a worksheet. |
|
| New SpreadsheetChecks at intervals | Triggers when a new spreadsheet is created. |
|
| New WorksheetChecks at intervals | Triggers when a worksheet is created in a spreadsheet. |
|
Google Sheets actions
| Name | Description | Fields |
|---|---|---|
| Add Row | Add a new row of data to a specific spreadsheet. |
|
| Add Row at Top | Inserts a new row at the top of a worksheet, just below the header row. |
+ 1
|
| Add Multiple Rows | Add multiple rows of data at once to a specific spreadsheet. |
+ 4
|
| Update Row | Update the data in an existing row. |
+ 1
|
| Update Multiple Rows | Updates multiple rows in a specific spreadsheet. |
+ 1
|
| Delete Row | Delete a specific row from the selected sheet. |
|
| Delete Multiple Rows | Deletes a contiguous range of rows, or a list of specific row numbers. Row numbers are 1-based. |
+ 1
|
| Find Rows | Look up rows in a worksheet based on a column value. |
+ 4
|
| Find or Create Row | Look up a row by column value; if no match is found, create a new row with the provided values. |
+ 5
|
| Create Spreadsheet | Creates a blank spreadsheet. |
|
| Create Worksheet | Create a new blank worksheet with a title. |
|
| Find or Create Worksheet | Look up a worksheet by title in a spreadsheet; if not found, create it with optional headers. |
|
| Clear Sheet | Clear every row on a worksheet, keeping the worksheet itself. |
|
| Clear Row(s) | Clears the contents of one or more rows without removing the rows themselves. Useful when you want to keep formatting and references stable. |
|
| Delete Worksheet | Permanently delete a specific worksheet. |
|
| Rename Worksheet | Give an existing worksheet a new title. |
|
| Format Row(s) | Apply colour and text styling to one or more rows. |
+ 4
|
| Get Row by Number | Retrieve one row by its row number. |
|
| Get Next Rows | Read the next batch of rows from a worksheet, continuing where the last run left off. A batch of only blank rows returns an empty list mid-sheet, so do not stop at the first empty result. |
+ 3
|
| Get All Rows | Read every row from a worksheet. |
|
| Read Data Range | Read cells from a range using A1 notation (e.g. A1:D10). Returns rows and the resolved range. |
|
| Find Spreadsheet(s) | Find spreadsheet(s) by name. |
|
| Find Worksheet(s) | Find worksheets in a spreadsheet by title. |
|
| Copy Worksheet | Creates a new worksheet by copying an existing one. |
|
| Create Column | Add a new column to a worksheet. |
|
| Export Worksheet | Download a worksheet as a CSV or TSV file. |
|
| Custom API Call | Make a custom API call to a specific endpoint |
+ 3
|
Productivity
Related integrations
Tools that often share a workflow.
Questions about Google Sheets
What can I automate with Google Sheets in Collabase?
Google Sheets brings 27 actions and 4 triggers, for example Add Row, Add Row at Top, Add Multiple Rows, Update Row and 23 more. You combine them in a workflow without code and mix them with every other integration.
How do I connect Google Sheets to Collabase?
You open the integrations in the workspace settings, choose Google Sheets and connect your account once, using OAuth 2.0. After that all triggers and actions are available in the workflow.
Can Google Sheets start a workflow?
Yes. Google Sheets provides 4 triggers, for example New or Updated Row, New Row Added, New Spreadsheet and 1 more. The workflow runs as soon as the event happens.
Does the Google Sheets integration cost extra?
No. All integrations are included in every licence, in the Isolated Cloud and in Self-Hosted operation. There is no module price.
Test it against your own content. A proof of concept is ready within days.
We set up an instance with your content and you test it against real workflows. In a first conversation we clarify scope, operating model and timing.
