What this workflow does
This workflow automatically gets SEO data from Google Search Console every Monday at 7 AM.
It makes a clear report with clicks, impressions, CTR, and positions for the past week.
Then, it sends the report by email using Gmail.
This removes slow manual work and keeps SEO updates reliable and on time.
Who should use this workflow
This workflow is for digital marketers or SEO specialists who report SEO data for several sites.
It helps anyone with Google Search Console data and a Gmail account who wants weekly automatic reports.
Tools and services used
- Google Search Console API: To request SEO performance data.
- n8n automation platform: To connect nodes and automate the workflow.
- Gmail with OAuth2 credentials: To send email reports.
- HTTP Basic Authentication: For secure API access to Google Search Console.
Inputs, processing, and outputs
Inputs
- Weekly cron trigger set for Monday 7 AM.
- Google Search Console API credentials.
- Gmail OAuth2 credentials.
- Site URL encoded properly in the API request.
Processing steps
- Cron Trigger node: Starts empty trigger every Monday at 7 AM.
- HTTP Request node: Sends POST request to Google Search Console API with a JSON body for last 7 days data, focusing on search queries.
- Function node: Runs JavaScript code to take API response rows, then makes a text report with top 10 queries and their clicks, impressions, CTR, and position.
- Gmail node: Sends the report by email using the Gmail account with OAuth2.
Outputs
- A clear SEO report listing top queries with key metrics.
- An email sent every Monday morning with the SEO report.
Beginner step-by-step: How to use this workflow in n8n
1. Import the workflow
- Click the Download button on this page to get the workflow file.
- Open n8n editor.
- Go to “Import from File” and select the downloaded workflow.
2. Configure credentials and settings
- Add Google Search Console API credentials with HTTP Basic Auth.
- Add Gmail OAuth2 credentials for sending emails.
- Update the site URL in the HTTP Request node to your URL in encoded format.
- Change the email address in the Gmail node to the one you want to receive reports.
3. Test and activate
- Run the workflow manually to check the report is generated and sent.
- If all looks good, switch the workflow to Active to run every Monday at 7 AM.
If self hosting n8n, see self-host n8n for setup help.
Customization ideas
- Change cron to daily or monthly for different report timing.
- Add more dimensions like “page” or “device” in the API request body for deeper details.
- Use HTML formatting in Gmail node to make the report easier to read.
- Send reports to multiple email addresses by adding them with commas.
Edge cases and errors to watch for
- HTTP 401 Unauthorized: Check Google API credentials are correct and not expired.
- Empty report or no data: Confirm API request date range and dimensions match your data in Search Console.
- Gmail errors: Ensure Gmail OAuth2 is set up and Google Cloud Console has Gmail API enabled.
Summary of results
✓ Saves many hours from manual SEO reporting each week.
✓ Makes SEO reports consistent and timely every Monday.
✓ Reduces mistakes in copying data.
✓ Sends a simple, clear email with the top search queries.
✓ Allows easy changes for more data or different schedules.