Automate Weekly Report Compilation
What: Auto-collect metrics from multiple sources into a single report every Monday morning.
Tools: n8n (self-hosted, free) + Google Sheets + Gmail
Setup:
- Install n8n via Docker:
docker run -it --rm --name n8n -p 5678:5678 n8nio/n8n
```
- Create a workflow with these nodes:
- Google Sheets node → read last week's data rows
- HTTP Request node → pull any API metrics (GitHub commits, Stripe revenue, etc.)
- Code node → merge and format into summary text
- Gmail node → send formatted email to your inbox
- Authenticate Google and Gmail via OAuth in n8n credentials.
- Test with manual trigger, then activate.
Time saved: ~45 min/week of manual copy-paste across tabs.
Bonus: Add a Slack node to post the summary to a channel instead of (or alongside) email. n8n has 400+ integrations, so swap any node for your actual tools — Linear, Notion, Airtable, etc.