Google Doc Summarizer to Google Sheets
Automate the summarization of Google Docs content and systematically record those summaries into a Google Sheet. This productivity workflow connects Google Drive, Google Docs, OpenAI, and Google Sheets to streamline information extraction and organization. A manual trigger initiates the process, where the workflow first fetches a specified Google Doc via the Google Drive node. The content of this document is then passed to the Generate Summary AI node, powered by OpenAI, to produce a concise summary. Finally, this AI-generated summary is appended as a new row in a designated Google Sheet. This workflow is ideal for researchers, content managers, or project coordinators who need to quickly distill key information from numerous documents and maintain a structured log of their content. It eliminates the manual effort of reading through lengthy documents and transcribing summaries, saving significant time and ensuring consistent record-keeping for document analysis and review.
Workflow JSON
{"id": "s8YgrWCxnGJxbctt", "meta": {"instanceId": "2b1c62c6d8c9216d51c1f40c64044e24b558ea8311c19d032d1278472159cfec", "templateId": "1750"}, "name": "Google Doc Summarizer to Google Sheets", "tags": [], "nodes": [{"id": "9098b59a-68b1-48bd-9b52-41a971e689b3", "name": "Google Docs", "type": "n8n-nodes-base.googleDocs", "position": [340, 240], "parameters": {"operation": "get", "documentURL": "={{ $json.id }}", "authentication": "serviceAccount"}, "credentials": {"googleApi": {"id": "", "name": "[Your googleApi]"}}, "typeVersion": 2}, {"id": "a7f224d4-232b-4201-82a0-d762830b546a", "name": "Wikipedia", "type": "@n8n/n8n-nodes-langchain.toolWikipedia", "position": [680, 180], "parameters": {}, "typeVersion": 1}, {"id": "12bb798e-fe7e-4340-846b-5caeb824959b", "name": "Calculator", "type": "@n8n/n8n-nodes-langchain.toolCalculator", "position": [940, 180], "parameters": {}, "typeVersion": 1}, {"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": "https://docs.google.com/spreadsheets/d/1s1v58pqGaVha9g_evNX4UEMchzteO7CyLNp87tcKJ1Q/edit#gid=0", "cachedResultName": "Sheet1"}, "documentId": {"__rl": true, "mode": "list", "value": "1s1v58pqGaVha9g_evNX4UEMchzteO7CyLNp87tcKJ1Q", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1s1v58pqGaVha9g_evNX4UEMchzteO7CyLNp87tcKJ1Q/edit?usp=drivesdk", "cachedResultName": "Docs Summarise Data"}}, "credentials": {"googleSheetsOAuth2Api": {"id": "", "name": "[Your googleSheetsOAuth2Api]"}}, "typeVersion": 4.5}, {"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}, {"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": "https://drive.google.com/drive/folders/1H8Xe2uIO0sI-QdxFsDH0Yg_w9RaPOoD_", "cachedResultName": "yashdata"}, "authentication": "serviceAccount"}, "credentials": {"googleApi": {"id": "", "name": "[Your googleApi]"}}, "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}, {"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}, {"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}, {"id": "81f80bd2-aa10-49a8-ae63-3a3322bcac80", "name": "Generate Summary AI", "type": "@n8n/n8n-nodes-langchain.openAi", "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": "", "name": "[Your openAiApi]"}}, "typeVersion": 1.7}, {"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}, {"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}], "active": true, "pinData": {}, "settings": {"executionOrder": "v1"}, "versionId": "e3318ab1-ef09-4207-9419-411208c35aab", "connections": {"Wikipedia": {"ai_tool": [[{"node": "Generate Summary AI", "type": "ai_tool", "index": 0}]]}, "Calculator": {"ai_tool": [[{"node": "Generate Summary AI", "type": "ai_tool", "index": 0}]]}, "Google Docs": {"main": [[{"node": "Generate Summary AI", "type": "main", "index": 0}]]}, "Google Drive ": {"main": [[{"node": "Google Docs", "type": "main", "index": 0}]]}, "Generate Summary AI": {"main": [[{"node": "Google Sheets", "type": "main", "index": 0}]]}}}How to Import This Workflow
- 1Copy the workflow JSON above using the Copy Workflow JSON button.
- 2Open your n8n instance and go to Workflows.
- 3Click Import from JSON and paste the copied workflow.
Don't have an n8n instance? Start your free trial at n8nautomation.cloud
Related Templates
Auto-create TikTok videos with VEED.io AI avatars, ElevenLabs & GPT-4
Automate the creation and distribution of trending TikTok videos using AI avatars. This workflow connects Telegram, Perplexity, OpenAI, ElevenLabs, VEED.io, and BLOTATO to generate scripts, synthesize voice, create video, and publish across multiple social platforms. Content creators and marketers can rapidly produce engaging short-form video content without manual editing.
Automate LinkedIn Posts with AI
Automate your LinkedIn content creation and publishing by leveraging AI with this powerful workflow. This n8n automation connects LinkedIn, OpenAI, and Notion to streamline your social media presence. A Schedule Trigger initiates the process daily, querying your Notion database for today's scheduled posts. For each post, the workflow fetches all content from its Notion page, including text blocks and an image URL, then uses OpenAI to reformat the post text for optimal engagement. The workflow then combines the rephrased text and fetched image, publishing the complete post directly to LinkedIn. Finally, it updates the post's status in Notion to "Done," ensuring your content calendar remains accurate. This workflow is ideal for content creators, marketers, and businesses looking to maintain a consistent and engaging LinkedIn presence without manual effort, saving significant time on content preparation and publishing while ensuring high-quality, AI-enhanced posts.
Personal life manager with Telegram, Google services & voice-enabled AI
Manage your personal life using voice or text commands through Telegram. This workflow connects Telegram, Google Calendar, Gmail, Google Tasks, and an AI assistant powered by OpenRouter to process requests. It's ideal for busy individuals who want to quickly schedule events, send emails, or manage tasks on the go. This automation streamlines daily organization, saving significant time and mental effort.