Best answer

'Lookup Spreadsheet Row in Google Sheets' randomly failed to work properly.

  • 6 October 2023
  • 2 replies
  • 166 views

Userlevel 1

Google sheet’s 'Lookup Spreadsheet Row in Google Sheets' randomly failed to work. I have check marked, ‘Create Google Sheets Spreadsheet Row if it doesn’t exist yet?’. 

It work fine only when data inserted in short spans of item. If data inserted after some seconds or minutes, then it again adds the header row, in middle of spreadsheet, even when it is already present on top of page. 

icon

Best answer by Inderjeet Singh 6 October 2023, 07:04

View original

2 replies

Userlevel 7
Badge +14

Hi @Inderjeet Singh 

Good question.

Have you reviewed all the available help articles for using GSheets in Zaps?

https://zapier.com/apps/google-sheets/help

Userlevel 1

I would like to post solution which fixed issue.

I was keeping ‘Lookup Value’ to static header’s values. It seemed after short interval of time Zapier was checking presence of that value in last row, while that static value was present only in header row. So, I had add dynamic ‘Lookup Value’ for an ID which was repeating in a column. This resulted in, when Zapier checked last row, it found that repeating value and it have fixed the issue. 

So, it create header row only if it don’t exist in a fresh worksheet. 

Bug:

While ‘Bottom-Up’ field which ‘Search from bottom of the sheet? In other words, pick the most recent match?’ was turned ‘False’, so it should not be fetching bottom row value. It seems like some bug in this Zap step.

 

Reply