This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"name": "AI Content Repurposing Pipeline",
"nodes": [
{
"parameters": {
"httpMethod": "POST",
"path": "repurpose-content",
"responseMode": "responseNode",
"options": {}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-400,
0
],
"id": "webhook-trigger",
"name": "Webhook Trigger"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "field-blog-url",
"name": "blog_url",
"value": "={{ $json.body.blog_url }}",
"type": "string"
},
{
"id": "field-author",
"name": "author_name",
"value": "={{ $json.body.author_name }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-200,
0
],
"id": "set-inputs",
"name": "Set Input Fields"
},
{
"parameters": {
"url": "={{ $json.blog_url }}",
"options": {
"response": {
"response": {
"responseFormat": "text"
}
}
}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
0,
0
],
"id": "fetch-blog",
"name": "Fetch Blog Content"
},
{
"parameters": {
"modelId": {
"__rl": true,
"value": "gpt-4o",
"mode": "list",
"cachedResultName": "GPT-4O"
},
"responses": {
"values": [
{
"role": "system",
"content": "You are an expert content strategist. Extract the key insights from the blog post and return ONLY a valid JSON object with no markdown, no backticks:\n{\n \"title\": \"article title\",\n \"key_points\": [\"point1\", \"point2\", \"point3\", \"point4\", \"point5\"],\n \"main_topic\": \"one sentence summary of the main topic\",\n \"target_audience\": \"who this content is for\",\n \"tone\": \"professional/casual/technical/inspirational\"\n}"
},
{
"content": "=Extract insights from this blog post:\n\n{{ $json.data }}"
}
]
},
"builtInTools": {},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.openAi",
"typeVersion": 2,
"position": [
200,
0
],
"id": "extract-insights",
"name": "Extract Key Insights"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "parse-insights",
"name": "insights",
"value": "={{ JSON.parse($json.output[0].content[0].text) }}",
"type": "object"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
400,
0
],
"id": "parse-insights",
"name": "Parse Insights"
},
{
"parameters": {
"modelId": {
"__rl": true,
"value": "gpt-4o",
"mode": "list",
"cachedResultName": "GPT-4O"
},
"responses": {
"values": [
{
"role": "system",
"content": "You are a LinkedIn content expert. Create a highly engaging LinkedIn post. Return ONLY valid JSON:\n{\n \"linkedin_post\": \"full post text with emojis and hashtags\",\n \"image_prompt\": \"detailed DALL-E prompt for a professional image\"\n}"
},
{
"content": "=Create a LinkedIn post from these insights:\nTitle: {{ $json.insights.title }}\nKey Points: {{ $json.insights.key_points.join(', ') }}\nTone: {{ $json.insights.tone }}\nAudience: {{ $json.insights.target_audience }}"
}
]
},
"builtInTools": {},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.openAi",
"typeVersion": 2,
"position": [
600,
-200
],
"id": "gen-linkedin",
"name": "Generate LinkedIn Post"
},
{
"parameters": {
"modelId": {
"__rl": true,
"value": "gpt-4o",
"mode": "list",
"cachedResultName": "GPT-4O"
},
"responses": {
"values": [
{
"role": "system",
"content": "You are a Twitter/X expert. Create a thread of 5 tweets. Return ONLY valid JSON:\n{\n \"tweets\": [\n {\"tweet_number\": 1, \"text\": \"hook tweet (max 280 chars)\"},\n {\"tweet_number\": 2, \"text\": \"point 1 (max 280 chars)\"},\n {\"tweet_number\": 3, \"text\": \"point 2 (max 280 chars)\"},\n {\"tweet_number\": 4, \"text\": \"point 3 (max 280 chars)\"},\n {\"tweet_number\": 5, \"text\": \"CTA tweet (max 280 chars)\"}\n ]\n}"
},
{
"content": "=Create a Twitter thread from:\nTitle: {{ $('Parse Insights').item.json.insights.title }}\nKey Points: {{ $('Parse Insights').item.json.insights.key_points.join(', ') }}"
}
]
},
"builtInTools": {},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.openAi",
"typeVersion": 2,
"position": [
600,
0
],
"id": "gen-twitter",
"name": "Generate Twitter Thread"
},
{
"parameters": {
"modelId": {
"__rl": true,
"value": "gpt-4o",
"mode": "list",
"cachedResultName": "GPT-4O"
},
"responses": {
"values": [
{
"role": "system",
"content": "You are an email marketing expert. Write a newsletter email. Return ONLY valid JSON:\n{\n \"subject_line\": \"compelling email subject\",\n \"preview_text\": \"preview text under 90 chars\",\n \"email_body\": \"full HTML email body with sections\",\n \"cta_text\": \"call to action button text\"\n}"
},
{
"content": "=Write a newsletter email from:\nTitle: {{ $('Parse Insights').item.json.insights.title }}\nKey Points: {{ $('Parse Insights').item.json.insights.key_points.join('\\n- ') }}\nAudience: {{ $('Parse Insights').item.json.insights.target_audience }}"
}
]
},
"builtInTools": {},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.openAi",
"typeVersion": 2,
"position": [
600,
200
],
"id": "gen-email",
"name": "Generate Newsletter Email"
},
{
"parameters": {
"mode": "raw",
"jsonOutput": "={\n \"status\": \"success\",\n \"source_url\": \"{{ $('Set Input Fields').item.json.blog_url }}\",\n \"title\": \"{{ $('Parse Insights').item.json.insights.title }}\",\n \"linkedin\": {{ $('Generate LinkedIn Post').item.json.output[0].content[0].text }},\n \"twitter_thread\": {{ $('Generate Twitter Thread').item.json.output[0].content[0].text }},\n \"newsletter\": {{ $('Generate Newsletter Email').item.json.output[0].content[0].text }},\n \"generated_at\": \"{{ $now }}\"\n}",
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
900,
0
],
"id": "merge-output",
"name": "Merge All Content"
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "YOUR_GOOGLE_SHEET_ID",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "Content Log",
"mode": "name"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"date": "={{ $now }}",
"source_url": "={{ $json.source_url }}",
"title": "={{ $json.title }}",
"linkedin_post": "={{ $json.linkedin.linkedin_post }}",
"twitter_thread": "={{ $json.twitter_thread.tweets[0].text }}",
"email_subject": "={{ $json.newsletter.subject_line }}",
"status": "Generated"
}
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1100,
0
],
"id": "log-to-sheets",
"name": "Log to Content Tracker"
},
{
"parameters": {
"respondWith": "json",
"responseBody": "={{ $json }}",
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1,
"position": [
1300,
0
],
"id": "respond-webhook",
"name": "Return Response"
}
],
"connections": {
"Webhook Trigger": {
"main": [
[
{
"node": "Set Input Fields",
"type": "main",
"index": 0
}
]
]
},
"Set Input Fields": {
"main": [
[
{
"node": "Fetch Blog Content",
"type": "main",
"index": 0
}
]
]
},
"Fetch Blog Content": {
"main": [
[
{
"node": "Extract Key Insights",
"type": "main",
"index": 0
}
]
]
},
"Extract Key Insights": {
"main": [
[
{
"node": "Parse Insights",
"type": "main",
"index": 0
}
]
]
},
"Parse Insights": {
"main": [
[
{
"node": "Generate LinkedIn Post",
"type": "main",
"index": 0
},
{
"node": "Generate Twitter Thread",
"type": "main",
"index": 0
},
{
"node": "Generate Newsletter Email",
"type": "main",
"index": 0
}
]
]
},
"Generate LinkedIn Post": {
"main": [
[
{
"node": "Merge All Content",
"type": "main",
"index": 0
}
]
]
},
"Generate Twitter Thread": {
"main": [
[
{
"node": "Merge All Content",
"type": "main",
"index": 1
}
]
]
},
"Generate Newsletter Email": {
"main": [
[
{
"node": "Merge All Content",
"type": "main",
"index": 2
}
]
]
},
"Merge All Content": {
"main": [
[
{
"node": "Log to Content Tracker",
"type": "main",
"index": 0
}
]
]
},
"Log to Content Tracker": {
"main": [
[
{
"node": "Return Response",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"meta": {
"templateCredsSetupCompleted": false
},
"tags": [
"content",
"ai",
"automation",
"linkedin",
"twitter",
"email"
]
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
AI Content Repurposing Pipeline. Uses httpRequest, openAi, googleSheets. Webhook trigger; 11 nodes.
Source: https://github.com/riham-tarabay/n8n-content-repurposing-pipeline/blob/main/content_repurposing_pipeline.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Propulsar — Content Engine v3. Uses openAi, httpRequest, googleSheets. Webhook trigger; 73 nodes.
OpenAI, HTTP Request, Google Sheets
Instantly map all internal URLs, perform AI-powered (ChatGPT) analysis, and deliver results in HTML via webhook, Google Sheets, or email. All from your own n8n instance!
OpenAI, HTTP Request, XML +3
Watch on Youtube▶️
HTTP Request, Email Send, Google Sheets +3
This workflow is perfect for marketing agencies, SEO consultants, and growth specialists who need to scale personalized outreach without spending hours on manual research.
Google Sheets, HTTP Request, OpenAI
This workflow automates the creation of Journal Entries in SAP Business One (SAP B1). Depending on the source of the input data, it dynamically transforms and sends accounting records in the appropria
HTTP Request, Google Sheets, OpenAI