- 12
- 59 746
Hemendra Velisetty
India
เข้าร่วมเมื่อ 25 พ.ย. 2018
Hey!! How are you doing? I am Hemendra a self-taught Full-stack web and mobile developer who loves to teach.
I always love to explore new technologies and share them with you here. You can find a lot of amazing content on Programming, Data structure and Algorithms, System Design, Micro Services, Operating Systems, DBMS, Networking, Data Science, Machine Learning, Artificial intelligence, BlockChain, Interview Tips, and a lot more.
Please do subscribe to my channel and support me. Your support motivates and encourages me to create a lot of useful content. Thanks for checking this out.
I always love to explore new technologies and share them with you here. You can find a lot of amazing content on Programming, Data structure and Algorithms, System Design, Micro Services, Operating Systems, DBMS, Networking, Data Science, Machine Learning, Artificial intelligence, BlockChain, Interview Tips, and a lot more.
Please do subscribe to my channel and support me. Your support motivates and encourages me to create a lot of useful content. Thanks for checking this out.
Add data to Google Sheet using App Script || Hemendra
Here is a tutorial for creating an API in Google Sheets for adding data using APPSCRIPT. If you like it, share the video.
Create API From GOOGLE SHEET
th-cam.com/video/WwECTqK6oY4/w-d-xo.html
What is JSON ?
th-cam.com/video/KGByhnih5Uc/w-d-xo.html
What is a REST Api?
th-cam.com/video/nphnyalBd64/w-d-xo.html
Linkedin: www.linkedin.com/in/hemendra-sundhar-kumar-velisetty-828a48103/
Wallpaper: imgur.com/a/FYHfk
Create API From GOOGLE SHEET
th-cam.com/video/WwECTqK6oY4/w-d-xo.html
What is JSON ?
th-cam.com/video/KGByhnih5Uc/w-d-xo.html
What is a REST Api?
th-cam.com/video/nphnyalBd64/w-d-xo.html
Linkedin: www.linkedin.com/in/hemendra-sundhar-kumar-velisetty-828a48103/
Wallpaper: imgur.com/a/FYHfk
มุมมอง: 31 427
วีดีโอ
Create API From GOOGLE SHEET || HEMENDRA
มุมมอง 23K3 ปีที่แล้ว
In this video I have explained about creating a REST APi from Google Sheet. What is REST API : th-cam.com/video/nphnyalBd64/w-d-xo.html What is JSON : th-cam.com/video/KGByhnih5Uc/w-d-xo.html Please subscribe to my channel.
Introduction to Arrays|| Java Arrays By Hemendra
มุมมอง 1794 ปีที่แล้ว
Hi I have explained about the following topics in this video 1. What are arrays 2. How to create Arrays in java 3. Different ways of initialization of an Array 4. How to Insert and fetch values into array etc. If you like this video about java Arrays please share this video and subscribe to my channel. For online Training: algorithmtraining.com/ Java Arrays Arrays in java introduction to java a...
Android Project Structure || Android Tutorials In Telugu || Applied Android
มุมมอง 9084 ปีที่แล้ว
In this video, I have explained about Android Project Structure . Please check it out and share your feedback. Android Tutorials Android Tutorials in Telugu Android Studio Tutorials Android Studio Tutorials by Applied Android. Android Application Development Tutorials by Applied Android. Android Tutorials by Hemendra Kotlin Tutorials by Hemendra Java Tutorials By Hemendra
What is JSON ?
มุมมอง 2.1K4 ปีที่แล้ว
Hi friends i have explained about JSON in this video please like and share with your friends. what is JSON JSON:- .............. JavaScript Object Notation is an open-standard file format or data interchange format that uses human-readable text to transmit data objects consisting of attribute-value pairs and array data types. JSON (JavaScript Object Notation) is a lightweight data-interchange f...
AdMob Android tutorial - Placing Banner Ads|Earn money from Admob
มุมมอง 2935 ปีที่แล้ว
HI friends in this video i have explained how to integrate banner ads into android app. admob bannerads android android app development integrating banner ads into android app
Open or Clone Github Project in Android Studio | How to open Github Source Code in Android Studio
มุมมอง 4065 ปีที่แล้ว
In this video i have explained how to clone or open project from github in android studio. android androidstudio github version control Applied Android
What is a REST Api?
มุมมอง 9735 ปีที่แล้ว
Hi friends in this video i have explained about Rest Api. for more info: WebSite : www.appliedandroid.com/ Intro Music: Track: Elektronomia - Sky High [NCS Release] Music provided by NoCopyrightSounds. Watch: th-cam.com/video/TW9d8vYrVFQ/w-d-xo.html Free Download / Stream: ncs.io/skyhigh
#3 Kotlin Hello World Program || Writing first program in Kotlin || intellij IDEA
มุมมอง 1395 ปีที่แล้ว
hi friends, kotlin is open source object oriented language developed by “JetBrains”. so in this video i have discussed abut how to write hello world program in kotlin and some syntactical difference of java and kotlin. Settting up intellij IDEA:- th-cam.com/video/fR0pZ4pd_50/w-d-xo.html for more info:- www.appliedandroid.com/ Intro Music: Track: Elektronomia - Sky High [NCS Release] Music provi...
#2. kotlin setup on windows || installing Intellij IDEA || Kotlin tutorials for Beginners
มุมมอง 855 ปีที่แล้ว
hi friends in this video i explained how to set up all the softwares that are required to in developing kotlin applications. as kotlin is a JVM based language you need JDK installed in your machine.and you need Intellij IDEA for writing kotlin programs it is the official IDE for developing and writing kotlin programs. thank you friend for watching this video. Please subscribe to my channel. for...
#1 Introduction to kotlin || Features of Kotlin || Kotlin Tutorials For Beginners
มุมมอง 2285 ปีที่แล้ว
kotlin is modern objected oriented programming language developed by jet brains. Kotlin is developed from various languages like JAVA and JAVA SCRIPT. Kotlin is developed to support JVM (JAVA virtual machine). Features Of Kotlin Language: Kotlin does not need semicolon(;) to end statements. Kotlin is null-safe programming language. Kotlin eliminates Null pointer Exception which is a big headach...
Obrigado e parabéns pelo vídeo, só estou com uma dificuldade, não sei se houve alguma mudança nas políticas do Google desde a gravação do vídeo, mas quando vou implantar o script não me aparece a opção de público, aparece apenas: somente eu e qualquer pessoa com uma conta do Google
Bro i made a react app its working in postman but i am facing CORS policy error in my react app when i am using axios for post request to insert data in the sheet
hello I had several ideas for use regarding APIs and Google sheets and also no code scenarios as you have a lot more knowledge than me, could you tell me what you think?
nice video👍
thank you so much bro, i had done the most silly mistake of assuming sheet name == filename. and was stuck debugging for over a week. when I saw your step-by-step walkthrough, I realized my mistake.
Hi, I am new to google apps-script. Had come across your video by sheer chance, and I liked it. I want to learn more about GAS (google apps script) and how to deploy it for web/mobile applications. Please guide me to grow.
Waiting for more content anna . Soo useful. Thankyou soo much. Love from Bangalore
Very helpful content
excelente, muy sintáctico y eficaz
What about Delete data and update data. Stuck in these both
AMAZING, CRYSTAL CLEAR EXPLANATION!
Muito bom o vídeo, deu tudo certo!
You`re a life saver, Thank you
Good Explanation.. Thank you.
this app script End point only work in postman not other platform
How to implement in custom form
error 302 Moved Temporarily
Works well, thank you! How do you add a Token ID to the code and how would it be appended in the end point? Many thanks!
Thanks for the video, but when I try to make a POST request, I have problems with CORS.
It worked great! Thanks.
Please make a video on sending 2D ArrayList Data to Google sheet, Thank you
Hello Hemendra, good job, this is great. Congratulations
hi thanks for video, i have problem, when i hit from my Frontend, i got CORS, can we solve the cors?
If we want to get specific data only then how to use constraint?
❤
Errors de raha hai
video is good, but ffs, upload CODE next time :D so much typing...
Amazingly simple explanation! Congratulations! I have a question - many of the API solutions on youtube assume that the sheets gets publicly shared. If working with at least some personal data (eg email, name etc) this poses an issue. Is there a way to protect the API request? Thank you!
Thank you so much sir. Subbed.
Hi! Hemendra, thank you for the video, I am not getting the success response when i test it in Postman. Getting result as "the Script completed but did not return anything". Can you please? I did exactly same as you did in the video.
Very good video helped a lot. I would like to save an image as well, I saw that google drawings allows saving, publishing and getting an html code that can be used in HTML projects. Could you help me create a script that also saves images? Thanks
Hi! Hemendra, thank you for the videos! How would you filter the results?
Hi Hemendra, can you help to create another example using a JSON Array of Object?
Update delete insert?
Sir, this tutorial is much helpful and I can't find this type of video on youtube . Now if you make tutorial for how to patch and delete , it will more helpful for us. so, it's my humble request to you sir.
very good tutorial , i subscribed for channel and thanks ^_*
I did exactly the same as you did but when I run the code I get an error: "TypeError: Cannot read property 'parameter' of undefined". What would be the problem?
JUST Copy This, And it will work var wbook = SpreadsheetApp.openByUrl(); var sheet = wbook.getSheetByName("Sheet1"); function doPost(e){ addUser(e); } function addUser(e){ var user = JSON.parse(e?.postData?.contents); sheet.appendRow([ user.Name, user.Age, user.Phone, user.Email, user.Address, user.Instagram, user.School]); return ContentService.createTextOutput("Sucess").setMimeType(ContentService.MimeType.TEXT); }
If change like: let action = e?.parameter?.action No error during run, but POST still do not work BTW, on video the same error UPD. Do not forget to redeploy after code correction. Now work!
@@OMGdon you saved my life, I have the same error bro.
Bro thank you for this great tutorial, I've almost surrendered finding great tutorial on google sheet api creation since previous tutorials are not working and I dont want to involve money on subscribing paid 3rd party api creator.Thank you!! already subscribe.
Possible to edit data conditionally
Thanks Hemendra ! I have a question if we want to push multiple rows of data from a a json with several entries as the actual script only work with one row, how would you amend you code to to that ? Best r.
Very useful but when I create the for another sheet api for the same workbook it doesn't work and open the same first sheet only where the misktake pls give the solution for this
run and deploy again
congratulations, how would you have an api that had query, update and insertion?
It worked me ...thank you...
I'm stuck on making it work when deployed with "Only myself" access. On the browser it prompts the Google authentication page and then it works, but I don't know how to authenticate from a generic client (in my case, an Android app): I only get 401-unauthorized response, since I don't know how to set the Authorization header (probably requires OAuth2 token??) Any help or resource is much appreciated!
Thanks for the video What about sending api from sheet. Not a manual changed cells but cells that changed by formulas?
How to post 2d array using loop? Please!
how to send multidimensional array of object? Please!
hello thanks for the video. When you run the script, it show you "TypeError: Cannot read property "parameter" from undefined. I have the same error. What you do for run correctly the script?
tengo el mismo problema
Pls thanks so much for the video , and can you show us how to PATCH and PUT record thanks ....
thanks so sir, pls can you show us how update (PUT or PATCH). thanks