Скачать или смотреть Automate Email Notifications From Google Forms & Sheets

Automate email notifications from Google Forms and Google Sheets to external recipients or yourself.

Code on Github: https://github.com/drewpager/automawa...

Reference URLs:
https://developers.google.com/apps-sc...
https://developers.google.com/apps-sc...

Requirements:
Google Account

Limitations:
Email recipients per day: (Consumer: 100/ day) & (Google Workspace: 1,500/ day)
Email recipients per day within domain: (Consumer: 100/ day) & (Google Workspace: 2,000/ day)

Steps:
1. Set Up Form
2. Add Spreadsheet
3. Apps Script For Spreadsheet
4. Set Up Trigger:
Choose which function to run: getEmailDetails
Choose which deployment should run: Head
Select event source: From spreadsheet
Select event type: On form submit

Chapters
00:00 What We're Building

#appsscript #googleappsscript #automationtools