How to get started with Zapier and Google Forms

Zapier, meanwhile, is an automation platform that connects an ecosystem of 3,000+ apps, enabling businesses to automate the processes that power their businesses.

If you're a business that uses Google Forms to collect data, then this article will show you how you can connect Google Forms to other apps using Zapier, so you can make things happen when a respondent fills out one of your forms - like sending them a message, or storing the data in a CRM or other app.

‍

Want more automation resources sent to your inbox? Join our newsletter.

‍

What is Google Forms?

Google Forms is one of the many products from Google that aims to give businesses the tools they need to run.

You can build powerful forms with single and multi-line text inputs, drop downs, radio buttons, and even file uploads.

Once you've built a form, you can share it with people, with responses either stored in Google Forms for you to view, or you have the option of response being added as a row to a Google Sheet you designate.

How to connect Zapier and Google Forms

Zapier has this helpful guide to help you connect Zapier + Google Forms.

To summarise, you'll want to create a new zap and select Google Forms as your trigger or action app.

Zapier will prompt you to connect your Google Forms account and when you click "Connect an Account" you'll be redirected to the Google site and prompted to login (if you aren't already).

‍

Next, Google will ask you to give permission to Zapier to access your account data. You'll need to allow this to finish connecting Google Forms in your Zapier account.

Once done, you'll find yourself back in the zap editor and will be able to continue building your zap.

If you encounter any issues, this issue summary from Zapier may help. Or you can open a support ticket with them here.

What triggers, searches and actions does Zapier's Google Forms integration have?

Triggers‍

New Response in Spreadsheet - Triggered when a new response row is added to the bottom of a spreadsheet.
New or Updated Response in Spreadsheet- Triggered when a new response row is added or modified in a spreadsheet.

Searches & Actions

Create Response - Create a new response/entry (row) in a specific spreadsheet.
Lookup Response - Finds a response row by a column and value. Returns all the values on that matching row.
Find or Create Response - Finds or creates a specific lookup row.

Zapier templates for creating Google Forms workflows

Click the links below to instantly install the zaps in your account.

1. Create Trello cards from new Google Forms responses
2. Share Google Forms responses in a Slack channel
3. Create or update Mailchimp subscribers from new Google Forms submissions
4. Send email via Gmail for new Google Forms submissions
5. Create Google Calendar events from new Google Forms submissions
6. Create Asana tasks from new Google Forms responses

Some ideas for using Zapier + Google Forms

Use Zapier to Connect Google Forms to Trello

Many businesses user Trello to mange their sales funnel or internal projects - and if you're using Google Forms alongside this to collect key data, you can use Zapier to create new cards or update existing ones in Trello

This video shows you how easy it is to setup this workflow:

‍

Real estate: Add open house attendees to Follow Up Boss with a Google Form

Open houses are a great source of new potential clients to market to. And Follow Up Boss is one of the market leading tools for real estate professionals to do just that.

Followup Up Boss can trigger automated messaging flows as soon as a contact is added, and Zapier can be used to add those contacts.

The missing piece is an input form, and if you don't want to spend extra then Google Forms is a perfect choice.

This guide talks you through the setup process:

‍

Create new contacts in Customer.io from a Google Form submission

Customer.io is a customer marketing and communications platform - and part of the setup involves adding a Javascript snipped to your form.

Some form apps don't support that, so if you want to connect it to Google Forms (or Jotform or Typeform), then this handy guide will help you work around the issue by using Zapier.

‍

Need the help of an automation expert? Contact us now.

‍