Google AppScript Sample App

Integrates Forms, Spreadsheet, Slides and GMail

Code Description

• Get values of column headers in the responses sheet
• Loop through rows and get values
• Add a conditional function that checks if the email has already been sent
• Duplicate the template Slides
• Replace content with row values
• Build email body and send email
• Update status column
• Add a custom menu to Spreadsheet