rupeshtiwari/google-app-script-demo-app

demo app for google app script learning

Google App Script Sample

Welcome to my demo app for Google app script.

Requirement

• User can register for a particular event
• After registration user will receive an email of confirmation
• Admin can send bulk email to all users with their certificate of completion pdf

Google app script Project Creation steps

Do not use ES6 features like Destructuring assignment is not supported in .gs file.

Step 1: Enable Google Apps Script API**

Enable it by visiting https://script.google.com/home/usersettings then retry. If you enabled this API recently, wait a few minutes for the action to propagate to our systems and retry.

Step 2: Create demo project

npm i -g @google/clasp  
npm init --y
npm i -S @types/google-apps-script
clasp login
clasp clone "1CVmMy8oe0o8LfBuhnqOR2PTEH90jSpdcSpo_C7jn69PKSwF_P_HjDLM-"
clasp push

Step 3 Development Tooling

clasp push --watch --force
clasp logs --setup 
# enter project id from .clasp.json file
clasp logs --watch

Dev Resources

• Use VsCode for GoogleSheet Development
• Clasp Guide
• Add Button on Sheet
• Load drop down from spread sheet
• Send SMS
• Sending SMS using Twilio
• Sending WhatsApp