Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I'm building an automated lead distribution system using Airtable, Zapier, OpenPhone, and Google Sheets. Leads come into Airtable (either via CSV or form) and are assigned to reps based on ZIP codes.

The goal is to automatically send 1 new lead per rep per day at 10AM, using Zapier. The message can go via OpenPhone or Gmail.

How can I make sure it only sends per rep everyday.

Hi ​@krishnaarana 

Much of that logic can be configured using Airtable Automations.

Airtable Automations have a schedule trigger event.

Airtable Automations have a native integration with Gmail.

https://support.airtable.com/getting-started-with-airtable-automations

 

If you need to hire help, there is a directory of Zapier Partners: https://zapier.com/partnerdirectory

The thing is ​@Troy Tessalone I also want to use openphone and that won’t be possible. My other workaround was that as the sales rep is low, can I use find record in my case? As it gives only 1 record (not sure abt this).

If you have any other suggestion that would be great.

​@krishnaarana 

You’ll have to use the concept of looping iterations in Zaps/Airtable Automations: 

https://zapier.com/apps/looping/integrations#help

https://support.airtable.com/docs/repeating-groups-of-automation-actions

Terms & Conditions