About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Sending emails to multiple found addresses (and a few related questions)

  • 14 March 2021
  • 6 replies
  • 897 views
A

Hello!

I'm new and I need help with a difficult task.

 

I use an Airtable and do a multi-column search to match the trigger value.

Each of the rows contains the cell with email address.

The search result can be multiple rows.

 

Questions:

  1. Is it possible to send emails to all the found email addresses?
  1. Is it possible to send emails only to few found addresses (randomly selected from all of them)?
  1. Is it possible to list all the found rows in the email body?

 

I will be appreciated for any help

icon

Best answer by Troy Tessalone 14 March 2021, 18:04

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

6 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @andreyandrievich 

Feedback:

  1. Is it possible to send emails to all the found email addresses?
    Would these be separate emails sent to each email address or 1 email sent to all email addresses?
  2. Is it possible to send emails only to few found addresses (randomly selected from all of them)?
    How many is a few?
  3. Is it possible to list all the found rows in the email body?
    Depends on how you want to display the data in the email body.
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
A

Hi @Troy Tessalone!

  1. Would these be separate emails sent to each email address or 1 email sent to all email addresses? 

It will be same email for all recipients.

 

  1. How many is a few?

I plan to make from 3 to 10 (the final decision has not yet been made)

 

  1. Depends on how you want to display the data in the email body.

I want to display several cells from each found row (preferably in the form of a table)

 

BowTieBots
Userlevel 4
Badge +4

@andreyandrievich what program do you want to send the email from? Gmail, Outlook, something else?

 

Setup is slightly different depending on the program

Rich Schnitzel | Helping 6 figure entrepreneurs scale
A

@BowTieBots, Gmail

Troy Tessalone
Userlevel 7
Badge +14

@andreyandrievich

Look into using the Looping action for sending 1 email to each recipient: https://zapier.com/apps/looping/integrations

Check out the Formatter > Utilities > Pick from List option to get a random email address.

https://zapier.com/help/create/format/pick-from-a-list-of-items-in-zaps

NOTE: You may have to use more advanced custom coded logic (perhaps in a Code step) to ensure the same random email address is only picked once from the returned list.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
A

@Troy Tessalone,

Great! Thank you very much!

Terms & Conditions