{"product_id":"n8n-workflow-airtable-tax-chasing-with-gpt-4o-gmail-telegram","title":"n8n Workflow: Airtable Tax Chasing with GPT-4o, Gmail \u0026 Telegram","description":"\u003ch3\u003eChase missing tax documents automatically—then notify your team in Airtable, Gmail, and Telegram\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks your \u003cstrong\u003eAirtable\u003c\/strong\u003e client records every weekday morning, sends \u003cstrong\u003eGPT-4o-mini\u003c\/strong\u003e-drafted reminder emails via \u003cstrong\u003eGmail\u003c\/strong\u003e, and keeps everyone updated with \u003cstrong\u003eTelegram\u003c\/strong\u003e alerts—including a webhook to log documents as soon as they’re received.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every weekday at 9:00 AM\u003c\/strong\u003e: loads firm settings, then scans the \u003cstrong\u003eAirtable Clients\u003c\/strong\u003e table for current document status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompares required vs. received documents\u003c\/strong\u003e: decides whether a client needs a reminder, should be escalated, can remain quiet, or is fully clear.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends GPT-4o-mini reminder emails\u003c\/strong\u003e: for clients due a reminder, the workflow drafts a short email with \u003cstrong\u003eOpenAI (GPT-4o-mini)\u003c\/strong\u003e, sends it through \u003cstrong\u003eGmail\u003c\/strong\u003e, updates \u003cstrong\u003elast_reminded\u003c\/strong\u003e in Airtable, and logs the action to the \u003cstrong\u003eAirtable DocLog\u003c\/strong\u003e table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates after one week of silence\u003c\/strong\u003e: if a client stays silent for a week after a reminder, it escalates to the firm owner via \u003cstrong\u003eTelegram and Gmail\u003c\/strong\u003e, updates \u003cstrong\u003elast_reminded\u003c\/strong\u003e, and writes an escalation entry to \u003cstrong\u003eDocLog\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts all-clear notifications\u003c\/strong\u003e: when no clients are missing documents, it posts an \u003cstrong\u003eall-clear\u003c\/strong\u003e message to \u003cstrong\u003eTelegram\u003c\/strong\u003e and logs the result to \u003cstrong\u003eDocLog\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles “Doc Received” via webhook\u003c\/strong\u003e: validates webhook payload fields, matches the client and required document against Airtable, updates \u003cstrong\u003ereceived_docs\u003c\/strong\u003e, logs to \u003cstrong\u003eDocLog\u003c\/strong\u003e, and notifies the team in Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eErrors won’t corrupt Airtable\u003c\/strong\u003e: if the webhook payload is incomplete or doesn’t match a known client\/document, the workflow sends an \u003cstrong\u003eerror alert to Telegram\u003c\/strong\u003e and emails the firm inbox—without updating Airtable.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomatic weekday follow-ups for missing tax forms tracked in Airtable.\u003c\/li\u003e\n  \u003cli\u003eEscalation to owners when clients don’t respond after a reminder.\u003c\/li\u003e\n  \u003cli\u003eFast document confirmation when a “Doc Received” webhook is triggered (and immediate team visibility in Telegram).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling\u003c\/strong\u003e: weekday automation at \u003cstrong\u003e9:00 AM\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes\/logic\u003c\/strong\u003e: if, set, code, switch, webhook\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: \u003cstrong\u003eAirtable\u003c\/strong\u003e, \u003cstrong\u003eOpenAI (GPT-4o-mini)\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eTelegram\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45962012262579,"sku":"N8N-19227","price":70.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/o1YD0ktq_URMzFhbq8UgP_W9pYZ38R.png?v=1788599109","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-airtable-tax-chasing-with-gpt-4o-gmail-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}