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 FormCrafts and Google Sheets

FormCrafts handles contact forms, payment forms and support ticket forms, and Google Sheets is a simple place to track them. FlowMattic writes each submission to the right sheet, numbers support tickets and emails the customer their reference, logs payment amounts as numbers and adds an AI-suggested reply column. For small businesses running support and sales from a sheet.

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

Try a pairing

When this happens in FormCrafts1 trigger

Do this in Google Sheets19 actions

1. TriggerNew Submission Received
2. ActionAdd New Row

When FormCrafts fires New Submission 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

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

FormCrafts app icon Google Sheets app icon Ready-made template

Log only submissions that mention a chosen word

A Filter checks one field for a word, such as urgent or cancel, and only those submissions become rows, so the sheet works as a short action list.

New Submission ReceivedFilterAdd New Row

View the template
FormCrafts app icon Google Sheets app icon

Number each support ticket and email the customer the reference

Counter gives each ticket form submission the next number. The row is written with it and the customer receives an email quoting the reference to use when they write again.

New Submission ReceivedCounterAdd New RowEmail (SMTP)

FormCrafts app icon Google Sheets app icon

Keep a payment log from your FormCrafts payment forms

Number Formatter turns the paid amount into a plain number, so the sheet totals what each payment form took this month without fixing currency text.

New Submission ReceivedNumber FormatterAdd New Row

FormCrafts app icon Google Sheets app icon

Send surveys, tickets and contact forms to separate sheets

A Router checks which form was used. Survey answers, ticket requests and general contact messages each go to their own spreadsheet with its own columns.

New Submission ReceivedRouterAdd New Row

FormCrafts app icon Google Sheets app icon

Add an AI-suggested reply next to each ticket

An AI Agent reads the ticket and writes a suggested first reply into its own column. Whoever works the queue edits it instead of starting from a blank email.

New Submission ReceivedAI AgentAdd New Row

Set up: keyword submissions logged

When done, FormCrafts submissions whose chosen field contains your word are added to your sheet as rows.

  1. Connect FormCrafts

    Under Connects, add a FormCrafts 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 add a header row.

  3. Start with New Submission Received

    Create a workflow with the FormCrafts New Submission Received trigger, pick the form and send a test submission.

  4. Filter and write

    Add a Filter on the field to check, then Add New Row with the fields mapped. Test with a matching submission and switch the workflow on.

Import the ready-made template Intermediate, about 5 min to set up
Log only submissions that mention a chosen word Template
  1. FormCrafts app icon 1. Trigger in FormCrafts New Submission 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 FormCraftsTo Google Sheets
    NameName
    EmailEmail
    SubjectSubject
    MessageDetails
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 FormCrafts submissions into the sheet, so closing a ticket in the sheet does not change anything in FormCrafts.
  • Write the Counter number to its own column and keep it as the first column, so sorting or filtering the sheet never separates a ticket from its reference.
  • Your field labels decide the names you map, so the mapping above is an example.
FormCrafts app icon

FormCrafts

Integration page

Triggers (1)

  • New Submission ReceivedTriggers when new submission 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

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

Ticket details stay on your server

Support and payment submissions pass from FormCrafts to the sheet through your own WordPress site, not through another automation account.

No charge per ticket

Runs are unlimited, so a busy support form costs nothing more in FlowMattic than a quiet contact form.

Every form type, its own sheet

One workflow sorts surveys, payments and tickets into the sheets the right people already watch.

Common questions

How do I connect FormCrafts to Google Sheets?

Create a workflow with the FormCrafts New Submission Received trigger, add Google Sheets Add New Row and map the fields to columns. Test with one submission, then switch the workflow on.

Can I use a Google Sheet as a simple ticket system?

Yes. Number each ticket with Counter, write it with Add New Row and keep a Status column for the team. A Google Sheets trigger such as Update Specific Column Value can email the customer when the status changes.

Can I save payment form entries only when payment went through?

Add a Filter on the payment status field your form sends, so only paid submissions are logged. Check a test submission to see the exact value.

Will the AI reply be sent to the customer?

No. In this example the AI Agent's text only goes into a sheet column. A person reads it and decides what to send.

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

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