Connect MakeForms and Google Sheets

MakeForms collects survey answers, questionnaires and registrations. FlowMattic copies each response into Google Sheets the way you want to analyse it: labelled NPS scores, open answers tagged by theme, one tab per form, and an email to the organiser when a capped registration form reaches its limit.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in MakeForms1 trigger

Do this in Google Sheets19 actions

1. TriggerNew Response

2. ActionAdd New Row

When MakeForms fires New Response, 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

MakeForms 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

Add a row for each new MakeForms response

Every response is written as one row with the answers in their own columns, so the team can sort, chart and share results from a familiar sheet.

New ResponseAdd New Row

View the template

Label NPS answers as promoters, passives and detractors

A Lookup Table turns the 0 to 10 score into its NPS group before the row is written, so a pivot table gives you the split without formulas.

New ResponseLookup TableAdd New Row

Tag open survey answers by theme

An AI Agent reads the free-text answer and returns a short theme such as pricing or onboarding, so a few hundred comments can be counted by topic.

New ResponseAI AgentAdd New Row

Email the organiser when a registration form is full

After each sign-up, Get Row Count checks how many rows the sheet has. A Filter passes once the cap is reached and an email tells the organiser to close the form.

New ResponseAdd New RowGet Row CountFilterEmail (SMTP)

Keep each questionnaire in its own tab

A Router reads which form the response came from and writes it to that form's tab, so one spreadsheet holds every questionnaire without mixing columns.

New ResponseRouterAdd New Row

Set up: responses as rows

By the end, each new response to your MakeForms form appears as a row in your sheet.

Connect MakeForms
Under Connects in FlowMattic, add a MakeForms connection for the account that owns the form.
Add the header row
In Google Sheets, create a header row with one column per question you want to keep, plus a Submitted column, and add a Google Sheets connection.
Start with New Response
Create a workflow with the MakeForms New Response trigger, pick the form and submit a test response so FlowMattic captures the answers.
Map and switch on
Add Google Sheets Add New Row, map each answer to its column, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From MakeForms	To Google Sheets
Name	Name
Email	Email
Rating question	Score
Comments question	Comments
Submission time	Submitted

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

The answers available depend on the questions in your form, so the mapping is an example. Add a column for each question before you map.
These workflows copy MakeForms responses into the sheet; they do not prefill or close the form. Closing a full form is still done in MakeForms.
If you add a question to the form later, send a new test response so the new field can be mapped to a column.

MakeForms

Integration page

Triggers (1)

New ResponseTriggers when form submission received

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

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

Survey answers stay private

Responses travel from MakeForms to Google Sheets through your own WordPress server, with no other automation account keeping a copy.

Large surveys cost the same

Runs are unlimited on every plan, so a customer survey sent to your whole list writes every response without a task limit.

Results ready to analyse

Scores are labelled and comments tagged on the way in, so the sheet is ready for charts as soon as responses arrive.

Common questions

How do I connect MakeForms to Google Sheets?

Add both connections under Connects, create a workflow with the MakeForms New Response trigger and add Google Sheets Add New Row. Map each answer to a column and test with one response.

Can each form go to a different spreadsheet?

Yes. Use one workflow per form, or a Router that picks the spreadsheet or tab by form, with an Add New Row step on each path.

Can I calculate an NPS score in the sheet?

Label each response with a Lookup Table as it comes in, then count promoters and detractors in the sheet. The NPS is the share of promoters minus the share of detractors.

Will file uploads come through?

If the form has an upload question, the response normally includes a link to the file, which you can put in a column like any other answer.

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

Start automating MakeForms and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

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. MakeForms integration 1.0, Google Sheets integration 2.2.4.