Google App Script for PDF Creation & Emailing
Budget: $30 – $250 AUD
I'm looking for a Google App Script that can accomplish the following tasks:
- Create a PDF from a selected Google Spreadsheet in the exact format of the spreadsheet.
- Email this PDF to all email addresses listed in a separate spreadsheet within the same Google document. This will involve extracting all email addresses from the separate sheet as well as Their name, Date and Pick up time (all seperate collumns in the same table)
The email content should follow a predefined email template.
- Hi *NAME*
Please see attached PDF for *DATE*
Your pick up time is *PICKUP_TIME*
Ideal skills and experience for the job include:
- Proficient in Google App Script
- Experience with Google Sheets
- Ability to understand and implement predefined templates and instructions.
- Create a PDF from a selected Google Spreadsheet in the exact format of the spreadsheet.
- Email this PDF to all email addresses listed in a separate spreadsheet within the same Google document. This will involve extracting all email addresses from the separate sheet as well as Their name, Date and Pick up time (all seperate collumns in the same table)
The email content should follow a predefined email template.
- Hi *NAME*
Please see attached PDF for *DATE*
Your pick up time is *PICKUP_TIME*
Ideal skills and experience for the job include:
- Proficient in Google App Script
- Experience with Google Sheets
- Ability to understand and implement predefined templates and instructions.