{"product_id":"n8n-weekly-coaching-check-ins-google-sheets-gmail-deepseek","title":"n8n Weekly Coaching Check-Ins: Google Sheets + Gmail + DeepSeek","description":"\u003ch3\u003eTurn Weekly Coaching Into an Automated, Personalized System\u003c\/h3\u003e\n\u003cp\u003eThis n8n weekly coaching check-in workflow automatically emails your active coaching clients a check-in link every week, collects their responses, drafts personalized replies using DeepSeek, logs everything back to Google Sheets, and alerts you via Telegram and Gmail when check-ins are missed or need attention.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSunday 07:00 (Asia\/Jakarta):\u003c\/strong\u003e Reads the \u003cstrong\u003eClients\u003c\/strong\u003e tab in Google Sheets and selects clients where status is set to \u003cstrong\u003eactive\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSends each active client a \u003cstrong\u003eGmail\u003c\/strong\u003e message containing a link to the \u003cstrong\u003en8n Form\u003c\/strong\u003e for weekly check-ins.\u003c\/li\u003e\n  \u003cli\u003eProcesses incoming submissions from the \u003cstrong\u003en8n Form\u003c\/strong\u003e, normalizing fields (including timestamps and numeric values) for consistent handling.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates required fields:\u003c\/strong\u003e if required data is missing, the workflow skips processing and notifies the coach via \u003cstrong\u003eTelegram\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFor valid submissions, it reads recent check-in history from the \u003cstrong\u003eCheckIns\u003c\/strong\u003e tab and sends the check-in + history to \u003cstrong\u003eOpenAI (DeepSeek model)\u003c\/strong\u003e to generate an \u003cstrong\u003eadherence score\u003c\/strong\u003e, \u003cstrong\u003eflags\u003c\/strong\u003e, and a \u003cstrong\u003eshort reply\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAppends the check-in and AI reply back to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (using the Google Sheets client roster to support reply context when the client is found), then emails the coaching reply to the client.\u003c\/li\u003e\n  \u003cli\u003eIf the AI flags attention needed, it sends a \u003cstrong\u003eTelegram\u003c\/strong\u003e alert to the coach.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonday 09:00 (Asia\/Jakarta):\u003c\/strong\u003e Compares active clients vs. check-ins from the last 7 days and sends \u003cstrong\u003eTelegram\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e nudges for missed clients, or an all-clear message.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate weekly accountability for coaching programs without manual follow-ups.\u003c\/li\u003e\n  \u003cli\u003eDetect incomplete submissions and quickly notify the coach to intervene.\u003c\/li\u003e\n  \u003cli\u003eSend personalized coaching responses powered by DeepSeek, while maintaining an audit trail in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule:\u003c\/strong\u003e Runs Sunday 07:00 and Monday 09:00 (Asia\/Jakarta).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (Clients, CheckIns, roster logging), \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003en8n Form\u003c\/strong\u003e, \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogic \u0026amp; processing:\u003c\/strong\u003e \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esplit out\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI:\u003c\/strong\u003e OpenAI using the \u003cstrong\u003eDeepSeek\u003c\/strong\u003e model to generate adherence scoring and replies.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45876859011251,"sku":"N8N-18515","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/T4rt8YndJsIbI3L4yBZKH_KnmemxpL.png?v=1787303371","url":"https:\/\/buyflowscripts.com\/products\/n8n-weekly-coaching-check-ins-google-sheets-gmail-deepseek","provider":"N8N Commerce","version":"1.0","type":"link"}