I got a Apps Script (onEdit) running, that locks certain cells when a particular time is over, and it also makes a time stamp. The script works perfectly, but o
Google sheet stock inventory Hello everyone, I'm turning to you because I can't get my code to work on google Sheets. The purpose of the program is to be able t
I'm trying to build a custom range for this sort function in an Apps Script for Google Sheets but I keep getting the error: "Exception: Range not found; sortPro
If i mark and select 5 rows in google sheet. I want to retrieve an array of retrieved rows. Particully column (0). function selectRow() { var sheet = Spreadsh
I have a sheet with a table with content in the range B6:Y1000. I would like a script that would delete all rows if column C-D-E-F-G are empty
As of a couple of weeks now, I'm getting a "Service error: Spreadsheets" error when running a script in Google Sheets. Before that, it was working fine. It's su
I encounter the following problem: An external app is using a service account to copy Google Sheets from a template folder to a shared drive. After the copy the
i made a bot for telegram using Apps script i have a spreadsheet which has a database... 3 columns 500 rows ID , Username, Full Name i want to make a command fo
Im trying to build an automatic program that get leads from API to my google sheet. when im running the program from my pc all works great, but, when im trying
I want to call the Steem API from inside a Google Apps Script function. I want to see the appropriate server response. But I get the following error instead. A
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