Absence

“Anytime a new form response is created in Google Forms, lookup spreadsheet row in Google Sheets, format my data in Formatter by Zapier, etc.”

created by Zohar Bogopolsky

How Zapier works (57 sec)

How Zapier works (57 sec)

Try this Zap FREE for 14 days

Trusted at companies large and small

This Zap works in 11 steps …

5.5 minutes to set up
Get back 1.2 hrs /week
5 people use this zap

This Zap uses the following 4 apps

Google Forms
Google Forms is an easy way to collect data from the web with a simple UI and powerful editor. Works hand-in-hand with Google Sheets!
Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Formatter by Zapier
Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.
Gmail
One of the most popular email services, Gmail keeps track of all your emails with threaded conversations, tags, and Google-powered search to find any message you need.

More ways to use these popular apps!

Check out all the other ways you can connect Google Forms and Google Sheets.