Automation · Operations
Find the records somebody left half-filled
Reads an Airtable table each morning and emails you the rows with fields still empty.
- Runs
- Every weekday at 9am
- Works with
- Airtable and Gmail
What it does
- 1Read the table
- 2Find the gaps without being told the columns
- 3Email me what needs filling in
This one already works. Start it on your own accounts and change it to how you work.
Use this automationRelated automations
All 10 in OperationsChase the approvals sitting in your inbox
Finds the approval requests from the last two days and posts them to Slack so nothing waits on one person.
Operations · Gmail and Slack
List what is still open on the project
Reads an Asana project each Monday and emails you the tasks that are still open.
Operations · Asana and Gmail
Read what is open in ClickUp
Reads a ClickUp list each Monday and emails you what is open, grouped by status.
Operations · Clickup and Gmail
Find the files anyone with the link can open
Searches Google Drive weekly for files shared by link and emails you the list to review.
Operations · Google Drive and Gmail
Find the meeting notes nobody turned into actions
Searches your Notion meeting notes each Friday and emails you the ones with decisions but no owner.
Operations · Notion and Gmail
Catch the renewals before they auto-renew
Searches the last month of mail for renewal and subscription notices and emails you what is coming up.
Operations · Gmail