An API gateway to facilitate automations and services relevant to our organization including adding emails to the mailing list, sending emails, tracking engagement, and contacting the leadership team.
cp .env.example .env- Create a new project in the Google Cloud Console.
- Enable the Admin SDK API, the Google Spreadsheets API, and other APIs as needed.
- Create a new service account and export the JSON credentials.
- A valid JSON will have
"type": "service_account"as the first key-value pair.
- A valid JSON will have
- Set the environment variable
GOOGLE_APPLICATION_CREDENTIALSto the path of the JSON.
Note: API calls can only be made if the "subject" field in the body is set to an admin of the Google Workspace. Set
GOOGLE_WORKSPACE_ADMIN_ACCOUNTto the email address of an admin in your workspace.
Set the environment variables SMTP_HOST, SMTP_PORT, SMTP_SECURE, SMTP_USER, and SMTP_PASS.
- Set the environment variable
SPREADSHEET_IDto the ID of the Google Spreadsheet you'd like to append to. - Set the environment variable
GROUP_IDto the ID of the Google Group you'd like to add members to.
Set the environment variables BOARD_USER and BOARD_PASS to a new user account that you would like to use to access the Bull Board dashboard where you'll be able to view and manage incoming requests. You can also set BOARD_SECRET to the secret string to be used for the Express session. The dashboard is available at /admin.
docker-compose builddocker-compose upnpm inpm i -g pm2npm run build && pm2 start