Simple Google Webapp script modification
Budget: $30 – $250 USD
Below is a short Webapp script. I want to modify it so that it will add the parameters inside the Webapp exec url (i..e, "col1=xxxx&col2=yyyyy&col3=zzzzz") not all in the first column, but each value in its own column. For example, if the URL is
https://script.google.com/macros/s/AKfycbzFMJbA...56oA/exec?col1=xxxx&col2=yyyyy&col3=zzzzz
xxxx would be added in column 1, yyyy in col2, zzzzz in col3 and so on up to coln
I have $50 for this.
WEBapp script:
var SHEET_URL = 'https://docs.google.com/spreadsheets/d/1QDp3fuWD...-wllUFO8GERfr5g_64/edit#gid=0';
function doGet(e){
var spreadsheet = SpreadsheetApp.openByUrl(SHEET_URL);
var sheet = spreadsheet.getSheets()[0];
sheet.appendRow([e.queryString]);
}
https://script.google.com/macros/s/AKfycbzFMJbA...56oA/exec?col1=xxxx&col2=yyyyy&col3=zzzzz
xxxx would be added in column 1, yyyy in col2, zzzzz in col3 and so on up to coln
I have $50 for this.
WEBapp script:
var SHEET_URL = 'https://docs.google.com/spreadsheets/d/1QDp3fuWD...-wllUFO8GERfr5g_64/edit#gid=0';
function doGet(e){
var spreadsheet = SpreadsheetApp.openByUrl(SHEET_URL);
var sheet = spreadsheet.getSheets()[0];
sheet.appendRow([e.queryString]);
}