hey guys is it possible to scrape this data using gviz
i am really confused @TIMAI2
You have three options:
- Set the permissions of your google sheet to
Anyone with the link can view, then use this:
The next two options will require you create a google apps script web app, in order to be able to access your private google sheet from your google account
1 Like
its my schools link , i cant change the perms
why are you using your school's sheet?
to make a time table scraper app kinda
its public though
then i guess
not working
see , this dosent work 
nah , not working
then please make your question more clear
my question is that i followed this guide
but the url dosent work
then follow this ^
not working either
then wait for someone else to reply i cant help you
1 Like
If the google sheet is private, and is not owned by your own google account, then you will not be able to access the data therein.
I see you are trying to use a published url with gviz. Try this instead:
2 Likes
What makes you think that ?
How will that help to run a SELECT query? The base query to run is SELECT * which will return all data.
hehehehe