Add data to Google Sheet using App Script || Hemendra
Вставка
- Опубліковано 14 жов 2024
- 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
• Create API From GOOGLE...
What is JSON ?
• What is JSON ?
What is a REST Api?
• What is a REST Api?
Linkedin: / hemendra-sundhar-kumar...
Wallpaper: imgur.com/a/FYHfk
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.
You`re a life saver, Thank you
Hello Hemendra, good job, this is great. Congratulations
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.
Very nice explanation..!
Can you please do one video for updating the sheet rows and deleting the rows !
Sure. I will do it. Thanks for the suggestion.
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
I have a suggestion🤔. Could you take it one step further and post and get nested array which is like relational database. For example student and courses or employee and his working days …. etc.
thanks . I will do it soon.
@@HemendraV Thank you . Highly appreciated.🙏
Thanks for the video, but when I try to make a POST request, I have problems with CORS.
Thank you sir
Your video helped me.please continue with these tutorials🤩🤩
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.
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.
Thank you so much sir. Subbed.
It worked me ...thank you...
Thanks for the video
What about sending api from sheet.
Not a manual changed cells but cells that changed by formulas?
hi thanks for video, i have problem, when i hit from my Frontend, i got CORS, can we solve the cors?
nice video👍
very nice! Thanks
congratulations, how would you have an api that had query, update and insertion?
Awesome!
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?
Very useful. thank you sir
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.
Pls thanks so much for the video , and can you show us how to PATCH and PUT record thanks ....
How to enable the script editor? I really need help... please help me... all I got is Apps script and it say "Sorry, unable to open the file at this time. Please check the address and try again." it quite frustrating because I cannot find any video that show how to solve this problem
I'm getting the same with my post requests when trying to send data in the body of the request.
Should work if you send your data as part of the querystring (after the ? charachter in the link, like this: [your_deploy_link]?[datakey1=data1&datakey2=data2]).
Btw I don't think this is clean nor safe to do-I'm also getting many other problems with Apps Script-so I think I'll move to a different, serious backend.
Thanks bro
Hi Hemendra, can you help to create another example using a JSON Array of Object?
What about Delete data and update data. Stuck in these both
Please make a video on sending 2D ArrayList Data to Google sheet, 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!
Possible to edit data conditionally
How to send Data (Post Request) from sheet to any URL . using app script Thanks in advance
How does it work with cUrl PHP
how to send multidimensional array of object? Please!
How to implement in custom form
Update delete insert?
How to post 2d array using loop? Please!
this app script End point only work in postman not other platform
Getting unauthorised 401
Did you set the Who has access property to Anyone, while deploying?