When this happens...
Google FormsNew Response in Spreadsheet
do these tasks!
Google SlidesCreate Presentation From Template
GmailSend Email

Giving your customers a quick, detailed response to their requests can help you secure business and loyalty. This integration allows you to handle every incoming request, find the appropriate answers in your database, and reply with a customized presentation.

Once active, it will trigger whenever someone submits a new response to your Google Form. It will then search Google Sheets for the row that matches a response that was given, and update a Google Slides presentation by replacing blanks with a combination of the information provided by your customer and the details that were found in the Google Sheet. This customized presentation will then be emailed to your respondent, and you can add your email to the cc field so you can watch for the response to your proposal.

Note: This workflow assumes certain components of your form, slide, and spreadsheet are named in a certain way. Be sure to insert the correct values if you don't use the provided templates

How this Google Forms-Google Sheets-Google Slides-Gmail integration works

  1. A new response is submitted to your Google Form
  2. Zapier finds matching information on a Google Sheet
  3. Zapier replaces variables in your Google Slides with information from your form and spreadsheet
  4. Zapier emails a customized version of your presentation to your form respondent via Gmail

Apps involved

  • Google Forms
  • Google Sheets
  • Google Slides
  • Gmail

Why Zapier?

Free

Get started for free—14 day trial of premium features and apps.

Easy

No coding required—automate any of 1,000+ apps in minutes.

Secure

Enterprise-level security—connect mission-critical apps.

It's easy to connect Gmail + Google Forms and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
New Email Matching Search

Triggers when you receive a new email that matches a search string you provide.

Create Draft

Create (but do not send) a new email message.

New Labeled Email

Triggers when you receive a new email and label it within two days.

Send Email

Create and send a new email message.

New Attachment

Triggers when you receive a new attachment (triggers once per attachment).

Create Response

Create a new response/entry (row) in a specific spreadsheet.

New Starred Email

Triggers when you receive a new email and star it within two days.

Add Label to Email

Add a label to an email message.

New Thread

Triggers when a new thread starts.

Create Label

Creates a new label.

Use our free platform to build a single Zapier integration and instantly connect your app with 1,000+ others.

Become a Zapier Integration Partner

One of the most popular email services, Gmail keeps track of all your emails with treaded conversations, tags, and Google-powered search to locate find any message you need.

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!

See Google Forms Integrations