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.

I am using Lookup Spreadsheet Row in Google Sheets in many steps of multiple different zaps. They have all stopped working!!!! Please Help. 

 

Even though I map the spreadsheet ID correctly (to a dynamic spreadsheet which does exist), and zapier successfully sees, and displays all the correct Worksheet options, once I select the worksheet and scroll down a little, the selected worksheet field DISSAPEARS (deselects). I can never get past this to test the step as it does not keep the selection. 

 

NOTE: A static spreadsheet that I select DOES work, but a dynamic selected sheet DOES NOT, even though Zapier recognizes it, and offers the worksheets for me to select from. 

 

Please help!

Video Attached. 

Video of issue

Hi ​@James Paver Restore,

 

Welcome to the Community.

 

If you're having issues with Zapier's Lookup Spreadsheet Row in Google Sheets, try these steps: ensure the Spreadsheet ID is correctly mapped, reconnect Google Sheets in Zapier, check if the worksheet has restrictions, and try a different browser or incognito mode to rule out cache-related issues.

 

I hope this helps. Let me know if you have any other questions.

Hello ​@JammerS , Thanks for your help and quick response! 

 

I did try duplicating the Zap and attempting again, same result, the selected worksheet disappears/deselects once I scroll down, so I can never get to the test stage of the step. I can include a video link if that helps?

https://drive.google.com/file/d/1lrK78qxF5T3W8LCL3iZYZgvfzsTrUBTy/view?usp=drive_link

 

Other things I tried, Remapping all dynamic sheets. Changing Trigger test input, clearing cache of Chrome, restarting PC, trying different browsers, tried Incognito mode, trying different PCs, reconnecting Google Sheets and Google Drive (both of which connections work great), checked permissions of the sheet/folder, Spreadsheet ID is mapped correctly and have tried many different ones. 

 

When I open another separate Zap to edit, the same thing occurs! 

 

The Lookup Spreadsheet Row and Rows functions we have been using for over a year and all has been great up until now. 

 

I will try ANYTHING! GETTING DESPERATE! Thank you again for your help!

Hi ​@James Paver Restore,

 

If your Google Sheets integration in Zapier deselects the worksheet when scrolling, it could be a bug or setup issue. Try using a different Google account, ensure all worksheets have visible content, and check for special characters in worksheet names. If the problem persists, contact Zapier Support for further assistance.

Hello ​@JammerS 

 

The issue has been resolved! Thank you so much for your help and attention to this matter. 

It was indeed a caching issue. I was logged in on three separate PC's and all three had to be cleared to resolve the issue. 

Now the function operates as intended. `

Thank you again!

That’s awesome news ​@James Paver Restore! We’re glad to hear that the issue is now resolved!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗

Terms & Conditions