📄 What this workflow does
📄 What this workflow does This workflow turns a spreadsheet row into a fully formatted, media-rich WordPress article. It pulls the outline and brand context from Google Sheets/Docs, drafts the article with Anthropic or Gemini, enriches it with internal links, converts it to WordPress-ready HTML, uploads images to the WordPress Media Library, and updates your Google Sheet with links and statuses. Optionally, it can create WooCommerce products (kept disabled by default). 👤 Who is this for Content & SEO teams who publish long-form articles at scale. E-commerce teams creating product blogs/landing pages with galleries. Agencies and freelancers who want a repeatable, trackable content pipeline. Founders/marketers who want “brief → draft → images → publish” in one click. ✅ Requirements Google Sheets (content tracker with columns like Title, Query, Outline Link, Image Links, Status). Google Docs (for outline sources and saving final content). Anthropic &/or Gemini API access (drafting + transformations). WordPress site with REST API enabled (Basic/App Password auth) to upload media (and optionally create posts/products). SerpAPI key (for Google Images cover search) — optional; can be removed. (Optional) Perplexity API if you want the “read official docs once” tool for specs. ⚙️ How to set up Connect Google Sheets and select your tracking sheet/tab. Connect Google Docs (for reading the outline and saving the final article). Add Anthropic and/or Gemini credentials in n8n. Add WordPress credentials (REST API) in the HTTP Request nodes used for media upload (and product/post creation if enabled). (Optional) Add SerpAPI key for the image-cover search node. (Optional) Add Perplexity key in the Sonar node if you’ll parse official docs/specs. Publish/enable the Webhook (or your trigger), then test with a sample row (Status Writing = “Run”). 🔁 How it works Trigger → Get Info (Sheets): Picks the next row marked to run and sets “Processing.” Fetch Outline (Docs): Opens the outline link from the sheet. Content Outline Generator & On-page (Anthropic/Gemini): Writes the article using brand context, E-E-A-T rules, and (optionally) reads official docs once via Perplexity Sonar. Previous Posts → Aggregate → Add Internal Links (Gemini): Loads summaries/keywords of prior posts and injects at least 5 high-relevance internal links into the draft. HTML Version: Converts the draft to strict WordPress-ready HTML (H1–H4, justified paragraphs, links, lists, blockquotes). Post image to WordPress (sub-flow) Image Covers (SerpAPI): Finds a cover image by query. Google Sheets + Code: Parses Image Links and Product Image columns; converts Google Drive shares into direct downloads. Split & HTTP Requests: Downloads each image and uploads to WordPress Media Library. Aggregate + Code: Builds an HTML gallery snippet from uploaded URLs. Update Google Doc: Inserts the final article content into a Google Doc and stores the link. Merge → Update Status to Sheet: Writes back Content Final, Outline Link, statuses (Draft/Complete), and any media links. (Optional) Create WooCommerce Product: Disabled by default—enable if you want automatic product creation using the article HTML and gallery. 💡 About Margin AI Margin AI is an AI-services agency that acts as your AI Service Companion. We design intelligent, human-centric automation solutions—turning your team’s best practices into scalable workflows and tools. Industries like marketing, sales, and operations benefit from our tailored AI consulting, automation tools, and chatbot development. An n8n automation workflow template by Cong Nguyen.
Cong Nguyen
web
paid
Others in the same category, ranked by how often they are opened.
