Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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

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

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.

@CBantoft 

You’d probably better served using a database app such as Airtable.

Airtable Automations have a native integrations with Outlook, so you may not need Zaps.

Airtable has an API that can be used in Airtable Automations to get 100 records per page at a time to then loop thru.

Airtable API: https://api.airtable.com

Thanks Troy.  I’ve used Airtable but a while ago.  I’ll have another look at it.  Thanks for the tip.

@Troy Tessalone Sorry.  Clarrification:  were you suggesting straight Airtable to Outlook or an Airtable-Zapier-Outlook mashup?  Thanks

@CBantoft 

Probably can be done with just Airtable and Outlook.

You can configure an Airtable Automation that runs on a schedule.

https://support.airtable.com/docs/outlook-automation-actions

👍

Terms & Conditions