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
The Zappy Awards are back
We're celebrating the Zapier builders making AI transformation happen. Winners get a published story on zapier.com, a trophy, $5,000 cash, and a feature at ZapConnect. Nominate yourself or a peer by July 24th, 2026.
Log in to the Community
No account yet? Create an account
Use your Zapier credentials
Log in with ZapierEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.