Interesting Tools Apps Script

A Google Apps Script for the Interesting Tools Google Sheet which shows custom menus:

1. Newsletter:
   1. Get the HTML code to copy into the MailChimp template. Uses lib-mailchimphtml.
   2. Create draft Tweets.

Open development

This repository is public, but is not currently open source. Feel free to read, copy, or use any aspect of this code. However, it is published without support, warranty, or guarantees of any kind. We have opened the repo to give a view into how we run Console rather than for it to be independent, release-quality code.

Local development

This script is bound to the Google Sheet container. You can access it from Tools > Script Editor within the sheet but using clasp is preferred.

1. Install clasp.
2. Clone this repo.
3. Ensure you have the latest copy of the code by cloning into the repo:

clasp login
clasp clone 1b2QUiAHmh-u42yy1x3LlOZhm7yGnRWKNNkNjsUtTnZqvlUe-w-2HtfRo

3. Push any changes up to the live version:

clasp push 1b2QUiAHmh-u42yy1x3LlOZhm7yGnRWKNNkNjsUtTnZqvlUe-w-2HtfRo

or have it watch for changes with clasp push --watch.

Debugging

Check the live Apps Script dashboard.