January 22, 2026

Google Sheets + LinkedIn: posts published and logged

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Copying drafts out of a spreadsheet, rewriting them for LinkedIn, posting, then hunting down the live link later is the kind of “small task” that quietly wrecks your week.

Social media managers feel this daily. A marketing lead trying to stay consistent does too. Even a founder posting between meetings runs into it. This Sheets LinkedIn automation takes the messy middle out of publishing and tracking.

You’ll see how one n8n workflow pulls queued drafts from Google Sheets, uses OpenAI to polish them, publishes to LinkedIn (and X), logs the live URLs, then sends a Slack recap so nothing gets lost.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Google Sheets + LinkedIn: posts published and logged

Click to explore

flowchart LR

    subgraph sg0["Hourly Content Check Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "Hourly Content Check", pos: "b", h: 48 }
        n1["<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/webhook.dark.svg' width='40' height='40' /></div><br/>Manual Post Trigger"]
        n2["<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/merge.svg' width='40' height='40' /></div><br/>Merge Triggers"]
        n3@{ icon: "mdi:database", form: "rounded", label: "Fetch Content Queue", pos: "b", h: 48 }
        n4["<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/>Filter Ready Posts"]
        n5@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Has Content to Post?", pos: "b", h: 48 }
        n6@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model", pos: "b", h: 48 }
        n7@{ icon: "mdi:robot", form: "rounded", label: "AI Content Optimizer", pos: "b", h: 48 }
        n8["<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/>Parse AI Content"]
        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/x.dark.svg' width='40' height='40' /></div><br/>Post to Twitter"]
        n10["<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/linkedin.svg' width='40' height='40' /></div><br/>Post to LinkedIn"]
        n11@{ icon: "mdi:cog", form: "rounded", label: "Aggregate Post Results", pos: "b", h: 48 }
        n12["<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/>Format Results"]
        n13@{ icon: "mdi:database", form: "rounded", label: "Update Content Status", pos: "b", h: 48 }
        n14["<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/>Post Summary to Slack"]
        n15@{ icon: "mdi:swap-vertical", form: "rounded", label: "No Content Response", pos: "b", h: 48 }
        n16["<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/merge.svg' width='40' height='40' /></div><br/>Merge Final Paths"]
        n17["<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/webhook.dark.svg' width='40' height='40' /></div><br/>Respond to Webhook"]
        n12 --> n13
        n12 --> n14
        n2 --> n3
        n9 --> n11
        n8 --> n9
        n8 --> n10
        n10 --> n11
        n16 --> n17
        n6 -.-> n7
        n4 --> n5
        n3 --> n4
        n1 --> n2
        n15 --> n16
        n7 --> n8
        n5 --> n7
        n5 --> n15
        n0 --> n2
        n14 --> n16
        n13 --> n16
        n11 --> n12
    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 n0 trigger
    class n7 ai
    class n6 aiModel
    class n5 decision
    class n3,n13 database
    class n1,n17 api
    class n4,n8,n12 code
    classDef customIcon fill:none,stroke:none
    class n1,n2,n4,n8,n9,n10,n12,n14,n16,n17 customIcon

The Problem: Posting is easy, but tracking is a mess

You can plan content in Google Sheets, but execution usually falls apart after that. Somebody forgets to check the scheduled_time column. Someone else rewrites the draft in a hurry, so the tone is off-brand. Then the post goes live, and the link never makes it back into the sheet, which means reporting turns into detective work at the end of the week. Multiply that by several posts and two platforms and you’re burning real time, not “a few minutes here and there.” Honestly, it’s exhausting.

The friction compounds. Here’s where it breaks down in real teams.

Drafts sit in “ready” status because nobody checks the sheet at the right time.
Posts get published, but the live URL isn’t captured, so you lose the audit trail.
Manual rewrites for LinkedIn and X create inconsistent messaging and more approvals.
You find mistakes late, because there’s no Slack recap to catch issues quickly.

The Solution: Google Sheets drafts → AI polish → publish + log + recap

This workflow runs on a schedule (hourly) or on demand via a webhook, so you can automate publishing while still keeping a manual “push” button when you want it. It pulls your content queue from Google Sheets, checks which rows are due based on scheduled_time and status, then hands the raw draft to an OpenAI agent to improve it. The AI generates platform-ready versions, including a professional LinkedIn post and a shorter X-style variant, plus hashtags and engagement suggestions. Next, n8n publishes to LinkedIn and Twitter (X) and collects the results. Finally, it writes the live URLs and updated status back to Google Sheets and posts a summary into Slack so the whole team can see what shipped.

The workflow starts with your sheet as the source of truth. OpenAI does the polishing and formatting. LinkedIn and X are the output channels, while Google Sheets and Slack become the “paper trail” you can trust later.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Scans Google Sheets on a schedule or via webhook for posts that are due.
Improves draft copy with OpenAI, including tone and hashtag suggestions.
Publishes to LinkedIn and Twitter (X) in the same run.
Logs publish results back to the sheet and pushes a recap to Slack.

Save about 2 hours a week if you post 5 times.
No more missing links, because live URLs get written back automatically.
More consistent voice across posts, even when different people draft.
Less “did this go out?” uncertainty thanks to Slack confirmations.
Cleaner reporting later, since the spreadsheet stays current.

Example: What This Looks Like

Say you publish 5 times a week to LinkedIn and X from a shared Google Sheet. Manually, you’ll spend maybe 10 minutes rewriting for each platform, plus another 5 minutes posting and grabbing links, which is about 25 minutes per draft. That’s roughly 2 hours a week. With this workflow, you update one row in Sheets, then the run handles AI optimization, posting, link logging, and a Slack recap automatically. You’re mostly just reviewing the output and moving on.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets to store drafts, statuses, and URLs
LinkedIn to publish the final post
OpenAI API key (get it from your OpenAI dashboard)
Twitter (X) to cross-post the shorter version
Slack to send a recap to your channel

Skill level: Intermediate. You’ll connect accounts, map a few sheet columns, and paste an API key.

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

How It Works

A schedule (or webhook) kicks things off. The workflow runs hourly via Schedule Trigger, and you can also fire it manually with an incoming webhook when you want to publish right now.

Your Google Sheet becomes the queue. n8n retrieves rows from Google Sheets, then filters entries based on status and scheduled_time so only “ready and due” posts move forward.

OpenAI turns a rough draft into platform-ready copy. The AI agent enhances the text, creates a LinkedIn-appropriate version, and outputs structured data that n8n can parse (captions, hashtags, and tips).

Publishing and tracking happen in one pass. n8n publishes to LinkedIn and Twitter (X), aggregates the results, updates the sheet with new statuses and live URLs, then sends a Slack summary so the team can verify everything quickly.

You can easily modify the tone and hashtag style to match your brand voice based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Trigger Type

Set up the scheduled scan and webhook intake so posts can be processed from both time-based scans and inbound requests.

Open Scheduled Queue Scan and configure the rule interval under Rule → Interval (e.g., hourly scans).
Open Incoming Post Webhook and set Path to social-post.
In Incoming Post Webhook, set HTTP Method to POST and Response Mode to responseNode.
Ensure Combine Trigger Paths is connected to both triggers using Mode set to chooseBranch.

Tip: Use Incoming Post Webhook for ad-hoc posts and Scheduled Queue Scan for recurring queue processing—both flow into Combine Trigger Paths.

Step 2: Connect Google Sheets for Content Queue and Status Updates

Pull the content queue and write back publishing results to Google Sheets.

Open Retrieve Content Queue and choose the Document and Sheet for your content queue.
Open Update Sheet Status and set Operation to append, then select the destination Document and Sheet.
Credential Required: Connect your Google Sheets credentials in both Retrieve Content Queue and Update Sheet Status.

⚠️ Common Pitfall: Leaving the Document or Sheet empty in Retrieve Content Queue or Update Sheet Status will cause the workflow to return no data or fail to append results.

Step 3: Configure Filtering and Content Readiness Logic

Filter scheduled rows and branch based on whether posts are ready to publish.

Review Filter Scheduled Entries to ensure the JavaScript logic matches your sheet columns for status, scheduled time, content, and platforms.
Verify Check Content Availability uses the condition {{ $json.noContent }} with operator notEquals to split ready content vs. no-content paths.
Open No Content Payload and confirm the message is No content scheduled for posting and timestamp is {{ $now.toISO() }}.

Tip: If your Google Sheet uses different column names, update the parsing logic inside Filter Scheduled Entries accordingly.

Step 4: Set Up AI Enhancement and Parsing

Configure the AI model and parsing logic that prepares platform-optimized text.

Open AI Post Enhancer and verify the prompt text includes expressions such as {{ $json.content }} and {{ $json.platforms.join(', ') }}.
Check OpenAI Chat Engine uses Model set to gpt-4o-mini and a Temperature of 0.7.
Credential Required: Connect your OpenAI credentials in OpenAI Chat Engine.
Note that OpenAI Chat Engine is connected as the language model for AI Post Enhancer—add credentials to the parent model node, not the agent.
Review Parse AI Output for JSON parsing and fallback logic, ensuring it still returns valid content if AI output is not parseable.

Step 5: Configure Publishing to Social Platforms

Send optimized content to Twitter and LinkedIn in parallel, then collect results for reporting.

Open Publish to Twitter and set Text to {{ $json.posts.twitter.text }}.
Credential Required: Connect your Twitter credentials in Publish to Twitter.
Open Publish to LinkedIn and set Text to {{ $json.posts.linkedin.text }}, and Person to {{ $json.linkedinPersonId || '' }} if you are using a specific profile.
Credential Required: Connect your LinkedIn credentials in Publish to LinkedIn.
Parse AI Output outputs to both Publish to Twitter and Publish to LinkedIn in parallel.
Confirm Collect Publish Results uses Aggregate set to aggregateAllItemData before moving to summary processing.

⚠️ Common Pitfall: If your LinkedIn app is not configured for posting permissions, Publish to LinkedIn will fail even with valid credentials.

Step 6: Summarize Results and Notify

Summarize publishing results, update the sheet, and send a Slack summary.

Review Prepare Result Summary for result aggregation and summary output structure.
Prepare Result Summary outputs to both Update Sheet Status and Send Slack Summary in parallel.
In Send Slack Summary, confirm the Text uses the template with expressions like {{ $json.platforms.join(', ') }} and {{ $json.summary.successCount }}.
Credential Required: Connect your Slack credentials in Send Slack Summary and select the target channel.
Ensure Merge Response Paths merges outputs from Send Slack Summary, Update Sheet Status, and No Content Payload for a single webhook response.
In Return Webhook Reply, confirm Response Body is set to {{ {success: true, published: $json.summary ? $json.summary.successCount : 0, message: $json.message || 'Posts published successfully'} }}.

Step 7: Test & Activate Your Workflow

Validate the workflow with both triggers, then enable it for production.

Use Scheduled Queue Scan to run a manual test and ensure rows are pulled from Retrieve Content Queue.
Send a test POST to Incoming Post Webhook and confirm Return Webhook Reply returns a JSON response with success and published counts.
Verify expected outcomes: posts appear on Twitter/LinkedIn, Update Sheet Status appends a row, and Send Slack Summary sends a notification.
Once validated, toggle the workflow 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 Google connection inside n8n’s Credentials list 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 LinkedIn automation?

About 45 minutes if your accounts and sheet are ready.

Do I need coding skills to automate Sheets LinkedIn posting?

No. You’ll mostly connect accounts and map columns. The only “code-ish” part is optional tweaking in the filter logic if your date format is unusual.

Is n8n free to use for this Sheets LinkedIn 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 costs, which are usually a few cents per post depending on your model and prompt size.

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 LinkedIn automation workflow for LinkedIn-only posting?

Yes, and it’s straightforward. You can disable the “Publish to Twitter” path and keep “Publish to LinkedIn” plus the logging steps. Common customizations include changing the AI tone field from your sheet, swapping hashtag rules in the Parse AI Output code node, and sending the Slack recap to a different channel per brand.

Why is my LinkedIn connection failing in this workflow?

Most of the time it’s expired OAuth access or missing permissions on the LinkedIn app connection. Reconnect LinkedIn in n8n Credentials, then re-run a single test item to confirm publishing works. If it fails only on some posts, check for content that violates LinkedIn formatting limits (too many hashtags, odd characters) and confirm the workflow is posting to the correct profile or organization. Rate limits can also show up when you try to publish a batch at once, so spacing posts out helps.

How many posts can this Sheets LinkedIn automation handle?

Plenty for most small teams: dozens a day is realistic if your API limits allow it.

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

It depends on how strict you are about tracking and how much logic you need. n8n is better when you want real branching (schedule trigger or webhook), custom filtering, and a clean “log it back to the sheet” loop without paying extra per path. It’s also easier to self-host, which matters if you plan to run lots of posts and recaps. Zapier or Make can be simpler for a basic “new row → post” automation, but you’ll often end up stitching together extra steps for URL logging and summaries. If you want a quick recommendation for your setup, Talk to an automation expert.

Once this is running, your spreadsheet stops being a plan and starts being a reliable publishing system. The workflow keeps the links, the status, and the recap handled so you can focus on what to say next.

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": "4123b323e2976326da901177778c15f3a2eb7e52b39c0c466aa9e0b43eca30f3",
"templateCredsSetupCompleted": null,
"templateId": null
},
"name": "Automated Social Post Scheduler",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-11969",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 2180,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "e6fa39a6-3eb5-4896-b0e8-f178efdae2ed",
"name": "Scheduled Queue Scan",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2030,
140
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "f601cb08-1506-4e66-be27-0c9ac5db491c",
"name": "Incoming Post Webhook",
"type": "n8n-nodes-base.webhook",
"onError": "continueRegularOutput",
"position": [
2080,
385
],
"webhookId": "b23f5c13-4ce5-4b39-9d1c-4ff2dd8a4411",
"parameters": {
"path": "social-post",
"options": [],
"httpMethod": "POST",
"responseMode": "responseNode"
},
"typeVersion": 2
},
{
"id": "448d52f3-7481-4fef-a4cc-109fbbf18457",
"name": "Combine Trigger Paths",
"type": "n8n-nodes-base.merge",
"position": [
1580,
245
],
"parameters": {
"mode": "chooseBranch"
},
"typeVersion": 3
},
{
"id": "42458dfc-9d2e-4fb6-b0ad-47b9f8a69c96",
"name": "Retrieve Content Queue",
"type": "n8n-nodes-base.googleSheets",
"position": [
1245,
270
],
"parameters": {
"sheetName": {
"__rl": true,
"mode": "list",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": ""
}
},
"typeVersion": 4.5
},
{
"id": "f8b72bff-8883-4e4f-834c-56763a6fa9aa",
"name": "Filter Scheduled Entries",
"type": "n8n-nodes-base.code",
"position": [
1045,
240
],
"parameters": {
"jsCode": "const items = $input.all();\nconst now = new Date();\nconst readyPosts = [];\n\nfor (const item of items) {\n  const row = item.json;\n  \n  // Check if post is scheduled and not yet published\n  const status = (row.status || '').toLowerCase();\n  if (status !== 'scheduled' && status !== 'ready') continue;\n  \n  // Check scheduled time\n  const scheduledTime = row.scheduled_time || row.scheduledTime;\n  if (scheduledTime) {\n    const schedDate = new Date(scheduledTime);\n    if (schedDate > now) continue; // Not yet time\n  }\n  \n  // Validate required fields\n  if (!row.content && !row.text && !row.message) continue;\n  \n  const platforms = (row.platforms || row.platform || 'twitter,linkedin')\n    .split(',')\n    .map(p => p.trim().toLowerCase());\n  \n  readyPosts.push({\n    json: {\n      id: row.id || row.row_number || Date.now(),\n      content: row.content || row.text || row.message,\n      platforms: platforms,\n      imageUrl: row.image_url || row.imageUrl || null,\n      scheduledTime: scheduledTime,\n      category: row.category || 'general',\n      campaign: row.campaign || '',\n      hashtags: row.hashtags || '',\n      linkUrl: row.link_url || row.linkUrl || '',\n      tone: row.tone || 'professional'\n    }\n  });\n}\n\nif (readyPosts.length === 0) {\n  return [{ json: { noContent: true, message: 'No posts ready to publish' } }];\n}\n\nreturn readyPosts;"
},
"typeVersion": 2
},
{
"id": "fced1dc4-1620-413b-ab3f-4b3d3debdf3c",
"name": "Check Content Availability",
"type": "n8n-nodes-base.if",
"position": [
730,
265
],
"parameters": {
"options": [],
"conditions": {
"options": {
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "content-check",
"operator": {
"type": "boolean",
"operation": "notEquals"
},
"leftValue": "={{ $json.noContent }}",
"rightValue": true
}
]
}
},
"typeVersion": 2
},
{
"id": "69efadfa-627c-41f3-ba12-3c57df88b1a2",
"name": "OpenAI Chat Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
485,
350
],
"parameters": {
"model": "gpt-4o-mini",
"options": {
"temperature": 0.7
}
},
"typeVersion": 1.2
},
{
"id": "38e02a47-f9b7-4b73-ac91-e3491affe50a",
"name": "AI Post Enhancer",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
535,
135
],
"parameters": {
"text": "=Optimize this social media post for maximum engagement:\n\nOriginal Content: {{ $json.content }}\nPlatforms: {{ $json.platforms.join(', ') }}\nTone: {{ $json.tone }}\nCategory: {{ $json.category }}\nExisting Hashtags: {{ $json.hashtags }}\nLink: {{ $json.linkUrl }}\n\nProvide optimized versions in this exact JSON format:\n{\n  \"twitter\": {\n    \"text\": \"optimized text for Twitter (max 280 chars)\",\n    \"hashtags\": [\"relevant\", \"hashtags\", \"max5\"]\n  },\n  \"linkedin\": {\n    \"text\": \"optimized text for LinkedIn (professional tone, can be longer)\",\n    \"hashtags\": [\"professional\", \"hashtags\"]\n  },\n  \"engagementTips\": [\"tip1\", \"tip2\"],\n  \"bestPostTime\": \"suggested time\",\n  \"contentScore\": 0-100\n}",
"options": {
"systemMessage": "You are a social media marketing expert. Optimize content for engagement while maintaining brand voice. Keep Twitter posts concise and punchy, LinkedIn posts professional and insightful. Include relevant trending hashtags when appropriate."
}
},
"typeVersion": 1.7
},
{
"id": "eb6268f6-9603-43f5-9c03-e5ccd0ae98e4",
"name": "Parse AI Output",
"type": "n8n-nodes-base.code",
"position": [
215,
260
],
"parameters": {
"jsCode": "const input = $input.first().json;\nconst originalData = $('Filter Scheduled Entries').item.json;\n\nlet optimized;\ntry {\n  const responseText = input.output || input.text || '';\n  const jsonMatch = responseText.match(/\\{[\\s\\S]*\\}/);\n  optimized = jsonMatch ? JSON.parse(jsonMatch[0]) : null;\n} catch (e) {\n  optimized = null;\n}\n\nif (!optimized) {\n  // Fallback to original content\n  optimized = {\n    twitter: {\n      text: originalData.content.substring(0, 280),\n      hashtags: originalData.hashtags ? originalData.hashtags.split(' ') : []\n    },\n    linkedin: {\n      text: originalData.content,\n      hashtags: originalData.hashtags ? originalData.hashtags.split(' ') : []\n    },\n    engagementTips: [],\n    bestPostTime: 'Now',\n    contentScore: 70\n  };\n}\n\n// Build final posts\nconst twitterText = optimized.twitter.text + \n  (optimized.twitter.hashtags?.length > 0 ? ' ' + optimized.twitter.hashtags.map(h => h.startsWith('#') ? h : '#' + h).join(' ') : '');\n\nconst linkedinText = optimized.linkedin.text + \n  (optimized.linkedin.hashtags?.length > 0 ? '\\n\\n' + optimized.linkedin.hashtags.map(h => h.startsWith('#') ? h : '#' + h).join(' ') : '');\n\nreturn [{\n  json: {\n    ...originalData,\n    optimized: optimized,\n    posts: {\n      twitter: {\n        text: twitterText.substring(0, 280),\n        ready: originalData.platforms.includes('twitter')\n      },\n      linkedin: {\n        text: linkedinText,\n        ready: originalData.platforms.includes('linkedin')\n      }\n    },\n    contentScore: optimized.contentScore || 70,\n    processedAt: new Date().toISOString()\n  }\n}];"
},
"typeVersion": 2
},
{
"id": "4d39d9f2-9aef-4bb1-8f2b-bb2c20895f34",
"name": "Publish to Twitter",
"type": "n8n-nodes-base.twitter",
"position": [
10,
120
],
"parameters": {
"text": "={{ $json.posts.twitter.text }}",
"additionalFields": []
},
"typeVersion": 2
},
{
"id": "4c609576-3906-4822-9c82-ed064fe5b6c6",
"name": "Publish to LinkedIn",
"type": "n8n-nodes-base.linkedIn",
"position": [
0,
385
],
"parameters": {
"text": "={{ $json.posts.linkedin.text }}",
"person": {
"__rl": true,
"mode": "id",
"value": "={{ $json.linkedinPersonId || '' }}"
},
"additionalFields": []
},
"typeVersion": 1
},
{
"id": "f0a19a81-e1db-40ee-92e4-0ecfee3d8474",
"name": "Collect Publish Results",
"type": "n8n-nodes-base.aggregate",
"position": [
270,
500
],
"parameters": {
"options": [],
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "3533a23e-9b66-4b93-bb00-990c00f15dec",
"name": "Prepare Result Summary",
"type": "n8n-nodes-base.code",
"position": [
480,
655
],
"parameters": {
"jsCode": "const results = $input.first().json.data || [];\nconst originalData = $('Parse AI Output').first().json;\n\nconst postResults = {\n  twitter: null,\n  linkedin: null\n};\n\nfor (const result of results) {\n  if (result.id_str || result.data?.id) {\n    postResults.twitter = {\n      success: true,\n      postId: result.id_str || result.data?.id,\n      url: `https://twitter.com/i/status/${result.id_str || result.data?.id}`\n    };\n  }\n  if (result.id && String(result.id).includes('urn:li:share')) {\n    postResults.linkedin = {\n      success: true,\n      postId: result.id,\n      url: `https://linkedin.com/feed/update/${result.id}`\n    };\n  }\n}\n\nconst successCount = Object.values(postResults).filter(p => p?.success).length;\nconst totalPlatforms = originalData.platforms.length;\n\nreturn [{\n  json: {\n    contentId: originalData.id,\n    originalContent: originalData.content.substring(0, 100) + '...',\n    platforms: originalData.platforms,\n    postResults: postResults,\n    summary: {\n      successCount: successCount,\n      totalPlatforms: totalPlatforms,\n      allSuccessful: successCount === totalPlatforms\n    },\n    contentScore: originalData.contentScore,\n    publishedAt: new Date().toISOString()\n  }\n}];"
},
"typeVersion": 2
},
{
"id": "b86abd85-723d-49bb-b82e-4500aeeed486",
"name": "Update Sheet Status",
"type": "n8n-nodes-base.googleSheets",
"position": [
795,
730
],
"parameters": {
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": ""
}
},
"typeVersion": 4.5
},
{
"id": "11bce6ef-c71e-4762-b573-853e8ecf138f",
"name": "Send Slack Summary",
"type": "n8n-nodes-base.slack",
"position": [
735,
880
],
"webhookId": "2db47c87-7ce7-4224-b28e-4531d86f57e0",
"parameters": {
"text": "=:mega: *Social Media Post Published*\n\n*Platforms:* {{ $json.platforms.join(', ') }}\n*Success:* {{ $json.summary.successCount }}/{{ $json.summary.totalPlatforms }}\n*Content Score:* {{ $json.contentScore }}/100\n\n*Preview:*\n{{ $json.originalContent }}",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "name",
"value": "[YOUR_ID]"
},
"otherOptions": []
},
"typeVersion": 2.2
},
{
"id": "a43c1f57-6383-426c-92a3-07a3c7b61bad",
"name": "No Content Payload",
"type": "n8n-nodes-base.set",
"position": [
520,
735
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "1",
"name": "message",
"type": "string",
"value": "No content scheduled for posting"
},
{
"id": "2",
"name": "timestamp",
"type": "string",
"value": "={{ $now.toISO() }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "896c50a0-3c34-466a-a5d3-5655a732033d",
"name": "Merge Response Paths",
"type": "n8n-nodes-base.merge",
"position": [
980,
980
],
"parameters": {
"mode": "chooseBranch"
},
"typeVersion": 3
},
{
"id": "975e2adf-b180-4333-a226-6f6d451999a5",
"name": "Return Webhook Reply",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
1295,
1000
],
"parameters": {
"options": [],
"respondWith": "json",
"responseBody": "={{ {success: true, published: $json.summary ? $json.summary.successCount : 0, message: $json.message || 'Posts published successfully'} }}"
},
"typeVersion": 1.1
}
],
"active": false,
"pinData": [],
"settings": {
"callerPolicy": "workflowsFromSameOwner",
"availableInMCP": false,
"executionOrder": "v1"
},
"versionId": null,
"connections": {
"Prepare Result Summary": {
"main": [
[
{
"node": "Update Sheet Status",
"type": "main",
"index": 0
},
{
"node": "Send Slack Summary",
"type": "main",
"index": 0
}
]
]
},
"Combine Trigger Paths": {
"main": [
[
{
"node": "Retrieve Content Queue",
"type": "main",
"index": 0
}
]
]
},
"Publish to Twitter": {
"main": [
[
{
"node": "Collect Publish Results",
"type": "main",
"index": 0
}
]
]
},
"Parse AI Output": {
"main": [
[
{
"node": "Publish to Twitter",
"type": "main",
"index": 0
},
{
"node": "Publish to LinkedIn",
"type": "main",
"index": 0
}
]
]
},
"Publish to LinkedIn": {
"main": [
[
{
"node": "Collect Publish Results",
"type": "main",
"index": 0
}
]
]
},
"Merge Response Paths": {
"main": [
[
{
"node": "Return Webhook Reply",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Engine": {
"ai_languageModel": [
[
{
"node": "AI Post Enhancer",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Filter Scheduled Entries": {
"main": [
[
{
"node": "Check Content Availability",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Content Queue": {
"main": [
[
{
"node": "Filter Scheduled Entries",
"type": "main",
"index": 0
}
]
]
},
"Incoming Post Webhook": {
"main": [
[
{
"node": "Combine Trigger Paths",
"type": "main",
"index": 1
}
]
]
},
"No Content Payload": {
"main": [
[
{
"node": "Merge Response Paths",
"type": "main",
"index": 1
}
]
]
},
"AI Post Enhancer": {
"main": [
[
{
"node": "Parse AI Output",
"type": "main",
"index": 0
}
]
]
},
"Check Content Availability": {
"main": [
[
{
"node": "AI Post Enhancer",
"type": "main",
"index": 0
}
],
[
{
"node": "No Content Payload",
"type": "main",
"index": 0
}
]
]
},
"Scheduled Queue Scan": {
"main": [
[
{
"node": "Combine Trigger Paths",
"type": "main",
"index": 0
}
]
]
},
"Send Slack Summary": {
"main": [
[
{
"node": "Merge Response Paths",
"type": "main",
"index": 0
}
]
]
},
"Update Sheet Status": {
"main": [
[
{
"node": "Merge Response Paths",
"type": "main",
"index": 0
}
]
]
},
"Collect Publish Results": {
"main": [
[
{
"node": "Prepare Result Summary",
"type": "main",
"index": 0
}
]
]
}
}
}