An AWS Lambda function that runs on a CRON schedule to grab content from a Google Sheet and generate a new MailChimp campaign. Read the detailed blog post here -> https://dev.to/kylegalbraith/automating-my-newsletter-generation-with-mailchimp-google-sheets-and-aws-lambda-1n11
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
src
.gitignore
LICENSE
README.md

README.md

newsletter-automation

An AWS Lambda function that runs on a CRON schedule to grab content from a Google Sheet and generate a new MailChimp campaign.

Getting Started

  1. You must create a g-auth.json file and add it to the src of this project next to serverless.yml. Instructions on how to create this authentication file for Google Sheets can be found here.
  2. Update serverless.yml with the appropriate environment variables.
environment:
  googleSheetId: <your-google-sheet-id>
  mailChimpKey: <your-mailchimp-api-key>
  mailchimpListId: <your-mailchimp-unique-list-id>
  1. Run npm install from the command line.
  2. Run serverless deploy from the command line.