Backend workflow to send bulk email to 22k users

[m.sherbiny]

Hi,
I want to send bulk emails to 22k users.

I use SendGrid but the problem is the total number of recipients must be no more than 1000.

I asked bubble support & they said
“you can set up an API workflow with an action that sends the email to 1000 users and then schedules the same API workflow for a later date/time on the next 1000 users. You can have a condition to only schedule the workflow when the list of users that you’re feeding into the workflow is not empty. This way, once you’ve sent the email to all 20k+ users, the API workflow no longer reschedules itself.”

I tried many ways but it failed & an error message displayed “we run into a temporary bug”

Any help please!

[adamhholmes]

Just use a recursive workflow to send to 1000 contacts at a time…

[m.sherbiny]

How I can do this please

[adamhholmes]

Just make the API call to sendgrid and include the 1st 1000 contacts.

Then run it again, and include the next 1000, then the next… and so on (22 times… or until all the contacts have been included).

Exactly how you do that will depend on the specifics of your app… but you could have a parameter on the workflow for ‘items from’, and start it at 1, then each time you run it add 1000 to than number.

Use an appropriate condition to stop the workflow running once all contacts have been emailed (again, that will depend on how you’re doing things).

If you’re asking more generally about how to set up and use recursive workflows, there are plenty of threads on this forum, plus this article is well worth a read: How To Set Up Recursive Workflows In Bubble - Amlie Solutions