Use a google sheet as your web app database (Slingcode) 

Thanks for the shoutout Chris! Great way to make a quick website with dynamic data that you can fill in with a google sheet.

Your method is so much more efficient for read-only!

It worked. Beautiful! Now gotta figure out how to post.

Thank you, Chris! from the bottom of my heart for creating such an exceptional learning video. Your expertise and dedication have made a significant difference in my understanding and overall learning experience. I eagerly look forward to exploring more of your content and continuing my educational journey with your guidance. Thanks again.

THIS IS A LIFESAVER! LOVE IT!

Thank you very much for making something so simple and yet useful.

it’s a funny way of doing this. looks like a cool hack to avoid the process of requesting credentials, setting up auth, writing some backend code to serve it all, etc. yes, you can’t modify the data this way, but you may not need to.

Thank you for this video, very informative

Thank you very much, it's a great video

thank you so much sir. best.

if you want to perform CRUD action with this google sheet database then you would need to write some function at google sheet apps script side too. and in that case this won't gonna help. although nice tutorial

Thank you!

This is great. I am looking to create knowledge base. Can I add a search feature on the front end linking to the google sheets database?

This is so useful. Thank you so much.

Hi this is great! You solve me a problem that tooka me more than 3 hours te resolve!. Any idea how i can select/print a specific cell with this method? Thanks!

Great video, thank you! Is it possible to switch between different tabs in the google sheet using this method?

Thank you sir. Can you add search box, so when I write "sword" in search box its only display Sword description and price? Hope for next tutorial🙏

Can you read and write via the Web App to Google sheets?

thanks ! it is useful ... at my job they based the company computer logistic on googlesheet. they are getting bigger and they need a proper ERP. BTW question : what if we have multiples sheets in a csv ?

When I move the script code in script.js file and provide the src in script tag in html the code doesn't load table data, However when the same code is run in one single html page it works properly, any idea why it's not working or suggestions how to make it work

how to fetch google sheet data to github hosted website? i am facing cross origin problem

i'm facing this error, kindly give me solution if you have? 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.

Gracias por este gran aporte! Solo que estamos trabados en como colocar un filtro o un search Box de los datos que traemoa de gsheets, muchas gracias!!

Hello from India.. superb tutorial...easy to understand..very helpful... is it possible to write data back to sheet as well? If so kindly show us the way. Highly appreciated.

Its good . now also tell us how to change values from database.

Thanks, do you know is it possible to export Google sheets table directly to some mysql table?

Thanks for this great video and explanation. Can you suggest a way to do exactly this without using the "fetch" command? Unfortunately my hosting provider does not allow fetch.

i followed your code to a T, but when i get to the first step where it dumps the cell data into the page (7:05), nothing happens on my page. no data. Sheet is public, sheet link is correct, quadruple checked all the code... no idea why, but mine isn't pulling date into the html...

Sir, how can i write, edit, delete google sheet rows and cells using this tricks.

Great video! Thank you, Chris! I'm trying to add a css to create different "cards" for each row data (I'm also trying to add buttons). But when I tryied, the CSS was applyied just once to all the data in the page. I tryied to create a div, but when I do this, I only receive the data from the 1st row. Exist another workaround to create those tipes of "cards"? What I did: csv.forEach(function(row) { main.classList.add('card'); div= main.innerHTML += row.Title + "" + row.Date + "" + row.Tag;

Thank you this great video sir. But, can you please do it with a dropdown choices? Thank you.

Thank you, sir. Do you know how to address the other sheet if there are multiple sheets in the document?

can you share the code to search please, thank you very much

Could you please help? I need to know how to transfer data from google sheet to g-suit admin directory by using submit button for example! or when I submit a google form, the google form inputs go automatically to g-suit admin directory! I hope that I explained what I want correctly, please advise, thanks.

Hi admin ! THis code do not work with Browser Usage from 10'39 I did exactily like you How to fix??? Please

very nice and everything but it did not work for me, difficult to put together the library as you are.

Can you suggest how to automatically update data on web page as soon as there is some updation on excel sheet. As refreshing the page again and again is not a good option nor is setInterval or timeout function. Kindly reply ASAP, a bit urgent

Doesnt seem to work now.

Can someone please tell me what did i do wrong?

You mean a static single page *website*. You know, the bit with the html extension.

Subswibed