I’m working with a team setup where we have multiple sales representatives and I need to create a Zapier workflow that connects to our Airtable base. The main challenge I’m facing is controlling the frequency of record distribution.
Right now I want to make sure that each sales rep gets exactly one new prospect from our Airtable database per day through the automated process. I don’t want anyone to get overwhelmed with multiple records at once or have some people get nothing while others get too many.
Has anyone successfully configured a Zapier automation that can handle this kind of daily limit per team member? I’m looking for the best approach to set up filters or delays that would ensure fair distribution of new prospects from our Airtable workspace to each representative on a daily basis.
We fixed this by adding a date field in Airtable that tracks when each rep last got a record. The Zapier filter checks if today’s date is after that timestamp before sending anything. Works great and stops double assignments even when the zap runs multiple times daily.
I tackled a similar situation with my team a while back. Instead of letting Zapier do all the heavy lifting, I found combining Airtable views with scheduled Zaps to be more effective for distributing records fairly. I set up a status field in Airtable to track which prospects were assigned and to whom. Each sales rep has their own Zap that runs daily and pulls only those records that are unassigned or overdue for assignment. The round-robin approach ensures that each rep gets their turn without overlap, and by introducing a slight delay between the Zaps, you can prevent any conflicts. This method helped us maintain a steady flow and ensured everyone received one record per day.
Had this exact issue when scaling our lead distribution. Here’s what worked: I built a daily counter right in Airtable before Zapier even kicks in. Created a formula field tracking how many records each rep got that day, then used it as a filter in my Zap. The trigger only fires when a rep’s count is zero AND there are unassigned records available. This way nobody gets multiple records per day, but everyone still gets their share. I run it every few hours, so if someone gets skipped due to timing, they’ll catch the next cycle.