tr Skip to content

Connect AidaForm and Google Sheets

AidaForm runs your quizzes, surveys and order forms, and FlowMattic writes each response to Google Sheets. Keep only answers that mention a keyword, sort quiz takers by score, hold testimonials for approval before they reach a shared sheet, and tidy up prices and dates first. For teachers, trainers and small teams that grade or report from a sheet.

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

Try a pairing

When this happens in AidaForm1 trigger

Do this in Google Sheets19 actions

1. TriggerNew Response Received
2. ActionAdd New Row

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

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

AidaForm app icon Google Sheets app icon Ready-made template

Keep only responses that mention a keyword

A Filter checks one answer for a word, such as a product name or refund, and only matching responses are added, so the sheet holds the replies you need to act on.

New Response ReceivedFilterAdd New Row

View the template
AidaForm app icon Google Sheets app icon

Add every AidaForm response to a results sheet

Each response becomes a row with the answers in their own columns, so you can chart results and share them without exporting from AidaForm.

New Response ReceivedAdd New Row

AidaForm app icon Google Sheets app icon

Sort quiz takers into passed and retake tabs

A Router reads the quiz score. Learners above the pass mark go to one tab and the rest to a retake tab, which gives the trainer a list to follow up.

New Response ReceivedRouterAdd New Row

AidaForm app icon Google Sheets app icon

Approve testimonials before they reach the shared sheet

Human in the Loop sends each testimonial to you for a yes or no. Only approved ones are written to the sheet your website or marketing team reads from.

New Response ReceivedHuman in the LoopAdd New Row

AidaForm app icon Google Sheets app icon

Format order form prices before they are logged

Number Formatter turns calculated totals into plain numbers with two decimals, so the sheet can add up the day's orders correctly.

New Response ReceivedNumber FormatterAdd New Row

AidaForm app icon Google Sheets app icon

Mark a student's row when their survey comes in

For course feedback, look up the student's email on the class list and fill in a Submitted column, so you can see at a glance who still owes a response.

New Response ReceivedLookup Row DataUpdate Row

Set up: keyword responses to a sheet

When finished, AidaForm responses that contain your keyword are added to the sheet and the rest are skipped.

  1. Connect both apps

    Under Connects, add AidaForm with the account that owns the form, and Google Sheets with an account that can edit the spreadsheet.

  2. Start with New Response Received

    Create a workflow with the AidaForm New Response Received trigger, pick the form and submit a test response.

  3. Add the Filter

    Add a Filter that continues only when the answer you choose contains your keyword.

  4. Write the row

    Add Google Sheets Add New Row, map the answers to columns, test with a matching response and switch the workflow on.

Import the ready-made template Intermediate, about 5 min to set up
Keep only responses that mention a keyword Template
  1. AidaForm app icon 1. Trigger in AidaForm New Response Received
  2. 2. FlowMattic tool Filter
  3. Google Sheets app icon 3. Action in Google Sheets Add New Row

    Fields mapped from the earlier steps (a typical setup)

    From AidaFormTo Google Sheets
    Respondent nameName
    Respondent emailEmail
    Answer with keywordComment
    Submitted atDate
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 AidaForm responses into the sheet; editing a row does not change a response or a score in AidaForm.
  • To match a keyword however the respondent capitalised it, lower-case the answer with Text Formatter before the Filter and write the keyword in lower case.
  • Your question titles become the field names, so the mapping above is an example. Test again after you add or rename a question.

Triggers (1)

  • New Response ReceivedTriggers when new response is received
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

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

Answers go through your own site

Quiz scores and survey answers pass from AidaForm to the sheet through your WordPress server, not through another automation account.

Large classes cost nothing extra

Runs are unlimited, so a quiz taken by a whole school writes every result on the same plan as a ten-person workshop.

Each response lands where it is used

Filters, Routers and approval steps decide which tab or sheet each response belongs in, so the sheet needs less sorting later.

Common questions

How do I send AidaForm responses to Google Sheets?

Create a workflow with the AidaForm New Response Received trigger, add Google Sheets Add New Row and map each answer to a column. Test it with one response and switch it on.

Can I save only some responses?

Yes. Put a Filter between the trigger and Add New Row with the condition you need, such as an answer that contains a word or a score above a number.

Can quiz scores go to different tabs?

Yes. Add a Router after the trigger with one path per score band, and give each path its own Add New Row step pointing at a different tab.

Can I review a response before it is saved?

Yes. Add Human in the Loop before Add New Row. The run waits for your decision, and the row is written only if you approve it.

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

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