Question

I want to create a automated mailing system that will send mail to all my audience that i have on Mailchimp

  • 18 April 2023
  • 1 reply
  • 37 views

i want to create a automate email sender 

that will triggered when i create a document in google docs 

then will create a campain in mailchimp after that will find a existing document that called mail list from my google doc acc and finaly will get the text data from the mail list document and will add the data in gmail app in the section send mail to pls if anyone can help will be awesome i was struggling to find this for over 8 strait ours in front of my laptop


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

1 reply

Userlevel 7
Badge +11

Welcome to the Community, @Taxiarxispurp! 👋
 

You could use Google Doc’s New Document trigger to trigger the Zap when a new document is created, then use Mailchimp’s Create Campaign action to make the campaign. The Google Docs app also has a Find a Document search action which you could potentially use to find the relevant mailing list document. Gmail isn’t meant for sending out email campaigns, so you’d likely need to handle the send of the email campaign via Mailchimp. But the Mailchimp app doesn’t have a way of adding a new list. And its Add/Update Subscriber action would only be able to add a single new subscriber to a list, not multiple ones.

That said, you could potentially put the Add/Update Subscriber action inside a Looping by Zapier action to run through a list of the subscribers you want to add to a particular list. But you’d need to create the list in Mailchimp first then select that list in the Zap. You can find out more about how to use loops here: Loop your Zap actions

Hope that helps to get you pointed in the right direction. Please do keep us updated on how it goes!