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.

I have a sheet with two columan, looks something like that:

user_name | email

A                 | a@email.com

B               | B@email.com

C               | c@email.com

….

I need to use the sheet as a lookup table i.e if a is in the input then I need to fetch a@email.com.
The thing is that there might be more than one inputs A, B should fetch a@email.com, b@email.com.

Tried various option to accomplish that. The best guess was using “Find Many Spreadsheet Rows (With Line Item Support) in Google Sheet”, but that didn’t end up finding anything. The input for the “Find Many Spreadsheet Rows” step is a comma-delimited text - user_name,another_user_name.

Can you please help me as to how can I accomplish that?

*using the zapier lookup table is not relevant as I need that table to be dynamic.

Hi @DoronNess 

Depends on how you are structuring the rest of your Zap action steps, but check out the Looping app: https://zapier.com/apps/looping/integrations

 

 

Thanks! it does look good. I would like to understand what a possible scenario for using this from receiving the list of user - names user_name, another_user_name through getting the right values (emails).

The end goal is to get the list of users and send emails to all their address.

 

Thank you very much!

Depends if you are sending individual emails vs having multiple TO/CC/BCC recipients sent on 1 email.

 

Zap Steps for individual email sends

  1. Trigger: APP] - EVENT] (depends on the trigger app and event supplying the array of users)
  2. Action: Looping
  3. Action: GSheets - Lookup Row
  4. Action: APP] - EVENT] (depends on what app you are using to send the email)

 

Thanks! It seems to wok 

Terms & Conditions