Fetch Google Sheet Data in Javascript (CSV, SQL)

Get data from a google sheet with Javascript. video contains 3 methods. The last method (SQL) is the most flexible and has the best parsing if you ask me, just skip right to that shit.

CODE:

Get entire google sheet in CSV format (with jQuery)

Get entire google sheet in CSV format (plain JS)

Use SQL query to SELECT sheet data

0:00 What is this?
1:00 Get sheet in CSV format with jQuery
3:41 Get sheet in CSV format with plain JS
6:36 Use SQL query to SELECT sheet data

[GrahamSteer-sj]

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?

[indrasuyut]

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

[Oxana]

Thank you for the great content and clear explanation 👍

[rabbitgames]

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 iframe function that basically just shows a "live" screenshot.

[FromOliviaWithLove]

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

[jai-hv]

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

[PhatNguyen-sbfo]

thnak you very much for this knowledge

[richarddelaltre]

Much better if there is a CRUD on this.