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