Please Help, how to convert comment's value to cell's value using google script? This is the comment, and i want to getValue that comment, and setValue to each
function setWebhook() { var url = telegramUrl + "/setWebhook?url=" + webAppUrl; var response = UrlFetchApp.fetch(url); var obj = JSON.parse(response) Lo
I have a Spreadsheet with about 3000 rows which are grouped by order number. I'm trying to build an macro to: remove all groups multisort all rows recreate gr
I want to retrieve the name of a cell having his range. this is the range : var rangeOfCell = sheet.getRange(100,5); I want to know how to get his native(A1, A
Simple contact web form. I cannot figure out why it does not work as intended. On open sets up a menu, allows me to select a modal, non-modal or sidebar for for
getLastRow() not working in my script. I am trying to return the last row that has data. But since the spreadsheet has empty rows below the rows filled with dat
I am trying to do something and I am almost there but I have been scratching my head on a 'length' issue for quite some time now. What I want to do : Get data f
I am unable to find what is the expiry of property we set using Properties.setProperty(key, value) method of Class PropertiesService. I know we can delete it us
Intuitively, I set a on form submit function in the form's script editor and set the trigger accordingly. function onSubmit(e) { console.log(e); } However, th
I'm using that in a cell but I have a lot of problems to get the information because many times the sheet is "loading" and does not load the information =QUERY(
I need to have a Google Form that returns the result of variable2 depends on the result of variable1. The code runs successfully but the variable 2 does not cha
I have been trying to translate text from HTML code. Here is an example: var s = '<span>X stopped the</span><icon></icon><subject>
It seems I can't parse a json file in a Document script despite it's possible via a DriveApp script. Here is a reproducible example : edit a json valid file and
I try to publish an Editor Add-on for Google Sheet into the workspace marketplace. But I'm struck on the review. With this message : The App doesn’t meet
I have a spreadsheet that I would like to create an app script function to clear data/set values from certain cells. It also needs to work up to the last row, a
I have a form in a web app where you can upload an image, and then i send a POST call to a GAS script. Then in the GAS script i save the image in a Google drive
I cannot find any property receiving the currently for the user displayed calendar week with google apps-script here What I want to do is: Extract the start and
I pull data from a Google Event Calendar. The events include multiple point of contact e-mails (Primary, Secondary, etc.) I am currently able to collect ALL of
I have a google sheet like this I Need to make a google appscript webapp like below with the above sheet. only the price field need to be editable. When it is
We have scales for which we upload data based on a Google sheet that we maintain. The Google Sheet translates the data into the correct configuration and we exp