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.

Best answer

Using a spreadsheet as lookup

  • February 17, 2021
  • 4 replies
  • 148 views
D

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.

Best answer by Troy Tessalone

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)

 

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

4 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • February 17, 2021

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

 

 

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
D
  • DoronNessBeginner
  • Author
  • Beginner
  • February 17, 2021

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!

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • Answer
  • February 17, 2021

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)

 

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
D
  • DoronNessBeginner
  • Author
  • Beginner
  • February 18, 2021

Thanks! It seems to wok 

Terms & ConditionsAccessibility statement