APIS and techniques
Gassypedia – public Google Apps Script on Github
All the Google Apps Script related github activity is now on Google Bigquery and Google Looker. Here’s how it was done. […]
github
Apps Script
Sharing data between Apps Script and Node using Github back end – 5 minute example
Quick demo of data sharing There are many ways to accomplish this of course, but using Caching across multiple Apps Script and Node projects using a selection of back end platforms is pretty fast to set […]
Apps Script
Caching across multiple Apps Script and Node projects using a selection of back end platforms
Motivation I’ve always been interested in ways to get multiple projects in Apps Script sharing data more easily and in a more standard way, independently of whatever platform is being used to host the data […]
Apps Script
Github as an Apps Script cache platform
Github as an Apps Script cache platform Another plugin available for Apps script library with plugins for multiple backend cache platforms so we can use Github as a back end for caching large objects across […]
Apps Script
4 ways to customize scrviz info card behavior
Info Card customization By default the info card appears when you hover over a node in the scrviz visualization. Although the info card is they key tool for investigating scrviz entries, it can be annoying […]
Apps Script
More scrviz updates to help you enrich your profile and repos
A few scrviz updates today, with more flexibility around the depth of the repo visualization and more options to enrich your own profile. Less is more for visualization We have a rapidly increasing number of […]
Apps Script
Enrich your developer profile on scrviz
In Showcase your Apps Script work and get hired via vizzy I showed how scrviz could be used to show off your Apps Script work to potential clients, so they could see what kind of […]
Apps Script
Direct scrviz link to your Apps Script github repo, project or owner
Motivation You’ll know from Every Google Apps Script project on Github visualized that you can get a very large diagram of all known public Apps Script projects and from Find and clone Apps Script projects from github […]
Apps Script
Find and clone Apps Script projects from github directly into the IDE with scrviz
Motivation Every Google Apps Script project on Github visualized describes how to use https://scrviz.web.app to find and visualize public Apps Script projects on Github. More and more apps script projects are being publicly shared on github. […]
Apps Script
Apps Script Vizzy – new views, searches and filtering examples
Apps Script Vizzy update Every Google Apps Script project on Github visualized introduces a way of visualizing public Apps Script projects on github. Showcase your Apps Script work and get hired via vizzy shows how […]
Apps Script
Showcase your Apps Script work and get hired via vizzy
Get yourself found as an Apps Script consultant Every Google Apps Script project on Github visualized introduced this vizzy app to give a searchable view into public apps script projects on Github. If you are […]
Apps Script
Vizzy github data open access – how to build something with Apps Script
In Every Google Apps Script project on Github visualized I introduced Vizzy which uses GitHub data as its source. That same data package is available publicly in case you want to build something on top of […]
Apps Script
Searching and cataloging Apps Script projects on Github
In Every Google Apps Script project on Github visualized I demonstrated an app that could be used to explore what every Apps Script developer who has shared their code is working on. It can be used […]
Apps Script
Every Google Apps Script project on Github visualized
Motivation There are so many Apps Script projects out there where the source code is published on Github, but it’s hard to find what you want. Whether it’s a library, an example of an add-on, […]
Google Authentication
Step by Step – Apps Script Oauth2 authentication with Github
In Oauth2 step by step – apps script authentication for the Drive JSON API I posted a tutorial on using EzyOauth2 – taking some pain out of Apps Script API authentication. Now here’s the same […]
Drive
Tracking github pageviews
Apps Script (advanced level) posted on 16th Oct 2017 Github pageviews You can get things like number of stars and watchers etc from the GitHub REST API repository data, but pageviews are not tracked there. […]
Apps Script & Java Script
Response format from apps script project query
Format of Info.json Each project directory contains an info file that describes the scripts for this project. It is also used to decide whether the sources in the project need to be refreshed. To force […]
Apps Script & Java Script
Making sense of gwt rpc dependency service
Obsolete This post is now pretty much obsolete. As of April 2016, the dependency service seemed to disappear. Next attempt was via a hacked autocomplete service to discover dependencies, which worked until 2018. Now this […]
Drive
Getting your apps scripts to Github
GasGit Getting your scripts to Github is not the easiest thing in world. Nowadays people mainly do it manually, which is fine for small scripts, but when you have many with lots of library dependencies, […]
Apps Script & Java Script
Gasgit – frictionless bulk maintenance of your Apps Script gitgub repos and integration with Clasp
GasGit For the past few years, I’ve been using gasGit (any many of you have too Getting your apps scripts to Github) to get all my public stuff to github. I have over 150 Apps Script repos […]
Drive
Visualizing Apps Script dependencies
dependencyForce If you use a lot of libraries, sometimes things get a bit messy. You delete an old version to clean up and suddenly notice a few days later that things stop working because it’s […]
Drive
Drive SDK and GitHub
You probably have used the Apps Script DriveApp service. There are examples of this scattered throughout the projects on this site. There is another way to manipulate your Google Drive – an SDK that exposes its APIs to external […]
Drive
Drive JSON API for apps script
In Using Drive SDK I described why you might want to use the SDK JSON API rather than the built in Apps Script Drive Class. Before you can start with this you need to authorize your access with OAUTH2, […]