AutoEmailSender is a Google Apps Script (based on JavaScript) for sending weekly newsletters/update emails to subscribers and not to unsubscribers.
Allows you to send upto 10,000 emails per day for free without paying for expensive email newsletter software.
- Set up a free Google account or paid GSuite account on a private domain.
- Create a new Google Sheet in Google Drive.
- In the first sheet, create a column of subscribers with their email.
- In the second sheet, create a column of unsubscribers with their email.
- Hover over Tools, and click on Script Editor.
- Copy paste the desired .gs file from this repo into the Script Editor.
- Run as desired.
- Create a new Google Form at Google Drive.
- Click Settings logo in the top-right corner.
- Click "Collect email addresses".
- Add in any other form fields as desired.
- Use Google Form link/embed to allow members to signup for your newsletter.
- Click on Responses on the Google Form -> the tree dots -> "Select response destination".
- Associate the existing Subscribers sheet with the Google Form to allow new members to be automatically added.
- Replicate above steps if you want to manage another Unsubscribers list.
- HTML_send.gs coverts an HTML file (with CSS) to send in an email.
- GoogleDoc_send.gs converts a Google Doc to send in an email. It also personalizes each email with the name retrieved from the Google Sheet into the Google Doc at this location: {{Name}}.
- GoogleForm_send.gs sends an email as soon as a new entry is added from a Google Form submission. If Optional Functionality with Google Form (as shown above) is integrated, you can trigger an email to be automatically send whenever a user submits the form. It also personalizes based on name.