I used the IMPORTXML formula to import values from a website. The formula imports a list of 4 cells in a column. The value of the 3rd cell is a number with a do
This is three similar actions needed in one sheet. Hopefully this ends up being a useful question in general. I have a script that copies the values of arbitrar
I'm attempting to provide a multi-line prompt message in a dialogue box using g-app script. The resulting dialogue box would be: Content of line 1. Content of l
I try a lot of think to create listenKey in app script but nothing work. the binance URL: https://binance-docs.github.io/apidocs/spot/en/#user-data-streams this
I tried to take a code and adapt it to my needs but without success as I am new in script. This code allows to generate a google map with markers on several add
I have a sheet which one column (column 10) is a drop down list with 2 possibilities : official or non official. I'm trying to create a script that export this
I need help, I'm using an onEdit function to implement data validation based on a sheet. It is working fine when I use it alone. I can choose a type in Colonne
It's been several days since I'm stuck on this problem. I've tried everything I saw but I think I miss some logic of the Google Script. I have a php form which
I already have a script that kind of making what I want, but I have a small issue with it, it's that it copy all the sheet with everything instead for me, I wan
when running my script to import .csv content from gmail it works and runs fine without any errors. But the content within the sheet is off. Strange thing is sa
Really sorry if this is the basic question. I have been searching for two days to find the documentation/sample function to use in apps script that fetches goog
I need to write a script that if a cell color is red, it will be deleted. I have found the answer for excel but not google sheets.
I have a script in google sheets with the following function: // Function to get current active sheet-name. function getsheetName(dummy) { return SpreadsheetA
I've started a script that matches an email address in Col D with Gmail and writes the last message date in Col E. I'd like that script to repeat row by row - n
With this script I can exclude to insert the same value column in Google Sheet for maximum 100 times. But I am trying to exclude (with if statement) some values
I am trying to extract the Stock Price History Section from Yahoo Finance Statistics page. The following Xpath seems to point to the right section, but the func
I am maintaining a workbook in google sheets where users update their status and date of completion after a certain task is done. A single sheet contains a stat
I am trying to fetch the attachment data from gmail to google sheets with identifier as subject. The subject format is such as "Disbursement File 2022-05-14" w
I have made a script that exports a certain sheet to a PDF. But at this moment we want to add a second sheet, so we need to export 2 sheets to a single PDF . An
I am still fairly new at script writing and am trying a write a script that deletes a row one day after the date which is in column L. The data is in range A133