Thanks for this video, I’ve used this for a couple of different friends who needed a super basic web “application” they could manage from a spreadsheet, and it’s been great to just make this in 20 minutes and hand it over to them
Sheets Get and POST without Google apps script and it's throttling limits? Is that correct? if so, WOW! If you have a chance to LMK that would be appreciated. Also, it seems no separate auth is required beyond the usual share access to the sheet. via Google sheets Is that correct? If so, how is access protected to prevent data corruption by anyone with the public link? In any case, thanks for the clear and simple method/explanation.
OK, i'm trying to learn how to do API calls from Google Sheets to Google "Distance Matrix API" and back to my google sheets document i use for truck dispatching. Im trying to calculate the distance and time. Can you please start a new series for the beginners showing us how to get started (clear back to Google Console for Developers and move us forward?) i have a site/video from here that gave me the code to copy and paste into script editor but i dont know what i need to do before that. PLEASE ANY HELP YOU CAN PROVIDE WOULD BE AWESOME! YOUR VIDEOS ARE SUPER INFORMATIVE
Ive been trying this but when I add my spreadsheet ID in, it opens the code page but its not editable... Any suggestions? Everything is there as in your video but cant do anything with it
Sounds great and pretty close to what I was looking for... but I am unable to take it further. Do you think you can make a video on CREATING an EXCEL LIKE DATA ENTRY FORM with this technique used in PHP or Flutter Web? Thanks and Regards -
You can just use basic javascript functions such as filter: alligator.io/js/filter-array-method/ to filter the object and return specific ids. There'll be plenty of vids on YT showing how to do this!
Great video however it is worth noting that this shouldn't be used with Sheets that contain personal or commercially sensitive data as the data is publicly available. Brilliant for many other use cases though, thanks!
Fars Fuad yes, you’re correct! This should be used as a nicer way of showing public-accessible data and shouldn’t have any confidential stuff (that applies to any public api)
there is a way , using both "gsheet flutter package" and "google sheet api" if you could make a video of them and how to use it , i will be very thankful here is the links : gsheet package: pub.dev/packages/gsheets#-example-tab- How to get api from google sheet : medium.com/@a.marenkov/how-to-get-credentials-for-google-sheets-456b7e88c430
Doesn't work , I followed steps, have correctly published it to web. but getting this error Sorry, unable to open the file at this time. Please check the address and try again.
You must be missing a step, as it works with everyone else. Try opening in a new browser and re-run through all the steps again, double check that you're using the correct ID to open up the json
Once data is entered into the spreadsheet it becomes instantly available via the api request (no delay). You would need to trigger the request again to pull in the new data, but could do this easily enough
The Sheets v3 API has been turned down.
Thanks for this video, I’ve used this for a couple of different friends who needed a super basic web “application” they could manage from a spreadsheet, and it’s been great to just make this in 20 minutes and hand it over to them
Not sure if anyone else is having the same issue, but cannot seem to get it to work. Perhaps google changed the link format?
i cant do it.
can record new entrys or update with this method?
Cool idea man, I just started a bootcamp and barely understand the syntax but keep up the videos. I need more ideas to understand what is capable.
Sheets Get and POST without Google apps script and it's throttling limits? Is that correct? if so, WOW!
If you have a chance to LMK that would be appreciated.
Also, it seems no separate auth is required beyond the usual share access to the sheet. via Google sheets Is that correct? If so, how is access protected to prevent data corruption by anyone with the public link?
In any case, thanks for the clear and simple method/explanation.
Follow up vid on basic CRUD operations makes sense (if available).
OK, i'm trying to learn how to do API calls from Google Sheets to Google "Distance Matrix API" and back to my google sheets document i use for truck dispatching. Im trying to calculate the distance and time. Can you please start a new series for the beginners showing us how to get started (clear back to Google Console for Developers and move us forward?) i have a site/video from here that gave me the code to copy and paste into script editor but i dont know what i need to do before that. PLEASE ANY HELP YOU CAN PROVIDE WOULD BE AWESOME! YOUR VIDEOS ARE SUPER INFORMATIVE
how is authentication handled?
This is very cool, but it would be awesome if there could be a way to update the sheet with new data using javascript.
what about post?
Bro, You can make a video passing the data from the spreadsheet to a table in html? Thanks bro
dude, you are a legend! I just tried it and everything worked..
Astonishing and simple. Thanks man
Ive been trying this but when I add my spreadsheet ID in, it opens the code page but its not editable... Any suggestions? Everything is there as in your video but cant do anything with it
Hey, can the same procedure be followed to read data from Google Docs? if not, what's the right procedure?
Sounds great and pretty close to what I was looking for... but I am unable to take it further. Do you think you can make a video on CREATING an EXCEL LIKE DATA ENTRY FORM with this technique used in PHP or Flutter Web?
Thanks and
Regards -
Thanks for sharing! Exactly what I'm looking for. Going to play around with it a bit now.
Very good....! Thaks... is posible add images in the JSON?
You can add the url for the images and host the images elsewhere!
Amazing this is exactly what i was looking for ! Do you know how i could stock a specific cell text content in a var ?
Oh mate - legend! This is exactly what I've been trying to do. Cheers for the video!
Hi dev101! thanks for this video. it's really simple to use. though I have been using an API tool of sheet best for years & I am used to using it
yes bro
does it works with dialogflow?
I was tried the same but it doesnot give me any output says error only
i have a question sir... when you convert the gsheet into JSON, can we make CRUD for this JSON that updates the sheets?
how about searching by column content
thanks bro. question, how can i do filtering with say a specific field
You can just use basic javascript functions such as filter: alligator.io/js/filter-array-method/ to filter the object and return specific ids. There'll be plenty of vids on YT showing how to do this!
Thanks 🙏🙏🙏
th-cam.com/video/EThaucDBY6g/w-d-xo.html
Great video however it is worth noting that this shouldn't be used with Sheets that contain personal or commercially sensitive data as the data is publicly available. Brilliant for many other use cases though, thanks!
can we post data to edite ?
Can you perform POST requests this way?
i also want to know bout this
but this makes the gsheet public , that means anyone can see what's in it ,
there is another way of making an api
Fars Fuad yes, you’re correct! This should be used as a nicer way of showing public-accessible data and shouldn’t have any confidential stuff (that applies to any public api)
there is a way , using both "gsheet flutter package" and "google sheet api"
if you could make a video of them and how to use it , i will be very thankful
here is the links :
gsheet package:
pub.dev/packages/gsheets#-example-tab-
How to get api from google sheet :
medium.com/@a.marenkov/how-to-get-credentials-for-google-sheets-456b7e88c430
i really need to know about the confidential stuff xD
dumb question: how to i display the data from sheet for user to see instead of console log :)))
what if I have multiple sheets in the same document?
Solution: feed->entry[...] contains all pages in your spreadsheet
@@vicentiubota8864 Awesome!
Where can I find the code?
If I use multiple columns the data gets put all in one string.
How to add authentication in it?
is this still working today ?
This does not work any more! Does anyone have any idea or alternative?... I have a project that really depends on my sheet
Im here just to looking for a comment talking about that. I dont know why suddendly stop working
It works for me except about 50% of the time it gives me a 404. I can’t figure out why it works sometimes and not others. Any idea?
Im here just to looking for a comment talking about that. I dont know why suddendly stop working
not work for me
You are a genius!
Is it still working?
No, this API is deprecated
Very cool idea! Do you think this works with Microsoft Excel?
thank you man
Not working anymore, anyone got any ideas on how to replicate this functionality?
not working now why
This API is deprecated
cool man :) no need to pay for airtable now
Hello. Can someone tell how many such requests can I make in a day?
Doesn't work , I followed steps, have correctly published it to web. but getting this error
Sorry, unable to open the file at this time.
Please check the address and try again.
I too got the same issue.
You must be missing a step, as it works with everyone else. Try opening in a new browser and re-run through all the steps again, double check that you're using the correct ID to open up the json
This error is usually related to permissions on the sheet. Check to make sure it is public and shared.
@@adolfosandoval262 I'm getting the same error after making it public???
Wow exclente, thak you
Was it real-time 🤔
Once data is entered into the spreadsheet it becomes instantly available via the api request (no delay). You would need to trigger the request again to pull in the new data, but could do this easily enough
not working btw
Great
genius
Are you trini?
I'm Welsh, British haha
@@adamthedev crazy, parts of your accent sounds trini.
That's great. It's just a shame youd have to turn it into public.
😧subbed
I think google blocked this