Google-apps-script supports Triggers that pass Events to trigger functions. Unfortunately, the development environment will let you test functions with no parameter passing, so you cannot simulate an ...
I'm looking for a way to 'pre fill' a google form with specific data from a google spreadsheet. The form will have the same 'standard' questions for everyone, but the data in the first two question wi...
I'm trying to write a script that will take data from a Google spreadsheet and create events in my Google calendar. I managed that fine but it produced duplicates every time I ran it. So now I'm try...
A documented restriction with document and sheet add-ons is that Apps Script cannot tell what a user does outside of the add-on. This tantalizing tip is given: It is possible to poll for changes i...
I have a legacy database system (not web accessible) on a server which generates CSV or XLS reports to a Google Drive folder. Currently, I am manually opening those files in Drive web interface and c...
I have written some code for my Google spreadsheet with the script editor. I want to share this spreadsheet with my clients but I don't want to share the code I have written. This code adds a menu t...
I've written a custom google-apps-script that will receive an id and fetch information from a web service (a price). I use this script in a spreadsheet, and it works just fine. My problem is that the...
In Google Apps Script, one of the basic tools is the onEdit trigger in a spreadsheet, which enables us to detect when a user edits a cell, and react to it. How about when a user inserts a row or colu...
I'm having some information in Google Spreadsheets as a single sheet. Is there any way by which I can read this information from .NET by providing the google credentials and spreadsheet address. Is it...
I have a Google spreadsheet of timesheet data; it has a sheet for each month, each sheet is a lot of six column blocks, one block per client. I have created a summary sheet that goes and gets the tot...