Send Gmail emails to new Google Forms respondents with customized Google Slides presentations using data from Google Sheets

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
Send Gmail emails to new Google Forms respondents with customized Google Slides presentations using data from Google Sheets
Google Forms integration logo

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!

Gmail integration logo

Gmail is a free advertising-supported email service provided by Google. It's one of the most popular email services in the world.

What Is Zapier?

Get Help