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”
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).