Search code examples
google-apps-scriptweb-applicationsquery-string

Parameterizing a script in an URL


I'm programming a Google script for a spreadsheet, and after deploying it as web app, you get an URL (https://script.google.com/macros/s/.../dev).

I would like pass an input parameter in the URL (e.g. (https://script.google.com/macros/s/.../dev/param).

How can I fetch the value of this parameter in the script?


Solution

  • you can add a string at the end of the deployed webapp url, just insert a question mark and separate arguments with &.

    example :

    the .dev     https://script.google.com/macros/s/AKfycb___vWxs/dev?val=test&otherVal=otherTest
    
    the .exec    https://script.google.com/macros/s/AKfycb___vWxs/exec?val=test&otherVal=otherTest
    

    demo code :

    function doGet(e) {
      var valToReturn = ContentService.createTextOutput('the parameters were '+e.parameter.val+'\nand\n'+e.parameter.otherVal).setMimeType(ContentService.MimeType.TEXT);
      return valToReturn;
    }
    

    You'll get both parameter values in your browser