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.

Question

Error: Failed to find a spreadsheet row in Google Sheets

  • 31 January 2023
  • 3 replies
  • 115 views
E

Hi. I have two separate Google Sheets.  Lets call them Parent Sheet and Child Sheet. 

When I update a particular column/row on the Parent Sheet, I also want to update that same column/row on the Child sheet.  My sheets have a unique identifier on each row that will tie the data between sheets together.  Lets call that column My Unique ID.

In Zapier, I’ve played with the Lookup Spreadsheet Row in Google Sheets Zap and can’t figure out how to dynamically find the same row (using My Unique ID value) I’m modifying in the Parent sheet, in the Child sheet. I know it has to be something silly I’m missing. 

In this Zap I see options for Lookup Column, Lookup Value, Supporting Lookup Column, and Supporting Lookup Value.  I’m not sure how to dynamically put references from my Parent Sheet here to find the corresponding row in the Child sheet.

Any help is appreciated!

Thanks all

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

3 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @ekaufman 

Good questions.

For clarity and context, please post detailed screenshots with how your Zap steps are configured, thanks.

 

In this Zap I see options for:

Lookup Column: select the desired column that has the unique id from the dropdown list

Lookup Value: map a variable from a previous step that contains the unique id

Supporting Lookup Column: likely can ignore

Supporting Lookup Value: likely can ignore

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

@Troy Tessalone Thanks.  Adding some screenshots below.  

So in my Lookup Value, I’m using my URL column which is the unique ID that ties the two sheets together.  However, when I set it up like this and test, the error I get is Required field “Lookup Value” (lookup_value) is missing.  I’m not sure what to change next to get it to work.

 

 

 

Troy Tessalone
Userlevel 7
Badge +14

@ekaufman 

The Zap step is returning an error when you test because the example record data from step 1 is empty for the URL field, bu the Lookup Value expects a value to be provided.

Help article about how to change your trigger test data: https://help.zapier.com/hc/en-us/articles/8496310366093

 

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