Sending an HTTP/HTTPS request with query string

You can send an HTTP/HTTPS request along with the query string. To do this, append the published URL with your query string.

For example: https://script.google.com/macros/s/AKfycbxa4ErKHiX_0gQ0JUU-Q1qMhvRrOsrx3HXuVZp7pzX8UVxMu4w/exec?fname=John

function doGet(e){
  Logger.log(e);
}

A sample of the logged HTTP/HTTPS request's event object is shown here:

The doGet function listed in the following code snippet shows how you can use the event object to get the required parameters for further processing:

function doGet(e){
  
  // Get the fname value from the query string.
  var firstName = e.parameter.fname;
  
  /*
   *  There is no active spreadsheet, so you should open by id.
   *  Use the id of the spreadsheet in which your script resides.
   *
   */
  var ss = SpreadsheetApp.openById("Replace spreadsheet id");

  var SheetData = ss.getSheetByName("Data");
  
  var data = SheetData.getDataRange().getValues();
  
  // Remove header
  data.shift...