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.
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?
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 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 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
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!
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.
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.
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!
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
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.
Thank you sir
Your video helped me.please continue with these tutorials🤩🤩
Thank you so much sir. Subbed.
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 useful. thank you sir
Thanks for the video, but when I try to make a POST request, I have problems with CORS.
nice video👍
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
It worked me ...thank you...
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.🙏
very nice! Thanks
Awesome!
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.
Thanks for the video
What about sending api from sheet.
Not a manual changed cells but cells that changed by formulas?
congratulations, how would you have an api that had query, update and insertion?
Hi! Hemendra, thank you for the videos! How would you filter the results?
How does it work with cUrl PHP
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
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.
hi thanks for video, i have problem, when i hit from my Frontend, i got CORS, can we solve the cors?
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.
Possible to edit data conditionally
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.
Pls thanks so much for the video , and can you show us how to PATCH and PUT record thanks ....
Update delete insert?
What about Delete data and update data. Stuck in these both
Hi Hemendra, can you help to create another example using a JSON Array of Object?
Please make a video on sending 2D ArrayList Data to Google sheet, Thank you
Thanks bro
how to send multidimensional array of object? Please!
How to implement in custom form
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!
How to post 2d array using loop? Please!
How to send Data (Post Request) from sheet to any URL . using app script Thanks in advance
Getting unauthorised 401
Did you set the Who has access property to Anyone, while deploying?
this app script End point only work in postman not other platform