Google Sheets (Any sheet) data to Javascript using fetch | Simple & Fully explained

  Рет қаралды 23,648

Learn Programming

Learn Programming

Күн бұрын

Google Sheets (Any sheet) data to Javascript using fetch | Simple & Fully explained
Source code: github.com/raj...
Want to learn more? Send your video request here:
Discord: / discord
Twitter: / rami12_30_21_03

Пікірлер: 35
@TheRingmaster500
@TheRingmaster500 Жыл бұрын
Thank you so much, this is the only tutorial that i've found comprehensive and actually useful.
@tylerderdern9739
@tylerderdern9739 4 ай бұрын
Yeah , I agree this good tutorial
@gregoryam
@gregoryam 8 ай бұрын
Great Tutorial. Honestly, yeah, it is a bit longer than other tutorials. Because you took the time to explain more in depth, which is more helpful.
@Boxing.kid7
@Boxing.kid7 Жыл бұрын
downloaded files to test put console syays: from origin 'null' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource. If an opaque response serves your needs, set the request's mode to 'no-cors' to fetch the resource with CORS disabled.
@jacobsmith7877
@jacobsmith7877 Жыл бұрын
How did you solve this
@Boxing.kid7
@Boxing.kid7 Жыл бұрын
@@jacobsmith7877 I had to use google script instead. I will see if I can find the files still
@Boxing.kid7
@Boxing.kid7 Жыл бұрын
@@jacobsmith7877 drive.google.com/file/d/1W2JtUW1fesM8Eo7GBjvgeg72f8hqERhy/view?usp=drivesdk
@agustinsimiand400
@agustinsimiand400 Жыл бұрын
so you culd use the information in visual code finally doing this?@@Boxing.kid7
@HaroonRashid-xc6hd
@HaroonRashid-xc6hd 9 ай бұрын
Guide me please how to solve this error. i executed this code (image) granted access also , got an url.@@Boxing.kid7
@211gopishankarv5
@211gopishankarv5 10 ай бұрын
Thank you so much. It will very useful for my project ☺️...
@larrygoddamn
@larrygoddamn 11 ай бұрын
You are a lifesaver. Thanks.
@1thimiranda
@1thimiranda 4 ай бұрын
I was stuck... Thank you!!!!!
@AwaisDeveloper-tn2yh
@AwaisDeveloper-tn2yh 2 ай бұрын
it helped alot
@lavendercode
@lavendercode Жыл бұрын
AWESOME thank you for this video!
@gusinthecloud
@gusinthecloud Жыл бұрын
Excellent, you did it great!!
@hilariouscoder7203
@hilariouscoder7203 Жыл бұрын
its showing cors error
@learnprogramming4818
@learnprogramming4818 11 ай бұрын
I recently created a new channel so sorrry for late response, i am going to release a new version in the future.
@alirazajafri6092
@alirazajafri6092 5 ай бұрын
it helped me a lot, thanks..
@user-qr3jc7lt9o
@user-qr3jc7lt9o Жыл бұрын
Excelente explicação, era isso que eu procurava, obrigada!
@soumyatarafder7656
@soumyatarafder7656 Жыл бұрын
Machaya
@CodeServices
@CodeServices 7 ай бұрын
Thank you so much
@cassiocustodio
@cassiocustodio Жыл бұрын
That's nice! How about writing, editing or deleting data?
@learnprogramming4818
@learnprogramming4818 11 ай бұрын
Writing and deleting must happen through a form, this method only works to display data.
@ugo7272
@ugo7272 Жыл бұрын
Thanks man !!
@Upbeat_Impact
@Upbeat_Impact Жыл бұрын
Hi Sir, i am new to programming, and actually looking for a specific solution, of getting my google sheet data updated by fetching data from ERP software ( used in retail business ). How can this be done ? Kindly reflect
@learnprogramming4818
@learnprogramming4818 11 ай бұрын
Hi, i have not used ERP unfortunaly.
@bryankenttnoynoyan1150
@bryankenttnoynoyan1150 Жыл бұрын
Hi, I am getting error on CORS Something like below: --->>>from origin 'null' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource. If an opaque response serves your needs, set the request's mode to 'no-cors' to fetch the resource with CORS disabled.
@learnprogramming4818
@learnprogramming4818 11 ай бұрын
make sure the sheet is not restricted.
@danilafadeev
@danilafadeev Жыл бұрын
Hi. Thank you for the video. How can you access a closed table? This is my table, but I don't want to make it public.
@learnprogramming4818
@learnprogramming4818 11 ай бұрын
I dont think it is possible, what i would do is perhaps export the data and import them.
@isabellajessyl.cortes6316
@isabellajessyl.cortes6316 Жыл бұрын
Hello what do i do it seems that i need to refresh the website everytime i change the value of the cell
@learnprogramming4818
@learnprogramming4818 11 ай бұрын
You can use localstorage to save the items.
@carljay2177
@carljay2177 Жыл бұрын
how about remove, find, delete data in google sheets?
@learnprogramming4818
@learnprogramming4818 11 ай бұрын
It is possible through a form method, i do not recomend it tho. it is a fairly limited mehtod.
How to build a Contact Form in Node.js and Google Sheets?
37:02
Max Programming
Рет қаралды 6 М.
JavaScript магазин на Google Таблицах. Часть 1
24:43
WebDev с нуля. Канал Алекса Лущенко
Рет қаралды 29 М.
Minecraft Creeper Family is back! #minecraft #funny #memes
00:26
The CUTEST flower girl on YouTube (2019-2024)
00:10
Hungry FAM
Рет қаралды 49 МЛН
哈莉奎因怎么变骷髅了#小丑 #shorts
00:19
好人小丑
Рет қаралды 34 МЛН
АЗАРТНИК 4 |СЕЗОН 2 Серия
31:45
Inter Production
Рет қаралды 1 МЛН
Control Google Sheets with Node.js / JavaScript (v4 API)
25:51
James Grimshaw
Рет қаралды 121 М.
How to Use Google Sheets as a Simple CMS
10:12
Coding in Public
Рет қаралды 10 М.
Update for Sheets Data as JSON for Web API using JavaScript fetch
12:34
Fetch Google Sheet Data in Javascript (CSV, SQL)
14:54
code hobo
Рет қаралды 5 М.
Always Check for the Hidden API when Web Scraping
11:50
John Watson Rooney
Рет қаралды 627 М.
Google Sheets… Your Next Database?
7:16
Fireship
Рет қаралды 395 М.
JSON Data from Google Spreadsheet Setup and Shares on your Webpage
23:14
Google Sheets API - JavaScript NodeJS Tutorial
45:29
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 114 М.
Minecraft Creeper Family is back! #minecraft #funny #memes
00:26