Google Sheets Reader - Unable to Load Data for Sheet Name

[Ariel]

I’ve tried reauthenticating, I tried creating this in a new workflow (same error). I have column header names.

Tried everything Gummy suggested for trouble shooting - what’s wrong here?

[Gumloop_Bot]

Hey @Ariel! If you’re reporting an issue with a flow or an error in a run, please include the run link and make sure it’s shareable so we can take a look.

1. Find your run link on the history page. Format: https://www.gumloop.com/pipeline?run_id={{your_run_id}}&workbook_id={{workbook_id}}

2. Make it shareable by clicking “Share” → ‘Anyone with the link can view’ in the top-left corner of the flow screen.
   

3. Provide details about the issue—more context helps us troubleshoot faster.

You can find your run history here: https://www.gumloop.com/history

[Wasay-Gumloop]

Hey @Ariel – By any chance is this a .xlsx file? If so, it would need to be saved as Google Sheet first and then you’d have to use that link.

If it is not that, do you mind sharing the Google Sheet with me please (wasay@gumloop.com) or trying to use the Use Link option on the node instead of the Drive file picker?

[Ariel]

Hi Wasay,

Yes, it is a google sheet - here is the link.

I tried using the ‘Use Link’ option and got this error.

I’ve logged in and out as well - still getting the same error.

Thanks,
Ariel

[Wasay-Gumloop]

Hey @Ariel – Thank you you for sharing this sheet! From your screenshot I can see that no link is added in the input field on the Google Sheet Reader node. Once you add that, it should work as expected. I just tested that on my end. If you want, you can clone the workflow below

https://www.gumloop.com/pipeline?workbook_id=rSMDCpbqJDcEP8iPnrpw9o

[Ariel]

Hi there,

Yes. Sorry I did insert the link and it is still not working as you show in your screenshot.

I also don’t see the option to clone your workflow on my end - how would I add this to my existing workflow and subflow - I just gave you access here.

Thanks,
Ariel

[Wasay-Gumloop]

Hey @Ariel – Can you make sure both your Drive and Google Sheet credentials match here: Gumloop | Credentials?

Also, where is the first screenshot from? It looks like the node is configured properly in that screenshot and that flow is already saved/cloned on your end.

If you’re still having trouble would you be able to hop on a quick call to troubleshoot? https://cal.com/wasay-ahmed/15min

[Ariel]

Hi @wasay@gumloop.com - I booked time for Monday. Yes, my credentials are correct and I have re-authenticated multiple times.

I was able to clone and save the node you created, but now need assistance integrating it into my workflow/subflow so I don’t have to rebuild everything in that new workflow (unless that is the only option).

Talk soon,
Ariel

[Wasay-Gumloop]

Sounds good and you won’t have to recreate anything, don’t worry!