Category "google-apps-script"

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

Google Classroom API Create Material

I am aware that there are multiple questions essentially asking the same thing, but part of the problem I've identified is a lack of detail in the questions, so

How to navigate html pages with standalone Google Apps Script?

I am using the HTMLService to create a standalone google apps script web app. I want to be able to write code to take clicks on links on the HTML page for the a

How to automatically add data to another sheet when a specific cell's values changes?

I have a sheet with the pricing of different products. These prices are updated very frequently, and I would love to find a solution whereby, whenever I change

How to do I locate a Google SpreadSheet ID?

https://developers.google.com/apps-script/guides/rest/api#parameter_and_return_types When using the Google Execution Api for Java, the ID of the spreadsheet is