Apps Script Web App as Get and Post endpoint for JavaScript Google Apps Script Coding Example

doPost and doGet as an endpoint for web applications.
You can setup your webapp to serve as an endpoint for web applications. In this example we explore how to make both GET method requests and POST method requests to the endpoint, retrieving and returning data from a spreadsheet into the JavaScript code as data from an AJAX request.

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.

Tags and Keywords

#AppsScript #googlesheets #workspace #accounting #finance #automation modern web design online course #onlinecourses #modernwebdesign #tips #appsscript #coding #codingtutorial #script #scriptinghelp #google #Viral #subscribe #helping #GoogleAppsScript #Gmail #Attachments #Spreadsheet #Automation #GmailAttachments #GoogleAppsScript #EmailProductivity #Automation #SpreadsheetLogs #AttachmentDetails #TechTips #ProductivityHacks #GoogleDrive #GmailSearch #GoogleAppsScript #Spreadsheet #Email #Automation #Iteration #subscribe
#GoogleSheets #GoogleAppsScript #CustomUIMenu #SpreadsheetTips #ProductivityTips #TechTutorial #CodingTutorial #BeginnerFriendly #StepByStepGuide

[pattyh]

Thanks so much for this video. Just wanted to comment for anyone who is following along the video and editing files as you go. I think the video skips a step after moving the "return ContentService.createTextOutput(JSON.stringify(data, vals)).setMimeType(ContentService.MimeType.JSON) from output(e) to doGet and doPost. After moving it, you need to replace it in output(e) with return data.vals; I checked the github code when I couldn't figure out why it wasn't returning anything after creating output function. Thanks again

[sue]

you literally saved me!! This thing was driving me crazy for real. thanks!!

[vaibhavagar]

Thank you very much, this helped me a lot with my project 🙌

[nelsonchai]

Thank you, very clear and easy understand.

[RemoteAppraisals]

Thanks for the great video. I noticed the web hook link I used called doPost not doGet. I switched my function over and got my program working great! Something worth mentioning though imo.

[KresimirPendic]

great video Laurence - very detailed and very helpfull! Have a good day man

[Ximaz-]

I waw wondering : is there a way to use the doGet route to get HTML page from GAS, including a form to perform a POST request to a doPost method ? I'm currently facing an issue because of the different iframes the GAS returns along with HTML. Any workaround for that ?

[renatonuneslima]

Great video. I'm having an issue: It's printing 'data' as "json() { [native code] }" after the get request. What am I missing?

[WebiosGameplay]

Is there a limitation in the request? like a quotas in App Scripts?

[manzoorahmed]

Hi I need your help i have wordpress website and i’m using webba booking plugin for appointment is there any way that i can store appointment booking details automatically in sheet and it should be update automatically once customer book any appointment

[lesptitsoiseaux]

I use it to connect and retrieve allot of data from an API. How would you do the spinning wheel or something to let the user know it's getting there?

[henryrivera]

Hello, I am using my web server and it gives me a CORS error. that could be happening?

thank you

[kfl-appsheet]

Exception: Login information disallowed: may i know why it it showing, i wrote rest api

[alexpo]

in this moment 12:07 i get string in browser
{"contentLength":-1, "parameter":{}, "contextPath":"", "parameters":{}, "queryString":""}

not

id= 1000


why?

[ymir]

TypeError: Cannot read properties of undefined (reading 'parameter')
doGet .need help with this error.

[tazulislam]

how to post bulk data to google sheet? Please

[alexsandroalex]

please, how to send a list in a url without htmltemplate?

[mytech]

error : Script function not found: doGet

[iBen-jzxz]

Doesn't work in fetch API. Curse cors.

[TheBlackBoyOne]

I am using appscript web app doGet and facing CORS related issuse. How to configure CORS in app script project?