ramblings.mcpher.comDektopLiberation - Desktop Liberation

Linkedin GitHub Search for: Desktop Liberation The definitive resource for Google Apps Script and Microsoft Office automation Home About Desktop Liberation Reusing code from this site My Public GAS Library Privacy and Usage Policy Blog Access all published posts Downloads APIS Google API Slides Chrome Docs Drive Execution KnowledgeGraph People Sheets Microsoft API OneDrive REST Video Intelligence Vimeo Vision Apps Script & Java Script Apps Script v8 Add-ons Javascript From VBA to Google Apps Script Office JavaScript API Snippets Cloud Platform BigQuery Cloud Functions Firebase Kubernetes Google Cloud Platform Google Cloud Storage Databases BigQuery CockroachDB Database abstraction Elastic Firebase GraphQL Office & VBA From VBA to Google Apps Script Optimization Elastic Full Stack GraphQL Kubernetes Node.js Redis- Vuejs Linkedin GitHub Desktop Liberation aims to help you use cloud based APIS and services without being constrained by your desktop software. There’s a particular emphasis on Google Workspace and Cloud APIs and JavaScript, but there’s also plenty of Microsoft and other stuff here too. All code here is unprotected and free to re-use To support my site, and if you find the material useful, you can buy my Google Apps Script and VBA titles published by O’Reilly media and Manning publications. Here’s the latest. Deal of the Day August 22 : New liveProject! Save 45% on my liveProject series Create AI-Powered Workspace Add-ons and other selected titles @ManningBooks : Latest articles 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. […] Kubernetes secret values as shell environment variables Getting a bunch of secret values out of kubernetes into your local shell […] Workload identity with Kubernetes cronjobs to synch Mongo to Bigquery An example use case for Kubernetes workload identity federation – transferring collections from mongodb to bigquery with a Kubernetes cron job […] Color scales, custom schemes and proxies with Apps Script How to add Google Material Colors and your own custom schemes to chroma […] Proxy magic with Google Apps Script I’ve written a few articles on here about JavaScript proxy and reflect. I use both extensively not only in Node projects but also in Apps Script. In this article I’ll demonstrate how to extend built-in [...] Sharing secrets between Doppler, GCP and Kubernetes 3 secret managers working together. How to use GCP Secret Manager, Kubernetes secrets and Doppler together. […] Find nearest matches in color schemes with Apps Script Here’s another article on playing around with color in Apps Script. Let’s say you have a defined list of colors in a scheme (for example paint or textile colors or perhaps a predefined scheme like [...] Detect fake news with Google Fact Check tools I came across Google’s FactCheckTools API today, so I thought it might be fun to add to my bmApiCentral Apps Script library. This API can be used to both search popular fake news claims and [...] Convert any file with Apps Script Apps Script library to convert between file types, including OCR for image to documents, with a huge repertoire of conversion combinations. […] Colorize sentiment in a Google document Anaylze and colorize the sentiment of inidivual sentences in Google using Documents Google Language API […] Content oriented color mixing with Apps Script Apps Script library to derive colors and color mixtures based on text to help contextualize sheets content. […] Obfuscate text with Apps Script Sometimes you want to hide data in a sheet that’s being used for demo purposes.Here’s some options and library to help you do it. […] Markup HTML from JSON with Apps Script and JavaScript Apps Script/JavaScript library to generate prettified HTML Markup from JSON […] Create GraphML markups from Apps Script A recent social network analysis project meant I had to find a way to convert Google Form data for visualization in NodeXL. Normally I’d use D3 for this kind of thing (you’ll find plenty of [...] Calculate contrasting font colors for Sheets. If you are playing around with Sheet colors with Apps Script, you sometimes find yourself with font colors that don’t go well with the background colors you’ve chosen. However, we can use Yiq values to [...] 12 Years and 1000 pages in Office,Google (Docs,Gsuite) Workspace, and other stuff 1000 pages and counting Most years I do a post on ‘a year in Apps Script’, looking back over the changes in the platform over the preceding year. As many of you will probably know, [...] Use a proxy to catch invalid property access Accidentally accessing non-existent properties and tracking down where that is happening is a big time waster that a JavaScript proxy can help you track down. In Fix Apps Script file order problems with Exports I [...] Caching, property stores and pre-caching I’ve written many times about various Apps Script caching techniques such as how to deal with size limits and use different back ends for more persistent caching. In this article, I’ll bring together a few [...] Fix Apps Script file order problems with Exports Motivation It’s good practice to keep class and namespace definitions in separate files and avoid defining functions or variables in the global space. However, App Script doesn’t give you control over the order in which [...] State management across CardService, HtmlService and Server side Add-ons Motivation I’ve been working on a CardService Add-on lately which also uses HtmlService, and also runs quite a few things Server side. All of these modes need to share state, and it always ends up [...] SuperFetch Plugin: Cloud Manager Secrets and Apps Script Smg is a SuperFetch plugin to access the Google Cloud Secrets API. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how it [...] Latest posts Apps Script & Java Script Google Apps Script – What a difference 5 years make – Episode 2 June 21, 2021 Comments Off on Google Apps Script – What a difference 5 years make – Episode 2 It’s been over 5 years since my book ‘Going Gas‘ was published, and Apps Script evolution means that a number of sections of it is now pretty out of date. I’ll use this format then [...] Apps Script Google Apps Script – What a difference 5 years make June 15, 2021 Comments Off on Google Apps Script – What a difference 5 years make I’ve been doing an annual update called ‘a year in Apps Script’ for a number of years now, but I didn’t get round to the 2021 post. This year I thought I’d do something different. [...] Search the site Search for: Or select a Tag in the below cloud d developers unfamiliar with the language, and demonstrates ways to build real-world apps using all of the Apps Script services previously covered. Video: Apps Script for developers In this Google Apps Script for Developers training course, expert author Bruce Mcpherson will teach you how to customize, enhance, and automate your Google Docs, Sheets, and Gmail with Google Apps Script. This course is designed for the absolute beginner, meaning no previous experience with Google Apps Script is required. Once you have completed this computer based training course, you will have learned how to customize, enhance, and automate your Docs, Sheets, and Gmail with Google Apps Script. Video: Apps Script for beginners The key to using Google Apps Script is understanding its underlying language – JavaScript. The course teaches you enough of the concepts and syntax of JavaScript that you’ll come away with the ability to confidently code Google Apps Script tasks on your own. Create ai powered Google Workspace Add-ons create, implement and test a Workspace Add-on add functionality from a collection of Google Cloud APIs such as Cloud Storage, CardService, Drive and others organize extracted data from a variety of documents using the Google AI Platform Manning...