Cobot and Google Sheets automations
Cobot holds coworking bookings and memberships, and Google Sheets logs them as rows through “Add New Row to Sheet”.
Set up an automation: when booking created in Cobot, add multiple rows in Google Sheets
Build itOr have an AI agent work across Cobot and Google Sheets: it decides what to do in each on every run, on a schedule or when you ask it in its chat.
Cobot and Google Sheets in practice
Used for
Cobot holds coworking bookings and memberships, and Google Sheets logs them as rows through “Add New Row to Sheet”.
Best template
“Booking Created” in Cobot, then “Add Multiple Rows” in Google Sheets. Every booking lands in a sheet row, giving you a running list of bookings.
Watch out
“Delete Rows” in Google Sheets removes rows by range or number, so check the range first.
Cobot and Google Sheets templates
Pick one and Captain builds it with you.


When membership confirmed in Cobot, add new row to sheet in Google Sheets
Build this

When booking created in Cobot, delete rows in Google Sheets
Build this

When booking created in Cobot, add multiple rows in Google Sheets
Build this

When booking will begin in Cobot, delete rows in Google Sheets
Build this

When booking will begin in Cobot, add multiple rows in Google Sheets
Build this
Cobot and Google Sheets triggers and actions
Every one of both apps. A trigger starts the work; actions are the steps.
Triggers
21- Booking createdTriggers when a booking is made.
- Booking will beginTriggers when a booking is about to begin.
- Event publishedTriggers when an admin publishes an event.
- Invoice createdTriggers when an invoice is created.
- External booking createdTriggers when an external booking is created.
- Membership cancelledTriggers when a membership is cancelled.
- Membership confirmedTriggers when a membership is confirmed.
- External booking approvedTriggers when an external booking that was pending before is approved.
- Drop in pass purchasedTriggers when an user has bought a drop in pass
- Update bookingTrigger when Update Booking
- Booking beginTrigger when booking_will_begin
- Booking endedTrigger when booking_has_ended
- Delete bookingTrigger when deleted_booking
- Update custom fieldTrigger when updated_custom_field
- Update invoiceTrigger when Update Invoice
- Wrote off invoiceTriggered when an invoice is written off.
- Sent invoiceTriggered when an invoice for a member was sent manually by an admin or automatically via cobot
- Confirme membershipTrigger when Confirme Membership
- Create membershipTriggered when a membership is created.
- Delete membershipTrigger when deleted_membership
- Reactivated membershipTriggered when a membership that was previously canceled has now been reactivated.
No triggers match.
Actions
18- Get membershipsRetrieve a membership or list all memberships; optionally provide a membership ID and select response fields.
- List booking calendar categoriesLists booking calendar categories for the connected space.
- List upcoming bookings for the current memberGet upcoming bookings for the current member; optionally select which response fields to return.
- List recent member bookingsRetrieve a member's recent, not-yet-invoiced bookings; optionally select response fields.
- Get member booking creditsRetrieve remaining booking credits for a selected member.
- List space Check-InsRetrieve space check-ins, optionally filtering by From/To dates or relative days.
- List guest accountsRetrieves guest accounts for the connected coworking space.
- List help desk issuesGet all the help desk issues for the space.
- List invoicesRetrieve invoices for a space; filter by IDs, date range (exact or relative), and select response fields.
- List open invoicesGet a list of open invoices.
- Get member questionnaireFetches the questionnaire shown to members after they sign up.
- List answers for a memberRetrieve a member's answers to the space's questions; optionally select a membership ID.
- List membersList current members of a space; filter by IDs, attributes, or as-of date.
- List payment methodsRetrieves all payment methods for the connected space.
- List plansList membership plans for a space; choose to include team plans, photo size, and response fields.
- List resourcesGet a list of all resources for a space.
- Get activitiesRetrieve activities by date range, by source IDs, or the last N activities.
- Get bookingsRetrieve bookings for a specified date range, with optional limit and selectable response fields.
No actions match.
Triggers
1- Row added or updatedRuns when row added or updated
No triggers match.
Actions
23- Update spreadsheet rowUpdate columns in sheet row
- List rows in sheetGet rows from a sheet tab as objects with row numbers. Supports an optional header row, offset/limit paging, and fetching from the last row.
- Delete rowsDelete one or more rows from a specific sheet in a Google Spreadsheet using a row range or row numbers.
- Add new row to sheetRuns as a step in Google Sheets.
- Lookup spreadsheet rowsFind rows in a Google Sheet that match a column value or an advanced filter.
- Copy sheet to spreadsheetCopy a sheet to another file
- Add multiple rowsAdd one or more rows to a specific sheet in a Google Spreadsheet. Provide data column-by-column or paste a JSON array for bulk inserts. If the sheet has no headers, they will be auto-created from your JSON keys.
- Create subsheetAdd a new subsheet to a spreadsheet and optionally set its position and add column headers in the first row.
- Create sheet columnInsert a new column into the specified Google Sheets sheet at the given index (or append to the end) and optionally set its header.
- Get rows from rangeRetrieve rows from sheet range
- Create a spreadsheetCreate a new spreadsheet.
- Find subsheetSearches a sheet in a spreadsheet by name and returns the sheet name, column titles, and number of rows.
- Get row detailsRetrieve values and metadata for a specific row in a spreadsheet sheet.
- Clear spreadsheet rowClears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.
- Create spreadsheet from templateCreate sheet from template
- List spreadsheetsFetch all spreadsheets
- List spreadsheet tabsLists all tabs (sheets) in a spreadsheet and returns the total count.
- Batch update cell valuesUpdate multiple cells at once
- Format spreadsheet rowFormat row font and background
- Add conditional formatting ruleApply conditional formatting to cells in a Google Sheets spreadsheet based on their values
- Update sheet nameRenames an existing sheet (tab) within a Google Spreadsheet to a new name you specify.
- Update multiple rowsUpdate values in one or more rows of a Google Sheet.
- Permanently delete spreadsheetPermanently delete a spreadsheet from Google Drive, including files on shared drives.
No actions match.
Questions about Cobot and Google Sheets
What can start a Cobot and Google Sheets automation?
“Membership confirmed”, “Booking created” and “Booking will begin”.
Which other apps work with both Cobot and Google Sheets?
Slack, HubSpot, Gmail, Google Calendar and Salesforce. Each one has templates with Cobot and with Google Sheets, so a third app can join the same job.
All Cobot integrations · All Google Sheets integrations · Every app, A to Z