Category "google-apps-script"

How to split single rows into multiple rows depending on whether one cell has values separated by commas or new lines in Google Sheet?

The spreadsheet has some cells with cell contents that are separated by commas, or a new line. 123, 876, 456 Column "C" is the column that determines whet

Loop ID through cells in Google Apps Script

Good Day! I would like the Purchase Order ID repeated upon submission of a form in an earlier sheet. My current code however repeats this throughout the length

Show Alert Popup when cell selection is changed (onSelectionChange)

I am trying to show an alert popup when cell selection is changed, using the new trigger onSelectionChange. For some reason it is not showing any alerts. Am i d

Moving from other contacts group in google contacts using google app scripts

I cant move my other contacts to my system group contacts via GAS var activeSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var group = Co

Looking to create an XML feed from a Google Sheet Table

Looking for some help please, I've been tinkering with the code now most of the day and im stuck, and this seems about the best solution I have found so far. I'

How to set a sheet's number of rows and columns at creation time? (And a word about Google's "advanced parameters")

When creating a spreadsheet ex novo, Google's SpreadsheetApp allows one to specify the number of rows and columns of said spreadsheet: var spreadsheet = Spread

Upload file to my google drive with Google Apps Script (NO FORM IN GOOGLE)

so basically the task is quite simple, but I didn't find any workable solution for my problem. I have a huge upload script on my website (at the moment localhos

Unable to figure out how to move a file to a folder after they have been matched based on an ID that they both have in their names Google apps script

In Google Drive I am trying to compare an id in a file name against folders named with that id, and if they match, to move that file to that folder. Some of the

Custom functions intermittently hang with "Error - Loading Data"

I have a Google Apps Script custom function, very simple: function sharesBurned(sharesToSell) { return "tree" } Obviously, this works when I test it in

Google apps script: how to refresh data connector from Salesforce with a script?

I'm using Data Connector from Salesforce addon. To refresh my data in Google sheet, I usually either setup an automated refresh via the addon, or I click manua

Running WebAssembly on Google Apps Script

I am attempting to run WebAssembly on the new V8 Google Apps Script runtime, and it appears to be supported, however it seems that async functions are terminate

How to declare Class fields in Google App Script using javascript

I'm trying to create a class with some fields on Google Scripts. I can't even save the file. From what I understand of this SO answer, I'm using the correct s

Call a Google Sheets add-on within a Google Apps Script?

Is it possible to call a Google Sheets add-on as if it were a function in an Apps Script? I am trying to automate a few steps like this: Import/append data fr

Google Spreadsheet with data from WebSocket

I want to write a custom script using Google Apps Script for Spreadsheet that gets data from WebSocket. Is there a way doing so?

How to trigger a script via clicking a cell

I have a google spreadsheet with many tabs and I'm trying to create a dynamic Index tab. So far this is what I'm doing: function jumpToSheet() { var ss = S

Add an open url handler to a button

I created a button and I have applied to this button a handler to collect the data of some fields and record them in a spreadsheet. I wish, however, at the end

How to sort sheets within a spreadsheet in chronological order by date in google apps script

I am attempting to sort the sheets within my spreadsheet in chronological order. They are all dates in the same format (MM-dd-yyyy), but I am unsure of how to t

Updating multiple appscript projects from one appscript

I have scenario where I have more than 60 sheet, and all have appscript project behind them running and managing those sheet. I want to updat/control those apps

Is there a way to tie code to multiple GAS using clasp for testing?

I work on a lot of google scripts that are tied to different people's google sheets. Recently I've been trying to shift to using Clasp and VS Code to make it ea

Error when connecting to MSSQL Server with Google Apps Script via JDBC

I'm trying to connect to Microsoft SQL Server using Google Apps Script. I'm using SQL Server 2008 R2 and I am using one of the suggested scripts that's supposed