This workflow follows the Agent → Google Sheets 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 Article Analysis and Blog Summary",
"nodes": [
{
"parameters": {
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"documentId": {
"__rl": true,
"value": "REPLACE_WITH_SPREADSHEET_ID",
"mode": "list",
"cachedResultName": "Configure resource after import",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/REPLACE_WITH_SPREADSHEET_ID/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Links",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/REPLACE_WITH_SPREADSHEET_ID/edit#gid=0"
},
"includeInOutput": "both",
"options": {}
},
"type": "n8n-nodes-base.googleSheetsTrigger",
"typeVersion": 1,
"position": [
0,
0
],
"id": "58150a2b-440c-47be-8507-d09c93a747bb",
"name": "Google Sheets Trigger"
},
{
"parameters": {
"promptType": "define",
"text": "={{ $json.Link }}",
"options": {
"systemMessage": "=Your task is to read and analyze the content of any article provided through a link(recieved from previous node) and transform it into a meaningful, insightful, and engaging blog-style summary that can be understood by readers of all ages, backgrounds, industries, and education levels.Core Objectives Explain the article in simple, clear language.Extract the most important insights and implications.Provide balanced analysis rather than merely restating facts.Help readers understand why the news matters.Focus on long-term impact, not just immediate events.Avoid technical jargon whenever possible.Make the content useful for business professionals, students, entrepreneurs, technology enthusiasts, and general readers alike.\nRequired Output Structure1. Headline\nCreate a compelling blog-style headline that captures the essence of the article.2. Executive Summary\nProvide a concise overview of what happened.\nLength: 2\u20134 paragraphs.\nAnswer:\nWhat happened?\nWho is involved?\nWhy is it important?\n3. Key Takeaways\nList 3\u20137 bullet points summarizing the most important insights.\n4. Understanding the Technology (If Applicable)\nExplain the technology, concept, product, or innovation discussed in the article in simple terms.\nAssume the reader has no prior technical knowledge.\nUse:\nAnalogies\nReal-world examples\nPlain language\nAvoid:\nUnexplained acronyms\nComplex engineering terminology\nAcademic explanations\n5. Pros and Advantages\nAnalyze the positive aspects.\nExamples:\nEfficiency improvements\nCost savings\nUser benefits\nInnovation potential\nBusiness opportunities\nSocial impact\nExplain why these advantages matter.\n6. Risks, Cons, and Challenges\nProvide a balanced assessment.\nExamples:\nTechnical limitations\nRegulatory concerns\nPrivacy risks\nSecurity issues\nAdoption barriers\nMarket uncertainty\nEthical considerations\nFocus on realistic concerns rather than sensationalism.\n7. Market Dynamics and Industry Impact\nAnalyze how the development may affect:\nBusinesses\nCompetitors\nConsumers\nInvestors\nStartups\nExisting industries\nConsider:\nCompetitive advantages\nIndustry disruption\nPricing pressures\nSupply chain effects\nEmerging opportunities\nExplain who stands to benefit and who may face challenges.\n8. Long-Term Perspective\nMove beyond the news cycle.\nDiscuss:\nWhat this could mean in 3\u20135 years.\nPossible future scenarios.\nIndustry trends this may accelerate.\nWhether this is a temporary development or part of a larger shift.\nFocus on strategic implications rather than predictions.\n9. What We Should Learn From This\nProvide practical lessons readers can apply.\nPossible areas:\nBusiness strategy\nInnovation\nTechnology adoption\nLeadership\nCareer development\nConsumer behavior\nMarket awareness\nMake the lessons actionable and thoughtful.\n10. Final Thought\nEnd with a short, memorable conclusion that captures the broader significance of the story.\nThe goal is not merely to summarize the article but to help readers understand why it matters.\nWriting Style GuidelinesTone\nUse:\nProfessional\nInsightful\nBalanced\nEducational\nConversational\nAvoid:\nClickbait\nFearmongering\nExcessive hype\nPolitical bias\nEmotional manipulation\nAudience\nWrite for:\nStudents\nProfessionals\nEntrepreneurs\nExecutives\nParents\nRetirees\nNon-technical readers\nAssume no specialized background knowledge.\nQuality Standards\nAlways:\nDistinguish facts from analysis.\nStay grounded in the article content.\nProvide context when necessary.\nExplain implications clearly.\nFocus on understanding, not repetition.\nNever:\nInvent facts.\nSpeculate without clearly labeling it as analysis.\nCopy large portions of the source article.\nUse overly technical language.\nPromote a particular company, product, or ideology.\nSuccess Criteria\nA successful summary should make readers say:\n\"I understand what happened.\"\n\"I understand why it matters.\"\n\"I understand the opportunities and risks.\"\n\"I understand what this means for the future.\"\n\"I learned something useful from it.\" {{ $json.Link }} \nalso write small prompt to create image of the article"
}
},
"type": "@n8n/n8n-nodes-langchain.agent",
"typeVersion": 3.1,
"position": [
576,
64
],
"id": "b5247c7e-d60f-4db1-a35c-1c42671413eb",
"name": "AI Agent"
},
{
"parameters": {
"model": {
"__rl": true,
"value": "gpt-4o-mini",
"mode": "list",
"cachedResultName": "gpt-4o-mini"
},
"builtInTools": {},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"typeVersion": 1.3,
"position": [
384,
336
],
"id": "aef1b267-a6a8-4716-ab4a-9ada988d8c1b",
"name": "OpenAI Chat Model",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "REPLACE_WITH_SPREADSHEET_ID",
"mode": "list",
"cachedResultName": "Configure resource after import",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/REPLACE_WITH_SPREADSHEET_ID/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 1210522656,
"mode": "list",
"cachedResultName": "Blogs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/REPLACE_WITH_SPREADSHEET_ID/edit#gid=1210522656"
},
"columns": {
"mappingMode": "autoMapInputData",
"value": {},
"matchingColumns": [
"Blogs"
],
"schema": [
{
"id": "Blogs",
"displayName": "Blogs",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
864,
128
],
"id": "e2ed121b-c6f0-448f-9033-40345e2bcf41",
"name": "Append row in sheet"
},
{
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.3,
"position": [
-64,
224
],
"id": "d74d025c-5845-40e9-a541-745acfa733df",
"name": "Schedule Trigger"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "REPLACE_WITH_SPREADSHEET_ID",
"mode": "list",
"cachedResultName": "Configure resource after import",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/REPLACE_WITH_SPREADSHEET_ID/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Links",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/REPLACE_WITH_SPREADSHEET_ID/edit#gid=0"
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
208,
192
],
"id": "2a4d436b-dd8f-42f8-a0d1-2551cf3a5f45",
"name": "Get row(s) in sheet"
}
],
"connections": {
"Google Sheets Trigger": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1",
"binaryMode": "separate",
"availableInMCP": false
},
"nodeGroups": [],
"tags": []
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
openAiApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
AI Article Analysis and Blog Summary. Uses googleSheetsTrigger, agent, lmChatOpenAi, googleSheets. Event-driven trigger; 6 nodes.
Source: https://github.com/hamisarqum/automation-projects/blob/main/03-ai-blog-summary-n8n/workflow.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.
This n8n workflow template automatically monitors your Google Sheets for new entries and uses AI to generate detailed descriptions for each topic. Perfect for content creators, researchers, project ma
OpenAI Chat, Output Parser Structured, Google Sheets +2
This automation is designed to help you generate AI-powered music tracks, cover art, and fully rendered music videos — all triggered from a simple Telegram chat and managed via Google Sheets.
OpenAI Chat, Memory Buffer Window, Output Parser Structured +11
This workflow is designed for marketers, content creators, agencies, and solo founders who want to publish long‑form posts with visuals on autopilot using n8n and AI agents.
Tool Http Request, Agent, HTTP Request +27
This template enables natural-language-driven automation using Bright Data's MCP tools, triggered directly by new leads in HubSpot. It dynamically extracts and executes the right tool based on lead co
Google Sheets Trigger, Output Parser Structured, Output Parser Autofixing +7
Automated Book Generation System. Uses googleSheetsTrigger, gmail, lmChatOpenAi, outputParserStructured. Event-driven trigger; 43 nodes.
Google Sheets Trigger, Gmail, OpenAI Chat +6