Andrew Roberts andrewroberts
andrewroberts
/ Log.gs
Last active
January 4, 2020 14:32
A simple wrapper for the BetterLog Google Apps Script Library - GAS Library MqTFuiXcPtS5rVUZ_jC9Z4tnfWGfgtIUb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 34567890123456789012345678901234567890123456789012345678901234567890123456789 | |
| // JSHint: 22 March 2015 08:56 GMT | |
| // Unit Tests: 22 March 2015 08:50 GMT | |
| /* | |
| * Copyright (C) 2015-2017 Andrew Roberts (andrew@roberts.net) | |
| * | |
| * This program is free software: you can redistribute it and/or modify it under | |
| * the terms of the GNU General Public License as published by the Free Software |
andrewroberts
/ createPDF.gs
Last active
December 29, 2023 07:49
Google Apps Script that merges the values from a Google Spreadsheet into a Google Doc template (does a mail merge) to create a GDoc or PDF. More details can be found at www.andrewroberts.net/2014/10/google-apps-script-create-pdf/. Go to https://tinyurl.com/yd8v2do2 if you would like me to set it up for you.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // | |
| // Create a PDF by merging values from a Google spreadsheet into a Google Doc | |
| // ========================================================================== | |
| // | |
| // Demo GSheet & script - http://bit.ly/createPDF | |
| // Demo GDoc template - 1QnWfeGrZ-86zY_Z7gPwbLoEx-m9YreFb7fc9XPWkwDw | |
| // | |
| // Config | |
| // ====== |
andrewroberts
/ Terrain.gas.js
Created
February 14, 2015 17:24
Generates terrain values for a 257x257 Google sheet
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function onOpen() { | |
| SpreadsheetApp | |
| .getUi() | |
| .createMenu('Terrain') | |
| .addItem('Generate terrain map', 'createTerrain') | |
| .addToUi(); | |
| } |
andrewroberts
/ testOpenStackGASLibrary.gs
Created
October 7, 2015 09:06
GAS OpenStack API Library example
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Memset/OpenStack API | |
| // -------------------- | |
| // Include the GAS OpenStack library - Mo6MqgzKidu5VYzZ7NzIM-tnfWGfgtIUb | |
| // Complete these fields appropriately for your storage provider | |
| var OPENSTACK_ROOT_URL = '[URL of storage using OpenStack API]' // e.g. 'https://auth.storage.memset.com/v2.0/' | |
| var OPENSTACK_USERNAME = '[Enter username here]' |
andrewroberts
/ OpenStack.gs
Created
October 7, 2015 09:11
Google Apps Script library for the OpenStack RESTful API
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 34567890123456789012345678901234567890123456789012345678901234567890123456789 | |
| /** | |
| * @fileOverview GAS Library for accessing an <a href="http://developer.openstack.org/api-ref.html">OpenStack API</a>. Library ID - Mo6MqgzKidu5VYzZ7NzIM-tnfWGfgtIUb | |
| * @author <a href="mailto:andrew@roberts.net">Andrew Roberts</a> | |
| * @copyright <a href="http://www.andrewroberts.net">Andrew Roberts</a> | |
| */ | |
| /* | |
| * This program is free software: you can redistribute it and/or modify it under |
andrewroberts
/ getAddress.gs
Created
November 16, 2015 19:44
Google Sheets custom function to get Google's best guess at the address of a place.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function GET_ADDRESS(placeName) { | |
| var response = Maps.newGeocoder().geocode(placeName); | |
| return response.results[0].formatted_address | |
| } |
andrewroberts
/ GASNeverBounce.gs
Created
January 29, 2016 09:27
Google Apps Script for accessing NeverBounce RESTful API (and writing to a GSheet)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| var VALID_COLUMN_INDEX = 4 | |
| var EMAIL_COLUMN_INDEX = 3 | |
| function onOpen() { | |
| SpreadsheetApp | |
| .getUi() | |
| .createMenu('Validate Emails') | |
| .addItem('Validate Sheet', 'validateEmail') | |
| .addToUi() | |
| } |
andrewroberts
/ CreatePDFRenameAndEmail.gs
Last active
October 10, 2019 15:19
A Google Apps Script that uses the values from a Google Sheet to construct a PDF from a GDoc template. It allows you to specify a name for the file and email it to someone. This is a demo sheet: https://docs.google.com/spreadsheets/d/1jLpPtmUS8__PceJx9z5iSSaLSfENojWK7hfsH6uHa9Y/edit#gid=0. It is a development of the CreatePDF script (https://gis…
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| PDF Create - with rename and email | |
| ================================== | |
| When you click "Create PDF>Create PDF" this script uses the data from | |
| the active row to construct a PDF in your GDrive. The value in the | |
| "File Name" column is used to name the file and - if there is a | |
| value - it is emailed to the recipient in the "Email" column. |
andrewroberts
/ GASWebsiteMonitor.gs
Last active
August 15, 2021 16:34
Website/domain monitoring with Google Sheet and Apps Script - http://goo.gl/pHc4SC
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 34567890123456789012345678901234567890123456789012345678901234567890123456789 | |
| // JSHint - 27 Feb 2016 21:19 | |
| /* jshint asi: true */ | |
| /* | |
| * Copyright (C) 2016 Andrew Roberts | |
| * | |
| * This program is free software: you can redistribute it and/or modify it under | |
| * the terms of the GNU General Public License as published by the Free Software |
andrewroberts
/ TrialBalance.gs
Last active
December 17, 2017 15:27
Google Apps Script request to Xero API for trial balance - snippet for Xero Forum question
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function getTrialBalancesWithNoDate() { | |
| // . | |
| // . | |
| // . | |
| fetchPublicAppData('Reports/TrialBalance', '', '') // OK | |
| // . | |
| // . |
OlderNewer