Want blog posts that research themselves, write themselves, add keywords, pick an image, and land in *WordPress* as a ready-to-publish draft? In this step-by-step tutorial I build a complete SEO content pipeline using *n8n*, *OpenAI*, *Perplexity*, *SerpAPI*, *Google Sheets/Trends*, and WordPress - including *weekly scheduling*, *images*, and *Rank Math-friendly metadata*. To *get the JSON and Google Sheet templates* , choose one of the implementation options: A) *Do-it-yourself* (€59): B) *Guided* (€159, up to 2 hours): Please send the payment confirmation to *alex@ * - I will reply with the artefacts and schedule integration session(s) (only for the Guided option) *What you’ll learn* 1. Find trending topics from your niche (Google Trends via SerpAPI), then auto-generate an SEO title 2. Deep research with Perplexity, structure the findings, and turn them into a long-form article 3. Generate SEO metadata (focus keyword, slug, meta description, OG/Twitter cards) 4. Create/select on-brand images (OpenAI image models or Pexels) with alt text 5. Format HTML for WordPress and auto-publish as a draft 6. Store outputs back to Google Sheets and tune Rank Math settings before publishing 7. Schedule the whole flow to run weekly *Stack* 1. n8n (workflows, scheduler, Google Sheets/Drive, WordPress) 2. SerpAPI (Google News/Trends search) 3. Perplexity (Sonar Deep/Reasoning for research) 4. OpenAI (content + image), or Pexels API for stock images 5. Rank Math for final on-page checks *Timestamps* below ⤵️ If this helped, please like & subscribe. Drop questions or your use case in the comments! 00:00 – What the pipeline automates (topic → article → keywords → image → WP draft) 00:30 – WordPress draft + metadata overview; start n8n locally 00:50 – Sign in to n8n; quick tour of existing flows 00:57 – Install/Update SerpAPI community node in n8n 01:32 – Create workflow + import prepared JSON 01:58 – Two run modes: manual trigger vs weekly Google Trends schedule 02:33 – Using Google Sheets profile as the single source of truth 02:44 – Manual run: read company/ICP data from the spreadsheet 02:53 – Find trending topics & harvest popular titles from your niche 03:18 – Deep research with Perplexity; generate metadata & outline 03:39 – Create/fetch images; merge with SEO-optimized article 04:01 – Convert to clean WordPress-ready HTML; write draft; append to Sheet 04:15 – Upload and assign the featured image in WordPress 04:28 – End-to-end run preview 04:44 – Configure Google Sheets node in n8n 05:12 – Configure Google Trends (SerpAPI) node 06:02 – Model choices (GPT-4.1 mini vs higher-end; Perplexity models) 06:24 – Perplexity setup: Sonar Deep Search + prompt structure 07:13 – Aggregate research & metadata → article generator 07:39 – Image keywords + alt text generation 08:05 – Image options: DALL·E vs GPT-Image-1 vs Pexels; prompts + API keys 09:53 – Pick generated vs stock image dynamically 10:03 – WordPress credentials (application password) 11:47 – Enable Google APIs (Sheets/Drive) in GCP 12:36 – OAuth credentials & redirect URI for Sheets/Drive 13:43 – Consent screen, scopes, add test user, sign-in flow 14:55 – Validate Sheets node connection & file picker 15:19 – Build the “Example Blog” spreadsheet; column overview 18:08 – Execute nodes; verify data flow in n8n 19:01 – SerpAPI account, quotas, quick test 20:02 – Perplexity credits & API key; known n8n connect quirk 21:07 – Parse research → concise report 21:40 – SEO metadata generator (focus KW, title, slug, OG/Twitter) 22:03 – Structured JSON for WordPress/Rank Math fields 22:45 – Image keyword suggestions (concepts that match the article) 24:06 – Image quality note & production model tips 24:27 – Final HTML formatting & cleanup 24:41 – Verify populated fields in Google Sheets 25:24 – Create WP draft, upload/assign image 25:41 – Find the draft in WordPress 26:10 – Why it’s a draft: finish Rank Math manually 27:18 – Set focus keyword, OG/Twitter cards from the Sheet 28:51 – Final checks: Rank Math score & AI-content % 29:08 – Publish & live demo; next steps #n8n #tutorial #openai #perplexity #serpapi #googletrends #wordpress #automation #aiautomation #blog #blogautomation