How to Turn Google Forms Entries Into Tasks and Projects
Because it comes with your Google account, Google Forms is an easy way to ask people for their information or opinions, but how can you ensure you'll act on that information? By sending every response over to your to do list or task manager as a task or project.
You could manually copy information from Google Sheets over to your task or project management app of choice, of course, but that's tedious and time-consuming. Which is why we recommend you automate the process instead.
In the example below, you can send responses from Google Forms over to Trello, so you can turn your form responses into tasks to complete. But you're not limited to Trello: You can send information you gather from a Google Form to other task and project management apps too. Here's how.
Create Trello Cards With Google Forms Responses
Zapier makes it possible to connect Google Forms with 1,500 apps, and we'll be using it to send responses over to Trello. Here's a template to get you started:
This template will help you build a Zap, which is what we call an automation connecting two apps. This particular Zap will add all new Google Forms responses to Trello as a card.
First, you'll set up Google Forms, which will be the first step of our automation.
You will be asked to sign into your Google account, if you haven't already, and then you will choose which spreadsheet you're going to automate.
Can't find your Google Form in the drop-down menu? You'll need to set Google Forms to send responses to a Google Sheet. Open your Google Form, click the Responses tab, then click the Google Sheets icon.
Do that and a Google Spreadsheet will be created for your Form. Head back to Zapier, then click Check Google Forms & reload to bring in new choices in order to see your form.
Once you've found your form select the proper worksheet—it should be called Form Responses 1 unless you've change something.
Click Continue when you're done. You'll be asked to pull in some sample data before you can move onto the Trello stage of the automation.
You will be asked to sign into your Trello account, assuming you haven't already. Then you can start setting everything up.
Choose which board and list you'd like new entries to show up on, using the drop-down menu.
Next, you can choose a name for all new cards. I recommend using a Field for this—to get started click the icon in the right side of the text box.
Click whichever question will help you identify the response—I'm going to use the name.
Want a little more detail included in the card? Click Show advanced options.
Now you can add things like a description, labels, and even a check list on the card itself.
Remember: you can use Fields to pull in responses from Google Forms. Include everything that's relevant, taking the time to put things just where you want them.
Click Continue when everything looks just right. and you'll be asked to send a test to Trello. It should show up there right away!
When you're done your Zap will tun on.
All new responses to your Google Form will now show up in Trello.
Connecting Google Forms to Other Project Management Systems
Not a Trello user? No worries! You can use Zapier to connect Google Forms to 1,500+ apps, including
For example, you can turn Google Forms responses into projects in JIRA, Asana, or Basecamp:
You can also turn responses into Google Calendar appointments.