Fetch Google Sheet Data in Javascript (CSV, SQL)

[@GrahamSteer-s3j]

Excellent video. Easy to understand but when trying to implement the code I continue to receive CORS errors - Cross-Origin Request Blocked. Reason: CORS header ‘Access-Control-Allow-Origin’ missing. How are you avoiding them?

[@BasGendt]

Change the fetch to: fetch(sheetURL, {mode: 'no-cors'})

[@cic_studios]

@@BasGendt @codehobo3675 I had the same error, used your fix and it's gone, now I am getting this error: Uncaught (in promise) SyntaxError: Unexpected end of JSON input at JSON.parse () at responseToObjects (getSheetData.js:15:27) at getSheetData.js:10:18 Any idea how to fix this?

[@indrasuyut1958]

Thank you, sir! It's worked for me ❤

[@Oxana191]

Thank you for the great content and clear explanation 👍

[@FromOliviaWithLove]

I'm cracking up at the noobs being dropped for step one. Immediate sub. Thank you!

[@rabbitgames1971]

This stuff absolutely confuses me. If I write all the code for the JS file, and then put the SRC link to it in my html/php document, how do I then use the data it's collecting from my Google Sheet? I understand that I can embed my sheet with an Iframe, but I'd like to actually do stuff with the data in a Table. For example, if a D&D character has a Strength of 18 in my Google Sheet, when that gets pulled to my website I'd like to have my Table on my website update the Cell next to it to show +5. (For example.) Can't do that with the function that basically just shows a "live" screenshot.

[@PhatNguyen-sb5fo]

thnak you very much for this knowledge

[@wilmercamas966]

Gracias amigo

[@richarddelaltre8804]

Much better if there is a CRUD on this.

[@sergiorodolforomeroq.7727]

Gracias me sirvio

[@jai-h3v]

Uncaught Error: CSVDataError: Illegal quote [Row:2] i am facing this error on my console .....and when i run this code it will return plain text.The text is /*O_o*/ google.visualization.Query.setResponse........etc so do you have solution of this error