Need help with workflow

[joelwee]

I have a large database in google sheets (about 35k rows).

Is there a workflow which i can use pabbly to automate to select 500 entries everyday at a set time and send an email to these entries?

 

[Luv]

Hello @joelwee

We have a video tutorial similar to your use case on our YouTube Channel. Kindly follow the instructions mentioned in this tutorial and let us know if it works for you -

 

[joelwee]

Hi Luv, I got the workflow, but is there a way to select a different set of people to send emails to?

e.g. Monday send emails to row a 1 to 500, then Tuesday send emails to row 501 to 1000 and so on.

 

[Gunjan]

Hey there!

I don't think there's a specific tutorial out there for this exact workflow, but there’s a way you can make it work. The easiest approach would be to maintain different sheets for each group of 500 rows. You can set up the workflow to run once, and once all the 500 rows for Monday are processed, you can either replace the data in that sheet with the next set (rows 501-1000) or just switch to a new sheet entirely.

This is a workaround, but it should do the job! If you need help setting this up or want a more streamlined solution, feel free to reach out to me at [email protected], and I'd be happy to assist!