TicketStacker

Help › How-to guides

How-to guide · ⏱ 30 minutes

Turn Google Forms responses into tickets

Replace a Google Form and its response sheet with a form that creates tickets, assigns them and replies to the sender.

Google Forms is great at collecting answers. It's not built for what happens next: who's handling it, where it's at, and telling the person. Here's how to move the form and keep its history.

1. Bring the old responses over

Open the form's response sheet, download it as CSV, and import it. TicketStacker recognizes the Timestamp column, so every response keeps its original date. Let it create a new stack from the columns.

2. Check the questions became good fields

In the editor's Fields, check each field's type: multiple-choice questions work best as Choose one or Choose any. Mark the essentials Required and add help text. (Ticket fields)

3. Turn on the web form

In Getting in, switch on Web form or QR code, click Set up the form → and add an intro and a thank-you message. (Web forms)

4. Put it where the old one was

  • Replace the Google Form link in your emails and website with the Form link, or
  • embed it in the same spot on your website, or
  • send people to your own thank-you page with After sending.

5. Make it better than before

  • Set the first step's New tickets go to so responses are handled, not just collected. (Automatic actions)
  • Senders now get a confirmation and a link to follow their request. (What requesters see)

Read more: Google Forms to tickets, without the spreadsheet.

Related

NextGet hourly staff on board without work emails

Still stuck? Email hello@ticketstacker.com. A real person reads every message.