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
- A new response is submitted to your Google Form
- Zapier finds matching information on a Google Sheet
- Zapier replaces variables in your Google Slides with information from your form and spreadsheet
- Zapier emails a customized version of your presentation to your form respondent via Gmail
Apps involved
- Google Forms
- Google Sheets
- Google Slides
- Gmail
**
Google Forms Trigger
New Response in Spreadsheet
Triggered when a new response row is added to the bottom of a spreadsheet.
**
**
No comments:
Post a Comment