Plenty of schedules start life as a spreadsheet: content calendars, shift rotas, course dates, client deadlines. FlowMattic turns those rows into Google Calendar events from your WordPress site, moves an event when its date cell changes and removes it when the row is marked cancelled. It can also write your calendar back into a sheet for reporting.
12 triggers 40 actions 6 example workflows 1 ready-made template Unlimited runs
When this happens in Google Sheets6 triggers
Do this in Google Calendar21 actions
1. TriggerNew Spreadsheet Row2. ActionCreate Detailed EventWhen Google Sheets fires New Spreadsheet Row, FlowMattic runs Create Detailed Event in Google Calendar with the data from that event.
You build this in the FlowMattic workflow builder on your own site. See the setup steps
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 templateAdd a task with a due date and it appears on the team calendar. The event ID is written back to the row so later workflows can find the event.
New Spreadsheet RowCreate Detailed EventUpdate Cell Data
View the template Planners reschedule in the sheet, not the calendar. Editing the Date column updates the linked event, using the event ID stored on that row.
Update Specific Column ValueDate/Time FormatterUpdate Event
Set the Status cell to Cancelled and a Filter lets the workflow remove the event, so nobody turns up for a session that is no longer happening.
Update Specific Column ValueFilterDelete Event
Workshop organisers collect names in a sheet. Each new row adds that person as an attendee to the workshop event, so the invitation comes from Google Calendar.
New Spreadsheet RowAdd Attendee to Event
Find Availability checks the requested time first. A Router creates the event when the calendar is free and writes Clash into the row when it is not.
New Spreadsheet RowFind AvailabilityRouterCreate Quick Event
Freelancers who bill by meeting get a row for every event as it ends, with its title, date and length, ready for invoicing at the end of the month.
Event EndedAdd New Row
By the end, each task you add to the sheet becomes an event on its due date, with the event ID saved on the row.
Use columns such as Task, Due date, Owner email and an empty Event ID column.
In Connects, add Google Sheets and Google Calendar. One Google account can be used for both if it can edit the sheet and the calendar.
Create a workflow with New Spreadsheet Row, choose the spreadsheet and tab, and add a test task.
Add Create Detailed Event, pick the calendar, and map the task name to the title and the due date to the start.
Add Update Cell Data to write the new event's ID into the Event ID cell, test, and switch the workflow on.
1. Trigger in Google Sheets
New Spreadsheet Row
2. Action in Google Calendar
Create Detailed Event
3. Action in Google Sheets
Update Cell Data
Fields mapped from the earlier steps (a typical setup)
| From Google Sheets | To Google Sheets |
|---|---|
| Task | Event title |
| Due date | Start date |
| Owner email | Attendee |
| Event ID from Calendar | Event ID column |
A trigger starts a workflow. An action is something FlowMattic does in the app as a step.
Google Sheets and Google Calendar connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.
Plan in the spreadsheet the team already edits, and let the calendar follow it rather than keeping two lists in step by hand.
Runs are unlimited, so a sheet with hundreds of shifts or sessions costs no more than one with a few.
The workflow runs on your WordPress site with your Google connections. No other automation service sees your schedule.
Yes. Start a workflow with New Spreadsheet Row and add Create Detailed Event or Create Quick Event. Map the title, date and time columns to the event fields and test with one row before switching it on.
Yes. New or Updated Event, Event Cancelled and Event Ended can each start a workflow. Lookup Row Data finds the row by the event ID stored on it, and Update Row writes the new time or status. If the sheet also moves events, add a Filter so a change only goes one way.
Create Detailed Event takes separate fields such as title, start, end, description and attendees. Create Quick Event takes a minimal input, which is handy when the sheet holds just a title and time.
Yes. Add a Router that checks a column such as Team, and give each path its own Create Detailed Event step pointed at that team's calendar.
Did not find your answer? You can browse the help center or ask us directly.
Google Sheets and Slack149 shared templates
Google Sheets and AI Agents26 shared templates
Google Sheets and Fluent Forms23 shared templates
Google Sheets and WooCommerce20 shared templates
Google Sheets and FluentCRM19 shared templates
Google Sheets and WPForms12 shared templates
Google Sheets and ActiveCampaign11 shared templates
Google Sheets and Gmail11 shared templatesInstall FlowMattic, connect both accounts and import a template. Every run stays on your own server.
30-day money-back guarantee Unlimited workflows and runs Self-hosted
Reviewed 23 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Google Sheets integration 2.2.4, Google Calendar integration 2.0.0.
