Connect Whereby and Google Sheets

Whereby runs video meetings in the browser, often embedded in your own site. FlowMattic logs its events in Google Sheets from your WordPress site: sessions that start and end, people joining and leaving, finished recordings and transcriptions. Coaches, clinics and online schools get a meeting log they can bill, report and audit from.

Try FlowMattic free See example workflows

15 triggers 19 actions 7 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Whereby9 triggers

Do this in Google Sheets19 actions

1. TriggerSession Started

2. ActionAdd New Row

When Whereby fires Session Started, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Whereby and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Ready-made template

Log each Whereby session as it starts

Every session that begins becomes a row with the room and start time, which gives you a dated record of every meeting that actually happened.

Session StartedAdd New Row

View the template

Add the end time to the session's row

When the session ends, find the room's open row and write the end time, so a formula gives the length of each meeting for billing.

Session EndedLookup Row DataUpdate Row

Keep an attendance register for classes

Each participant who joins is added with their name and join time, giving online schools a register they can check against the class list.

User Joined MeetingAdd New Row

Record when each participant leaves

Find the participant's attendance row and add the leave time, so you can see who stayed for the whole session.

User Left MeetingLookup Row DataUpdate Cell Data

Index finished cloud recordings

Each recording that finishes uploading is added to a recordings tab with the room and date, so staff can find a past session's recording quickly.

Recording FinishedAdd New Row

List transcriptions that failed

Failed transcriptions go to a to-do tab, so someone can request the transcript again before the meeting notes are needed.

Transcription FailedAdd New Row

Track how often visitors knock in the waiting room

Visitors who knock are logged with the time, which shows how often people wait for a host and at what hours more staff would help.

User WaitingDate/Time FormatterAdd New Row

Set up: a row for each session

At the end, every Whereby session that starts is added to your meeting log as one row.

Prepare the meeting log
Add a header row such as Room, Started, Ended and Duration, leaving Ended and Duration for the second workflow.
Connect Whereby and Google Sheets
In FlowMattic, open Connects and add your Whereby account and a Google Sheets account with edit access.
Start with Session Started
Create a workflow with the Whereby Session Started trigger, then join a test room from two devices so FlowMattic captures a session.
Map and switch on
Add Google Sheets Add New Row, map the room name and start time, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From Whereby	To Google Sheets
Room name	Room
Meeting ID	Meeting ID
Session start time	Started

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

As the trigger description says, a session starts when at least two people are in the room. One person waiting alone does not create a row.
Session Ended fires after the room has had fewer than two people for some time, so the end time can be a little after the last real conversation.
A recurring room name can have many sessions. Look up the latest row with an empty Ended column, or store the session ID if the trigger provides one.

Whereby

Integration page

Triggers (9)

Session StartedTriggers when a room session starts, which is when there are at least 2 users in a room.
Session EndedTriggers when a room session ends if the number of participants has been less than 2 for some time.
User Joined MeetingTriggers when a user joins the meeting room.
User WaitingTriggers when a visitor knocks the meeting room from the waiting room.
User Left MeetingTriggers when a user leaves the meeting room.
Transcription FinishedTriggers when a transcription has finished processing.
Recording FinishedTriggers when a cloud recording has finished and the recording has uploaded successfully.
Transcription FailedTriggers when a transcription has failed to process.
Knock CancelledTriggers when a visitor cancels their knock from the waiting room.

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Whereby and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Billable time with real timestamps

Start and end times from Whereby, not from memory, make session-based billing and timesheets easier to defend.

Attendance without a roll call

Join and leave rows build the register while the teacher or host runs the session.

Every meeting logged, one price

FlowMattic runs on your own WordPress site with unlimited runs, so a busy clinic or school pays nothing extra per session.

Common questions

How do I log Whereby meetings in Google Sheets?

Create a FlowMattic workflow with the Whereby Session Started trigger and a Google Sheets Add New Row step. Add a second workflow on Session Ended that updates the same row with the end time.

Can I track who attended each meeting?

Yes. Log User Joined Meeting to an attendance tab, and use User Left Meeting with Lookup Row Data and Update Cell Data to add when each person left.

Can recordings be listed in the sheet?

Yes. The Recording Finished trigger fires once the cloud recording has uploaded. Add each one to a recordings tab with the room and date.

Why did a short test not create a session row?

Whereby counts a session only when at least two people are in the room. Join from a second device or browser when you test the trigger.

Can transcripts go to the sheet?

Transcription Finished tells you a transcript is ready. Log it with the room and date so whoever writes the meeting notes knows where to look.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Whereby and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Whereby integration 1.0.0, Google Sheets integration 2.2.4.