Using Google Spreadsheets as an API in under 4 minutes!

[@JasonBoyce]

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

[@kyoteam8739]

The Sheets v3 API has been turned down.

[@rogerccaqp]

can record new entrys or update with this method?

[@stephen-dev]

Not sure if anyone else is having the same issue, but cannot seem to get it to work. Perhaps google changed the link format?

[@filipemarques3294]

i cant do it.

[@littlered55555]

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.

[@ryanpeterson7998]

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

[@clebhosh]

dude, you are a legend! I just tried it and everything worked..

[@moses5407]

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.

[@raphaeljones9747]

Follow up vid on basic CRUD operations makes sense (if available).

[@GarethSteedman]

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

[@alickzhang3721]

how is authentication handled?

[@Fellixify]

This is very cool, but it would be awesome if there could be a way to update the sheet with new data using javascript.

[@ben.1202]

Oh mate - legend! This is exactly what I've been trying to do. Cheers for the video!

[@rainthstrive]

Astonishing and simple. Thanks man

[@edisongaiborconde1483]

Bro, You can make a video passing the data from the spreadsheet to a table in html? Thanks bro

[@AbdullahAlSalem_abood]

what about post?

[@hafizhmahendra5105]

i have a question sir... when you convert the gsheet into JSON, can we make CRUD for this JSON that updates the sheets?

[@hossainabeer]

Hey, can the same procedure be followed to read data from Google Docs? if not, what's the right procedure?

[@anilpandit52]

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 -

[@cameosisj6007]

Thanks for sharing! Exactly what I'm looking for. Going to play around with it a bit now.

[@spicytopics7962]

I was tried the same but it doesnot give me any output says error only

[@paulntegeka7363]

how about searching by column content

[@tonmoitanvi1773]

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

[@miansaqlain8360]

yes bro

[@cashionsteven5695]

dumb question: how to i display the data from sheet for user to see instead of console log :)))

[@ignatiusmaziofa2393]

thanks bro. question, how can i do filtering with say a specific field

[@adamthedev]

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!

[@benedictomindajao6054]

does it works with dialogflow?

[@leandrobandres9856]

Very good....! Thaks... is posible add images in the JSON?

[@adamthedev]

You can add the url for the images and host the images elsewhere!

[@ollysalanson9452]

Can you perform POST requests this way?

[@hafizhmahendra5105]

i also want to know bout this

[@kayan_dev]

can we post data to edite ?

[@DJJuanCuba]

Amazing this is exactly what i was looking for ! Do you know how i could stock a specific cell text content in a var ?

[@Mariusz.opalka]

Where can I find the code?

[@farsfuad3002]

but this makes the gsheet public , that means anyone can see what's in it , there is another way of making an api

[@adamthedev]

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)

[@farsfuad3002]

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

[@farsfuad3002]

i really need to know about the confidential stuff xD

[@morganarnel4261]

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!

[@Gigabyteserviceofficial]

How to add authentication in it?

[@alexlytle089]

If I use multiple columns the data gets put all in one string.

[@TramitesNanos]

Thanks 🙏🙏🙏

[@dr-mnizam]

kzbin.info/www/bejne/e4XLkqiZeaeMbMk

[@vicentiubota8864]

what if I have multiple sheets in the same document?

[@vicentiubota8864]

Solution: feed->entry[...] contains all pages in your spreadsheet

[@adamthedev]

@@vicentiubota8864 Awesome!

[@jasongaretthatcher]

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?

[@ezequielcuirolo1928]

Im here just to looking for a comment talking about that. I dont know why suddendly stop working

[@zX3pLeELITEXz]

This does not work any more! Does anyone have any idea or alternative?... I have a project that really depends on my sheet

[@ezequielcuirolo1928]

Im here just to looking for a comment talking about that. I dont know why suddendly stop working

[@suchizgames4748]

is this still working today ?

[@romualdo_ah]

You are a genius!

[@11hamma]

Hello. Can someone tell how many such requests can I make in a day?

[@pfmbb6785]

Not working anymore, anyone got any ideas on how to replicate this functionality?

[@Ethan-dd4ln]

Very cool idea! Do you think this works with Microsoft Excel?

[@sheikhshuaib8451]

not working now why

[@Arctur17]

This API is deprecated

[@Actidle]

not work for me

[@rafarolsky7522]

Is it still working?

[@Arctur17]

No, this API is deprecated

[@qtech108]

thank you man

[@danceindia]

cool man :) no need to pay for airtable now

[@Harshalk]

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.

[@internetofthings4526]

I too got the same issue.

[@adamthedev]

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

[@adolfosandoval262]

This error is usually related to permissions on the sheet. Check to make sure it is public and shared.

[@DigitalMediaCanada]

@@adolfosandoval262 I'm getting the same error after making it public???

[@gkram8800]

Was it real-time 🤔

[@adamthedev]

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

[@g-57643]

Wow exclente, thak you

[@parthapaul4306]

not working btw

[@abilioscoelho]

Great

[@KawaiiLuckyGirl]

genius Are you trini?

[@adamthedev]

I'm Welsh, British haha

[@KawaiiLuckyGirl]

@@adamthedev crazy, parts of your accent sounds trini.

[@joaocarlossilvadeoliveiram723]

That's great. It's just a shame youd have to turn it into public.

[@jaydmatacarita]

I think google blocked this

[@supremaunus7100]

😧subbed