Online Marketing Weekly Report

Welcome to Online Marketing Weekly Report Workflow!

This workflow has the following sequence:

1. time trigger (e.g. every Monday at 7 a.m.)
2. retrieval of Online Marketing data from the last 7 days (via sub workflows)
3. assignment and summary of the data
4. retrieval of Online Marketing data from the same time period of the previous year
5. allocation and summary of the data
6. preparation in tabular form and brief analysis by AI.
7. sending the report as an email
8. preparation in short form by AI for Telegram (optional)
9. sending as Telegram message.

The following accesses are required for the workflow:
- Google Analytics (via Google Analytics API): [Documentation](https://docs.n8n.io/integrations/builtin/credentials/google/)
- Google Ads (via HTTP Request -> Google Ads API):[Documentation](https://docs.n8n.io/integrations/builtin/credentials/google/)
- Meta Ads (via Facebook Graph API): [Documentation](https://docs.n8n.io/integrations/builtin/credentials/facebookgraph/)
- AI API access (e.g. via OpenAI, Anthropic, Google or Ollama)
- SMTP access data (for sending the mail)
- Telegram access data (optional for sending as Telegram message): [Documentation](https://docs.n8n.io/integrations/builtin/credentials/telegram/)

You can contact me via LinkedIn, if you have any questions: https://www.linkedin.com/in/friedemann-schuetz