Generate 7 new LinkedIn posts from top Apify posts using OpenAI and save to Google Sheets

by Jonas Frewert ✓ · 17 views · created 2026-04-04 · Content Creation, Multimodal AI

What this workflow does

This workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls api.openai.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Set Config (Edit Fields (Set)): sets 5 fields: apify_token, apify_actor_id, openai_api_key…
2. Validate Config + Build Actor Input (Code): runs custom JavaScript code
3. Apify Get LinkedIn Posts (HTTP Request): calls an HTTP API (POST)
4. Normalize + Rank LinkedIn Posts (Code): runs custom JavaScript code
5. OpenAI Analyze + Generate (HTTP Request): calls api.openai.com (POST)
6. Parse OpenAI Output (Code): runs custom JavaScript code
7. Prepare Google Sheets Rows (Code): runs custom JavaScript code
8. Append Rows to Google Sheet (Google Sheets): append

Services it uses

Google Sheets

HTTP calls to: api.openai.com

Before you upgrade to n8n 3.0

Nodes used (5)

• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Edit Fields (Set)n8n-nodes-base.set
• Manual Triggern8n-nodes-base.manualTrigger

From the author

This workflow helps you turn your best-performing LinkedIn posts into a repeatable content creation system. It pulls LinkedIn post data from Apify, normalizes and ranks the posts by impressions, identifies the strongest-performing content, and sends the top…

View the original on n8n.io → Check your own copy