Create a Simple But Effective Bug Ticketing System Using Google Forms + Zapier + Trello

Jeanmarie Jackman
The Startup
Published in
3 min readFeb 16, 2021

--

created using Pixlr.com

So, I found myself working on a small team developing a game, which is great, huzzah! But soon we needed testers (other than the few of us on the team). And once we had a few dozen people testing and reporting bugs, it became necessary to have a system in place — but one that doesn’t come with a big sticker price.

First, I designed a Trello board. With a key, for labeling the categories of the bugs from severe to minor. Then set I set up my Trello bug tracker tool to have this list structure:

  1. Key
  2. Incoming
  3. Acknowledged Bugs
  4. In progress
  5. Needs checking
  6. Verified Fixed
  7. Released
  8. Unknown Status
  9. Won’t fix
  10. Can’t Reciprocate

Second step, create the Google Form.

In addition to email address and discord username, which is the server where our testers communicate with the dev team, we ask for device and operating system, version of the app, type of submission (bug, suggestion, feedback, other), a description of the issue in detail, attach image files, and a mailing list opt-in/opt-out.

Then we select “Responses” at the top of the form editing area, and we can click the green “Create Spreadsheet” icon, to generate the Sheet that will record all of the responses.

Now comes the magic!

We will go to our Zapier account, and create a new Zap. Select the trigger:

In our case we select Google Forms as the Trigger. Then select the Event, that Zapier will be listening for:

We want it to listen for “New or Updated Response in the Spreadsheet”. Select your google forms account in the next dropdown. Then set up the Trigger, choose the Spreadsheet, Choose the Worksheet, and then Test the trigger.

Once you have a test response successfully triggered, you can then handle the Action on the Trello Board.

You’ll choose the Trello app, and event “Create a Card”, link to your trello account, then select the action(s):

Run a Test again, and Voila!

Now we have a simple but effective system gathering the information from the testers on an easy to use form, and placing it right into our Trello system so that the Dev Team can work methodically through all of the tickets.

--

--

Jeanmarie Jackman
The Startup

Full Stack Developer | Software Engineer | React | Ruby on Rails | Musician | Artist | Educator