cURL script to obtain tokens with Google OAuth flow
If you just need a token to do some experimenting, or perhaps you don't want to download the whole client library just to get your hands on a token, here is a minimal cURL script.
How to get a blob from selected files on GooglePicker
(StackOverflow Answer) The Google Picker API is quite powerful but there is not much documentation on it. In this example the Picker is used to get a file ID and then make a Drive API call from the front-end with the same auth client, to get a blob.
How to get an Apps Script web app front-end to pull values from a spreadsheet.
(StackOverflow Answer) An example of how to set up a web app with a front-end, to pull values from a spreadsheet to populate a datalist element.
Can I directly extract contents of a tweet using google sheet formulas?
(StackOverflow Answer) No, unfortunately you can't. Because it's a dynamic site. Click here to find out more.
(StackOverflow Answer) It would appear that you can manually increase the length of an arc in Google Slides, but doing it via the API or Apps Script is not possible. In this answer I prove this and offer a workaround to creating custom length arcs using a pop up and the Canvas API.
IMPORTHTML/IMPORTXML suddenly returning resource at URL not found
(StackOverflow Answer) The Google Sheets formula IMPORTHTML and IMPORTXML are often used for web-scraping, but using these formulae are unreliable for this. To answer this SO question I investigated why it fails for Yahoo finance.
Arduino sensors and Apps Script web apps
(Stack Overflow Answer) An example of a simple Apps Script web app and a corresponding cURL to add data to a spreadsheet. In this question the user was using it with Arduino sensors.
Just dump the whole spreadsheet into memory
(Stack Overflow Answer) Its common for beginners in Apps Script to make calls to the spreadsheet in a loop, finding that the script is extremely slow. The solution is normally to just grab everything in the spreadsheet in one call, transform it, and then dump it back (within reason).
Generating custom charts from a Spreadsheet using Apps Script and the Canvas API
(StackOverflow Answer) Another example of using the Canvas API to generate custom images. In this answer it is used to generate a series of custom charts and then save the images to Drive.
Importing Stars to Google Maps
Google lets you export your "stars", your marked places on Google maps, as JSON, but doesn't let you import them. Here is a way to automate entering them with Puppeteer.
Find and Replace plus for Google Docs. A function that will replace the text but keep the hyperlink and format.
(StackOverflow Answer) Simple finding and replacing with Apps Script in Google docs will not keep format or hyperlinks. In this answer I demonstrate a function that will keep all these attributes.
Arduino Tea Temperature Sensor
Learn C++ and Arduino by creating a sensor that will let you know when your tea is at the optimum temperature by playing a Super Mario song.
Google Drive API, is there an endpoint to get all the files in my domain?
(StackOverflow Answer) There is no specific endpoint to get all the files that everyone has uploaded to your entire Google Workspace domain, but there are ways to approach such a task. In this answer I go over a few options.
How to use the properties service in Apps Script to workaround the execution time limit.
(StackOverflow Answer) If you are running into the execution time limit of Apps Script, first, you should ask yourself if you really need to do this in Apps Script! If you do though, here is a way to use the properties service to save the script state and then create a one time trigger to resume execution. It will do this in a loop until done.
How to programatically use the "link to spreadsheet" function when copying a table from Sheets to Docs?
(StackOverflow Answer) Unfortunately, this is not possible as it seems to be available in the UI only. However, in this answer I preset a possible workaround if this functionality is necessary. Though at this point you might as well be using a Web App.
Simple Baduk (Go game)
A python AI programmed for the "Coders Strike Back" competition on codingame.com which made it to the top 1% worldwide.
A python project that will scrape twitter for tweets containing a chosen term, and then create a word cloud with the cleaned text.
A video cover of a classic video game song, the Dr. Robotnik theme. Recorded during the 2020 Covid Lockdown.
An example of using the VBA Scripting Dictionary to model data and manage an excel spreadsheet, along with some useful devlopment tools.
Flyers and Websites
A few flyer and website designs that I made while working for a small gallery in Barcelona.
The "Bridge", a.k.a. La Maquina del Espacio-Tiempo
A music performance augmentation system. Finding creative ways to integrate digital tools into a live improvised performance.
Siglo 22 / Smode feat. Royal Society
A recording of the "bridge", the music performance machine, complete with live projected visualizations. The short song was written in situ while recording takes.
MIDI for the bridge
An overview of the MIDI programming done for the "bridge". From the hardware routing to the music theory.
Taking a Hack-saw to an FCB1010
Modding a MIDI footpedal. It had poor quality pedals and even though its internals ran on standard 9v DC, it came with an 240v AC adaptor which could be removed, all of which cuts down on the weight and size of the pedal.
Tracking Time in a Foundry
The story of trying to get a foundry to use computers, with some lessons in keeping design simple and not letting salesmen near the specification.
I was lucky enough to be neighbours with a music producer who recorded me playing guitar and used the samples in his songs.