Google Apps Script

ChatGPT – Generating Google Sheets formula to extract string from URL

TL;DR – quick generation of a Regex string inside a google sheet formula.  I have leveraged other online Regex tools, but this makes it seamless to implement as a working formula.  Allowed me to stay focused on the overall task and not dive into the vagaries of Regex and Array formulas. I need a google …

ChatGPT – Generating Google Sheets formula to extract string from URL Read More »

First Impressions of Clasp extension for VS Code to manage local development of Google Apps Scripts

The editor for google apps scripts is OK for simple (single file) macros or scripts. But it falls short when you are managing more complex scripts and multiple files. That is where google clasp comes in. Google clasp is an extension for VS code that allows google apps scripts to be updated locally, with changes easily pushed …

First Impressions of Clasp extension for VS Code to manage local development of Google Apps Scripts Read More »

Scroll to Top