Find incomplete tasks due soon and email each assignee on a schedule. Set the date window, filter records and test recipients before enabling reminders.
We recommend building automation examples directly in AI chat. Just describe the automation you want, and AI will handle the full setup for you, including the trigger, actions, script, and configuration.
Build with AI
Open the AI Chat in your table’s right sidebar and tell AI what you want. For example, you can say:“Every morning at 8am, find tasks due within the next 2 days that aren’t completed, and email each assignee a reminder”AI will create the complete automation automatically. You can review the generated script, test it with real data, and enable the automation when ready.
Manual setup
Create an automation with trigger At scheduled time — daily at 08:00.
Add an action → Get records.
Table: Tasks
Filter: Due Dateis withinnext 2 days AND Statusis notCompleted
Click Test to see matching records.
Add an action → Send email with Loop enabled.
Select the array from the Get records step as the loop source.
Map:
To → Assignee’s email (via +, referencing the current loop item)
Subject: Reminder: "<task title>" is due soon
Body: Your task "<task title>" is due on <due date>. Please update the status when done.
Click Test, then enable.
Tips
Adjust the filter window (“next 2 days”, “next 7 days”) based on how urgent tasks typically are.
Add a condition to only email tasks where the Assignee is not empty.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Teable","colors":{"primary":"#131415","light":"#131415","dark":"#F9FAFB"},"logo":{"light":"https://mintcdn.com/teablecn/Sov59EnEPMakaGyj/images/teable-logo-full.png?fit=max\u0026auto=format\u0026n=Sov59EnEPMakaGyj\u0026q=85\u0026s=24e1fe49258a9a8f76eaec5792623926","dark":"https://mintcdn.com/teablecn/Sov59EnEPMakaGyj/images/teable-logo-full-dark.png?fit=max\u0026auto=format\u0026n=Sov59EnEPMakaGyj\u0026q=85\u0026s=be076104208b417182461b52d697a124","href":"https://teable.ai"},"favicon":"https://mintcdn.com/teablecn/MGUqMJ8iafwbPo_j/images/teable-logo.png?fit=max\u0026auto=format\u0026n=MGUqMJ8iafwbPo_j\u0026q=85\u0026s=bd76b377e5d2b5c43bd18f20ddb0c6ad","seo":{"metatags":{"og:image":"https://teable.ai/assets/images/og-image.png","twitter:site":"@teableai","twitter:card":"summary_large_image","canonical":"https://help.teable.ai","description":"Teable is an AI-powered database and app builder. Build apps, automate workflows, and manage data with ease.","keywords":"database, app builder, AI, no-code, low-code, Airtable alternative, PostgreSQL, automation"},"indexing":"all"},"integrations":{"ga4":{"measurementId":"G-LQ8H9TEDRD"}},"metadata":{"timestamp":true},"styling":{"latex":false},"navigation":{"languages":[{"language":"en","banner":{"content":"🚀 Share your projects as templates. See our [changelog](/en/changelog#nov-20-2026) for details.","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Support"}]},"href":"en"},{"language":"zh","banner":{"content":"🚀 把项目做成模板分享。查看[更新日志](/zh/changelog#2026-11-20)了解详情。","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"支持"}]},"href":"zh"},{"language":"ru","banner":{"content":"🚀 Делитесь проектами как шаблонами. Подробнее в [журнале изменений](/ru/changelog#20-ноября-2026).","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Поддержка"}]},"href":"ru"},{"language":"de","banner":{"content":"🚀 Teile deine Projekte als Vorlagen. Details im [Änderungsprotokoll](/de/changelog#20-november-2026).","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Support"}]},"href":"de"},{"language":"fr","banner":{"content":"🚀 Partagez vos projets sous forme de modèles. Consultez notre [journal des modifications](/fr/changelog#20-novembre-2026) pour en savoir plus.","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Assistance"}]},"href":"fr"},{"language":"es","banner":{"content":"🚀 Comparte tus proyectos como plantillas. Consulta el [registro de cambios](/es/changelog#20-de-noviembre-de-2026) para más detalles.","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Soporte"}]},"href":"es"},{"language":"it","banner":{"content":"🚀 Condividi i tuoi progetti come modelli. Scopri i dettagli nel [registro delle modifiche](/it/changelog#20-novembre-2026).","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Supporto"}]},"href":"it"},{"language":"ja","banner":{"content":"🚀 プロジェクトをテンプレートとして共有。詳しくは[更新履歴](/ja/changelog#2026年11月20日)をご覧ください。","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"サポート"}]},"href":"ja"},{"language":"tr","banner":{"content":"🚀 Projelerinizi şablon olarak paylaşın. Ayrıntılar için [değişiklik günlüğüne](/tr/changelog#20-kasım-2026) bakın.","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Destek"}]},"href":"tr"},{"language":"uk","banner":{"content":"🚀 Діліться проєктами як шаблонами. Докладніше в [журналі змін](/uk/changelog#20-листопада-2026).","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Підтримка"}]},"href":"uk"},{"language":"ar","banner":{"content":"🚀 شارك مشاريعك كقوالب. راجع [سجل التغييرات](/ar/changelog#20-نوفمبر-2026) لمعرفة التفاصيل.","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"الدعم"}]},"href":"ar"}]}},"deployment":{"deploymentMetadataValue":{"subdomain":"teablecn","hasAudioNarration":false,"actualSubdomain":"teablecn","customDomains":["help.teable.ai"],"gitSource":{"type":"github","owner":"teableio","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"feedback":{"thumbs":true},"entitlements":{},"buildId":"6affe9183c0658a430f8c4d4","clientVersion":"0.0.4270","searchFilterCounts":[{"language":"ar","tag":"واجهة API","count":737},{"language":"de","tag":"API","count":737},{"language":"en","tag":"API","count":737},{"language":"es","tag":"API","count":737},{"language":"fr","tag":"API","count":737},{"language":"it","tag":"API","count":737},{"language":"ja","tag":"API","count":737},{"language":"ru","tag":"API","count":737},{"language":"tr","tag":"API","count":737},{"language":"uk","tag":"API","count":737},{"language":"zh","tag":"API 文档","count":737},{"language":"ar","tag":"مرجع واجهة API","count":726},{"language":"de","tag":"API-Referenz","count":726},{"language":"en","tag":"API Reference","count":726},{"language":"es","tag":"Referencia de la API","count":726},{"language":"fr","tag":"Référence de l’API","count":726},{"language":"it","tag":"Riferimento API","count":726},{"language":"ja","tag":"APIリファレンス","count":726},{"language":"ru","tag":"Справочник API","count":726},{"language":"tr","tag":"API Referansı","count":726},{"language":"uk","tag":"Довідник API","count":726},{"language":"zh","tag":"API Reference","count":726},{"language":"ar","tag":"admin","count":145},{"language":"de","tag":"admin","count":145},{"language":"en","tag":"admin","count":145},{"language":"es","tag":"admin","count":145},{"language":"fr","tag":"admin","count":145},{"language":"it","tag":"admin","count":145},{"language":"ja","tag":"admin","count":145},{"language":"ru","tag":"admin","count":145},{"language":"tr","tag":"admin","count":145},{"language":"uk","tag":"admin","count":145},{"language":"zh","tag":"admin","count":145},{"language":"zh","tag":"功能文档","count":120},{"language":"ar","tag":"الوثائق","count":118},{"language":"de","tag":"Dokumentation","count":118},{"language":"en","tag":"Docs","count":118},{"language":"es","tag":"Documentación","count":118},{"language":"fr","tag":"Documentation","count":118},{"language":"it","tag":"Documentazione","count":118},{"language":"ja","tag":"ドキュメント","count":118},{"language":"ru","tag":"Документация","count":118},{"language":"tr","tag":"Dokümanlar","count":118},{"language":"uk","tag":"Документація","count":118},{"language":"ar","tag":"المشروع","count":45},{"language":"ar","tag":"space","count":45},{"language":"de","tag":"Projekt","count":45},{"language":"de","tag":"space","count":45},{"language":"en","tag":"Project","count":45},{"language":"en","tag":"space","count":45},{"language":"es","tag":"Proyecto","count":45},{"language":"es","tag":"space","count":45},{"language":"fr","tag":"Projet","count":45},{"language":"fr","tag":"space","count":45},{"language":"it","tag":"Progetto","count":45},{"language":"it","tag":"space","count":45},{"language":"ja","tag":"プロジェクト","count":45},{"language":"ja","tag":"space","count":45},{"language":"ru","tag":"Проект","count":45},{"language":"ru","tag":"space","count":45},{"language":"tr","tag":"Proje","count":45},{"language":"tr","tag":"space","count":45},{"language":"uk","tag":"Проєкт","count":45},{"language":"uk","tag":"space","count":45},{"language":"zh","tag":"项目","count":45},{"language":"zh","tag":"space","count":45},{"language":"ar","tag":"project","count":39},{"language":"de","tag":"project","count":39},{"language":"en","tag":"project","count":39},{"language":"es","tag":"project","count":39},{"language":"fr","tag":"project","count":39},{"language":"it","tag":"project","count":39},{"language":"ja","tag":"project","count":39},{"language":"ru","tag":"project","count":39},{"language":"tr","tag":"project","count":39},{"language":"uk","tag":"project","count":39},{"language":"zh","tag":"project","count":39},{"language":"tr","tag":"Alan","count":35},{"language":"ar","tag":"الأتمتة","count":34},{"language":"de","tag":"Automatisierung","count":34},{"language":"en","tag":"Automation","count":34},{"language":"es","tag":"Automatización","count":34},{"language":"fr","tag":"Automatisation","count":34},{"language":"it","tag":"Automazione","count":34},{"language":"ja","tag":"オートメーション","count":34},{"language":"ru","tag":"Автоматизация","count":34},{"language":"tr","tag":"Otomasyon","count":34},{"language":"uk","tag":"Автоматизація","count":34},{"language":"zh","tag":"自动化","count":34},{"language":"ar","tag":"الحقل","count":30},{"language":"ar","tag":"automation","count":30},{"language":"de","tag":"Feld","count":30},{"language":"de","tag":"automation","count":30},{"language":"en","tag":"Field","count":30},{"language":"en","tag":"automation","count":30},{"language":"es","tag":"Campo","count":30},{"language":"es","tag":"automation","count":30},{"language":"fr","tag":"Champ","count":30},{"language":"fr","tag":"automation","count":30},{"language":"it","tag":"Campo","count":30},{"language":"it","tag":"automation","count":30},{"language":"ja","tag":"フィールド","count":30},{"language":"ja","tag":"automation","count":30},{"language":"ru","tag":"Поле","count":30},{"language":"ru","tag":"automation","count":30},{"language":"tr","tag":"automation","count":30},{"language":"uk","tag":"Поле","count":30},{"language":"uk","tag":"automation","count":30},{"language":"zh","tag":"字段","count":30},{"language":"zh","tag":"automation","count":30}]},"assistantConfig":{},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"site-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"control","enabled":true,"payload":{"type":"string","value":"control"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":".nav-logo{width:108px;height:28px;object-fit:contain}[data-continuous-changelog]>[data-changelog-footer],[data-changelog-year]>a{display:none!important}.changelog-year summary{display:flex;align-items:center;justify-content:space-between;list-style:none;cursor:pointer;padding:0.375rem 1rem;font-size:0.875rem;border-radius:0.75rem}.changelog-year summary::-webkit-details-marker{display:none}.changelog-year summary::marker{content:\"\"}.changelog-year summary svg{width:14px;height:14px;fill:none;stroke:currentColor;stroke-width:1.5}.changelog-year[open] summary svg{transform:rotate(90deg)}.changelog-year summary,.changelog-year a{color:#374151}.dark .changelog-year summary,.dark .changelog-year a{color:#9ca3af}.changelog-year summary:hover,.changelog-year a:hover{color:#111827}.dark .changelog-year summary:hover,.dark .changelog-year a:hover{color:#d1d5db}.changelog-year summary:focus-visible,.changelog-year a:focus-visible{outline:2px solid currentColor;outline-offset:-2px}.changelog-year ul{list-style:none;padding:0;margin:0}.changelog-year a{display:block;margin-block:0.125rem;padding:0.375rem 1rem 0.375rem 2rem;border-radius:0.75rem;font-size:0.875rem}.changelog-year a:hover,.changelog-year summary:hover{background:rgb(156 163 175 / 8%)}.changelog-year a[aria-current]{color:rgb(var(--primary));background:rgb(var(--primary) / 10%);text-shadow:-0.2px 0 0 currentColor, 0.2px 0 0 currentColor}.changelog-year a[aria-busy]{opacity:0.5}.changelog-next-month{display:block;padding-block:2rem}.changelog-next-month[hidden]{display:none}.update-container{scroll-margin-top:180px}.update-container[hidden],.toc-item[hidden]{display:none!important}.changelog-title-anchor{display:block;scroll-margin-top:180px}#content[data-continuous-changelog]{display:flex;flex-direction:column}#changelog-month-stream{display:contents}.changelog-next-month{order:1}.update-container>div:first-child{display:none!important}.update-container>div:has(>[data-component-part=\"update-content\"]){overflow:visible;min-width:0}#content .changelog-heading-link{color:inherit;font:inherit;text-decoration:none;border:0}#content .changelog-heading-link:focus-visible{outline:2px solid currentColor;outline-offset:4px}:has(>svg[style*=\"arrow-left-from-line\"]){display:none!important}.eyebrow{display:none!important}.docs-card-link{display:block;color:inherit!important;text-decoration:none!important}.docs-card-link .card{cursor:pointer}.docs-card-link:hover .card,.docs-card-link:focus-visible .card{border-color:rgb(var(--primary))!important}#header:has(~#content[data-page-href*=\"/changelog\"]) #page-title{position:absolute!important;width:1px!important;height:1px!important;padding:0!important;margin:-1px!important;overflow:hidden!important;clip-path:inset(50%);white-space:nowrap;border:0}#header:has(~#content[data-page-href*=\"/changelog\"]){position:relative;height:0!important;min-height:0!important;margin:0!important;padding:0!important}#header:has(~#content[data-page-href*=\"/changelog\"])>*{margin:0!important}#header:has(~#content[data-page-href*=\"/changelog\"]) .prose{display:none}#header:has(~#content[data-page-href*=\"/changelog\"]) #page-context-menu{position:absolute!important;right:0;top:0;z-index:10}#content[data-page-href*=\"/changelog\"]{margin-top:0!important}#content[data-page-href*=\"/changelog\"]>.update-container:first-of-type{padding-top:0!important}#content[data-page-href*=\"/changelog\"] [data-component-part=\"update-content\"]>h2:first-of-type{font-size:2rem;line-height:1.25;font-weight:700;letter-spacing:-0.025em;margin-top:0;margin-bottom:1.25rem;padding-inline-end:2.5rem}#content[data-page-href*=\"/changelog\"] [data-component-part=\"update-content\"]>h3{font-size:1.5rem;line-height:1.4;font-weight:600}@media (width \u003c 640px){#content[data-page-href*=\"/changelog\"] [data-component-part=\"update-content\"]>h2:first-of-type{font-size:1.75rem}}html:not(.dark){--primary: 19 20 21;--primary-light: 19 20 21;--primary-dark: 19 20 21}.dark{--primary: 249 250 251;--primary-light: 249 250 251;--primary-dark: 249 250 251}#banner{background:rgb(var(--primary))!important}@layer utilities{html:not(.dark) #banner,html:not(.dark) #banner *{color:rgb(249, 250, 251)!important}html:not(.dark) #banner a{color:rgb(249, 250, 251)!important;text-decoration-color:rgba(249, 250, 251, 0.7)!important}.dark #banner,.dark #banner *{color:rgb(19, 20, 21)!important}.dark #banner a{color:rgb(19, 20, 21)!important;text-decoration-color:rgba(19, 20, 21, 0.35)!important}}[data-component-part=\"update-label\"]{background:rgba(17, 17, 17, 0.08)!important;color:#111111!important;border:1px solid rgba(17, 17, 17, 0.18)}.dark [data-component-part=\"update-label\"]{background:rgba(255, 255, 255, 0.1)!important;color:#f3f4f6!important;border-color:rgba(255, 255, 255, 0.25)}html[data-current-path*=\"/changelog\"] #table-of-contents .toc-item[data-changelog-active=\"true\"]>a,html[data-current-path*=\"/changelog\"] #table-of-contents .toc-item[data-active]>a,html[data-current-path*=\"/changelog\"] #table-of-contents .toc-item[data-active-deepest]>a{color:rgb(var(--primary))!important;font-weight:600}html[data-current-path*=\"/changelog\"] #table-of-contents .toc-item[data-changelog-active=\"true\"]::before,html[data-current-path*=\"/changelog\"] #table-of-contents .toc-item[data-active]::before,html[data-current-path*=\"/changelog\"] #table-of-contents .toc-item[data-active-deepest]::before{content:\"\";position:absolute;left:-12px;top:6px;bottom:6px;width:3px;border-radius:999px;background:rgb(var(--primary))}html.dark[data-current-path*=\"/changelog\"] #table-of-contents .toc-item[data-changelog-active=\"true\"]>a,html.dark[data-current-path*=\"/changelog\"] #table-of-contents .toc-item[data-active]>a,html.dark[data-current-path*=\"/changelog\"] #table-of-contents .toc-item[data-active-deepest]>a{color:rgb(var(--primary))!important}.callout[data-callout-type=\"note\"]{border-color:rgba(96, 165, 250, 0.45)!important;background:rgba(239, 246, 255, 0.9)!important}.callout[data-callout-type=\"note\"] [data-component-part=\"callout-icon\"] svg{color:rgb(59, 130, 246)!important}.callout[data-callout-type=\"note\"] [data-component-part=\"callout-content\"]{color:rgb(30, 64, 175)!important}.callout[data-callout-type=\"note\"] [data-component-part=\"callout-content\"] strong,.callout[data-callout-type=\"note\"] [data-component-part=\"callout-content\"] a,.callout[data-callout-type=\"note\"] [data-component-part=\"callout-content\"] code,.callout[data-callout-type=\"note\"] [data-component-part=\"callout-content\"] p,.callout[data-callout-type=\"note\"] [data-component-part=\"callout-content\"] li,.callout[data-callout-type=\"note\"] [data-component-part=\"callout-content\"] span{color:inherit!important}.dark .callout[data-callout-type=\"note\"]{border-color:rgba(96, 165, 250, 0.35)!important;background:rgba(30, 58, 138, 0.22)!important}.dark .callout[data-callout-type=\"note\"] [data-component-part=\"callout-icon\"] svg{color:rgb(147, 197, 253)!important}.dark .callout[data-callout-type=\"note\"] [data-component-part=\"callout-content\"]{color:rgb(219, 234, 254)!important}.docs-screenshot{display:block;height:auto;max-width:100%;margin:1.5rem auto;overflow:hidden;vertical-align:middle;border:1px solid rgba(15, 23, 42, 0.08);border-radius:14px;width:auto}.dark .docs-screenshot{border-color:rgba(255, 255, 255, 0.12)}.docs-inline-icon{display:inline-block;width:1.4em;height:1.4em;margin:0 0.1em;vertical-align:-0.35em}.dark .docs-inline-icon{filter:invert(1)}@media (max-width: 640px){.docs-screenshot{margin:1.25rem auto;border-radius:12px}}@media (min-width: 1024px){#localization-select-trigger{position:fixed!important;bottom:16px!important;right:16px!important;left:auto!important;z-index:50!important}}"}]}
{"page":{"pagePath":"en/basic/automation/examples/deadline-reminders","slug":"/en/basic/automation/examples/deadline-reminders","pageMetadata":{"title":"Send deadline reminders before tasks are due","description":"Find incomplete tasks due soon and email each assignee on a schedule. Set the date window, filter records and test recipients before enabling reminders.","href":"/en/basic/automation/examples/deadline-reminders"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Find incomplete tasks due soon and email each assignee on a schedule. Set the date window, filter records and test recipients before enabling reminders.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,em:`em`,li:`li`,ol:`ol`,p:`p`,strong:`strong`,ul:`ul`,..._provideComponents(),...props.components},{Heading,Tip}=_components;if(!Heading)_missingMdxReference(`Heading`,true);if(!Tip)_missingMdxReference(`Tip`,true);return _jsxs(_Fragment,{children:[_jsx(Tip,{children:`We recommend building automation examples directly in AI chat. Just describe the automation you want, and AI will handle the full setup for you, including the trigger, actions, script, and configuration.`}),`\n`,_jsx(Heading,{level:`2`,id:`build-with-ai`,children:`Build with AI`}),`\n`,_jsx(_components.p,{children:`Open the AI Chat in your table’s right sidebar and tell AI what you want. For example, you can say:`}),`\n`,_jsx(_components.p,{children:_jsx(_components.em,{children:`“Every morning at 8am, find tasks due within the next 2 days that aren’t completed, and email each assignee a reminder”`})}),`\n`,_jsx(_components.p,{children:`AI will create the complete automation automatically. You can review the generated script, test it with real data, and enable the automation when ready.`}),`\n`,_jsx(Heading,{level:`2`,id:`manual-setup`,children:`Manual setup`}),`\n`,_jsxs(_components.ol,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Create an automation`}),` with trigger `,_jsx(_components.strong,{children:`At scheduled time`}),` — daily at 08:00.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Add an action`}),` → `,_jsx(_components.strong,{children:`Get records`}),`.`,`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`Table: `,_jsx(_components.strong,{children:`Tasks`})]}),`\n`,_jsxs(_components.li,{children:[`Filter: `,_jsx(_components.code,{children:`Due Date`}),` `,_jsx(_components.strong,{children:`is within`}),` `,_jsx(_components.code,{children:`next 2 days`}),` AND `,_jsx(_components.code,{children:`Status`}),` `,_jsx(_components.strong,{children:`is not`}),` `,_jsx(_components.code,{children:`Completed`})]}),`\n`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`Click `,_jsx(_components.strong,{children:`Test`}),` to see matching records.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Add an action`}),` → `,_jsx(_components.strong,{children:`Send email`}),` with `,_jsx(_components.strong,{children:`Loop`}),` enabled.`]}),`\n`,_jsx(_components.li,{children:`Select the array from the Get records step as the loop source.`}),`\n`,_jsxs(_components.li,{children:[`Map:`,`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`To → Assignee’s email (via `,_jsx(_components.strong,{children:`+`}),`, referencing the current loop item)`]}),`\n`,_jsxs(_components.li,{children:[`Subject: `,_jsx(_components.code,{children:`Reminder: \"\u003ctask title>\" is due soon`})]}),`\n`,_jsxs(_components.li,{children:[`Body: `,_jsx(_components.code,{children:`Your task \"\u003ctask title>\" is due on \u003cdue date>. Please update the status when done.`})]}),`\n`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`Click `,_jsx(_components.strong,{children:`Test`}),`, then `,_jsx(_components.strong,{children:`enable`}),`.`]}),`\n`]}),`\n`,_jsx(Heading,{level:`2`,id:`tips`,children:`Tips`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:`Adjust the filter window (“next 2 days”, “next 7 days”) based on how urgent tasks typically are.`}),`\n`,_jsx(_components.li,{children:`Add a condition to only email tasks where the Assignee is not empty.`}),`\n`]}),`\n`,_jsxs(_components.p,{children:[`For practical use cases, see `,_jsx(_components.a,{href:`https://teable.ai/ai-project-management`,children:`AI project management workflows`}),`.`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Send deadline reminders before tasks are due","description":"Find incomplete tasks due soon and email each assignee on a schedule. Set the date window, filter records and test recipients before enabling reminders.","href":"/en/basic/automation/examples/deadline-reminders"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Build with AI","slug":"build-with-ai","depth":2,"children":[]},{"title":"Manual setup","slug":"manual-setup","depth":2,"children":[]},{"title":"Tips","slug":"tips","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/_mintlify/custom/teablecn/00e327112fed3559/changelog-toc.js","/_mintlify/custom/teablecn/52b6025e1e6e9c39/language-route.js","/_mintlify/custom/teablecn/58987b414332357e/help-link-tracking.js"],"subdomain":"teablecn","siteName":"Teable","title":"Send deadline reminders before tasks are due - Teable","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"en":{"href":"/en/basic/automation/examples/deadline-reminders","matchLevel":0},"zh":{"href":"/zh/basic/automation/examples/deadline-reminders","matchLevel":1},"ru":{"href":"/ru/basic/automation/examples/deadline-reminders","matchLevel":1},"de":{"href":"/de/basic/automation/examples/deadline-reminders","matchLevel":1},"fr":{"href":"/fr/basic/automation/examples/deadline-reminders","matchLevel":1},"es":{"href":"/es/basic/automation/examples/deadline-reminders","matchLevel":1},"it":{"href":"/it/basic/automation/examples/deadline-reminders","matchLevel":1},"ja":{"href":"/ja/basic/automation/examples/deadline-reminders","matchLevel":1},"tr":{"href":"/tr/basic/automation/examples/deadline-reminders","matchLevel":1},"uk":{"href":"/uk/basic/automation/examples/deadline-reminders","matchLevel":1},"ar":{"href":"/ar/basic/automation/examples/deadline-reminders","matchLevel":1}}},"lastModified":"2026-11-11T07:47:50.921Z","gitLastModified":"2026-11-11T07:45:07.000Z","originalFileLocation":"en/basic/automation/examples/deadline-reminders.mdx","locale":"en"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Find incomplete tasks due soon and email each assignee on a schedule. Set the date window, filter records and test recipients before enabling reminders.\">\u003cmeta data-mint-head name=\"keywords\" content=\"database, app builder, AI, no-code, low-code, Airtable alternative, PostgreSQL, automation\">\u003cmeta data-mint-head name=\"application-name\" content=\"Teable\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/teablecn/rUjbOrtkw4E-Xgfe/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/teablecn/rUjbOrtkw4E-Xgfe/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/teablecn/rUjbOrtkw4E-Xgfe/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/teablecn/rUjbOrtkw4E-Xgfe/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/teablecn/rUjbOrtkw4E-Xgfe/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/teablecn/rUjbOrtkw4E-Xgfe/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/teablecn/rUjbOrtkw4E-Xgfe/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/teablecn/rUjbOrtkw4E-Xgfe/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/teablecn/rUjbOrtkw4E-Xgfe/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Send deadline reminders before tasks are due - Teable\">\u003cmeta data-mint-head property=\"og:description\" content=\"Find incomplete tasks due soon and email each assignee on a schedule. Set the date window, filter records and test recipients before enabling reminders.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Teable\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://help.teable.ai/en/basic/automation/examples/deadline-reminders\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://teable.ai/assets/images/og-image.png\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Send deadline reminders before tasks are due - Teable\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Find incomplete tasks due soon and email each assignee on a schedule. Set the date window, filter records and test recipients before enabling reminders.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://teable.ai/assets/images/og-image.png\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/teablecn/rUjbOrtkw4E-Xgfe/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Teable\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#131415\">\u003clink data-mint-head rel=\"canonical\" href=\"https://help.teable.ai/en/basic/automation/examples/deadline-reminders\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/en/basic/automation/examples/deadline-reminders.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://help.teable.ai/en/basic/automation/examples/deadline-reminders\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"zh\" href=\"https://help.teable.ai/zh/basic/automation/examples/deadline-reminders\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ru\" href=\"https://help.teable.ai/ru/basic/automation/examples/deadline-reminders\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"de\" href=\"https://help.teable.ai/de/basic/automation/examples/deadline-reminders\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"fr\" href=\"https://help.teable.ai/fr/basic/automation/examples/deadline-reminders\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"es\" href=\"https://help.teable.ai/es/basic/automation/examples/deadline-reminders\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"it\" href=\"https://help.teable.ai/it/basic/automation/examples/deadline-reminders\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ja\" href=\"https://help.teable.ai/ja/basic/automation/examples/deadline-reminders\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"tr\" href=\"https://help.teable.ai/tr/basic/automation/examples/deadline-reminders\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"uk\" href=\"https://help.teable.ai/uk/basic/automation/examples/deadline-reminders\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ar\" href=\"https://help.teable.ai/ar/basic/automation/examples/deadline-reminders\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://help.teable.ai/en/basic/automation/examples/deadline-reminders\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://help.teable.ai/#organization\",\"name\":\"Teable\",\"url\":\"https://help.teable.ai\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/teablecn/Sov59EnEPMakaGyj/images/teable-logo-full.png?fit=max\u0026auto=format\u0026n=Sov59EnEPMakaGyj\u0026q=85\u0026s=24e1fe49258a9a8f76eaec5792623926\"}},{\"@type\":\"WebSite\",\"@id\":\"https://help.teable.ai#website\",\"name\":\"Teable\",\"url\":\"https://help.teable.ai\",\"publisher\":{\"@id\":\"https://help.teable.ai/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://help.teable.ai/en/basic/automation/examples/deadline-reminders#webpage\",\"url\":\"https://help.teable.ai/en/basic/automation/examples/deadline-reminders\",\"name\":\"Send deadline reminders before tasks are due\",\"description\":\"Find incomplete tasks due soon and email each assignee on a schedule. Set the date window, filter records and test recipients before enabling reminders.\",\"dateModified\":\"2026-11-11T07:45:07.000Z\",\"isPartOf\":{\"@id\":\"https://help.teable.ai#website\"},\"breadcrumb\":{\"@id\":\"https://help.teable.ai/en/basic/automation/examples/deadline-reminders#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://help.teable.ai/en/basic/automation/examples/deadline-reminders#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Automation\",\"item\":\"https://help.teable.ai/en/basic/automation\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Examples\",\"item\":\"https://help.teable.ai/en/basic/automation/examples/recurring-records\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Send deadline reminders before tasks are due\",\"item\":\"https://help.teable.ai/en/basic/automation/examples/deadline-reminders\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://help.teable.ai/en/basic/automation/examples/deadline-reminders#article\",\"headline\":\"Send deadline reminders before tasks are due\",\"name\":\"Send deadline reminders before tasks are due\",\"description\":\"Find incomplete tasks due soon and email each assignee on a schedule. Set the date window, filter records and test recipients before enabling reminders.\",\"url\":\"https://help.teable.ai/en/basic/automation/examples/deadline-reminders\",\"mainEntityOfPage\":{\"@id\":\"https://help.teable.ai/en/basic/automation/examples/deadline-reminders#webpage\"},\"image\":\"https://teable.ai/assets/images/og-image.png\",\"dateModified\":\"2026-11-11T07:45:07.000Z\",\"publisher\":{\"@id\":\"https://help.teable.ai/#organization\"},\"isPartOf\":{\"@id\":\"https://help.teable.ai#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Teable\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Teable\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/en/basic/automation/examples/deadline-reminders.md","siteName":"Teable","nav":{"global":null,"languages":[{"language":"en","banner":{"content":"🚀 Share your projects as templates. See our [changelog](/en/changelog#nov-20-2026) for details.","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Support"}]},"tabs":[{"tab":"Docs","groups":[{"group":"Start here","pages":[{"title":"Documentation: AI, tables, APIs and self-hosting","sidebarTitle":"Teable documentation","href":"/en"}]},{"group":"AI","pages":[{"title":"AI features: chat, app building and automation","sidebarTitle":"AI capabilities in Teable","href":"/en/basic/ai/overview"},{"title":"AI Chat: analyze data and work with your tables","sidebarTitle":"AI Chat","href":"/en/basic/ai/ai-chat"},{"title":"Artifacts: save, revise, and share AI-generated reports and charts","sidebarTitle":"Artifacts","href":"/en/basic/ai/artifact"},{"title":"AI routines: scheduled and event-triggered tasks","sidebarTitle":"Routine","href":"/en/basic/ai/routine"},{"group":"App Builder","pages":[{"title":"App Builder: create and publish AI-built apps","sidebarTitle":"App Builder","href":"/en/basic/ai/app-builder"},{"title":"App Builder tips: plan, prompt and troubleshoot","sidebarTitle":"App Builder Best Practices","href":"/en/basic/ai/app-builder-practical-guide"},{"title":"Track clinical study startup and site readiness","sidebarTitle":"Study startup and site readiness","href":"/en/basic/ai/examples/study-startup"}]},{"title":"AI fields: summarize, classify and generate values","sidebarTitle":"AI Fields","href":"/en/basic/field/ai/ai-field"},{"group":"Connect \u0026 Migrate Everything","pages":[{"title":"Connect Everything: migrate external data","sidebarTitle":"Connect \u0026 Migrate Everything","href":"/en/basic/ai/connect-everything"},{"title":"Migrate Airtable data to Teable","sidebarTitle":"Migrate Airtable","href":"/en/basic/ai/connect-everything/migrate-airtable"},{"title":"Migrate Baserow data to Teable","sidebarTitle":"Migrate Baserow","href":"/en/basic/ai/connect-everything/migrate-baserow"},{"title":"Migrate SmartSuite data to Teable","sidebarTitle":"Migrate SmartSuite","href":"/en/basic/ai/connect-everything/migrate-smartsuite"},{"title":"Migrate NocoDB data to Teable","sidebarTitle":"Migrate NocoDB","href":"/en/basic/ai/connect-everything/migrate-nocodb"},{"title":"Migrate Jira data to Teable","sidebarTitle":"Migrate Jira","href":"/en/basic/ai/connect-everything/migrate-jira"},{"title":"Migrate monday.com data to Teable","sidebarTitle":"Migrate monday.com","href":"/en/basic/ai/connect-everything/migrate-monday"},{"title":"Migrate ClickUp data to Teable","sidebarTitle":"Migrate ClickUp","href":"/en/basic/ai/connect-everything/migrate-clickup"},{"title":"Migrate Smartsheet data to Teable","sidebarTitle":"Migrate Smartsheet","href":"/en/basic/ai/connect-everything/migrate-smartsheet"},{"title":"Migrate Glide data to Teable","sidebarTitle":"Migrate Glide","href":"/en/basic/ai/connect-everything/migrate-glide"},{"title":"Migrate AppSheet data to Teable","sidebarTitle":"Migrate AppSheet","href":"/en/basic/ai/connect-everything/migrate-appsheet"},{"title":"Migrate Asana data to Teable","sidebarTitle":"Migrate Asana","href":"/en/basic/ai/connect-everything/migrate-asana"},{"title":"Connect APIs, databases and other data sources","sidebarTitle":"Connect \u0026 Migrate More Sources","href":"/en/basic/ai/connect-everything/more-sources"}]},{"title":"Manage connections, API keys and secrets","sidebarTitle":"Credentials and Integrations","href":"/en/basic/credential"},{"title":"Connect AI agents with Teable Skill or MCP","sidebarTitle":"Connect AI Agents to Teable","href":"/en/basic/ai/teable-skill"},{"title":"Custom AI models: add providers and test access","sidebarTitle":"Custom AI Model","href":"/en/basic/ai/custom-model"}]},{"group":"Space","pages":[{"title":"Create and manage spaces","sidebarTitle":"Manage spaces","href":"/en/basic/space"},{"title":"Invite and manage space collaborators","sidebarTitle":"Space Invitation","href":"/en/basic/space/space-invite"},{"title":"Invite collaborators to a specific project","sidebarTitle":"Project Invitation","href":"/en/basic/space/base-invite"},{"title":"Space and project permission levels","sidebarTitle":"Collaboration Permission Details","href":"/en/basic/space/space-permission"},{"title":"Cloud billing: plans, credits, usage and invoices","sidebarTitle":"Billing \u0026 Subscription","href":"/en/basic/space/billing"}]},{"group":"Automation","pages":[{"title":"Build automations with triggers and actions","sidebarTitle":"Build automations","href":"/en/basic/automation"},{"group":"Triggers","pages":[{"title":"Record Matches Conditions trigger: detect state changes","sidebarTitle":"When record matches conditions","href":"/en/basic/automation/trigger/records/record-matches-conditions"},{"title":"Record Created trigger: automate new rows","sidebarTitle":"When record created","href":"/en/basic/automation/trigger/records/record-created"},{"title":"Record Updated trigger: watch field changes","sidebarTitle":"When record updated","href":"/en/basic/automation/trigger/records/record-updated"},{"title":"Form Submitted trigger: process new responses","sidebarTitle":"When form submitted","href":"/en/basic/automation/trigger/forms/form-submitted"},{"title":"Scheduled Time trigger: recurring or one-time runs","sidebarTitle":"At scheduled time","href":"/en/basic/automation/trigger/external/scheduled-time"},{"title":"Button Click trigger: run an automation from a record","sidebarTitle":"When button clicked","href":"/en/basic/automation/trigger/forms/button-click"},{"title":"Webhook trigger: start an automation with HTTP POST","sidebarTitle":"When webhook received","href":"/en/basic/automation/trigger/external/webhook-received"},{"title":"Connector Event trigger: react to app events","sidebarTitle":"When connector event received","href":"/en/basic/automation/trigger/external/connector-event"},{"group":"When email received","pages":[{"title":"Email Received trigger: connect a mailbox","sidebarTitle":"When email received overview","href":"/en/basic/automation/trigger/email/email-received-overview"},{"title":"Gmail IMAP setup and app passwords","sidebarTitle":"Set up Gmail IMAP","href":"/en/basic/automation/trigger/email/gmail-imap"}]}]},{"group":"Actions","pages":[{"group":"Build with AI (recommended)","pages":[{"title":"Generate automation scripts with AI","href":"/en/basic/automation/actions/ai/ai-script"}]},{"group":"Build manually","pages":[{"title":"Create record action in an automation","sidebarTitle":"Create record","href":"/en/basic/automation/actions/records/create-record"},{"title":"Update record action in an automation","sidebarTitle":"Update record","href":"/en/basic/automation/actions/records/update-record"},{"title":"Get records action: filters and pagination","sidebarTitle":"Get records","href":"/en/basic/automation/actions/records/get-records"},{"group":"Send email","pages":[{"title":"Send email action: recipients, content and SMTP","sidebarTitle":"Send email overview","href":"/en/basic/automation/actions/communication/send-email-overview"},{"title":"Custom SMTP for automation email actions","sidebarTitle":"Set up SMTP and sender","href":"/en/basic/automation/actions/communication/smtp-sender"}]},{"title":"HTTP request action: call an external API","sidebarTitle":"HTTP request","href":"/en/basic/automation/actions/logic/http-request"},{"title":"AI generate action: text and structured output","sidebarTitle":"AI generate","href":"/en/basic/automation/actions/ai/ai-generate"},{"title":"Cross-project data access in automations","sidebarTitle":"Cross-project access","href":"/en/basic/automation/actions/records/cross-base"},{"title":"Loop action: process arrays in batches","sidebarTitle":"Loop (batch)","href":"/en/basic/automation/actions/logic/loop-run"},{"title":"Conditional logic: branch automations","sidebarTitle":"Conditional logic","href":"/en/basic/automation/actions/manual/conditional-logic"},{"title":"Run script action: custom JavaScript automations","sidebarTitle":"Write automation scripts","href":"/en/basic/automation/ai/scripting/runscript"}]}]},{"group":"Examples","pages":[{"title":"Auto-create records on a recurring schedule","href":"/en/basic/automation/examples/recurring-records"},{"title":"Run different actions based on record values","href":"/en/basic/automation/examples/conditional-actions"},{"title":"Batch-process records with loop","href":"/en/basic/automation/examples/batch-loop"},{"title":"Avoid unwanted triggers with filters and watch fields","href":"/en/basic/automation/examples/prevent-unwanted-triggers"},{"title":"Auto-record the time when a status changes","href":"/en/basic/automation/examples/timestamp-status"},{"title":"Push notifications to Slack, Discord, or Teams","description":"Send new high-priority tickets to Slack, Discord or Teams with an HTTP request. Configure the channel webhook and adapt the message body for each platform.","href":"/en/basic/automation/examples/push-notifications"},{"title":"Send deadline reminders before tasks are due","href":"/en/basic/automation/examples/deadline-reminders"},{"title":"Generate and send a daily email digest with AI","description":"Run a daily automation that finds completed tasks, turns them into a short AI summary and emails the report to your team.","href":"/en/basic/automation/examples/ai-email-digest"},{"title":"Auto-classify new form entries with AI","href":"/en/basic/automation/examples/ai-classify-forms"},{"title":"Keep records in sync across multiple projects","href":"/en/basic/automation/examples/cross-base-sync"},{"title":"Build automations programmatically with the API","href":"/en/basic/automation/examples/api-automation"}]}]},{"group":"Project","pages":[{"title":"Create, share and migrate projects","sidebarTitle":"Create and manage projects","href":"/en/basic/base"},{"group":"Table","pages":[{"title":"Create, organize and share tables","sidebarTitle":"Create and manage tables","href":"/en/basic/table"},{"title":"Import CSV, Excel, Airtable and Google Sheets data","sidebarTitle":"Import","href":"/en/basic/table/import"},{"title":"Export a table or view to CSV","sidebarTitle":"Export","href":"/en/basic/table/export"}]},{"group":"Field","pages":[{"title":"Field types: choose, add and manage columns","sidebarTitle":"Fields and field types","href":"/en/basic/field"},{"title":"AI fields: summarize, classify and generate values","sidebarTitle":"AI Fields","href":"/en/basic/field/ai/ai-field"},{"group":"Basic Field","pages":[{"title":"Single line text field: names, IDs and links","sidebarTitle":"Single line text","href":"/en/basic/field/single-line-text"},{"title":"Long text field: multiline notes and Markdown","sidebarTitle":"Long text","href":"/en/basic/field/long-text"},{"title":"Number field: decimals, currency and percentages","sidebarTitle":"Number","href":"/en/basic/field/number"},{"title":"Single select field: statuses and option management","sidebarTitle":"Single select","href":"/en/basic/field/single-select"},{"title":"Multiple select field: tags and option management","sidebarTitle":"Multiple select","href":"/en/basic/field/multiple-select"},{"title":"Date field: formats, time zones and defaults","sidebarTitle":"Date","href":"/en/basic/field/date"},{"title":"Rating field: visual scores for records","sidebarTitle":"Rating","href":"/en/basic/field/rating"},{"title":"Checkbox field: track yes/no and completion","sidebarTitle":"Checkbox","href":"/en/basic/field/checkbox"},{"title":"Attachment field: upload and download files","sidebarTitle":"Attachment","href":"/en/basic/field/attachment"}]},{"group":"Advanced Field","pages":[{"group":"Formula","pages":[{"title":"Formula field: calculations and field references","sidebarTitle":"Formula","href":"/en/basic/field/formula"},{"title":"Formula syntax: values, field references and operators","sidebarTitle":"Formula Grammar","href":"/en/basic/field/formula/grammar"},{"title":"Formula function reference with syntax and examples","mode":"wide","sidebarTitle":"Function Cheat Sheet","href":"/en/basic/field/formula/cheat-sheet"}]},{"title":"Link to record field: connect records across tables","sidebarTitle":"Link to record","href":"/en/basic/field/link"},{"title":"Rollup field: summarize linked records","sidebarTitle":"Rollup","href":"/en/basic/field/rollup"},{"title":"Lookup field: reference linked table values","sidebarTitle":"Lookup","href":"/en/basic/field/lookup"},{"title":"Conditional rollup: count and summarize matches","sidebarTitle":"Conditional rollup","href":"/en/basic/field/conditional-rollup"},{"title":"Conditional lookup: find matching table records","sidebarTitle":"Conditional lookup","href":"/en/basic/field/conditional-lookup"},{"title":"User field: assign members to records","sidebarTitle":"User field","href":"/en/basic/field/user"},{"title":"Created by field: track record creators","sidebarTitle":"Created by","href":"/en/basic/field/created-by"},{"title":"Last modified by field: track record editors","sidebarTitle":"Last modified by","href":"/en/basic/field/last-modified-by"},{"title":"Created time field: track record creation dates","sidebarTitle":"Created time","href":"/en/basic/field/created-time"},{"title":"Last modified time field: track record changes","sidebarTitle":"Last modified time","href":"/en/basic/field/last-modified-time"},{"title":"Auto number field: generate record sequences","sidebarTitle":"Auto number","href":"/en/basic/field/auto-number"},{"group":"Button","pages":[{"title":"Button field: trigger an automation","sidebarTitle":"Button","href":"/en/basic/field/button"},{"title":"Button automation example: convert sales leads","sidebarTitle":"Button Practical Guide","href":"/en/basic/field/button-practical-guide"}]}]},{"group":"Common","pages":[{"title":"Field formatting: numbers, currency and dates","sidebarTitle":"Formatting","href":"/en/basic/field/common/formatter"},{"title":"Field display: email links and number charts","sidebarTitle":"Interactive Display","href":"/en/basic/field/common/show-as"},{"title":"Single-value and multiple-value fields","sidebarTitle":"Single Value and Multiple Values","href":"/en/basic/field/common/is-multiple-value"}]}]},{"group":"Records","pages":[{"title":"Create, edit and delete records","sidebarTitle":"Create and manage records","href":"/en/basic/record"},{"title":"Record comments: discuss data and mention teammates","sidebarTitle":"Comments","href":"/en/basic/record/comment"},{"title":"Record history: review data changes and editors","sidebarTitle":"Record history","href":"/en/basic/record/record-history"},{"title":"Archive records and restore deleted table data","sidebarTitle":"Archive and Trash","href":"/en/basic/record/archive-trash"}]},{"group":"View","pages":[{"title":"Grid view: edit, organize and review table data","sidebarTitle":"Grid","href":"/en/basic/view/grid"},{"title":"Form view: collect responses into a table","sidebarTitle":"Form","href":"/en/basic/view/form"},{"title":"Kanban view: group records and track progress","sidebarTitle":"Kanban","href":"/en/basic/view/kanban"},{"title":"Gallery view: image cards and record details","sidebarTitle":"Gallery","href":"/en/basic/view/gallery"},{"title":"Calendar view: schedule records by date","sidebarTitle":"Calendar","href":"/en/basic/view/calendar"},{"title":"Filter, group, sort and share a view","sidebarTitle":"View Toolbar","href":"/en/basic/view/toolbar"}]},{"title":"Turn a project into a template and publish it","sidebarTitle":"Make a template","href":"/en/basic/template"}]},{"group":"Authority Matrix","pages":[{"group":"Authority Matrix","pages":[{"title":"Authority Matrix: roles and data access permissions","sidebarTitle":"Roles and access permissions","href":"/en/basic/authority-matrix"},{"title":"Authority Matrix example: sales team permissions","sidebarTitle":"Authority Matrix Guidelines","href":"/en/basic/authority-matrix/authority-matrix-practical-guide"}]}]},{"group":"SSO","pages":[{"title":"Space SSO: verify domains and connect an identity provider","sidebarTitle":"Single Sign-On (SSO)","href":"/en/basic/sso/overview"},{"title":"Set up Azure Entra ID single sign-on","sidebarTitle":"Azure Entra ID SSO","href":"/en/basic/sso/azure-entra-id"},{"title":"Set up Okta single sign-on","sidebarTitle":"Okta SSO","href":"/en/basic/sso/okta"},{"title":"Set up Google Workspace single sign-on","sidebarTitle":"Google Workspace SSO","href":"/en/basic/sso/google-workspace"},{"title":"Set up Auth0 single sign-on","sidebarTitle":"Auth0 SSO","href":"/en/basic/sso/auth0"},{"title":"Set up OneLogin single sign-on","sidebarTitle":"OneLogin SSO","href":"/en/basic/sso/onelogin"},{"title":"Set up Authentik single sign-on","sidebarTitle":"Authentik SSO","href":"/en/basic/sso/authentik"}]},{"group":"Comparison","pages":[{"title":"Teable vs Excel: database and spreadsheet workflows","sidebarTitle":"Teable vs Excel","href":"/en/compare/teable-vs-excel"}]}]},{"tab":"Self-hosted","pages":[{"title":"Self-hosted","href":"/en/deploy/activate"}]},{"tab":"API","pages":[{"title":"API","href":"/en/api-doc/overview"}]},{"tab":"Security","pages":[{"title":"Security","href":"/en/basic/security"}]},{"tab":"Changelog","pages":[{"title":"Changelog","href":"/en/changelog"}]}]},{"language":"zh","banner":{"content":"🚀 把项目做成模板分享。查看[更新日志](/zh/changelog#2026-11-20)了解详情。","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"支持"}]},"pages":[{"title":"zh","href":"/zh/basic/automation/examples/deadline-reminders"}]},{"language":"ru","banner":{"content":"🚀 Делитесь проектами как шаблонами. Подробнее в [журнале изменений](/ru/changelog#20-ноября-2026).","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Поддержка"}]},"pages":[{"title":"ru","href":"/ru/basic/automation/examples/deadline-reminders"}]},{"language":"de","banner":{"content":"🚀 Teile deine Projekte als Vorlagen. Details im [Änderungsprotokoll](/de/changelog#20-november-2026).","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Support"}]},"pages":[{"title":"de","href":"/de/basic/automation/examples/deadline-reminders"}]},{"language":"fr","banner":{"content":"🚀 Partagez vos projets sous forme de modèles. Consultez notre [journal des modifications](/fr/changelog#20-novembre-2026) pour en savoir plus.","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Assistance"}]},"pages":[{"title":"fr","href":"/fr/basic/automation/examples/deadline-reminders"}]},{"language":"es","banner":{"content":"🚀 Comparte tus proyectos como plantillas. Consulta el [registro de cambios](/es/changelog#20-de-noviembre-de-2026) para más detalles.","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Soporte"}]},"pages":[{"title":"es","href":"/es/basic/automation/examples/deadline-reminders"}]},{"language":"it","banner":{"content":"🚀 Condividi i tuoi progetti come modelli. Scopri i dettagli nel [registro delle modifiche](/it/changelog#20-novembre-2026).","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Supporto"}]},"pages":[{"title":"it","href":"/it/basic/automation/examples/deadline-reminders"}]},{"language":"ja","banner":{"content":"🚀 プロジェクトをテンプレートとして共有。詳しくは[更新履歴](/ja/changelog#2026年11月20日)をご覧ください。","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"サポート"}]},"pages":[{"title":"ja","href":"/ja/basic/automation/examples/deadline-reminders"}]},{"language":"tr","banner":{"content":"🚀 Projelerinizi şablon olarak paylaşın. Ayrıntılar için [değişiklik günlüğüne](/tr/changelog#20-kasım-2026) bakın.","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Destek"}]},"pages":[{"title":"tr","href":"/tr/basic/automation/examples/deadline-reminders"}]},{"language":"uk","banner":{"content":"🚀 Діліться проєктами як шаблонами. Докладніше в [журналі змін](/uk/changelog#20-листопада-2026).","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"Підтримка"}]},"pages":[{"title":"uk","href":"/uk/basic/automation/examples/deadline-reminders"}]},{"language":"ar","banner":{"content":"🚀 شارك مشاريعك كقوالب. راجع [سجل التغييرات](/ar/changelog#20-نوفمبر-2026) لمعرفة التفاصيل.","dismissible":true},"navbar":{"links":[{"icon":"comment","href":"https://community.teable.ai/","label":"الدعم"}]},"pages":[{"title":"ar","href":"/ar/basic/automation/examples/deadline-reminders"}]}]},"basePath":"","title":"Send deadline reminders before tasks are due - Teable","deploymentId":"dpl_DyXGnKeCjZyA3sUdfMJ7FjkdBefg","buildId":"dpl_DyXGnKeCjZyA3sUdfMJ7FjkdBefg","dynamics":["10e4515597"],"chunks":["BannerMarkdown-BOAJk9BH.js","dist-Dl6_zDnT.js","lib-DMeTj1gb.js","lib-B8HbPgcC.js","katex-Dbtb6Wk7.js","html-void-elements-mCSPHezU.js","marked.esm-CZWythHk.js"]}