Workflow templateChase clients for missing tax documents
Emails clients about the documents still missing on an Airtable checklist each weekday, counts every reminder on the row, and tells you on Telegram when a client reaches three.
Workflow illustration
01Trigger
TriggerEvery weekday at 09:00 AM UTC.
02Ai
AirtableRead the Airtable base and table ids you choose in setup, with the columns Client, Email, Missing Items, Times Chased and Last Chased.
03Gm
GmailFor each row with Missing Items whose Last Chased is not today, email the client a courteous reminder listing them with Gmail.
04
Custom stepAdd one to that row's Times Chased and set Last Chased to today.
05Te
TelegramMessage the Telegram chat id you choose in setup with the clients whose Times Chased reached 3 today.
06
OutputFinish
How it runs
This is the brief Whenever builds from. Change any of it in plain words before you publish.
When
Every weekday at 09:00 AM UTC.
Then
- Read the Airtable base and table ids you choose in setup, with the columns Client, Email, Missing Items, Times Chased and Last Chased.
- For each row with Missing Items whose Last Chased is not today, email the client a courteous reminder listing them with Gmail.
- Add one to that row's Times Chased and set Last Chased to today.
- Message the Telegram chat id you choose in setup with the clients whose Times Chased reached 3 today.
Agents should build your automations, not be them
Describe your first workflow in plain words. AI building is free within weekly usage limits; you pay when it runs.