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.

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

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.

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)

 

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

 

Setup is slightly different depending on the program

@BowTieBots, Gmail

@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,

Great! Thank you very much!

Terms & Conditions