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.

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

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 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.

 

 

 

@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

 

Terms & Conditions