Send weekly SEO keyword email reports with Google Search Console, GPT-4o-mini and Gmail

Every Monday morning, this workflow pulls your top 10 keywords from Google Search Console, passes the data to GPT-4o-mini, and emails a polished 150–200 word SEO digest to your client — automatically. You configure it once with four values, and it runs on its own every week. Built for SEO agencies and freelancers who want to deliver consistent client reporting without spending an hour writing it manually. --- What This Workflow Does Scheduled weekly trigger — Fires automatically every Monday at 8AM so you never miss a reporting week, with zero manual effort. Live GSC data pull — Fetches the top 10 keywords by clicks from Google Search Console for the past 7 days, directly from the API. Clean keyword formatting — Converts raw API data into a readable list showing keyword, clicks, impressions, CTR, and average position for every query. AI-written email body — GPT-4o-mini reads the keyword data and writes a professional, conversational 150–200 word digest — no templates, no copy-paste. One-config setup — All client details (site URL, client name, recipient email, agency name) live in a single node. Change it once to deploy for any client. Automated Gmail delivery — The final report is sent from your connected Gmail account with a dynamic subject line including the date range and client name. --- Setup Requirements Tools and accounts needed: - n8n instance (self-hosted or cloud) - Google account with Google Search Console access (OAuth2 credential) - Gmail account for sending reports (OAuth2 credential — can be the same Google account) - OpenAI account with GPT-4o-mini API access Estimated Setup Time: 10–15 minutes --- Step-by-Step Setup 1. Import the workflow — Open n8n → Workflows → Import from JSON. Paste the workflow JSON and import. Confirm all 9 nodes are connected in a straight line. 2. Connect your Google Search Console credential — In n8n, go to Credentials → New → Google OAuth2 API. Complete the OAuth flow with the Google account that has access to your GSC property. Once connected, open the 3. HTTP — Fetch GSC Top Keywords node and select this credential under the OAuth2 field. > ⚠️ Your GSC property URL must match exactly. If your property is https://www.example.com/, the URL in the config must be identical — including the trailing slash. 3. Connect your Gmail credential — Go to Credentials → New → Gmail OAuth2. Complete the OAuth flow with the Gmail account you want to send reports from. Open the 9. Gmail — Send Weekly Report node and select this credential. 4. Add your OpenAI API key — Go to Credentials → New → OpenAI API. Paste your API key from platform.openai.com. Open the 7. OpenAI — GPT-4o-mini Model node and select this credential. 5. Edit your config values — Open the 2. Set — Config Values node. This is the only node you need to change. Replace all four values: | Field | What to enter | |---|---| | siteUrl | Your exact GSC property URL (e.g. https://www.example.com/) | | clientName | Client business name (appears in the email greeting) | | recipientEmail | The email address to receive the weekly report | | agencyName | Your agency name (appears in the email footer) | 6. Activate the workflow — Toggle the workflow to Active. It will now run automatically every Monday at 8AM. --- How It Works (Step by Step) Step 1 — Schedule Trigger (Every Monday 8AM) The workflow fires automatically using a cron schedule set to every Monday at 8AM. No manual action is needed once the workflow is active. Step 2 — Set Config Values Four variables are stored here: the site URL, client name, recipient email, and agency name. These are referenced by every subsequent step so you only update them in one place. Step 3 — HTTP Request (Google Search Console API) An authenticated POST request goes to the Google Search Console Search Analytics API. It asks for the top 10 keywords by clicks for the past 7 days, automatically calculating the start and end dates based on today's date. Step 4 — Set (Extract Fields) The raw API response is