Refresh Google Slides charts with new responses from Google Forms

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

Tired of updating the charts on regularly accessed presentations by hand? Set up this integration, and Zapier will do it for you. It will trigger whenever a new form response is received on Google Forms, updating the charts on a Google Slides presentation so you don't have to.

How this Google Forms-Google Slides integration works

1. A new response is received on Google Forms
2. Zapier updates charts on a Google Slide

Apps involved

• Google Forms
• Google Slides