Google Sheets
Read, append, update, clear, search rows, and manage sheets in Google Sheets spreadsheets.
Overview
Read and write data in Google Sheets — use it as a simple database, a reporting output, or a data source. Supports batch updates, row search, and sheet metadata retrieval.
How to configure
Navigate to Integrations in your Collabase Workspace Settings.
Click Connect Account and configure your authentication credentials.
Available Triggers
| Name | Parameters |
|---|---|
| New Row Added | A new row is appended to a tracked sheet |
| Row Updated | An existing row's content is changed |
Available Actions
| Name | Parameters |
|---|---|
| Get Row(s) | spreadsheetId, range (A1 notation) |
| Append Row | spreadsheetId, sheetName, values[] |
| Update Row | spreadsheetId, range, values[][] |
| Clear Range | spreadsheetId, range |
| Find Row | spreadsheetId, sheetName, column, value |
| Batch Update | spreadsheetId, data[] (range + values pairs) |
| List Sheets | spreadsheetId |
| Create Sheet | spreadsheetId, title |
| Get Spreadsheet Info | spreadsheetId |
Related integrations. Other connectors that are often used together.
Monday.com
Collabase
Create and update items, post updates, search boards, and respond to Monday.com events.
Notion
Collabase
Create and update Notion pages, query databases, append blocks, and search your workspace.
Outlook Calendar
Collabase
Manage Microsoft 365 calendar events, respond to meeting requests, and check scheduling availability.
Trello
Collabase
Create and manage cards, add comments and labels, and respond to Trello board events.
HTTP
Collabase
Make GET, POST, PUT, PATCH, and DELETE requests to any external API.
HubSpot
Collabase
Manage contacts, deals, companies, tickets, notes, and tasks in HubSpot CRM.