January 22, 2026

Google Sheets + ClickUp: idea briefs ready to ship

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Your content backlog looks “full,” but somehow it’s still empty. Lots of half-ideas, recycled takes, and Slack threads where someone says “we should post about this” and nothing happens.

This is what content strategists complain about privately. growth marketers feel it when pipeline slows. And founders get dragged into brainstorming because nobody trusts the ideas. A solid Sheets ClickUp automation fixes that by turning real customer language into briefs your team can actually ship.

Below you’ll see how the workflow discovers pain points, generates platform-ready ideas, drops them into Google Sheets, and creates ClickUp tasks plus a Slack summary so the whole team stays aligned.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Google Sheets + ClickUp: idea briefs ready to ship

Click to explore

flowchart LR

    subgraph sg0["Scheduled Market Discovery Flow"]
        direction LR
        n2@{ icon: "mdi:play-circle", form: "rounded", label: "Scheduled Market Discovery T..", pos: "b", h: 48 }
        n3@{ icon: "mdi:swap-vertical", form: "rounded", label: "Inject Niche and Keyword Par..", pos: "b", h: 48 }
        n4@{ icon: "mdi:robot", form: "rounded", label: "Extract Raw User Pain Points..", pos: "b", h: 48 }
        n5@{ icon: "mdi:wrench", form: "rounded", label: "Public Search & Social Intel..", pos: "b", h: 48 }
        n6@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Reasoning Engine for ..", pos: "b", h: 48 }
        n7@{ icon: "mdi:robot", form: "rounded", label: "Generate Pain-Driven Content..", pos: "b", h: 48 }
        n8@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Reasoning Engine for ..", pos: "b", h: 48 }
        n9["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Normalize and Parse Content .."]
        n10@{ icon: "mdi:database", form: "rounded", label: "Append Content Ideas to Cont..", pos: "b", h: 48 }
        n11["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/clickup.svg' width='40' height='40' /></div><br/>Create Content Task in ClickUp"]
        n12@{ icon: "mdi:cog", form: "rounded", label: "Aggregate Generated Content ..", pos: "b", h: 48 }
        n13@{ icon: "mdi:robot", form: "rounded", label: "Generate Slack Summary of Co..", pos: "b", h: 48 }
        n14@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Reasoning Engine for ..", pos: "b", h: 48 }
        n15["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/slack.svg' width='40' height='40' /></div><br/>Send Content Ideation Summar.."]
        n12 --> n13
        n2 --> n3
        n3 --> n4
        n13 --> n15
        n9 --> n10
        n9 --> n11
        n9 --> n12
        n14 -.-> n13
        n8 -.-> n7
        n6 -.-> n4
        n5 -.-> n4
        n4 --> n7
        n7 --> n9
    end

    subgraph sg1["Workflow Error Handler Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "Workflow Error Handler", pos: "b", h: 48 }
        n1@{ icon: "mdi:message-outline", form: "rounded", label: "Send a message1", pos: "b", h: 48 }
        n0 --> n1
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n2,n0 trigger
    class n4,n7,n13 ai
    class n6,n8,n14 aiModel
    class n5 ai
    class n10 database
    class n9 code
    classDef customIcon fill:none,stroke:none
    class n9,n11,n15 customIcon

The Problem: Great content ideas don’t survive the handoff

Most teams don’t fail at “coming up with ideas.” They fail at getting from raw customer signals to something a writer or creator can execute without a meeting. You might spot a perfect complaint on Reddit, a sharp question in a community, or a blunt line in a comment thread. Then it gets copied into a doc, lost in a bookmark folder, or paraphrased until it sounds like marketing again. Next week, you’re back to guessing. The worst part is the mental load: deciding what’s real, what repeats, and what deserves a brief.

It adds up fast. Here’s where it breaks down in day-to-day work.

Manual “research days” eat half a day, and you still leave with shaky confidence.
Good quotes get rewritten, which makes the final hook weaker and less believable.
Ideas live in five places, so your team duplicates work and misses patterns.
Even when an idea is strong, it doesn’t become a ClickUp task with a clear angle, CTA, and format.

The Solution: Turn public pain points into briefs in Sheets and ClickUp

This workflow runs on a schedule and behaves like a lightweight research assistant that never forgets to log the work. First, it loads your niche and keyword parameters (so you control the lane). Then an AI discovery agent scans public conversations via a social/search connector and extracts recurring pain points and the exact phrases people use. No “thought leadership” spin. Just the raw frustrations, questions, and unmet needs. A second AI agent turns those signals into execution-ready content ideas, including the platform, format, hook, core pain point, resonance logic, and a CTA. Finally, the ideas are normalized (cleaned and structured), appended into a Google Sheets database, converted into ClickUp tasks, and summarized in Slack so the team sees what’s new without digging.

The workflow starts on a timed schedule, then runs two AI passes: one to discover pain, another to convert it into usable ideas. After cleanup, it writes the same “source of truth” into Google Sheets, creates ClickUp tasks automatically, and posts a short team summary in Slack.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Runs market discovery on a schedule without anyone remembering.
Extracts recurring pain points and the exact wording people use.
Generates platform-specific ideas with hooks, formats, and CTAs.
Appends to Google Sheets, creates ClickUp tasks, and posts a Slack summary.

Get a fresh batch of briefs in about 30 minutes of background run time.
Stop burning a half day per week on manual “idea mining.”
Publish with more confidence because the hook comes from real language.
Keep writers and operators aligned with one Sheet and one task queue.
Catch failures quickly via email instead of discovering gaps days later.

Example: What This Looks Like

Say your team wants 15 new content briefs each week across LinkedIn and a newsletter. Manually, it’s common to spend about 2 hours collecting quotes, another hour clustering themes, then another hour turning the best bits into “real” briefs, so roughly half a day. With this workflow, you set the niche and keywords once, let the scheduled run do the discovery and ideation, and you review the new rows in Google Sheets plus the ClickUp tasks. Your time becomes a quick editorial pass, maybe 20 minutes, not a research marathon.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets for the central idea database.
ClickUp to turn ideas into assigned tasks.
Slack for visibility and daily team awareness.
OpenAI API key (get it from your OpenAI account dashboard).
MCP (Xpoz) credentials (get them from your MCP provider workspace).

Skill level: Intermediate. You’ll connect accounts, paste API keys, and tweak prompts/fields to match your niche.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A scheduled run kicks things off. n8n triggers this workflow automatically, so discovery happens even when the team is busy shipping.

Your niche and keywords set the boundaries. The workflow injects your research inputs first, which keeps outputs relevant and prevents the agents from wandering into random trends.

AI pulls pain from public conversations, then converts it into briefs. One agent focuses on extracting frustrations and phrasing through the social/search connector. A second agent turns those raw signals into platform-ready ideas with a hook, the core pain point, and a CTA that fits.

Everything lands where your team already works. The workflow cleans the AI output, appends structured rows into Google Sheets, creates ClickUp tasks for execution, then aggregates the run into a Slack summary so nobody has to hunt.

You can easily modify the keyword set to target a new product line based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Error Trigger

This workflow includes an error-handling path that triggers when any node fails, ensuring you receive alerts immediately.

Add the Error Capture Trigger node to your canvas (this is already present in the template).
Connect Error Capture Trigger to Dispatch Error Email as shown in the execution flow.
In Dispatch Error Email, set Subject to Workflow Error Alert.
Set Message to =🚨 *Workflow Error Alert* *Error Node:* {{ $json.node.name }} *Error Message:* {{ $json.error.message }} *Timestamp:* {{ $now.toISO() }} Please investigate immediately..

Credential Required: Connect your Gmail OAuth2 credentials in Dispatch Error Email (this node requires Gmail credentials but none are configured).

Step 2: Configure the Scheduled Trigger

The main workflow starts on a schedule and feeds research inputs into the AI pipeline.

Open Scheduled Discovery Start and set the schedule interval under Rule to your preferred cadence (e.g., daily or weekly).
Connect Scheduled Discovery Start to Set Research Inputs.
In Set Research Inputs, set body.niche to =n8n automations.
Set body.query to =lead generation and CRM automation using n8n.

⚠️ Common Pitfall: If you change the field names in Set Research Inputs, update the prompt expressions in AI Pain Insight Extractor accordingly.

Step 3: Set Up Market Discovery and AI Reasoning

This section captures market pain points and prepares the AI reasoning model and tool connection.

Open AI Pain Insight Extractor and confirm the Text prompt includes the expressions {{ $json.body.niche }} and {{ $json.body.query }}.
Ensure AI Pain Insight Extractor is connected to Market Reasoning Model via the ai_languageModel connection.
Verify Social Search MCP Connector is connected as the AI tool to AI Pain Insight Extractor.
In Social Search MCP Connector, set Endpoint URL to https://mcp.xpoz.ai/mcp and Authentication to bearerAuth.

Credential Required: Connect your httpBearerAuth credentials in Social Search MCP Connector.

Credential Required: Connect your openAiApi credentials in Market Reasoning Model.

The Social Search MCP Connector is an AI tool used by AI Pain Insight Extractor—credentials should be added to the tool node, and the AI model credentials should be added to Market Reasoning Model.

Step 4: Generate and Normalize Content Ideas with AI

The workflow converts market insights into structured content ideas, then normalizes the JSON output for downstream actions.

Open AI Content Idea Generator and confirm the Text prompt includes {{ $json.output }} to consume the discovery output.
Ensure AI Content Idea Generator is connected to Ideation Reasoning Model via the ai_languageModel connection.
Open Normalize Idea Output and keep the JavaScript code as-is to parse and normalize the AI JSON output.
Confirm the flow is AI Pain Insight Extractor → AI Content Idea Generator → Normalize Idea Output.

Credential Required: Connect your openAiApi credentials in Ideation Reasoning Model.

Step 5: Configure Output Destinations and Parallel Actions

After normalization, content ideas are routed to multiple destinations simultaneously.

Verify that Normalize Idea Output outputs to both Append Ideas to Sheet and Create ClickUp Content Task and Aggregate Idea Records in parallel.
In Append Ideas to Sheet, set Operation to append, select your Document and Sheet, and map columns to expressions like ={{ $json.content_hook }}, ={{ $json.platform }}, and ={{$now}}.
In Create ClickUp Content Task, set List, Team, Space, and Folder to your ClickUp IDs, and set Name to ={{$json.content_hook}}.
Set Additional Fields → Content in Create ClickUp Content Task to =Platform: {{$json.platform}} Format: {{$json.content_format}} Pain Point: {{$json.pain_point}} Why it resonates: {{$json.why_it_resonates}} CTA: {{$json.cta}}.

Credential Required: Connect your googleSheetsOAuth2Api credentials in Append Ideas to Sheet.

Credential Required: Connect your clickUpApi credentials in Create ClickUp Content Task.

Step 6: Summarize and Post to Slack

The aggregated ideas are summarized for a Slack channel using a separate AI model and then posted.

Ensure Aggregate Idea Records connects to Compose Slack Idea Summary and that Compose Slack Idea Summary connects to Post Summary to Slack.
In Compose Slack Idea Summary, keep the Text prompt as-is and confirm it uses {{ JSON.stringify($input.all().map(i => i.json), null, 2) }}.
Verify Slack Summary Model is attached as the language model to Compose Slack Idea Summary.
In Post Summary to Slack, set Text to ={{ $json.output }} and choose the target Channel.

Credential Required: Connect your openAiApi credentials in Slack Summary Model.

Credential Required: Connect your slackApi credentials in Post Summary to Slack.

The Slack Summary Model provides the AI output for Compose Slack Idea Summary—add OpenAI credentials to the model node, not the agent node.

Step 7: Test & Activate Your Workflow

Run a test execution to confirm all branches work, then activate the schedule for production use.

Click Execute Workflow to run a manual test from Scheduled Discovery Start.
Verify that Append Ideas to Sheet adds rows, Create ClickUp Content Task creates tasks, and Post Summary to Slack posts a summary.
Trigger an error intentionally (e.g., by removing an ID in Create ClickUp Content Task) to ensure Dispatch Error Email sends an alert.
When satisfied, toggle the workflow to Active to enable scheduled runs.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Google Sheets credentials can expire or need specific permissions. If things break, check the n8n credentials screen and the Google Cloud project access first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Frequently Asked Questions

How long does it take to set up this Sheets ClickUp automation?

Plan on about an hour once your accounts and API keys are ready.

Do I need coding skills to automate Google Sheets to ClickUp briefs?

No. You’ll mostly connect tools and adjust a few fields and prompts. The only “technical” part is copying API keys into n8n.

Is n8n free to use for this Sheets ClickUp automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API usage plus any MCP provider costs.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Sheets ClickUp automation workflow for a different niche or platform mix?

Yes, and it’s the point of the workflow. Update the “Set Research Inputs” node to change your niche, keywords, and constraints, then tune the prompts in the AI Pain Insight Extractor and AI Content Idea Generator to match your channels. Common tweaks include forcing only LinkedIn + email ideas, adding your ICP/job titles, and requiring a specific CTA style. If you want stricter structure, adjust the Normalize Idea Output step so Google Sheets and ClickUp always get clean fields.

Why is my Google Sheets connection failing in this workflow?

Usually it’s expired or missing OAuth permissions on the Google account tied to your n8n credential. Reconnect the Google Sheets credential in n8n, then confirm the target spreadsheet is shared with the same account. Also check that the sheet tab name and column mapping still match what the workflow expects, because renamed tabs are a surprisingly common cause.

How many ideas can this Sheets ClickUp automation handle?

A lot. On self-hosted n8n there’s no hard execution cap, so it mostly depends on your server and API rate limits from OpenAI, Slack, Google Sheets, and ClickUp.

Is this Sheets ClickUp automation better than using Zapier or Make?

For this specific workflow, n8n is usually the better fit because the logic is more complex than a simple “if this, then that.” You’re running multi-step AI agents, cleaning/normalizing the output, branching to both Google Sheets and ClickUp, then aggregating a Slack summary. Zapier and Make can do parts of that, but the cost and complexity climb quickly once you add AI steps and data shaping. n8n also gives you the option to self-host, which matters because this workflow is intended for self-hosted setups due to MCP tooling. If you’re unsure, Talk to an automation expert and you’ll get a straight answer based on your volume and team.

Once this is running, your backlog stops depending on someone having a “research mood.” The workflow handles the repetitive digging and formatting, and your team stays focused on publishing.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"meta": {
"instanceId": "150fee8897ed6fa512c925e6aca08385cdbdb6c3b95cec35c4778baa0333ea78",
"templateCredsSetupCompleted": null,
"templateId": null
},
"name": "Automated Market Signal Content Generator",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-12497",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
130,
70
],
"parameters": {
"color": 7,
"width": 1865,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "f8862827-0854-4d81-b8d7-af0a2a2d778e",
"name": "Error Capture Trigger",
"type": "n8n-nodes-base.errorTrigger",
"position": [
140,
560
],
"parameters": [],
"typeVersion": 1
},
{
"id": "532127a6-e52a-4899-abb5-c608c8b93938",
"name": "Dispatch Error Email",
"type": "n8n-nodes-base.gmail",
"position": [
380,
560
],
"webhookId": "3661e730-399e-45d7-8062-ec6affcff392",
"parameters": {
"message": "=\ud83d\udea8 *Workflow Error Alert*  *Error Node:* {{ $json.node.name }} *Error Message:* {{ $json.error.message }} *Timestamp:* {{ $now.toISO() }}  Please investigate immediately.",
"options": [],
"subject": "Workflow Error Alert",
"emailType": "text"
},
"typeVersion": 2.2
},
{
"id": "7dd9e60f-8fa6-40f2-a4cb-f5f92a7aba92",
"name": "Scheduled Discovery Start",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
130,
210
],
"parameters": {
"rule": {
"interval": [
[]
]
}
},
"typeVersion": 1.3
},
{
"id": "8daaa7c4-d159-46dc-9a54-d0c6cef4cc78",
"name": "Set Research Inputs",
"type": "n8n-nodes-base.set",
"position": [
360,
170
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "105bdfc5-b28e-4d96-a993-af24e5b24fff",
"name": "body.niche",
"type": "string",
"value": "=n8n automations"
},
{
"id": "619782c6-212c-4782-86f7-6f7819f1c294",
"name": "body.query",
"type": "string",
"value": "=lead generation and CRM automation using n8n"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "0a37bc3e-08db-4169-ab51-d19d0d4ccad4",
"name": "AI Pain Insight Extractor",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
610,
230
],
"parameters": {
"text": "=DISCOVERY REQUEST:\n\nNiche: \"{{ $json.body.niche }}\"\nResearch Topic / Keywords: \"{{ $json.body.query }}\"\n\nTask:\nScan public discussions related to the niche and keywords across the selected platforms.\n\nExtract:\n- Repeated pain points and frustrations\n- Common questions or complaints\n- Language users naturally use to describe their problems\n- Mentions of tools, workflows, or alternatives people talk about\n- Any marketing or growth challenges mentioned\n\nOutput requirements:\n- Write in clear bullet points\n- Group insights logically if needed\n- Focus on problems, not solutions\n- Ignore promotions, tutorials, or generic advice\n\nDo NOT format as JSON.\nThis output will be processed by another AI step.\n",
"options": {
"maxIterations": 30,
"systemMessage": "You are a market research discovery assistant.\n\nYour role:\n- Observe and summarize real user pain points from public online discussions\n- Capture authentic language and frustrations\n- Highlight patterns, not opinions\n\nRules:\n- Use only public information\n- Do not invent private or personal data\n- Be neutral and factual\n- Do not suggest solutions\n- Do not format output as JSON\n- Do not add conclusions or summaries\n\nYour output is raw discovery data for downstream processing.\n"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 3
},
{
"id": "b11c119b-d9d8-468a-ab55-b1f44bc6d91a",
"name": "Social Search MCP Connector",
"type": "@n8n/n8n-nodes-langchain.mcpClientTool",
"position": [
720,
430
],
"parameters": {
"options": [],
"endpointUrl": "https://mcp.xpoz.ai/mcp",
"authentication": "bearerAuth"
},
"credentials": {
"httpBearerAuth": {
"id": "t7ezbRpBs11G61N9",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "2a68fcee-95d8-4323-80ed-8bc844433049",
"name": "Market Reasoning Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
470,
400
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "gpt-4o"
},
"options": [],
"responsesApiEnabled": false
},
"credentials": {
"openAiApi": {
"id": "5Kzt6hGSZ1JHZqWN",
"name": ""
}
},
"typeVersion": 1.3
},
{
"id": "cb3853f8-a28e-4b27-9453-ccf313a47a8d",
"name": "AI Content Idea Generator",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
880,
190
],
"parameters": {
"text": "=CONTENT IDEA GENERATION TASK:\n\nYou are given raw market discovery insights below.\n\nINPUT DISCOVERY DATA:\n{{ $json.output }}\n\nYour task:\nConvert these pain points, frustrations, and user language into high-quality content ideas.\n\nFor each content idea, generate:\n- Content hook (scroll-stopping)\n- Best platform (LinkedIn, Twitter/X, Instagram)\n- Content format (Post, Thread, Carousel, Reel, Video)\n- Core pain point addressed\n- Why this content will resonate with the audience\n- Suggested CTA\n\nFocus on:\n- n8n automations\n- CRM and lead generation workflows\n- Complexity, learning curve, scaling, and integration issues\n\nAvoid:\n- Generic advice\n- Educational tutorials\n- Tool documentation tone\n\nThink like a growth marketer creating viral, pain-driven content.\n\nReturn ONLY valid JSON in the following format.\n",
"options": {
"maxIterations": 30,
"systemMessage": "You are a senior content strategist and growth marketer.\n\nYou specialize in:\n- Turning real customer pain points into high-performing content\n- B2B SaaS and automation niches\n- LinkedIn, Twitter/X, and Instagram content strategy\n\nRules:\n- Every idea must map to a real pain point\n- Hooks must be emotional, clear, and specific\n- Content must be creator-ready (can be posted as-is)\n- No fluff, no theory, no generic motivation\n- Output must be structured and actionable\n"
},
"promptType": "define"
},
"typeVersion": 3
},
{
"id": "8cb5e7ec-4930-4a0a-83b0-1712745ed6b6",
"name": "Ideation Reasoning Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
930,
420
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "gpt-4o"
},
"options": [],
"responsesApiEnabled": false
},
"credentials": {
"openAiApi": {
"id": "5Kzt6hGSZ1JHZqWN",
"name": ""
}
},
"typeVersion": 1.3
},
{
"id": "2ed29e45-6a74-4b1c-b394-b71f0b7ac09a",
"name": "Normalize Idea Output",
"type": "n8n-nodes-base.code",
"position": [
1140,
240
],
"parameters": {
"jsCode": "const item = $input.first();\n\nif (!item.json || !item.json.output) {\n  throw new Error(\"Missing AI output\");\n}\n\nlet raw = item.json.output;\n\n// 1\ufe0f\u20e3 Remove markdown fences\nraw = raw\n  .replace(/```json/gi, \"\")\n  .replace(/```/g, \"\")\n  .trim();\n\n// 2\ufe0f\u20e3 Parse JSON\nlet parsed;\ntry {\n  parsed = JSON.parse(raw);\n} catch (error) {\n  throw new Error(\"Failed to parse AI output as JSON: \" + error.message);\n}\n\n// 3\ufe0f\u20e3 Ensure array\nif (!Array.isArray(parsed)) {\n  throw new Error(\"Parsed output is not an array\");\n}\n\n// 4\ufe0f\u20e3 Normalize BOTH old + new formats\nreturn parsed.map(item => {\n  // NEW format (nested content_idea)\n  const idea = item.content_idea || item;\n\n  return {\n    json: {\n      platform:\n        idea.platform ||\n        idea.best_platform ||\n        \"Unknown\",\n\n      content_format:\n        idea.format ||\n        idea.content_format ||\n        \"Post\",\n\n      content_hook:\n        idea.hook ||\n        idea.content_hook ||\n        \"\",\n\n      pain_point:\n        idea.pain_point ||\n        idea.core_pain_point_addressed ||\n        \"\",\n\n      why_it_resonates:\n        idea.reason_resonate ||\n        idea.why_this_content_will_resonate ||\n        \"\",\n\n      cta:\n        idea.cta ||\n        idea.suggested_CTA ||\n        \"\"\n    }\n  };\n});\n"
},
"typeVersion": 2
},
{
"id": "b3c898f5-bd0a-4a07-af12-52ac7c3447f6",
"name": "Append Ideas to Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1110,
440
],
"parameters": {
"columns": {
"value": {
"CTA": "={{ $json.cta }}",
"Status": "New",
"Platform": "={{ $json.platform }}",
"Created At": "={{$now}}",
"Pain Point": "={{ $json.pain_point }}",
"Content Hook": "={{ $json.content_hook }}",
"Content Format": "={{ $json.content_format }}",
"Why It Resonates": "={{ $json.why_it_resonates }}"
},
"schema": [
{
"id": "Platform",
"type": "string",
"display": true,
"required": false,
"displayName": "Platform",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Content Format",
"type": "string",
"display": true,
"required": false,
"displayName": "Content Format",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Content Hook",
"type": "string",
"display": true,
"required": false,
"displayName": "Content Hook",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Pain Point",
"type": "string",
"display": true,
"required": false,
"displayName": "Pain Point",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Why It Resonates",
"type": "string",
"display": true,
"required": false,
"displayName": "Why It Resonates",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CTA",
"type": "string",
"display": true,
"required": false,
"displayName": "CTA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created At",
"type": "string",
"display": true,
"required": false,
"displayName": "Created At",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "content database"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "sample_leads_50"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "kpPEOLCGn963qpoh",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "38fdae68-abdb-494a-b72e-c7d503be519b",
"name": "Create ClickUp Content Task",
"type": "n8n-nodes-base.clickUp",
"position": [
1365,
450
],
"parameters": {
"list": "[YOUR_ID]",
"name": "={{$json.content_hook}}",
"team": "[YOUR_ID]",
"space": "[YOUR_ID]",
"folder": "[YOUR_ID]",
"additionalFields": {
"status": "to do",
"content": "=Platform: {{$json.platform}} Format: {{$json.content_format}}  Pain Point: {{$json.pain_point}}  Why it resonates: {{$json.why_it_resonates}}  CTA: {{$json.cta}}"
}
},
"credentials": {
"clickUpApi": {
"id": "kahuAqa6VKsSxhn1",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "e43cc333-584f-4d60-a9cb-e79842ae2a1d",
"name": "Aggregate Idea Records",
"type": "n8n-nodes-base.aggregate",
"position": [
1395,
200
],
"parameters": {
"options": [],
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "1ffc9d16-ab78-42e8-83df-3fc7c5cad1f3",
"name": "Compose Slack Idea Summary",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1645,
230
],
"parameters": {
"text": "=TASK:\nCreate a concise Slack message summarizing the generated content ideas.\n\nINPUT DATA:\n{{ JSON.stringify($input.all().map(i => i.json), null, 2) }}\n\nREQUIREMENTS:\n- This message is for a Slack channel (marketing / growth team)\n- Keep it short, clear, and skimmable\n- Highlight:\n  \u2022 Total number of content ideas\n  \u2022 Platforms covered\n  \u2022 Top 3 strongest hooks\n- Use emojis lightly for clarity (not spammy)\n- Do NOT include raw JSON\n- Do NOT include explanations\n\nOUTPUT:\nReturn ONLY the Slack message text.\n",
"options": {
"maxIterations": 30,
"systemMessage": "You are a senior growth and content operations manager.\n\nYour job:\n- Communicate insights clearly to busy teams\n- Summarize content plans in a Slack-friendly way\n- Highlight what matters, not everything\n\nRules:\n- Be concise and professional\n- Avoid marketing fluff\n- Prioritize clarity and action\n- Assume the reader will scan, not read deeply\n"
},
"promptType": "define"
},
"typeVersion": 3
},
{
"id": "c66bbfb1-01d1-4234-bbca-934400e150fd",
"name": "Slack Summary Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1610,
430
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "gpt-4o"
},
"options": [],
"responsesApiEnabled": false
},
"credentials": {
"openAiApi": {
"id": "5Kzt6hGSZ1JHZqWN",
"name": ""
}
},
"typeVersion": 1.3
},
{
"id": "f68709f5-75dc-4154-b24a-71b7701d7bf6",
"name": "Post Summary to Slack",
"type": "n8n-nodes-base.slack",
"position": [
1895,
210
],
"webhookId": "c15b6935-ed1d-4d93-9e8d-27d1b67d29f0",
"parameters": {
"text": "={{ $json.output }}",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "general-information"
},
"otherOptions": []
},
"credentials": {
"slackApi": {
"id": "rNqvWj9TfChPVRYY",
"name": ""
}
},
"typeVersion": 2.1
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": null,
"connections": {
"Error Capture Trigger": {
"main": [
[
{
"node": "Dispatch Error Email",
"type": "main",
"index": 0
}
]
]
},
"Aggregate Idea Records": {
"main": [
[
{
"node": "Compose Slack Idea Summary",
"type": "main",
"index": 0
}
]
]
},
"Scheduled Discovery Start": {
"main": [
[
{
"node": "Set Research Inputs",
"type": "main",
"index": 0
}
]
]
},
"Set Research Inputs": {
"main": [
[
{
"node": "AI Pain Insight Extractor",
"type": "main",
"index": 0
}
]
]
},
"Compose Slack Idea Summary": {
"main": [
[
{
"node": "Post Summary to Slack",
"type": "main",
"index": 0
}
]
]
},
"Normalize Idea Output": {
"main": [
[
{
"node": "Append Ideas to Sheet",
"type": "main",
"index": 0
},
{
"node": "Create ClickUp Content Task",
"type": "main",
"index": 0
},
{
"node": "Aggregate Idea Records",
"type": "main",
"index": 0
}
]
]
},
"Slack Summary Model": {
"ai_languageModel": [
[
{
"node": "Compose Slack Idea Summary",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Ideation Reasoning Model": {
"ai_languageModel": [
[
{
"node": "AI Content Idea Generator",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Market Reasoning Model": {
"ai_languageModel": [
[
{
"node": "AI Pain Insight Extractor",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Social Search MCP Connector": {
"ai_tool": [
[
{
"node": "AI Pain Insight Extractor",
"type": "ai_tool",
"index": 0
}
]
]
},
"AI Pain Insight Extractor": {
"main": [
[
{
"node": "AI Content Idea Generator",
"type": "main",
"index": 0
}
]
]
},
"AI Content Idea Generator": {
"main": [
[
{
"node": "Normalize Idea Output",
"type": "main",
"index": 0
}
]
]
}
}
}