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

SupportCandy runs your help desk inside WordPress. FlowMattic, on the same site, copies ticket events into Google Sheets: new tickets, closures, reassignments and SLA breaches. Support leads get a sheet they can chart and share with managers who never log in to the help desk.

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

Try a pairing

When this happens in SupportCandy12 triggers

Do this in Google Sheets19 actions

1. TriggerCreate Ticket
2. ActionAdd New Row

When SupportCandy fires Create Ticket, 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

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

SupportCandy app icon Google Sheets app icon Ready-made template

Log every new SupportCandy ticket as a row

Each ticket opened on your site becomes a row with its number, subject, category, priority and customer, so you can count tickets by topic each week.

Create TicketAdd New Row

View the template
SupportCandy app icon Google Sheets app icon

Fill in the closed date when a ticket is closed

Find the ticket's row by number and write the closing date beside the opening date, so the sheet can work out how long each ticket stayed open.

Close TicketLookup Row DataUpdate Row

SupportCandy app icon Google Sheets app icon

Keep a register of tickets that breach the SLA

Each ticket that goes out of SLA is added to its own tab with the agent and category, which gives the support lead a list to review at the weekly meeting.

Out Of SLAAdd New Row

SupportCandy app icon Google Sheets app icon

Update the owner column when a ticket is reassigned

Write the new assignee into the ticket's row, so workload per agent in the sheet matches who is really holding each ticket.

Change AssigneeLookup Row DataUpdate Cell Data

SupportCandy app icon Google Sheets app icon

Copy urgent tickets to an escalation tab

A Filter passes tickets whose priority was raised to high or urgent, so managers watching the escalation tab see only the tickets that need them.

Change Ticket PriorityFilterAdd New Row

SupportCandy app icon Google Sheets app icon

Track status changes ticket by ticket

Every status change is written as a row with the old and new status and the time, so you can spot tickets that bounce between waiting and open.

Change StatusDate/Time FormatterAdd New Row

Set up: each new ticket as a row

At the end, every ticket created in SupportCandy is written to your Google Sheet as one row.

  1. Check SupportCandy is active

    SupportCandy and FlowMattic must run on the same WordPress site, so the help desk's triggers are available in the workflow builder.

  2. Connect Google Sheets

    Under Connects in FlowMattic, add a Google Sheets connection that can edit the ticket log spreadsheet.

  3. Start with Create Ticket

    Create a workflow with the SupportCandy Create Ticket trigger and open a test ticket from the front end so FlowMattic captures its fields.

  4. Map the ticket row

    Add Google Sheets Add New Row, map the ticket number, subject, category, priority and customer email, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up
Log every new SupportCandy ticket as a row Template
  1. SupportCandy app icon 1. Trigger in SupportCandy Create Ticket
  2. Google Sheets app icon 2. Action in Google Sheets Add New Row

    Fields mapped from the earlier steps (a typical setup)

    From SupportCandyTo Google Sheets
    Ticket IDTicket
    SubjectSubject
    CategoryCategory
    PriorityPriority
    Customer emailCustomer
    Date createdOpened
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

  • Keep the ticket ID in its own column. The close, reassign and status workflows find the row with Lookup Row Data on that ID.
  • Reply To Ticket and Submit Private Note carry message text, including internal notes. Keep any sheet that stores them shared with your team only.
  • Custom fields arrive under the names you gave them in SupportCandy, so the mapping above is an example. Create a test ticket after adding a field, then map it.
SupportCandy app icon

SupportCandy

Integration page

Triggers (12)

  • Create TicketTriggers when a new support ticket is created.
  • Change StatusTriggers when the status of a support ticket is changed.
  • Change AssigneeTriggers when the assignee of a support ticket is changed.
  • Close TicketTriggers when a support ticket is closed.
  • Reply To TicketTriggers when a reply is added to a support ticket.
  • Submit Private NoteTriggers when an agent submits a private note in a ticket.
  • Change Ticket SubjectTriggers when the subject of the support ticket is changed.
  • Change Ticket CategoryTriggers when the category of the support ticket is changed.
  • Change Ticket FieldsTriggers when any custom field of the support ticket is changed.
  • Change Ticket PriorityTriggers when the priority of the support ticket is changed.
  • Change Agentonly FieldsTriggers when the Agentonly field of the support ticket is changed.
  • Out Of SLATriggers when the SLA (Service Level Agreement) of the support ticket exceeds the given time interval.
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

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

Ticket data never leaves your stack

SupportCandy and FlowMattic both run on your WordPress site, so ticket details go straight from your server to your own spreadsheet.

Reports for people outside the help desk

Managers and product teams read trends in a shared sheet without needing an agent seat in SupportCandy.

Busy weeks cost nothing extra

Runs are unlimited, so logging every status change and reply is as affordable as logging new tickets only.

Common questions

How do I export SupportCandy tickets to Google Sheets automatically?

Create a FlowMattic workflow with the SupportCandy Create Ticket trigger and a Google Sheets Add New Row step. Map the ticket fields to columns and every new ticket is added as it is created.

Can I measure how long tickets stay open?

Yes. Log the created date with Create Ticket, then use Close Ticket with Lookup Row Data and Update Row to write the closed date. A sheet formula gives the difference.

Can the sheet show SLA breaches?

Yes. The Out Of SLA trigger fires when a ticket passes its SLA. Add each one to an SLA tab with the agent, category and ticket number for review.

Will tickets from before the workflow appear?

No. Triggers fire for events that happen after the workflow is switched on. Export your older tickets once and paste them into the sheet to start from a full history.

Can I log customer replies as well?

Yes. Use the Reply To Ticket trigger with Add New Row on a replies tab, keyed by ticket ID, to see how many messages each ticket took.

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

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