Blog Writer & Editor with Google Sheets Memory (GPT-4)

Chat to write or reword a blog post. The workflow stores each result in Google Sheets and uses a sub-workflow “Google tool” to count rows per session (your running context). If a session exceeds a row threshold, the flow can branch (e.g., stop or notify).

⚙️ Setup Instructions

1️⃣ Set Up OpenAI Connection Go to OpenAI Platform
Navigate to OpenAI Billing
Add funds to your billing account
Copy your API key into the OpenAI credentials in n8n

2️⃣ Prepare Your Google Sheet Connect your Data in Google Sheets Use this format: Sample Sheet Row 1 = column names (e.g., session, Rows, output) Data in rows 2–100 (or more if you prefer) In n8n, use Google Sheets OAuth2 → pick your Spreadsheet and Worksheet (Optional) You can adapt this to Airtable, Notion, or a Database

🧠 How It Works Chat Trigger**: Provide a topic (write) or paste existing text (reword).
Code Node (“Choose to Write or Edit Blog”):
Builds a system_prompt + user_prompt
Instructs the agent to call the Google tool (sub-workflow) with only the sessionid to count existing rows.
Tool Workflow (“google”):
Fetches rows from the sheet → filters by session → summarizes row count.
Agent (“Blog Writer & Editor”):
Returns structured JSON (items/rows, session, blog body).
Store (Google Sheets):
Appends { session, Rows, output } to the sheet.
If Node**:
Example rule: Rows > 3 → branch/limit/notify as needed.

💬 Example Prompts “Write a 600-word blog about n8n agents with 3 bullet takeaways. Session: abc123.”
“Reword this post into a concise LinkedIn article. Session: launchQ3:\n<your text here>”
“Draft a blog intro and 5 SEO headlines on marketing automation. Session: mkt-01.”

📬 Contact Need help tailoring this to Airtable/Notion/DB, or adding auto-publishing?

📧 rbreen@ynteractive.com
🔗 Robert Breen
🌐 ynteractive.com