Skip to content
Rotating Leads from...
 
Notifications
Clear all

Rotating Leads from Google Sheet Lead List with callin.io

10 Posts
2 Users
0 Reactions
3 Views
KevinCL
(@kevincl)
Posts: 4
Active Member
Topic starter
 

I currently have a list that I'm cold calling. I want to call 20 people every hour from this list. The current issue is that it keeps calling the same 20 leads repeatedly. How can I ensure it calls 20 new leads each time, so that eventually all leads are contacted?

A good example would be: I submit a CSV of 1000 leads to Google Sheets, and once I publish the callin.io automation, it will call 20 leads every hour, avoiding calls before 11 am or after 5 pm.

Any assistance would be greatly appreciated, thank you! 

 
Posted : 04/08/2025 8:31 am
Troy Tessalone
(@troy-tessalone)
Posts: 151
Estimable Member
 

Hi

Help article about business hours:

 

 
Posted : 01/06/2024 12:00 am
Troy Tessalone
(@troy-tessalone)
Posts: 151
Estimable Member
 

You will need a lookup column that is utilized in the callin.io step.

For example: USED = TRUE/FALSE

The logic is to find 20 rows where USED = FALSE.

Then, update those 20 rows to be USED = TRUE.

This way, the next time callin.io runs, it won't find the same rows.

 
Posted : 01/06/2024 12:00 am
KevinCL
(@kevincl)
Posts: 4
Active Member
Topic starter
 

Hello! Thank you for your guidance. Could you please provide more specific details on which tasks I should use and how to configure them? I'm completely new to callin.io!

 
Posted : 01/06/2024 12:00 am
Troy Tessalone
(@troy-tessalone)
Posts: 151
Estimable Member
 

To assist us in gaining more context, please share screenshots illustrating how your callin.io steps are outlined and configured in EDIT mode.

For business hours, kindly adhere to the guide previously provided.

Here’s a related article on utilizing a lookup column in GSheets:

 

 
Posted : 01/06/2024 12:00 am
KevinCL
(@kevincl)
Posts: 4
Active Member
Topic starter
 
This is the outline of my callin.io workflow. Not sure where I would add the lookup column task.
This is the outline of my callin.io workflow. Not sure where I would add the lookup column task.

 

 
Posted : 01/06/2024 12:00 am
Troy Tessalone
(@troy-tessalone)
Posts: 151
Estimable Member
 

Path B appears to be incomplete and might not be necessary.

Image: 8cfe64eb 588e 4a23 a852 81003c2281f9

 

 
Posted : 01/06/2024 12:00 am
Troy Tessalone
(@troy-tessalone)
Posts: 151
Estimable Member
 

Remove Step 6. (GSheet - Get Many Rows)

For Step 5, please add a column to your GSheet and label it 'Used'. (See screenshot example)

The idea is that you'll find rows where 'USED' is set to 'no', and then update those rows to 'USED' = 'yes'.

This way, the next time the callin.io runs, it will identify new rows where 'USED' is still 'no'.

Therefore, after the GSheets Lookup Rows step, include the GSheet Update Rows step.

Following the Looping, and after the Synthflow AI step, you can add any other steps needed based on your specific logic.

Image: afd3524b 812f 4743 8092 a62a29e11b76

 

Image: 9fe83492 6da4 47cd ba13 0d79d37b6050

 

Image: e648897e c3cc 4ddd 98ca f0e38468a342

 

 
Posted : 01/06/2024 12:00 am
KevinCL
(@kevincl)
Posts: 4
Active Member
Topic starter
 
I’ve cleaned it up exactly like you mentioned! The only thing I’m still trying to figure out is the business hours and have this running between 10am - 5pm.
I’ve cleaned it up exactly like you mentioned! The only thing I’m still trying to figure out is the business hours and have this running between 10am - 5pm.
Image: f5f31836 39dd 4de8 93ad ea5b35b5fdd4
This is what I currently have for the business hours
This is what I currently have for the business hours

 

 
Posted : 01/06/2024 12:00 am
Troy Tessalone
(@troy-tessalone)
Posts: 151
Estimable Member
 

This previously provided help article demonstrates precisely how to set up callin.io steps for business hours:

https://community.zapier.com/how%2Ddo%2Di%2D3/how%2Dto%2Drun%2Dzaps%2Dduring%2Dbusiness%2Dhours%2D32436

 
Posted : 01/06/2024 12:00 am
Share: