Skip to main content
Question

How can I get Zapier to analyze all rows in a Beta Worksheet to match data with an Alpha Worksheet?

  • November 4, 2024
  • 2 replies
  • 14 views

Hi!

  • I want Zapier to Upgrade a Spreadsheet Row from Gamma Worksheet
  • But only if A1 Alpha Worksheet data matches exactly with A1 Beta Worksheet

Until here everything done. The problem is that Zapier is not looking at the whole range of data. 

  • Beta Worksheet has 100 rows and I want Zapier to analyze all rows and get the data once matches with previous criteria.

I’ve created next ZAP:

 

1.- New or Updated Spreadsheet Row

2.- Lookup Spreadsheet Row

3.- Lookup Spreadsheet Row

4.- Filter conditions

5.- Update Spreadsheet Row(s)

 

Can someone help me please?

Thanks in advance!

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

2 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • November 4, 2024

Hi @Becky 

Perhaps you can outline a specific example for us to have a better understanding of what you are trying to configure with the Zap steps.

Also, it is help for us if you can post how the Zap steps are outlined and configured in EDIT mode so we can see the field mappings.


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • November 8, 2024

Hi @Becky,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.