tr Skip to content
Black Friday FlowMattic for life, 12 payments of $33.25 Or $399 once. Nothing added for splitting Ends in --Days --Hrs --Min --Sec See the deal

Connect LeadConnector V2 and Google Sheets

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 triggers 47 actions 7 example workflows 1 ready-made template Unlimited 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.

LeadConnector V2 app icon Google Sheets app icon 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.

Pipeline Stage ChangedAdd New Row

View the template
LeadConnector V2 app icon Google Sheets app icon

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 ChangedLookup Row DataUpdate Row

LeadConnector V2 app icon Google Sheets app icon

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 ReceivedDate/Time FormatterAdd New Row

LeadConnector V2 app icon Google Sheets app icon

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 AppointmentAdd New Row

LeadConnector V2 app icon Google Sheets app icon

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 RowCreate or Update a ContactAdd Tags to Contact

LeadConnector V2 app icon Google Sheets app icon

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 ValueFilterUpdate Opportunity

LeadConnector V2 app icon Google Sheets app icon

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.

ScheduleGet RowsIteratorAdd 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.

Import the ready-made template Beginner, about 5 min to set up
Log every pipeline stage change in a sheet Template
  1. LeadConnector V2 app icon 1. Trigger in LeadConnector V2 Pipeline Stage Changed
  2. Google Sheets app icon 2. Action in Google Sheets Add New Row

    Fields mapped from the earlier steps (a typical setup)

    From LeadConnector V2To Google Sheets
    Opportunity nameOpportunity
    Contact nameContact
    PipelinePipeline
    Pipeline stageStage
    Monetary valueValue
    Assigned userOwner
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.
LeadConnector V2 app icon

LeadConnector V2

Integration page

Triggers (53)

  • Birthday ReminderTriggers on the birthday of a contact
  • Contact ChangedTriggers when contact details are updated
  • Contact CreatedTriggers when a new contact is created
  • Contact DNDTriggers when the contact's DND is updated
  • Contact TagTriggers when tags are added or removed from a contact
  • Custom Date ReminderTriggers on custom dates set for a contact
  • Note AddedTriggers when a note is added to a contact
  • Note ChangedTriggers when a note on a contact is updated
  • Task AddedTriggers when a task is added to a contact
  • Task ReminderTriggers to remind about a due task for a contact
  • Call StatusTriggers on outbound and inbound calls
  • Email EventsTriggers on specific email events
  • Customer RepliedTrigger when a contact responds to the campaign
  • Form SubmittedTriggers when a form is submitted
  • Survey SubmittedTriggers when a survey is submitted
  • Trigger Link ClickedTriggers when your trigger link is clicked
  • Facebook Lead Form SubmittedTriggers when a Facebook lead form is submitted
  • TikTok Form SubmittedTriggers when a TikTok form is submitted
  • Video TrackingTriggers on specific video tracking events
  • Twilio Validation ErrorTriggers when there is a validation error on Twilio
  • Appointment StatusTriggers when appointment status updates
  • Customer Booked AppointmentTriggers when the customer books an appointment themselves
  • Opportunity Status ChangedTriggers when the opportunity status gets changed
  • Opportunity CreatedTriggers when a new opportunity is created
  • Opportunity ChangedTriggers when an existing opportunity is updated
  • Pipeline Stage ChangedTriggers when the pipeline stage updates for an opportunity
  • Stale OpportunitiesTriggers when opportunities are older than the given time duration
  • Affiliate CreatedTriggers when a new affiliate is created
  • Category StartedTriggers when a category is started by a user
  • Category CompletedTriggers when a category is completed by a user
  • Lesson StartedTriggers when a lesson is started by a user
  • Lesson CompletedTriggers when a lesson is completed by a user
  • Membership New SignupTriggers when there is a new membership signup
  • Offer Access GrantedTriggers when access to an offer is granted
  • Offer Access RemovedTriggers when access to an offer is removed
  • Product Access GrantedTriggers when access to a product is granted
  • Product Access RemovedTriggers when access to a product is removed
  • Product StartedTriggers when a user starts a product
  • Product CompletedTriggers when a user completes a product
  • User LoginTriggers when a user logs in
  • Invoice SentTriggers when an invoice is sent
  • Invoice PaidTriggers when an invoice is paid
  • Payment ReceivedTriggers when a payment is received
  • Order Form SubmissionTriggers when an order form is submitted
  • Order SubmittedTriggers when an order is submitted
  • Abandoned CheckoutTriggers when a checkout is abandoned
  • Order PlacedTriggers when an order is placed
  • Order FulfilledTriggers when an order is fulfilled
  • Task CompletedTriggers when a task is completed by a contact
  • LinkedIn Lead Form SubmittedTriggers when a LinkedIn lead form is submitted
  • New Affiliate SalesTriggers when a new sale is made by an affiliate
  • New SubscriptionTriggers on subscription events
  • Refund ProcessedTriggers when a refund is processed

Actions (28)

  • Create Location (Sub-Account)Creates a new location/subaccount on the agency account
  • Create UserCreate a new user on the agency level inside teams
  • Create or Update a ContactCreate or updates contact on a sub-account level
  • Create ContactCreates contact on a sub-account level
  • Create or Update OpportunityCreates or updates an existing opportunity on a sub-account level
  • Create OpportunityCreates opportunity on a sub-account level
  • Create Opportunity with custom fieldsCreates opportunity on a sub-account level
  • Create TaskCreates a new task on a sub-account level
  • Create BusinessCreates business on sub account level
  • Add Notes to ContactAdds notes to a contact on a sub-account level
  • Add Tags to ContactAdds tags to an existing contact on a sub-account level
  • Add Contact to WorkflowAdds contact to workflow on a sub-account level
  • Add Contact to CampaignAdds contacts to existing campaign on a sub-account level
  • Update ContactUpdates an existing contact on a sub-account level
  • Update UserUpdate the user on the agency level inside teams
  • Search UserSearches a specific user on the agency level inside teams
  • Update OpportunityUpdates an existing opportunity on a sub-account level
  • Update Opportunity with custom fieldsUpdates an existing opportunity on a sub-account level
  • Update TaskUpdates an existing task on a sub-account level
  • Get PipelinesRetrieves pipelines and it's corresponding stages
  • Search OpportunitySearches an existing opportunity
  • Search TaskSearches an existing task
  • Update Location (Sub-Account)Updates an existing location on the agency account
  • Search LocationsSearches an existing location
  • Delete Location (Sub-Account)Deletes an existing location on on the agency account
  • Remove Contact from CampaignRemoves contacts from existing campaign
  • Remove Contact from Every CampaignRemoves contacts from every campaign
  • Get Company or Location IDsRetrieves IDs of company or location
Google Sheets app icon

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

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.

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

Start automating LeadConnector V2 and Google Sheets

Install 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. LeadConnector V2 integration 1.1.2, Google Sheets integration 2.2.4.