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...