Google Sheets API - Read Data - Part 1

[@amysemanek8326]

OMG! Thank you so much. I learned more here in 10 minutes than I did in the last 3 days reading stuff online

[@ericwillis1326]

Thank you for this concise tutorial! Looking forward to part 2!

[@jameslee8997]

Awesome!!! You made it so easier to get started. Thank you.

[@trevinhaseltine3029]

Thank you!!! Saved me a ton of time

[@carlosalbertocm]

Hello, thanks for your tutorial, excuse me for my english, I want to make a web application in which you are going to consult some spreadsheets in google drive, how can I do this without needing to ask me to log in?

[@taewoongyoon1268]

THank you for tutorial!

[@No_Direct_Translation]

Awesome Tutorial

[@FlightSimMuseum]

Fantastic tutorial - very clear and easy to follow!

[@tonmoitanvi1773]

I have been roaming on youtube to find some API tools that turn google sheets into API, then I found you again. though I haven't found better Than Sheet Best yet. do you have any suggestions buddy?

[@ibrahimbek2804]

Thank you

[@mariavillanueva9576]

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

[@ProCodeLife]

why it doesn't work if not make copy?

[@YABEEful]

hello Anthony. Thanks a lot for this informative video..! I want to pull a specific set of data from my local excel file to google sheets through google api. could you please provide some help on this.

[@projavadevelopers]

Can I call google API from POSTMAN ? If yes how? I'm developing web App on a local server so I don't have URL or domain for it.

[@bear99ky]

thank you so much, Anthony. Will you explain how to select certain data to display from the google sheet using this API approach? thank you again!

[@AnthonyBrunson]

kzbin.info/www/bejne/fpOzlH2jqd6Co9U

[@colinjones5699]

2 Great videos so far - looking forward to the rest! One question - I am new to Google sheets and I want to set up a db that will allow users to add data - should be no problem! - but I also want them to be able to change their added info at a later date, if necessary. Is this done through the API you describe or through the Ui - or maybe a combination of both? Thanks.

[@AnthonyBrunson]

Hi Colin. In this video we covered testing the connection in the Google API explorer. In order to test pushing data back to the sheet, you can do the same thing as we did here to test. Actual implementation will be close to the same as the next video. The main difference is instead of using a "get" we will use an "update" or "append". I'll be posting the how to for that here shortly.

[@AnthonyBrunson]

kzbin.info/www/bejne/eXiVepikab1leKs

[@thangtranuc8421]

Thanks bro. Now i want to create client id with localhost. Can you help me.

[@noob4reel]

Thank you Anthony!

[@dilChahta_hai]

is there any tutorial on how to submit form using react native to google sheet ? how i can use this tutorial for react native?

[@jameslee8997]

Are you available for hire to work on a project?

[@SunggukLim]

Nice video. some of UI on google console have been changed. though.

[@paulloup5210]

Thank you very much for the video very useful suscribed!!!

[@dr-mnizam]

kzbin.info/www/bejne/e4XLkqiZeaeMbMk

[@sanyamjaincs1]

thanks for github repo

[@mpickard9]

I get the following error: Unable to post message to file://. Recipient has origin null. What is this? I copied and modified the code just as you instructed.

[@mpickard9]

By the way, the Google Sheet API test was successful, so I know all of my IDs and KEYs are okay.

[@AnthonyBrunson]

hard to say without seeing the code or when this is happening. First thought is you may want to check your spreadsheet ID (ensure there are no spaces also). but I'd need more info if that's not it.

[@mpickard9]

Since the Google Sheets API "Try it" worked perfectly, something in the Javascript code is attempting to post a message to a null file. I don't understand the sample code we copied well enough to identify anything that looks like a POST. Since I was running from my client computer, I also tested running from a server. 2 errors: (1) [Error] The source list for Content Security Policy directive 'script-src' contains an invalid source: ''strict-dynamic''. It will be ignored. (2) [object Object] which expanded to (anonymous function) __ cb=gapi.loaded_0:104. I'd be happy to send you the code if you're willing.

[@AnthonyBrunson]

I posted the code to github. check the description and let me know if you're unable to access it. good luck!

[@mpickard9]

Using your code, I got (1) the same error: The source list for Content Security Policy directive 'script-src' contains an invalid source: ''strict-dynamic''. It will be ignored., but (2) I got the data! Thanks so much! Have any idea what the error means?

[@josefz]

Can this be set up to run on my local server (e.g. XAMPP) with no domain name?

[@AnthonyBrunson]

Yes it can

[@Hari-ge2sc]

@@AnthonyBrunson how? what to be given in Authorized JS origin and Authorized redirect URIs?

[@liamcarr1288]

Thanks

[@cedroid]

Can you please tell me how to configure the JavaScript origin if my website is hosted on google sites? Is part of my work group. Thank you in advance

[@NitinJaine]

Somehow it is not working for me in my react native app. Thanks for this video.

[@mpickard9]

I learned a lot of things by trial and error getting the code to work. (1) I couldn't run it on my client computer. I had to store the code on a server and run it through a browser or it failed. (2) My sheet is sparse (not every cell is filled in). For those rows that have empty cells at the end, I don't get anything past the last filled cell. In sokme cases, of 17 cells, I'll get 1 thru 12 and then nothing else for that row. If there are cells in between that are empty, I receive a null value.