Question

How do I send bulk personalized emails via Office 365 at a regulated pace?

6 months ago
15 November 2023
7 replies
109 views

CBantoft
Beginner
4 replies

Hi. I need to send an email to 14,000 people. I’m using Zapier because each person needs their own unique email.

I am using google sheets to store the data (Name, Email address, unique content)

I am using an Office 365 account to send the emails

I would like Zapier to send 100 emails per 10 minutes though instead of trying to send them all at once.

I have tried putting a send time on the spreadsheet but Zapier doesn’t seem to talk to Google Sheets frequently enough for this and it was trying to send several batches at once.

Anyone know how I do this?

Thanks

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Userlevel 7

+14

Troy Tessalone
Certified Zapier Expert
24657 replies
5 months ago
15 November 2023

Hi @CBantoft

Good question.

You probably don’t want to use Zapier for this type of activity and volume.

You’ll likely need to use an email app that can handle bulk delivery and personalization, such as Mailchimp.

Outlook likely has sending limits that won’t allow for that type of volume.

GSheets with 10k plus rows have issues in Zaps.

https://zapier.com/apps/google-sheets/help

CBantoft
Author
Beginner
4 replies
5 months ago
15 November 2023

Thanks for your response, Troy.

Mailchimp (and other email apps).

I used to use Mailchimp but it is now so disrespected by domains the world over.
Servers strip out emails sent by mailchimp at a rate that makes it not worth using.

Outlook

I use mailmerge with Excel and Outlook normally but this dataset is a little too big so am looking to use Zapier.
Microsoft have sending limits and that’s exactly why I need Zapier to be able to throttle.

I think the only answer is to use a formula in google/excel to slowly move data from sheet A to sheet B x rows at a time with Sheet B being the trigger sheet that fires to Zapier. I’ve tried that before but Zapier doesn’t seem to go check for updates in Google Sheets as often as they say they do.