I am trying to pull data from an API from https://app.scrapingant.com/ using Google Apps Script. The documentation is here: https://docs.scrapingant.com/request
I'm new to using apps script and I'm just trying this out. I want to convert zeros to blanks. This is the code I've managed to create, but it doesn't work and I
sure I had this down but just can't get it right. Had a script set up to get data from one sheet and put it into another one, which I have done but it leaves ga
When clicking "button1" I would like the code to check the First Cell (Column A) of Rows 38-58 and hide the Row if the corresponding cell is empty and show if i
Good evening everyone, forgive the trouble, I tried to do a "search" on the site but I could not find the answer to my problem so I thought of opening a new dis
I got responses from Google form into Google Spreadsheet. I want to filter out the "Weekend" and "Workday". For the "Weekend" days, I only want to select the co
Currently with my 3rd party video conferencing plugin, When user clicks on Google calendar there is popup for scheduling event and in that they can select custo
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