See llms.txt for all machine-readable content.

Back to Templates

Draft weekly SEO blogs and social posts with OpenAI, Google Sheets and WordPress

Created by

Created by: AI Automation Playbook || aiautomationplaybook
AI Automation Playbook

Last update

Last update 2 days ago

Categories

Quick overview

This workflow runs two weekly schedules to draft an SEO blog post with OpenAI, store it in Google Sheets, and email it for approval, then repurposes approved drafts into social copy, saves it to Sheets, and creates a WordPress post in draft status.

How it works

  1. Runs every Monday at 7:00 AM to start the weekly blog-drafting lane.
  2. Selects the next topic/keyword from a rotating quarterly topic list and sends the brief to OpenAI to generate a 1,000–1,200 word Markdown blog draft.
  3. Appends the draft to the Google Sheets “Drafts” tab with a pending status and emails the draft to the owner via Gmail for review.
  4. Runs every Wednesday at 9:00 AM to start the repurposing lane.
  5. Reads the Google Sheets “Drafts” tab, keeps only rows marked Approved, and sends each approved draft to OpenAI to generate a labeled pack of social posts and a newsletter blurb.
  6. Saves the generated social content to the Google Sheets “SocialPosts” tab, creates a WordPress post as a draft (not published), and emails the owner the social pack via Gmail.

Setup

  1. Add OpenAI API credentials for the two OpenAI chat model nodes and choose the model name in the CONFIG values if needed.
  2. Add a Google Sheets OAuth2 connection, set your Google Sheet ID in both CONFIG nodes, and create two tabs named “Drafts” and “SocialPosts” with columns that match the appended fields.
  3. Add a Gmail OAuth2 connection and set the owner email address in the CONFIG values.
  4. Add WordPress API credentials and confirm the site and permissions allow creating posts in draft status.
  5. Update the CONFIG values (business name, niche, service area, phone) and edit the topic list in the code step to match your quarterly content plan.

Additional info

A two-stage, approval-gated content pipeline. Stage 1 (Mondays): rotates through a quarterly topic list, AI writes the blog draft, saves it to Google Sheets and emails it for review — nothing publishes without approval. Stage 2 (Wednesdays): takes only owner-marked Approved drafts, AI repurposes them into social posts, saves them to Sheets, and creates a WordPress DRAFT — never auto-published. Unlike 4082, which auto-publishes its blog posts to WordPress and schedules social posts with no approval step, and unlike 11285, which approval-gates a single blog draft into Google Docs, workflow-05 pairs an approval gate with a second leg: Monday drafts are saved to Sheets and emailed for review and nothing publishes without approval, and on Wednesday only owner-marked Approved drafts are repurposed into social posts and created as WordPress drafts — never auto-published. Setup: OpenAI credentials, Google Sheets (tabs Drafts and SocialPosts), Gmail, and WordPress credentials; business name and owner email go in the CONFIG node.