tr Skip to content

Connect Formsite and Google Sheets

Formsite takes registrations, applications and order forms. FlowMattic copies each result into Google Sheets and can do more with it on the way: move people to a waitlist once places run out, update an applicant's row when they send the form again, or log order totals as numbers. For event organisers, schools and small offices.

7 triggers 19 actions 6 example workflows 1 ready-made template Unlimited runs

Try a pairing

When this happens in Formsite1 trigger

Do this in Google Sheets19 actions

1. TriggerNew Form Result
2. ActionAdd New Row

When Formsite fires New Form Result, 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

Formsite 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.

Formsite app icon Google Sheets app icon Ready-made template

Store each new Formsite result in Google Sheets

Every result becomes a row with its answers in the columns you choose, so the people who act on the forms work from a shared sheet instead of the Formsite results page.

New Form ResultAdd New Row

View the template
Formsite app icon Google Sheets app icon

Fill event places, then move registrants to a waitlist

Get Row Count reads how many people are registered. A Branch adds the result to the attendee tab while places remain and to the waitlist tab once the event is full.

New Form ResultGet Row CountBranchAdd New Row

Formsite app icon Google Sheets app icon

Keep one row per applicant when they submit again

Applicants often resend a form to correct something. Lookup Row Data finds their email, a Router updates their existing row, and only first-time applicants get a new one.

New Form ResultLookup Row DataRouterUpdate RowAdd New Row

Formsite app icon Google Sheets app icon

Log order form totals as numbers you can add up

Number Formatter turns the total from your order form into a plain number before it is written, so the sheet can sum takings by day without fixing text values.

New Form ResultNumber FormatterAdd New Row

Formsite app icon Google Sheets app icon

Show a running registration count on a summary tab

After the row is added, the new row count is written to one cell on a summary tab. Organisers glance at that cell instead of scrolling the list.

New Form ResultAdd New RowGet Row CountUpdate Cell Data

Formsite app icon Google Sheets app icon

Split full names into first and last name columns

A single name box gives one string. Text Formatter splits it, so mail merges and name badges can use the first name on its own.

New Form ResultText FormatterAdd New Row

Set up: results stored as rows

By the last step, each new result on your Formsite form is added to the sheet as one row.

  1. Connect Formsite

    Under Connects, add a Formsite connection with the account that owns the form.

  2. Connect Google Sheets

    Add a Google Sheets connection with an account that can edit the spreadsheet, and give the sheet a header row.

  3. Start with New Form Result

    Create a workflow with the Formsite New Form Result trigger, pick the form and submit a test result so FlowMattic captures the items.

  4. Write the row

    Add Google Sheets Add New Row, map each form item to its column, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up
Store each new Formsite result in Google Sheets Template
  1. Formsite app icon 1. Trigger in Formsite New Form Result
  2. Google Sheets app icon 2. Action in Google Sheets Add New Row

    Fields mapped from the earlier steps (a typical setup)

    From FormsiteTo Google Sheets
    Result IDResult ID
    Date submittedSubmitted
    NameName
    EmailEmail
    Order totalTotal
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

  • These workflows copy each Formsite result into the sheet; editing a row does not edit or delete the result in Formsite.
  • The waitlist example counts rows, including the header. Set the Branch limit to your capacity plus one, or count from a column that only holds attendees.
  • Item names come from your form, so the mapping above is an example. Results submitted before the workflow was switched on are not copied.

Triggers (1)

  • New Form ResultTriggers when a user submits a new form result.
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

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

Results go through your own site

Registrations and applications move from Formsite to Google Sheets through your WordPress server, not through another company's automation account.

Busy registration weeks cost nothing extra

Runs are unlimited, so the week a popular event opens costs the same in FlowMattic as a quiet one.

The sheet acts on each result

Waitlists, repeat applicants and running counts are handled as each result arrives, so nobody tidies the sheet by hand afterwards.

Common questions

How do I send Formsite results to Google Sheets?

Create a workflow with the Formsite New Form Result trigger, add Google Sheets Add New Row and map the form items to columns. Test it with a real result, then switch it on.

Can I stop accepting registrations when the sheet is full?

FlowMattic cannot close the form in Formsite, but it can sort people. Count rows with Get Row Count and use a Branch to send later registrants to a waitlist tab, then close the form yourself.

Can I copy my older Formsite results?

The trigger only sees results submitted after the workflow is on. Export your earlier results from Formsite once and paste or import them into the sheet before you switch the workflow on.

Can different forms write to different tabs?

Yes. Build one workflow per form, each with its own Add New Row step pointing at a tab, or use one spreadsheet with a tab per form.

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

Start automating Formsite 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. Formsite integration 1.0, Google Sheets integration 2.2.4.