Connect SmartSurvey and Google Sheets

SmartSurvey collects responses to your questionnaires and screens people out when they do not qualify. FlowMattic writes completed, disqualified and updated responses to Google Sheets, so researchers can watch quotas fill, analysts can work on the raw answers, and comments can be tagged by theme before anyone reads them.

Try FlowMattic free See example workflows

9 triggers 19 actions 6 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in SmartSurvey3 triggers

Do this in Google Sheets19 actions

1. TriggerSurvey Response Completed

2. ActionAdd New Row

When SmartSurvey fires Survey Response Completed, 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

SmartSurvey 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 each completed SmartSurvey response as a row

Every finished response becomes a row with its answers, giving researchers raw data to analyse in the sheet as fieldwork runs.

Survey Response CompletedAdd New Row

View the template

Track screened-out respondents for quota checks

Each disqualified response adds a row to its own tab, so you can see how many people fail screening and adjust your sample.

Survey Response DisqualifiedAdd New Row

Overwrite a response row when the answers are edited

Survey Response Updated finds the response by ID and rewrites the answers, so the sheet matches SmartSurvey after edits.

Survey Response UpdatedLookup Row DataUpdate Row

Tag open comments by theme with AI

AI Agent reads the free-text answer and adds a theme such as price, service or delivery, so comments can be counted by topic.

Survey Response CompletedAI AgentAdd New Row

Email the researcher when the target sample is reached

After each row, Get Row Count checks the total. A Filter passes once it reaches your target and Email (SMTP) tells the researcher to close fieldwork.

Survey Response CompletedAdd New RowGet Row CountFilterEmail (SMTP)

Split responses into tabs by a screening answer

A Router reads an answer such as region or customer type and writes the response to that tab, so each segment can be read on its own.

Survey Response CompletedRouterAdd New Row

Set up: completed responses as rows

At the end, every completed SmartSurvey response is added to your sheet.

Prepare the sheet
Add a header row with Response ID, Submitted and one column per question you want to keep.
Connect Google Sheets
In Connects, add a Google account that can edit the spreadsheet.
Choose Survey Response Completed
Create a workflow with the SmartSurvey Survey Response Completed trigger and complete the setup the trigger step asks for.
Submit a test response
Answer your survey once so FlowMattic captures a completed response.
Map and turn 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 SmartSurvey	To Google Sheets
Response ID	Response ID
Date completed	Submitted
Question 1 answer	Q1
Question 2 answer	Q2

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 that arrive depend on your questionnaire, so the mapping is an example. Add a column for each question before mapping.
Disqualified responses come from their own trigger and do not fire Survey Response Completed. Build both if you track quotas.
Keep the response ID in its own column. The update workflow finds rows by it.

SmartSurvey

Integration page

Triggers (3)

Survey Response CompletedTriggers when a survey response is completed.
Survey Response DisqualifiedTriggers when a survey response is disqualified.
Survey Response UpdatedTriggers when a survey response is updated.

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

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

Research data on your server

Answers pass from SmartSurvey through your own WordPress site to your sheet, not through another automation company.

Large samples cost the same

Runs are unlimited, so a survey with thousands of respondents needs no bigger plan.

Analysis in a familiar tool

Researchers chart and filter raw answers in a sheet while fieldwork is still open.

Common questions

How do I send SmartSurvey responses to Google Sheets?

Create a workflow with the SmartSurvey Survey Response Completed trigger, submit a test response, then add Google Sheets Add New Row and map each answer to a column.

Can I track disqualified respondents?

Yes. Survey Response Disqualified starts its own workflow. Write those responses to a separate tab to see how screening affects your sample.

What happens when a response is edited?

Survey Response Updated fires. Find the row by response ID with Lookup Row Data and overwrite the answers with Update Row.

Can I be told when I have enough responses?

Yes. After adding the row, use Get Row Count and a Filter for your target number, then send an Email (SMTP) message to the researcher.

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

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