{"product_id":"n8n-client-check-in-automation-airtable-openai-gmail-discord","title":"n8n Client Check-In Automation: Airtable + OpenAI + Gmail + Discord","description":"\u003ch3\u003eAutomated client check-ins with Airtable, OpenAI, Gmail \u0026amp; Discord (plus a weekly Friday digest)\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation monitors your Airtable “Client Projects” on a schedule, detects clients that have gone quiet for 10+ days, generates personalized check-in emails using OpenAI, sends them via Gmail, logs every touch back to Airtable, and posts updates to Discord—then sends a weekly health digest every Friday.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns Mondays at 09:00\u003c\/b\u003e (workflow timezone) and reads the Airtable \u003cb\u003eClient Projects\u003c\/b\u003e table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eChecks recency:\u003c\/b\u003e calculates days since each project’s \u003cb\u003elast_touch\u003c\/b\u003e and flags projects quiet for \u003cb\u003e10+ days\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eData quality handling:\u003c\/b\u003e emails an internal address if any rows have missing or malformed \u003cb\u003elast_touch\u003c\/b\u003e values.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAll-clear messaging:\u003c\/b\u003e if no projects are quiet, posts an “all clear” update to \u003cb\u003eDiscord\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI-assisted outreach:\u003c\/b\u003e for each quiet project, generates a short check-in email (subject + body) referencing the \u003cb\u003eproject name\u003c\/b\u003e and \u003cb\u003estage\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends + records activity:\u003c\/b\u003e sends the email via \u003cb\u003eGmail\u003c\/b\u003e, appends a row to Airtable’s \u003cb\u003eTouch Log\u003c\/b\u003e, and updates the project’s \u003cb\u003elast_touch\u003c\/b\u003e in Airtable.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eVisibility in Discord:\u003c\/b\u003e posts a one-line summary for each sent check-in.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns Fridays at 16:00:\u003c\/b\u003e compiles project health metrics from Airtable (including recent check-ins), uses \u003cb\u003eOpenAI\u003c\/b\u003e to write a brief digest, and sends it via \u003cb\u003eGmail\u003c\/b\u003e and \u003cb\u003eDiscord\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eKeep client relationships active by automatically following up when there’s no recent touch.\u003c\/li\u003e\n  \u003cli\u003eReduce manual admin: schedule check-ins, log outcomes, and maintain accurate Airtable timelines.\u003c\/li\u003e\n  \u003cli\u003eGive your team transparency with Discord updates and a Friday health overview.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e Airtable, OpenAI, Gmail, Discord.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eWorkflow nodes:\u003c\/b\u003e if, set, code, gmail, discord, airtable.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRequired Airtable tables\/fields:\u003c\/b\u003e \u003cb\u003eClient Projects\u003c\/b\u003e and \u003cb\u003eTouch Log\u003c\/b\u003e, including \u003cb\u003eproject_id\u003c\/b\u003e, \u003cb\u003estatus\u003c\/b\u003e, \u003cb\u003elast_touch\u003c\/b\u003e, \u003cb\u003eclient_email\u003c\/b\u003e, and \u003cb\u003elog_id\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950265458867,"sku":"N8N-19123","price":76.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7joLZ8S2uvahk3coaW3gf_qhlC5gmF.png?v=1788514275","url":"https:\/\/buyflowscripts.com\/products\/n8n-client-check-in-automation-airtable-openai-gmail-discord","provider":"N8N Commerce","version":"1.0","type":"link"}