Automate a daily task

• 

  Mails sent from fetched data to respective participants

• 

  The sheet where names and mail are fetched from the form

• 

  Customized certificated sent along mail using the special add-ons

Automatic Certificate naming and Mailing

The project uses various extensions to automatically get names from an excel sheet along with their email addresses and sends them the customized certificated to their ids.

Used google form and google sheets to keep the process active and dynamic, i added extension and add-ons to sheets to extact names of participants directly and send them their certificate automatically by entering their name

Great experiance to see how easily a simple task can be automated thus saving human labour time and work!

Built With

• design
• docs
• excel
• form
• google
• google-calendar
• google-spreadsheets