Is there an easy way to just count all the records in an Airtable table, and send an email with this number? Trigger could be when a new record is created.
Question
How to count all records in an Airtable and send the count via email using Zapier?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Yes.
Also, you can probably use Airtable Automations for this.
Airtable Automations has a Find Records step and an Email step (or can use Gmail/Outlook steps).
Another way is to use linked records in Airtable.
2 Tables
- Table: Dashboard
- Search for the 1 ”MAIN” record which will have the Count of all linked records from the Table XXX
- Table: XXX
- Link all the records in Table XXX to 1 record in the Dashboard Table
- Then you can add a Count field type in the Dashboard Table
- Help: https://support.airtable.com/docs/counting-the-number-of-records-in-linked-record-fields
Hi
Yes.
Also, you can probably use Airtable Automations for this.
Airtable Automations has a Find Records step and an Email step (or can use Gmail/Outlook steps).
Another way is to use linked records in Airtable.
2 Tables
- Table: Dashboard
- Search for the 1 ”MAIN” record which will have the Count of all linked records from the Table XXX
- Table: XXX
- Link all the records in Table XXX to 1 record in the Dashboard Table
- Then you can add a Count field type in the Dashboard Table
- Help: https://support.airtable.com/docs/counting-the-number-of-records-in-linked-record-fields
I have already an automation in Airtable that finds all the records, and return the total “Length of Records”. However, there is a limit of 100 records in Airtable.
+14- Zapier Orchestrator & Solution Partner
Try this approach...
Another way is to use linked records in Airtable.
2 Tables
- Table: Dashboard
- Search for the 1 ”MAIN” record which will have the Count of all linked records from the Table XXX
- Table: XXX
- Link all the records in Table XXX to 1 record in the Dashboard Table
- Then you can add a Count field type in the Dashboard Table
- Help: https://support.airtable.com/docs/counting-the-number-of-records-in-linked-record-fields
Early access
Next Gen Zaps
Build and deploy automations from AI tools you already use. With Agentic Management, if anything breaks, the agent diagnoses the issue and proposes a fix.
Request access now
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.