n8n Workflow: Google Sheets SEO Articles to Blogger with OpenAI

Automatically turn Google Sheets keyword ideas into published Blogger SEO articles—using OpenAI

This n8n workflow runs every 30 minutes to pull an unpublished keyword from your Google Sheets, generate a long-form SEO article with OpenAI research (via Wikipedia), publish it to Blogger, and then write the published post URL back into the same sheet.

What this workflow does

• Schedules runs every 30 minutes to keep your content pipeline moving.
• Retrieves a matching row from your keyword list in Google Sheets using the Is_pub field (unpublished items).
• Generates a long-form SEO article with an OpenAI-powered agent that performs research using the Wikipedia tool.
• Extracts a strict HTML payload from the AI response (wrapped in <title> and <content>) so the Blogger post is reliable.
• Publishes to Blogger using the generated title and HTML content, applying the sheet’s Niche value as a label.
• Updates Google Sheets by writing the new Blogger post URL back into the same row’s Is_pub column.

Use cases

• Maintain an always-on Blogger SEO content pipeline from a spreadsheet-managed keyword backlog.
• For SaaS operators, streamline “keyword → article → URL tracking” without manual publishing steps.
• For automation engineers, use a production-style flow that includes state management via Is_pub and URL feedback loops.

Technical details

• Schedule Trigger: runs every 30 minutes.
• Google Sheets (OAuth2): reads columns including Niche, Keyword, Is_pub, and uses row_number to update the correct row.
• OpenAI via LangChain agent (Wikipedia tool): generates a full HTML article.
• Code: cleans/extracts <title> and <content> for dependable posting.
• Blogger API (OAuth2): creates posts under the specified Blog ID with labels.

Setup checklist: configure Google Sheets OAuth2, OpenAI API credentials and chat model(s), Blogger OAuth2 + target Blog ID, and ensure your Is_pub column reliably marks unpublished keywords and stores the published URL after posting.