Workflow: Google Doc Summarizer to Google Sheets
Integrations: googleDocs, googleDriveTrigger, googleSheets, noOp, stickyNote, stopAndError

{"id": "s8YgrWCxnGJxbctt", "meta": {"instanceId": "workflow-946ae4c6", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:45.407650", "updatedAt": "2025-09-29T07:07:45.407663", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "name": "Google Doc Summarizer to Google Sheets", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "nodes": [{"id": "9098b59a-68b1-48bd-9b52-41a971e689b3", "name": "Google Docs", "type": "n8n-nodes-base.googleDocs", "position": [340, 240], "parameters": {"operation": "get", "documentURL": "{{ $env.BASE_URL }}", "authentication": "{{ $credentials.serviceAccount }}"}, "credentials": {"googleApi": {"id": "Xx4ObVZ3yYoA5XCx", "name": "Google Drive account"}}, "typeVersion": 2, "notes": "This googleDocs node performs automated tasks as part of the workflow."}, {"id": "a7f224d4-232b-4201-82a0-d762830b546a", "name": "Wikipedia", "type": "n8n-nodes-base.noOp", "position": [680, 180], "parameters": {}, "typeVersion": 1, "notes": "This toolWikipedia node performs automated tasks as part of the workflow."}, {"id": "12bb798e-fe7e-4340-846b-5caeb824959b", "name": "Calculator", "type": "n8n-nodes-base.noOp", "position": [940, 180], "parameters": {}, "typeVersion": 1, "notes": "This toolCalculator node performs automated tasks as part of the workflow."}, {"id": "7d479725-f973-45c5-a798-d1868aefdd82", "name": "Google Sheets", "type": "n8n-nodes-base.googleSheets", "position": [1280, 280], "parameters": {"columns": {"value": {"Name": "={{ $('Google Drive ').item.json.lastModifyingUser.displayName }}", "Email ": "={{ $('Google Drive ').item.json.lastModifyingUser.emailAddress }}", "Summarise Conetent data ": "={{ $json.message.content }}"}, "schema": [{"id": "Email ", "type": "string", "display": true, "required": false, "displayName": "Email ", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "Name", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Name", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "Summarise Conetent data ", "type": "string", "display": true, "required": false, "displayName": "Summarise Conetent data ", "defaultMatch": false, "canBeUsedToMatch": true}], "mappingMode": "defineBelow", "matchingColumns": []}, "options": {}, "operation": "append", "sheetName": {"__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Sheet1"}, "documentId": {"__rl": true, "mode": "list", "value": "1s1v58pqGaVha9g_evNX4UEMchzteO7CyLNp87tcKJ1Q", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Docs Summarise Data"}}, "credentials": {"googleSheetsOAuth2Api": {"id": "A2b2I9leWjfYSzSW", "name": "Google Sheets account"}}, "typeVersion": 4.5, "notes": "This googleSheets node performs automated tasks as part of the workflow."}, {"id": "35716e44-14e7-4cc3-a273-2ba2e749892f", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [-80, -80], "parameters": {"color": 5, "height": 260, "content": "## Get Latest File\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "fc3ac84f-887f-4908-a870-e6c3d46f4576", "name": "Google Drive ", "type": "n8n-nodes-base.googleDriveTrigger", "notes": "Received the doc", "position": [0, 0], "parameters": {"event": "fileCreated", "options": {}, "pollTimes": {"item": [{"mode": "everyMinute"}]}, "triggerOn": "specificFolder", "folderToWatch": {"__rl": true, "mode": "list", "value": "1H8Xe2uIO0sI-QdxFsDH0Yg_w9RaPOoD_", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "yashdata"}, "authentication": "{{ $credentials.serviceAccount }}"}, "credentials": {"googleApi": {"id": "Xx4ObVZ3yYoA5XCx", "name": "Google Drive account"}}, "notesInFlow": true, "typeVersion": 1}, {"id": "14f0c78f-73c7-42c4-8916-284a876659cb", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [260, 140], "parameters": {"color": 5, "width": 260, "height": 260, "content": "## Get Document Content\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "6c87fc48-6b22-46fb-a509-d2037dc302bc", "name": "Sticky Note2", "type": "n8n-nodes-base.stickyNote", "position": [620, -60], "parameters": {"color": 5, "width": 440, "height": 380, "content": "## AI Summarization\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "bcf259bd-df2a-4a16-a679-3a5d3ee68122", "name": "Sticky Note3", "type": "n8n-nodes-base.stickyNote", "position": [1160, 160], "parameters": {"color": 5, "width": 300, "height": 280, "content": "## Store Summary in Sheet\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "81f80bd2-aa10-49a8-ae63-3a3322bcac80", "name": "Generate Summary AI", "type": "n8n-nodes-base.noOp", "position": [700, 20], "parameters": {"modelId": {"__rl": true, "mode": "list", "value": "gpt-4o-mini", "cachedResultName": "GPT-4O-MINI"}, "options": {}, "messages": {"values": [{"content": "=Summarise the below content\n {{ $json.content }}"}]}}, "credentials": {"openAiApi": {"id": "aMNetdb7Sh3K62cJ", "name": "OpenAi account"}}, "typeVersion": 1.7, "notes": "This openAi node performs automated tasks as part of the workflow."}, {"id": "f7379ef9-9940-4aec-9717-b7df688fd2df", "name": "Sticky Note4", "type": "n8n-nodes-base.stickyNote", "position": [240, -260], "parameters": {"color": 5, "width": 800, "height": 80, "content": "# Google Doc Summarizer to Google Sheets\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "0bf7d344-64ad-4074-8e7c-20055a3bf082", "name": "Sticky Note5", "type": "n8n-nodes-base.stickyNote", "position": [-20, 500], "parameters": {"color": 5, "width": 1280, "content": "## Description\nThis workflow is created by WeblineIndia, it streamlines and automates the end-to-end process of managing recently added document files in Google Drive. It begins by identifying the most recently uploaded .doc file in a designated folder within Google Drive. The document's content is then directly retrieved and passed through an AI-powered summarization model that condenses the content into a concise and meaningful summary. Finally, the summarized content, along with relevant metadata such as the document's name, upload date, and other details, is systematically stored in a Google Sheet. This ensures easy reference, enhanced organization, and quick access to key information, making it an ideal solution for managing and summarizing large volumes of document data efficiently."}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "error-72731bc8", "name": "Error Handler", "type": "n8n-nodes-base.stopAndError", "typeVersion": 1, "position": [1000, 400], "parameters": {"message": "Workflow execution error", "options": {}}}], "active": true, "pinData": {}, "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "versionId": "e3318ab1-ef09-4207-9419-411208c35aab", "connections": {"9098b59a-68b1-48bd-9b52-41a971e689b3": {"main": [[{"node": "error-handler-9098b59a-68b1-48bd-9b52-41a971e689b3-1bc92354", "type": "main", "index": 0}]]}, "7d479725-f973-45c5-a798-d1868aefdd82": {"main": [[{"node": "error-handler-7d479725-f973-45c5-a798-d1868aefdd82-a13c4ba0", "type": "main", "index": 0}]]}, "fc3ac84f-887f-4908-a870-e6c3d46f4576": {"main": [[{"node": "error-handler-fc3ac84f-887f-4908-a870-e6c3d46f4576-66f3cd4d", "type": "main", "index": 0}]]}, "81f80bd2-aa10-49a8-ae63-3a3322bcac80": {"main": [[{"node": "error-handler-81f80bd2-aa10-49a8-ae63-3a3322bcac80-634a7b5e", "type": "main", "index": 0}]]}}, "description": "Automated workflow: Google Doc Summarizer to Google Sheets. This workflow integrates 8 different services: stickyNote, googleDriveTrigger, stopAndError, toolWikipedia, googleSheets. It contains 16 nodes and follows best practices for error handling and security.", "notes": "Excellent quality workflow: Google Doc Summarizer to Google Sheets. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}