Run a Brilliant Directories site from a spreadsheet when that is easier. FlowMattic creates directory posts and members from Google Sheets rows, and writes leads, reviews and plan signups back to a sheet. Directory owners get bulk publishing and a reporting list without exporting from the admin.
32 triggers 35 actions 7 example workflows 1 ready-made template Unlimited runs
When this happens in Google Sheets6 triggers
Do this in Brilliant Directories16 actions
1. TriggerNew Or Updated Spreadsheet Row2. ActionCreate PostWhen Google Sheets fires New Or Updated Spreadsheet Row, FlowMattic runs Create Post in Brilliant Directories 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 templateWrite listings, events or articles in a sheet and each new or edited row creates a post on the directory, which suits teams that prepare content in bulk.
New Or Updated Spreadsheet RowCreate Post
View the template Onboarding a chamber of commerce or an association list? Each row added to the sheet runs Create User, so members arrive without manual entry.
New Spreadsheet RowCreate User
Leads sent to members go to a sheet with the member, category and date, so you can show members how many enquiries the directory sent them.
Lead SubmittedAdd New Row
Each Paid Plan Signup adds a row with the member and plan, which gives the owner a simple income record to reconcile against payments.
Paid Plan SignupAdd New Row
Member Plan Cancelled finds the member's row by email and updates its status, so the sheet shows churn next to the signup date.
Member Plan CancelledLookup Row DataUpdate Row
Every review submitted by a member is listed with its rating and text, so a moderator can scan new reviews in one place each morning.
Member Review SubmittedAdd New Row
Your sales team edits the Status column of the leads sheet. A change runs Update Lead, so the directory record carries the same status.
Update Specific Column ValueUpdate Lead
At the end, each row you add or edit in the sheet creates a post on your Brilliant Directories site.
Give the sheet one column per post field you fill, for example Title, Content, Category, Member ID and Image URL.
Under Connects in FlowMattic, add Google Sheets with an account that can read the spreadsheet, and Brilliant Directories with your site's API details.
Create a workflow with Google Sheets and New Or Updated Spreadsheet Row, choose the spreadsheet and tab, and capture a sample row.
Add Brilliant Directories Create Post, map the columns to the post fields, test with the sample row and switch the workflow on.
1. Trigger in Google Sheets
New Or Updated Spreadsheet Row
2. Action in Brilliant Directories
Create Post
Fields mapped from the earlier steps (a typical setup)
| From Google Sheets | To Brilliant Directories |
|---|---|
| Title | Post title |
| Content | Post content |
| Category | Post category |
| Member ID | Member |
| Image URL | Post image |
A trigger starts a workflow. An action is something FlowMattic does in the app as a step.
Google Sheets and Brilliant Directories connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.
Prepare members and posts in a spreadsheet your team already shares, and each row is created on the directory as it is added.
Leads, reviews and plan changes collect in a sheet you can chart, which helps when members ask what their listing is worth.
FlowMattic runs on your own server with unlimited runs, so a directory with thousands of members costs the same to automate as a small one.
Yes. Start a workflow with New Spreadsheet Row and add a Create User step that maps the row's name, email and plan. Each new row becomes a member on the directory.
It can with New Or Updated Spreadsheet Row. Add a Posted column, use a Filter to skip rows already marked, and write the post ID back with Update Row after Create Post.
Many of the Brilliant Directories triggers can, including Lead Submitted, Member Review Submitted, Paid Plan Signup, Free Plan Signup, Member Plan Changed, Member Plan Cancelled and One-Time Purchase.
Yes. Delete Lead, Delete Post, Delete Review and Delete User are actions. Start from Update Specific Column Value and a Filter on a value like Remove, so nothing is deleted by accident.
Only to the spreadsheet you choose. The workflow runs on your own WordPress site and passes data between Brilliant Directories and Google Sheets.
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 27 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, Brilliant Directories integration 1.0.
