Update for Sheets Data as JSON for Web API using JavaScript fetch
ฝัง
- เผยแพร่เมื่อ 16 มิ.ย. 2024
- Connect to Google Sheets using JavaScript Get data as JSON data
www.udemy.com/course/sheets-d...
Source Code
github.com/lsvekis/JavaScript... Course content web development and web design courses with coding examples and source code for the lesson content. Source Code is available within my Github account. Lessons posted are designed to help students learn more about a specific topic related to modern web development and applying code.
Laurence Svekis is a professional top selling course author having instructed over 1 Million students both online and in person. Laurence Svekis is a Google Developer Expert specializing in Google Workspace automation using Google Apps Script Code.
Check out my Website for more details at basescripts.com/
Awesome tutorial! Thank you very much! It was exactly what I needed for my job.
Glad it helped!
Thank you so much! This is exactly what I needed for a little prototype I am building. I took your short course on Udemy and it was super useful to have it both there an here on YT. I'm using it to display the results of a Google Form through a Google Sheet on a webpage.
If not unrelated, could you please recommend a quick way to display only one entry at time, for a short interval, followed/replaced by the next one?
You can use a setInteval function in JavaScript since its frontend code, making the AJAX request on the interval. Keep in mind you need to track the last item and then move to the next, if you a set amount of items you should AJAX and load the array into JavaScript then move between items in the array
Nice way what about change the data from the webpage to sheet and update the sheet and the page with the new data
Thanks for the video. Is it also possible to add new cells/rows? Or changing cells?
Yes you can!
@@LaurenceSvekisCourses Could you possibly do a video on this or give some quick pointers on how to change values in the spreadsheet with JS? I believe all your current videos on Sheets+JS only cover retrieving data, but not updating. Thank you so much for your help!
Hi, in the case you have two tabs in the same sheets, how can we access to each one. By default is only getting the first one. Thanks so much
You can set and get it using the sheet name if you have more than one sheet
Hi Svekis
I watched your course in udemy
while executing the code, it is showing the below error even after adding "gviz/tq?"
"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."
Can you please provide the solution
CORS is generally a coding error on the server side, you need to ensure the path is correct and returning data properly. Deconstruct the code until you get a response
Greate demonstration! Thank you. Okay so how can I add $ymbols to the numbers and keep my text content? (Cell.v) just gives me numbers as (cell.f) give me the numbers and the symbols but the text content goes undefined. 🤯🤷🏽♂️
Google does try to automatically convert the cell data type, you can set the type in the format of the sheet as well adding a space infront will keep it as string text content
aaaaa
Is there any CRUD implementation similar to this?
buenas noches alguna documentación para capacitarme
pls documentation
Can you please make a video using googlesheets as authentication login with email and password directly on node?
Or how to use query to search for a user.
Thanks.
I have many more course videos coming shortly.
hii, thanks ...this is very informative & helpful for me ..... but i have a query how we select any other sheet of same google sheet??
Yes, you can you can use as many sheets as needed, set the output using a webapp and construct the JSON data object from the sheets selecting them with their IDs
how to add user input in encodeuricomponent
Hi,
Thanks so much for the video
This is very informative. But, I’m getting a CORS error 😭
I’m using a sheet data to be displayed on my squarespace website
Could you please assist with this?
Thank you so very much!
CORS is either a script error or permissions.
thanks
You're welcome!
What about when ele is null? it goes good until it encounters a blank cell
Yes it would have null contents if its blank
Since V3 is sunset on august 2nd 2021, please show on how to generate Json url using new method i.e V4
Its not using V3 in the video its showing the new format for JSON data from a sheet
Is it possible to edit a Google Sheet using Javascript?
You can post to it but not really secure with JavaScript
@@LaurenceSvekisCourses Thanks. I found a way.
@@denizkarakas9888 what was the solution that you found?
please, may I know your way?
posible to post the same? If posible please make a video.
sorry I don't understand the question I post regular videos on this channel
sir please i req.. input type name & email then database google sheet and submit then redirect to another page there for anyone page but name or email and button that is form is encoded sir. so how to create sir please sir create to video sir please i request .. input type name and email then database google sheet and submit and then redirect to any other page for any page but email button is encoded sir. So how to make sir please sir create in video
check out this video it will show you how studio.th-cam.com/users/videoZPo4QW3QKfk/comments
aaaa
hello