Google Sheets API - Read and Write Data

[@ackreik6334]

is there a git repo? i want to look into the code (analyze it) so i can understand what's going on better

[@kunalvirk]

What will be the function for Save button, I am not able to make it work i.e. the data is not saving back to sheet..Thanks for the video, Cheers!!!

[@Mr_MadZac]

Is possible to only show the first 3 columns form my sheet wich have 30-40 columns? and also, is possible to create a filter in the div table so i can only see the rows with certain values? because my sheet have like +400 rows

[@tonmoitanvi1773]

Hello Anthony, the way you showed to turning google sheets into API, is a very lengthy process. i am using an API tool of Sheet Best , which is easy to connect and edit.

[@jigneshrana7326]

can you please share your sample code on git or somewhere?

[@mpickard9]

I loved your first two videos because you took your time and explained things in detail. And with the stuff you posted on Github, I have the "Google technique" for access the Sheet working (instead of using Tabletop). My HTML form is done and works, and now all I need is to do a batch update of a particular row of the Sheet. Unfortunately, your explanation at the end of this video was way too fast with no demonstration, just some verbal references about it was pretty simple. Except I depend on your videos to understand because it isn't all that simple for me. I need your step-by-step with accompanying show and tell. Could you do a short video that presumes reading is up and running and demonstrate the batch update feature? Thanks.

[@mariavillanueva9576]

How do you implement a workaround for 'too many request' with error code 429 aside from upgrading the account?

[@normhoward4408]

Hello my spread sheet stock list does not respond all time but my API that call back let me log back for how long draws question.For short project see that takes more time for beginner programming P N P return impacted id unsure what table.Set up AP for chrome low tension range at about 220 horizontal 55i right but visible. Time in response AP request ^ thinking again 003; phone 1 ,2 Te-ken. Also for beginner hard to adjust stock setting for like back ground color and none transparent on copy transfer page.So my continuance to none cluster cell shows standard would that be A -Z?

[@koaykh]

You missed out on the save button and codes associated with it, it was not explained in your video. Also, the SCOPE should be changed to 'www.googleapis.com/auth/spreadsheets'

[@prosecutorgodot519]

The code is impossible to read in your video. Is it available somewhere else?

[@MaxDrake]

Hi Anthony, Love your videos, I have the same issue as others below. What is the function for the save button? I have tried Save (also tried it with only 1 = sign) neither worked. I cannot get the data in the sheets to update. I get the populateSheet to bring the data in to the web page but cannot send it back. In your video you never quite scroll down to the buttons section in index.php (you do on the original index2.php). I would really appreciate some guidance. Thankyou, kind regards Max

[@MaxDrake]

This is a cut/paste of my code: At the bottom: I added a button SAVE with a call to a function function handleSaveClick() that calls the makeApiCall(action="write"); and that seems to work. I hope this helps others, function makeApiCall(action="read") { var ssId = 'xxx; var rng = 'Sheet1'; // Writing to sheet if(action=="write"){ var vals = new Array(6); for (var row= 0; row

[@pablodiaz1811]

Actually, It helps me. Thanks for think in others.

[@anonymouspeh6803]

@Max Drake, Thank you so much!

[@zaheerabbasaghani7593]

How can i display list of sheets or get list of sheet ids to display content dynamic ?

[@AnthonyBrunson]

developers.google.com/sheets/api/samples/sheet#determine_sheet_id_and_other_properties

[@shankarmanchal8621]

instead of for loop can we use foreach loop @anthony

[@mpickard9]

I'm going to build an HTML page that reads a Google Sheet for the purpose of searching it for relevant records/rows and displaying only those. However, I anticipate that I'll be asked to provide an update function at a later date. Could you do a video where not all of the sheet's data is displayed, and how you'd approach updating a particular record/row using Batch update?

[@AnthonyBrunson]

kzbin.info/www/bejne/fpOzlH2jqd6Co9U Better late than never

[@mpickard9]

Sorry to bother you. I've implemented write functionality after using the TRY IT at Google with successful results to be sure the call was structured properly. But my Javascript code gets "error: A network error occurred, and the request could not be completed" which doesn't seem to be associated with the format of my Google API call. I have no clue how to debug this, and I haven't found anyone who solved this. Do you have an approach for debugging this kind of error? Thanks.

[@mpickard9]

By the way, I get the same error with Insert, if that helps.

[@mpickard9]

I never solved the 'network error' problem, but that doesn't matter because IT WORKS! I can now read the entire sheet and then selectively update a row at a time, insert new rows and even do partial update when necessary (using null padding). Thank you so much for getting me started. The set-up with keys and 0Auth were invaluable, and introducing me to the Try It feature provided an opportunity to test out my Google API calls before making them real in my code. I almost feel like making my own video about how I used yours as a launching pad to go further, except I have more programming to do. Thanks again.

[@Cutiepie-ky9oh]

Hello Anthony, thank you for your tutorial.

[@pablodiaz1811]

Thanks for all

[@gustoledano111]

The "save" button is not... Please help!

[@mosalahlorsanov318]

did you solve it?

[@mohamedelmancy1136]

where is the full code of part 3

[@vilaspakhale4097]

Thanks Anthony... Its gonna help me very much

[@gcho91]

Hi Anthony, is there a way to sort the data coming back? For example, I'm using a sheets doc as API with things like Name, Birthday, Birthplace, etc. I want to sort Name by Ascending and Descending and display it on the front end while giving users the options to select which one they want. How should I approach this?

[@AnthonyBrunson]

Yes you can. Are you using appscript as the backend or are you displaying it on a website?

[@gcho91]

AH I found the parameter request doc in the v3 docs NOT v4. Looks like they disabled sort in v4 though... I am trying to display the individual items in the front end and give users the ability to sort. Theoretically I could do different requests with param ? ascending and or descending I think

[@thabangmadisa9417]

Hi Anthony. Can this be done in Azure.

[@JaeTask]

Brilliant, thanks Anthony

[@swist666]

There is also a solution called sheetdb.io - it is much easier to setup. You make a request to API and in response you get json data from spreadsheet.

[@tahabera891]

Can somebody send source code?

[@manbowkornwalis3604]

why'd you disappear man?

[@AnthonyBrunson]

Chris Bowman I'm still here. I'll be putting out a video tonight. Be looking out for it. Is there anything specific you would be interested in learning about?

[@manbowkornwalis3604]

Anthony Brunson i don't mean the video i mean i know you when you lived in oklahoma

[@AnthonyBrunson]

Chris Bowman gotcha. Yeah injuries man. I definitely miss it though.

[@manbowkornwalis3604]

Anthony Brunson i feel yah man. hope you're doing good in life brotha.

[@viniciusnoyoutube]

Very good!