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. […]
scrviz
Apps Script
Data Studio connector for scrviz – finally connecting it up
This series of articles will work through how to create a connector for Data Studio in Apps Script. For an introduction into the structure I’ll be following see Creating a connector for Data Studio and for a […]
Apps Script
Coding a connector for Data Studio (without using data studio)
This series of articles will work through how to create a connector for Data Studio in Apps Script. For an introduction into the structure I’ll be following see Creating a connector for Data Studio This article […]
Apps Script
Creating a connector for Data Studio
This series of articles will work through how to create a connector for Data Studio in Apps Script. The source data will be the github apps script project catalog from Every Google Apps Script project on […]
Apps Script
Finding the scriptId from 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. One of the features […]
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
Sharing data with Upstash between Node and Apps Script – end to example in 5 minutes
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
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
Find an Apps Script library id in 10 seconds with scrviz
You want to include an Apps Script library, and you know it’s name, but not its id. A pain right? Here’s 3 easy steps to find it in https://scrviz.web.app Step 1 – find the library […]
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
Microsoft OneDrive plugin as a cache for Google Apps Script
OneDrive as Cache platform In Apps script library with plugins for multiple backend cache platforms I covered a way to get more into cache and property services, and the bmCrusher library came with built in plugins […]
Apps Script
Enrich your scrviz repo profiles and drive traffic to your website or blog
In Enrich your developer profile on scrviz I showed how scrviz could be used to show off your Apps Script work to potential clients (Showcase your Apps Script work and get hired via vizzy) and how to […]