Scripted
A Google AppScript Playground
Install / Use
/learn @kimberrypi/ScriptedREADME
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
