{"product_id":"zoom-coaching-recap-homework-automation-with-n8n-openai-google-sheets","title":"Zoom Coaching Recap + Homework Automation with n8n, OpenAI \u0026 Google Sheets","description":"\u003ch3\u003eTurn every Zoom coaching call into an AI recap + automated homework follow-up—logged, emailed, and nudged daily\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically converts completed \u003cstrong\u003eZoom coaching\u003c\/strong\u003e recordings into \u003cstrong\u003eAI-generated session recaps and homework action plans\u003c\/strong\u003e using \u003cstrong\u003eOpenAI\u003c\/strong\u003e, writes everything to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, emails clients via \u003cstrong\u003eGmail\u003c\/strong\u003e, and runs every day to send \u003cstrong\u003enudge emails\u003c\/strong\u003e for upcoming or overdue tasks.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives Zoom webhook events\u003c\/strong\u003e for endpoint validation and recording completion (returns the required validation response, or immediately acknowledges recording events).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches transcripts or transcribes audio\u003c\/strong\u003e: extracts recording metadata, downloads the Zoom transcript when available, otherwise downloads the session audio and transcribes it with \u003cstrong\u003eOpenAI Whisper\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches clients in Google Sheets\u003c\/strong\u003e using the Zoom meeting ID or meeting topic, skipping inactive clients and sessions already logged.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a structured action plan\u003c\/strong\u003e with \u003cstrong\u003eOpenAI (GPT-4o-mini)\u003c\/strong\u003e from the transcript + client context, producing a JSON plan including recap, wins, insights, homework tasks with due dates, and a progress score.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an HTML recap email\u003c\/strong\u003e to the client via \u003cstrong\u003eGmail\u003c\/strong\u003e (CC’ing the coach), then appends the session to a \u003cstrong\u003eGoogle Sheets Session Log\u003c\/strong\u003e and each homework task to a \u003cstrong\u003eHomework Tracker\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends daily homework check-ins\u003c\/strong\u003e at \u003cstrong\u003e10:00\u003c\/strong\u003e: groups tasks due soon or slightly overdue per client, drafts one concise email per client with OpenAI, sends via Gmail, and updates each task row with incremented nudge count and last nudge date.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCoaches who want recaps + homework plans generated immediately after every Zoom call\u003c\/li\u003e\n  \u003cli\u003eSaaS operators automating client communication without manual copy\/paste\u003c\/li\u003e\n  \u003cli\u003eTeams needing reliable task nudges for upcoming and overdue action items\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCore logic and helpers: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eEmail delivery: \u003cstrong\u003eGmail\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eSecurity: uses \u003cstrong\u003ecrypto\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eAI + transcription: \u003cstrong\u003eOpenAI Whisper\u003c\/strong\u003e, \u003cstrong\u003eOpenAI (GPT-4o-mini)\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eData storage + matching: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (Session Log + Homework Tracker)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46123233149107,"sku":"N8N-20088","price":76.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/0C4FqKesamH6fJCPVKRze_196FBllf.png?v=1790673751","url":"https:\/\/buyflowscripts.com\/products\/zoom-coaching-recap-homework-automation-with-n8n-openai-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}