{"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","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,"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,"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":{"Google Docs":{"main":[[]]},"Google Sheets":{"main":[[]]},"Google Drive ":{"main":[[]]},"Generate Summary AI":{"main":[[]]}},"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."}