Synchronizes Mailchimp with the latest email addresses gathered from Google Sheets.
Create a new project at https://console.developers.google.com/
Enable Google Sheets API for the project and generate a new API key under Google Sheets
Rename docker-compose.yml.example
to docker-compose.yml
Fill in docker-compose.yml
SPREADSHEET_ID
- Can be found from the url of the document:
https://docs.google.com/spreadsheets/d/<SPREADSHEET ID>
SPREADSHEET_RANGE_NAME
- Format: <SHEET NAME>
!<START COLUMN>
:<END COLUMN>
MAILCHIMP_API_KEY
- Mailchimp API key
MAILCHIMP_LIST_ID
- Mailchimp mailing list IDs (Multiple list IDs are supported with a comma delimiter). If no list IDs are specified, then all available lists will be printed out instead of running the bot. (docker-compose up --build
can be used to display the lists)
Build docker container docker-compose build
Run docker container docker-compose up