• Linkedin
  • GitHub

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
Home2013September

Month: September 2013

No Picture
From VBA to Google Apps Script

Excel custom functions that can lookup data in Google Apps Script ScriptDB

September 30, 2013 Comments Off on Excel custom functions that can lookup data in Google Apps Script ScriptDB

In REST access to Google Apps Script list management functions we looked at accessing the Google Apps ScriptDB and some custom functions using the rest to Excel library In that post, I mentioned that it would even be […]

No Picture
Microsoft Office & VBA

REST access to list management cloud based functions – plus a VBA example

September 27, 2013 Comments Off on REST access to list management cloud based functions – plus a VBA example

In Google Apps Script lists and validation I showed how to use custom functions from Google Spreadsheets to perform common spreadsheet tasks like lookup, index, filter, sort, match and apply dataValidation using cloud based lists. Of […]

No Picture
scriptDB

Validation and lookups using shared scriptDB lists

September 19, 2013 Comments Off on Validation and lookups using shared scriptDB lists

When the scriptable data validation feature in Google Apps Script came out recently, I started thinking about how we don’t really use the cloud based nature of Google Docs to its potential in a number […]

No Picture
Apps Script & Java Script

Pinyin Tone converter – Google Apps Script custom functions

September 1, 2013 Comments Off on Pinyin Tone converter – Google Apps Script custom functions

I’ve never been shy of writing up something I don’t know much about, and today’s post is no different. A few weeks ago I’d never heard of Pinyin; today, here’s a couple of Google Apps […]

My Books and Videos

Manning liveproject 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 LiveProject
going gas

All formats are available from O'Reilly, Amazon and all good bookshops. You can also read a preview on O'Reilly

A video course over about 8 hours and 70 lessons taking you through the basics of Apps Script and JavaScript. Available at O'Reilly, Amazon, Infinite Skills & all good media outlets

Google Apps Script for Beginners: A video course over about 8 hours and 70 lessons taking you through the basics of Apps Script and JavaScript. Available from O'Reilly, Infinite Skills and all good media outlets

bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines

I am supporting CandidateX

CandidateX is a startup that focuses on creating inclusion-focused hiring solutions, designed to increase access to job opportunities for underestimated talent. Check them out if you have a few minutes to spare. They need visibility!

Book : Going Gas

Whether you’re moving from Microsoft Office to Google Docs or simply want to learn how to automate Docs with Google Apps Script, this practical guide shows you by example how to work with each of the major Apps Script services. The book introduces JavaScript basics for experienced 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
Manning liveproject 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 LiveProject
  • Linkedin
  • GitHub

bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines