To manually run the monthly report:
1- Update the template: https://github.com/opencollective/opencollective-api/blob/main/templates/emails/collective.monthlyreport.hbs
2- If you want to preview some of the emails, you can run it locally with
PG_DATABASE=opencollective_prod_snapshot DEBUG=preview npm run cron:monthly
(it won't send real emails but it will output links to preview them in the browser)
3- Run bash on heroku production:
heroku run bash --app opencollective-prod-api
4- Run the monthly cron job manually:
npm run cron:monthly
If you want to only run it for certain collectives, modify the query here: https://github.com/opencollective/opencollective-api/blob/main/cron/monthly/collective-report.js