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
- Web formsGive a stack a public request form, so customers and coworkers can ask without an account and every request lands as a ticket.
- Import from a spreadsheetTurn your Google Form responses or any spreadsheet into a stack full of tickets, with original dates, quietly and undoably.
- QR codes and website embedsDownload a QR code for flyers and counters, or paste the form into your own website with one line of code.
- After sending: thank-you message or your own pageShow a thank-you message, or send people to a page on your own website once they've sent the form.
Still stuck? Email hello@ticketstacker.com. A real person reads every message.
