Agencies use LeadConnector to run each client's pipeline and Google Sheets to report on it. FlowMattic connects the two: stage changes, payments and booked appointments become rows for client reports, and rows from a sheet become contacts, opportunity updates or workflow enrolments. It runs on your WordPress site, one connection per sub-account.
59 triggers47 actions7 example workflows1 ready-made templateUnlimited runs
Try a pairing
When this happens in LeadConnector V253 triggers
Do this in Google Sheets19 actions
1. TriggerPipeline Stage Changed
2. ActionAdd New Row
When LeadConnector V2 fires Pipeline Stage Changed, 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
LeadConnector V2 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 every pipeline stage change in a sheet
Each move becomes a row with the opportunity, old and new stage and the date, which gives you a history to measure how long deals sit in each stage.
Keep a client's contact sheet current when details change
Clients who want their leads in a sheet see the latest email, phone and tags. Lookup Row Data finds the contact's row by ID and Update Row rewrites it.
Contact Changed→Lookup Row Data→Update Row
Build a monthly revenue log from received payments
Each payment is written to a tab named after the month, formatted with Date/Time Formatter, so month-end reports for each client start from a ready total.
Payment Received→Date/Time Formatter→Add New Row
Record self-booked appointments for show-rate reports
Appointments customers book themselves are logged with the calendar and time. Compare them with later appointment statuses to see which campaigns bring people who turn up.
Customer Booked Appointment→Add New Row
Import leads from a sheet as tagged contacts
Event lists and purchased lists usually arrive as spreadsheets. Each new row is created or updated as a LeadConnector contact and tagged with the list's source.
New Spreadsheet Row→Create or Update a Contact→Add Tags to Contact
Update an opportunity when a manager edits its row
Sales managers who review the pipeline in a sheet can change the status column. A Filter checks the value and Update Opportunity applies it to the opportunity ID in that row.
Update Specific Column Value→Filter→Update Opportunity
Enrol a sheet's contacts in a LeadConnector workflow each week
Keep a follow-up list in a sheet. Each Monday the rows are read, an Iterator goes through them and each contact is added to a LeadConnector workflow for nurture.
Schedule→Get Rows→Iterator→Add Contact to Workflow
Set up: a log of pipeline stage changes
At the end, each time an opportunity changes stage, a row is added to your sheet with the details.
1
Prepare the sheet
Add a header row such as Date, Opportunity, Contact, Pipeline, Stage, Value and Owner.
2
Connect both apps
Under Connects, add LeadConnector V2 for the sub-account you report on, and Google Sheets with an account that can edit the spreadsheet.
3
Trigger on Pipeline Stage Changed
Create a workflow with LeadConnector V2 Pipeline Stage Changed, then move a test opportunity so FlowMattic captures the data.
4
Add the row
Add Google Sheets Add New Row, pick the spreadsheet and tab, map the opportunity fields to the columns, test the step and switch it on.
Log every pipeline stage change in a sheetTemplate
1. Trigger in LeadConnector V2
Pipeline Stage Changed
2. Action in Google Sheets
Add New Row
Fields mapped from the earlier steps (a typical setup)
From LeadConnector V2
To Google Sheets
Opportunity name
Opportunity
Contact name
Contact
Pipeline
Pipeline
Pipeline stage
Stage
Monetary value
Value
Assigned user
Owner
Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.
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
Each LeadConnector V2 connection works with one sub-account. Agencies reporting on several clients add a connection and a workflow for each sub-account.
Pipeline Stage Changed fires on every move, including moves back. Keep the stage in its own column, or add a Filter if you only want forward moves logged.
Rows that update the CRM need the contact or opportunity ID in a column. Write the ID into the sheet when you log the row, so later workflows can find it.
Do not log Contact Created into the same sheet that imports contacts, or each imported row creates a contact that adds another row.
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
LeadConnector V2 and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.
Client reports from live data
Stage changes, payments and bookings land in the sheet as they happen, so monthly reports for each client come from rows, not exports.
Spreadsheets can feed the CRM too
New rows, status edits and weekly lists can create contacts, update opportunities and start LeadConnector workflows.
No task bill across sub-accounts
FlowMattic runs on your WordPress site with unlimited runs, so adding another client's sub-account adds no per-task cost.
Common questions
Can I export HighLevel pipeline changes to Google Sheets automatically?
Yes. LeadConnector V2 is the connection for HighLevel accounts. Trigger on Pipeline Stage Changed and add a Google Sheets Add New Row step, and each stage move is logged as a row.
Can I import a spreadsheet of leads into LeadConnector?
Yes. Use New Spreadsheet Row with Create or Update a Contact so each pasted row becomes a contact, then Add Tags to Contact to mark where the list came from. For a sheet that is already full, use Get Rows with Iterator.
Will a contact appear twice if they are in the sheet twice?
Create or Update a Contact matches on the email or phone, so a repeat row updates the existing contact instead of making a new one. Use Create Contact only when you are sure the person is new.
Can one sheet hold data from several sub-accounts?
Yes. Build a workflow per sub-account and write the client name in its own column, or give each sub-account its own tab in the same spreadsheet.
Can I log opportunities that go quiet?
Yes. Stale Opportunities runs for opportunities older than the time you set. Add each one as a row so the team has a weekly list of deals to chase.
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. LeadConnector V2 integration 1.1.2, Google Sheets integration 2.2.4.