Get a clear SEO snapshot in your inbox every Monday. The setup pulls search performance from Google Search Console and emails a simple report through Gmail. It helps marketing teams track top queries without opening dashboards.

At 7AM each Monday a schedule starts the run. An HTTP Request calls the Search Analytics API for your site and returns rows with queries, clicks, impressions, click through rate, and average position. A Function node turns these rows into a short list with numbered lines that anyone can read. Gmail then delivers the summary to your chosen recipients so the team can react to wins or dips right away. The flow keeps the message short and readable, which makes weekly reviews fast.

Connect a Gmail account and a Google Search Console property, then update the site URL and request settings in the HTTP node. Expect to cut weekly reporting time from 2 hours to 5 minutes and lower copy paste errors by about 90 percent. Great for small teams that want a steady Monday report for keywords and performance. After testing with real data, switch it on and let the report arrive on time every week.

• Weekly Monday 7AM schedule starts the run automatically.
• HTTP Request pulls Search Analytics data from Google Search Console for your site URL.
• Function node formats rows into a numbered list with query, clicks, impressions, CTR, and position.
• Gmail node sends the formatted summary to chosen recipients using OAuth2 credentials.
• Sticky notes on the canvas outline config steps for Search Console and email.
• Lean, single path flow with three action nodes for easy maintenance.

• Reduce manual work from 2 hours to 5 minutes each week
• Automate 100 percent of weekly SEO email delivery
• Improve reporting accuracy by about 90 percent by removing copy paste steps
• Connect Gmail and Google Search Console in one flow
• Deliver a consistent 7AM Monday report without reminders

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Gmail and Google Search Console. See the Tools Required section above for links to create accounts with these services.
3. Open the Cron node named Weekly Trigger and confirm the schedule is set to Monday at 7AM. Adjust day and time to match your timezone and reporting window.
4. Double click the HTTP Request node named Get SEO Data from GSC. In the Credential to connect with dropdown, click Create new credential and follow the on screen steps to connect your Google Search Console access.
5. Still in the HTTP Request node, replace YOUR_SITE_URL in the URL with your verified property URL. Make sure the request body includes the date range and dimensions you need for your report.
6. Double click the Function node named Generate SEO Report. Review the text format and adjust the lines if you want different fields or labels in the email.
7. Open the Gmail node named Send Weekly Report by Email. In the Credential to connect with dropdown, click Create new credential and follow the on screen steps to connect your Gmail account.
8. Set the To field to your recipients. In the email body, click Add Expression and pick the field from the Function node that contains the report text so the message includes the generated summary.
9. Click Execute Workflow to run a test. Check the node logs for any HTTP errors and confirm the email arrives with the expected content.
10. If the HTTP Request returns empty data, confirm that your Google Search Console property is verified and that the date range contains recent traffic.
11. If you see an authentication error, reopen the node, reselect the credential, and complete the sign in flow again. Make sure the account has access to the GSC property and that Gmail sending is allowed.
12. Once the test looks good, click Activate to turn on scheduling. Monitor the next Monday run and compare metrics with Search Console to validate accuracy.