How to download google sheet by public link

[Sadgira]

I know how to use google sheets with API credentials.

I need to work with sheet only accessible by public share link.

Tryed to scrape it but no success.

Anyone can share his experience?

Thanks

[ramin1]

use the google sheet node as usual but select document By Url and paste your public sheet url

[Sadgira]

it doesnt work

I tryed this in first attempt as obvious decission

[ramin1]

what happened? i tested it and worked

[Sadgira]

**The provided authorization grant (e.g., authorization code, resource owner credentials) or refresh token is invalid, expired, revoked, does not match the redirection URI used in the authorization request, or was issued to another client.**

sheet from another google account and I cant get API creds for it

I tryed google the solution of my problem but cant find any advice…

[ramin1]

the error that you provided is telling that is something is wrong with your OAuth.

if you can not access a sheet you will get a 403 - Forbidden

[Sadgira]

Thanks u are right, somehow it became broken and aftrer reconnect it works again.