how to run a function in my google app script via api using javascript

Question

I want to run a function in my google app script file. but how can i run it via api in an external website. Help anyone please.

I tried to send an api request as this target script code.gs

 function addtext(sheetId) {
   var ss = SpreadsheetApp.openById(sheetId);
   ss.appendRow(['test', 'blabla'])
   });
 }

and javascript as this var scriptId = "";

 // Initialize parameters for function call.
 var sheetId = "<ENTER_ID_OF_SPREADSHEET_TO_EXAMINE_HERE>";

 // Create execution request.
 var request = {
   'function': 'addtext',
   'parameters': [sheetId],
   'devMode': true  
 };

// Make the request.
 function apire() {
   gapi.client.request({
   'root': 'https://script.googleapis.com',
   'path': 'v1/scripts/' + scriptId + ':run',
   'method': 'POST',
   'body': request
   });
 }

Community · Accepted Answer · 2020-06-20 09:12:55Z

-2

You can follow JavaScript Quickstart:

HTML Service: Communicate with Server Functions

google.script.run is an asynchronous client-side JavaScript API that allows HTML-service pages to call server-side Apps Script functions. The following example shows the most basic functionality of google.script.run — calling a function on the server from client-side JavaScript.

HTML

<!DOCTYPE html>
<html>
<head>
<base target="_top">
<script>
google.script.run.doSomething();
</script>
</head>
</html>

code.gs

function doGet() {
return HtmlService.createHtmlOutputFromFile('Index')
.setSandboxMode(HtmlService.SandboxMode.IFRAME);
}

function doSomething() {
Logger.log('I was called!');
}

For an in-depth example, complete the steps described in the rest of this page, and in about five minutes you'll have a simple JavaScript application that makes requests to the Google Apps Script Execution API.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jun 12, 2016 at 13:27

Mr.Rebot

6,8092 gold badges19 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to run a function in my google app script via api using javascript

1 Answer 1

HTML Service: Communicate with Server Functions

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related