Google Sheets to OpenAI SEO Generator

Turbocharge your content production. This workflow watches a Google Sheet for new rows containing keywords or topics, sends them to OpenAI with a custom prompt, and writes the generated SEO content back to the same row. Perfect for e-commerce catalogs and bulk blogging.

#OpenAI

#GPT-4

#Google Sheets

#SEO

#Content

Automation Logic

n8n JSON Blueprint

This workflow is pre-configured and ready for deployment. Simply import the JSON template into your n8n instance and configure your credentials.

This is an exclusive blueprint. Copy the JSON below to use it.

QUICK DEPLOY

1
Download the .json file
2
Open n8n & click "Import"
3
Configure your API keys

PRO TIP

Always test your workflow in a development environment before pushing to production.

JSON BLUEPRINT

n8n-workflow.json

{
  "nodes": [
    {
      "parameters": {
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "documentId": "YOUR_GSHEET_ID",
        "sheetName": "Sheet1",
        "options": {}
      },
      "name": "Google Sheets Trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "typeVersion": 1,
      "position": [
        250,
        300
      ]
    },
    {
      "parameters": {
        "model": "gpt-4",
        "messages": {
          "message": [
            {
              "role": "system",
              "content": "You are an SEO expert. Write a compelling 160-character meta description for the following keyword."
            },
            {
              "content": "={{$node[\"Google Sheets Trigger\"].json[\"Keyword\"]}}"
            }
          ]
        }
      },
      "name": "OpenAI SEO",
      "type": "n8n-nodes-base.openAi",
      "typeVersion": 1,
      "position": [
        500,
        300
      ]
    },
    {
      "parameters": {
        "operation": "update",
        "documentId": "YOUR_GSHEET_ID",
        "sheetName": "Sheet1",
        "key": "Keyword",
        "columns": {
          "mappingMode": "defineBelow",
          "value": [
            {
              "column": "SEO Description",
              "value": "={{$node[\"OpenAI SEO\"].json[\"message\"][\"content\"]}}"
            }
          ]
        }
      },
      "name": "Update Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 3,
      "position": [
        750,
        300
      ]
    }
  ],
  "connections": {
    "Google Sheets Trigger": {
      "main": [
        [
          {
            "node": "OpenAI SEO",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI SEO": {
      "main": [
        [
          {
            "node": "Update Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

To use this, copy the JSON above and paste it directly onto your n8n canvas.

IMPLEMENTATION GUIDE

Required Nodes

OpenAI Node
GPT-4 Node
Google Sheets Node
SEO Node
Content Node
Cron / Webhook Trigger

Core Benefits

100% Automated Execution
Reduces Manual Data Entry
Infinite Scalability

Need Help Building Your Private Cloud?

Join the elite marketers who have offloaded their entire backend to n8n. Get direct support and custom builds in our private forum.

EXPLORE PREMIUM PLANS PRIVATE FORUM