Skip to main content
Best answer

Google Sheet Row ID Not Showing to Select


I am using a row lookup so I can update a specific row. The looup actually finds/retrieves the row just fine.  It’s when I go to update the row based on the Row ID it falls apart.

There is NO ID field that shows up for me to select.  There are two Row fields that show up in the same list which is weird too.

Why is the ID field not showing up for me to select so I can update the row I just looked up?

 

 

Best answer by Troy Tessalone

Hi @Kwallenbeck 

Alternatively you can use the Row data point.

 

View original
Did this topic help you find an answer to your question?
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

  • Author
  • Beginner
  • 4 replies
  • April 21, 2021

To help clarify, here is the test data coming back from the lookup. I can see ID here, but when I go to choose it, not there.

 


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31067 replies
  • Answer
  • April 21, 2021

Hi @Kwallenbeck 

Alternatively you can use the Row data point.

 


  • Author
  • Beginner
  • 4 replies
  • April 27, 2021

This did the trick. Feels a bit untrustworthy, but works.  Thanks for the reply.