Skip to main content

I’m familiar with the Zap/Sheets flow where I or someone else can receive an email anytime Sheet data is changed. I want to do something different. 

I have a sheet with a huge email list in it and I want to send a stock prospecting email out to everyone on the list. 

BCC tons of people crushes delivery rate, and most CRMs don’t let you upload massive lists without names at a minimum. I just have email addresses. MailChimp isn’t it either unfortunately. So that possibly brings me to Zapier. 

To clarify- I want a stock email to go out to everyone on a massive list, with no CC’ing or BCC’ing. Individual ‘TO’ emails off of the list in Sheets. Any help is appreciated! 

Hi there @rightpathdrew,

Welcome to the Community! 🎉

You can use Looping by Zapier for your desired workflow. Looping is a tool that allows you to run an action or set of actions multiple times. Any action that follows a looping step will run once for each set of values input into a Create Loop step.

You can learn more about Looping by Zapier here: https://help.zapier.com/hc/en-us/articles/8496106701453-Loop-your-Zap-actions

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!


Hi @rightpathdrew,

How did you get on with the Looping by Zapier app that Ken suggested here? Did that allow you to send out the emails out to everyone on the list?

Want to ensure you’re all set here so let us know if there’s anything further we can help with! 🙂