Weekly SEMrush and GA4 SEO report
Weekly SEO summary from SEMrush and GA4, sent to Gmail and Slack. This free n8n template sends a weekly SEO and competitor summary. Every Monday at 7am it requests organic ranking data from the SEMrush API, a 7-day landing page report from the GA4 Data API and the HTML of one competitor page. It hashes that page and compares it with the previous run's stored hash. An AI step using the OpenAI gpt-5-mini model writes a 4 to 5 sentence summary with one key action item. The summary goes out as an HTML email through Gmail and to a Slack channel.
Steps
- Trigger: Every Monday at 7am
Scheduled trigger. - Request domain organic ranking dataSEMrush
SEMrush API. - Combine SEMrush, GA4 and competitor-page responses
One dataset for analysis. - Hash the competitor HTML and compare
Flags whether the competitor page changed. - AI writes the summaryOpenAI
gpt-5-mini, 4 to 5 sentences, one action item. - Output: Send the summary by Gmail and SlackGmail
Same text in an HTML email and a Slack channel. - Output: Post an error alert on failureSlack
To an ops Slack channel.
Limits
- Watches a single competitor page.
- Needs a SEMrush API key; SEMrush plan terms are not on the page.
- Needs five credentials: SEMrush, Google, OpenAI, Gmail and Slack.
What it does well
- Flags a change on one competitor page each week.
- Failed steps send an alert to a separate Slack channel.
Before you import
If any step fails, an error alert goes to an ops Slack channel.
Similar templates
Shopify orders to Sheets with AI tags
Also for scheduling and ops, 9 steps.
Slack standup digest with OpenAI
Also for scheduling and ops, 8 steps.
Daily RSS digest scored by Gemini
Also for scheduling and ops, 7 steps.
Gmail and OpenAI: 29 templates compared
Same two apps, different steps.
Gmail and Slack: 18 templates compared
Same two apps, different steps.
OpenAI and Slack: 17 templates compared
Same two apps, different steps.
Send a recurring summary
Other templates that do this task.