{"product_id":"google-drive-meeting-action-extractor-with-gemini-sheets","title":"Google Drive Meeting Action Extractor with Gemini \u0026 Sheets","description":"\u003ch3\u003eTurn new Google Drive meeting transcripts into action items—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches a Google Drive folder for new meeting transcript files, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to extract structured meeting metadata and action items, saves them to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends \u003cstrong\u003eSlack\u003c\/strong\u003e notifications for newly created and due\/overdue tasks.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors a Google Drive folder\u003c\/strong\u003e and triggers when a new file is created.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads the transcript\u003c\/strong\u003e and extracts its text content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls Google Gemini\u003c\/strong\u003e to generate a structured JSON meeting summary, including a title, discussion points, decisions, risks\/blockers, conclusions, and an overall summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls Google Gemini again\u003c\/strong\u003e to extract action items (task, owner, deadline, priority, and context), then parses and normalizes the resulting JSON (including \u003cstrong\u003einferring deadlines when missing\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates a Google Sheets tracker\u003c\/strong\u003e by \u003cstrong\u003ematching on Action ID\u003c\/strong\u003e as the unique key (append or update per action item).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts a Slack message\u003c\/strong\u003e for each newly created action item \u003cstrong\u003ewhen a deadline is present\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily on a schedule\u003c\/strong\u003e, checks pending tasks in the Google Sheet, and sends \u003cstrong\u003eSlack reminders\u003c\/strong\u003e for items due today or earlier.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAuto-capture team action items from recurring meeting transcripts saved to Google Drive.\u003c\/li\u003e\n  \u003cli\u003eKeep a single source of truth in Google Sheets for owners, priorities, deadlines, and context—without manual note-taking.\u003c\/li\u003e\n  \u003cli\u003eEnsure accountability with Slack alerts for newly added tasks and daily reminders for overdue or due-today items.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger\/logic:\u003c\/strong\u003e n8n \u003cstrong\u003eif\u003c\/strong\u003e and \u003cstrong\u003ecode\u003c\/strong\u003e nodes for parsing, normalization, and deadline handling.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e (file monitoring + download), \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e (meeting summary + action-item extraction), \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (tracker updates using Action ID), and \u003cstrong\u003eSlack\u003c\/strong\u003e (new-item posts + daily due reminders).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotes:\u003c\/strong\u003e Designed for an n8n automation workflow using the specified node set (including Slack, Google Drive, and Google Sheets).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146433450163,"sku":"N8N-20219","price":35.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/KoLIHvs4bdXW-PV20w984_YxsGO8qb.png?v=1790846818","url":"https:\/\/buyflowscripts.com\/products\/google-drive-meeting-action-extractor-with-gemini-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}