Write SEO WordPress posts from Google Sheets with Perplexity, OpenAI and PostWire

## Turn a keyword list into researched WordPress articles that share themselves Twice a week Perplexity researches the next keyword from your sheet and writes the article with its sources, GPT Image draws the cover, WordPress publishes it and PostWire shares it on LinkedIn and Facebook. ### How it works 1. Monday and Thursday at 8:00 takes the first keyword with the status ready from Google Sheets. 2. Research and write with Perplexity returns the SEO title, slug, meta description, the article in HTML, a cover idea and a post per network. Is the article ready? stops short articles. 3. Make the cover image (GPT Image) draws the cover, Upload the cover to WordPress adds it to your media library and Publish the article (WordPress) posts it with a sources list. 4. Share on LinkedIn and Facebook (PostWire) posts the link with the cover. 5. Mark the keyword posted writes the links in the row. If a step fails, Describe the problem says how to fix it, the row is marked needs fix and Email me the fix sends it to you. ### Setup 1. Install the verified PostWire node, connect your networks at postwire.io and paste your API key into a PostWire API credential. 2. Add Perplexity, OpenAI and Gmail credentials, and a WordPress credential (application password) in both WordPress steps. 3. Create a sheet with the columns keyword, audience, status, post_url, links, posted_at and note, and pick it in the three Sheets nodes. 4. Fill in Blog settings. ### Customize Set Publish the article to Draft to review first, or add Bluesky or Mastodon in the PostWire node on a paid plan.