Twitter
follow
https://twitter.com/brucemcpherson
Github
follow
https://github.com/brucemcpherson/
Youtube
follow
https://www.youtube.com/user/brucemcphercom/
Gitter
follow
https://gitter.im/desktopliberation/community
Slideshare
follow
https://www.slideshare.net/BruceMcPherson1
LinkedIn
follow
https://www.linkedin.com/in/brucemcpherson/
Desktop LiberationThe definitive resource for Google Apps Script and Microsoft Office automation
follow
https://ramblings.mcpher.com/
Home
follow
https://ramblings.mcpher.com
About Desktop Liberation
follow
https://ramblings.mcpher.com/ramblings/about/
Reusing code from this site
follow
https://ramblings.mcpher.com/reusing-code-from-this-site/
My Public GAS Library
follow
https://docs.google.com/spreadsheets/d/1DlKpVVYCrCPNfRbGsz6N_K3oPTgdC9gQIKi0aNb42uI/edit#gid=0
Privacy and Usage Policy
follow
https://ramblings.mcpher.com/privacy-and-usage-policy/
Sitemap
follow
https://ramblings.mcpher.com/ramblings/sitemap/
Blog
follow
https://ramblings.mcpher.com/blog/
Access all published posts
follow
https://ramblings.mcpher.com/ramblings-blog/
Downloads
follow
https://ramblings.mcpher.com/download-complete-projects/downloads/
APIS
follow
https://ramblings.mcpher.com/category/cloud/apis-and-techniques/
Google API
follow
https://ramblings.mcpher.com/category/google-api/
Slides
follow
https://ramblings.mcpher.com/category/google-api/charts/
Chrome
follow
https://ramblings.mcpher.com/category/google-api/chrome/
Docs
follow
https://ramblings.mcpher.com/category/google-api/docs/
Drive
follow
https://ramblings.mcpher.com/category/google-api/drive/
Execution
follow
https://ramblings.mcpher.com/category/google-api/execution/
KnowledgeGraph
follow
https://ramblings.mcpher.com/category/google-api/knowledgegraph/
People
follow
https://ramblings.mcpher.com/category/google-api/people/
Sheets
follow
https://ramblings.mcpher.com/category/google-api/sheet/
Microsoft API
follow
https://ramblings.mcpher.com/category/microsoft-api/
OneDrive
follow
https://ramblings.mcpher.com/category/microsoft-api/onedrive/
REST
follow
https://ramblings.mcpher.com/category/rest-api/
Video Intelligence
follow
https://ramblings.mcpher.com/category/cloud/apis-and-techniques/video-intelligence/
Vimeo
follow
https://ramblings.mcpher.com/category/cloud/apis-and-techniques/vimeo/
Vision
follow
https://ramblings.mcpher.com/category/cloud/apis-and-techniques/vision-apis-and-techniques/
Apps Script & Java Script
follow
https://ramblings.mcpher.com/category/appsjavascripts/
Apps Script v8
follow
https://ramblings.mcpher.com/category/appsjavascripts/snippets/apps-script-v8/
Add-ons
follow
https://ramblings.mcpher.com/category/add-ons/
Javascript
follow
https://ramblings.mcpher.com/category/appsjavascripts/snippets/javascript/
From VBA to Google Apps Script
follow
https://ramblings.mcpher.com/category/vbatogas/
Office JavaScript API
follow
https://ramblings.mcpher.com/category/officevba/javascript-api/
Snippets
follow
https://ramblings.mcpher.com/category/appsjavascripts/snippets/
Cloud Platform
follow
https://ramblings.mcpher.com/category/gcp/
BigQuery
follow
https://ramblings.mcpher.com/category/bigquery/
Cloud Functions
follow
https://ramblings.mcpher.com/category/gcp/cloud-functions/
Firebase
follow
https://ramblings.mcpher.com/category/databases/firebase-databases/
Kubernetes
follow
https://ramblings.mcpher.com/category/kubernetes/
Google Cloud Platform
follow
https://ramblings.mcpher.com/category/gcp/
Google Cloud Storage
follow
https://ramblings.mcpher.com/category/cloud/storage/
Databases
follow
https://ramblings.mcpher.com/category/databases/
BigQuery
follow
https://ramblings.mcpher.com/category/bigquery/
CockroachDB
follow
https://ramblings.mcpher.com/category/databases/cockroach/
Database abstraction
follow
https://ramblings.mcpher.com/category/database-abstraction/
Elastic
follow
https://ramblings.mcpher.com/category/elastic/
Firebase
follow
https://ramblings.mcpher.com/category/databases/firebase-databases/
GraphQL
follow
https://ramblings.mcpher.com/category/redisreactredux/graphql/
Office & VBA
follow
https://ramblings.mcpher.com/category/officevba/
From VBA to Google Apps Script
follow
https://ramblings.mcpher.com/category/vbatogas/
Optimization
follow
https://ramblings.mcpher.com/category/officevba/optimization-officevba/
Elastic
follow
https://ramblings.mcpher.com/category/elastic/
Full Stack
follow
https://ramblings.mcpher.com/category/redisreactredux/
GraphQL
follow
https://ramblings.mcpher.com/category/redisreactredux/graphql/
Kubernetes
follow
https://ramblings.mcpher.com/category/kubernetes/
Node.js
follow
https://ramblings.mcpher.com/category/node-js/
Redis- Vuejs
follow
https://ramblings.mcpher.com/category/redisreactredux/
[ June 21, 2021 ] Google Apps Script – What a difference 5 years make – Episode 2 Apps Script & Java Script
follow
https://ramblings.mcpher.com/5-years-in-apps-script-what-a-change-e2/
[ June 15, 2021 ] Google Apps Script – What a difference 5 years make Apps Script
follow
https://ramblings.mcpher.com/5-years-in-apps-script-what-a-change/
[ October 16, 2019 ] Looping through files in a directory VBA
follow
https://ramblings.mcpher.com/looping-through-files-in-a-directory/
[ July 15, 2019 ] Use a spreadsheet as a database in 5 minutes Microsoft Office & VBA
follow
https://ramblings.mcpher.com/use-a-spreadsheet-as-a-database-in-5-minutes/
[ June 13, 2019 ] 2019 – a decade in Apps Script Yearly posts
follow
https://ramblings.mcpher.com/2019-decade-in-apps-scrip/
[ February 7, 2019 ] 2018 – yet another year in and out of Google Apps Script Yearly posts
follow
https://ramblings.mcpher.com/2018-yet-another-year-in-and-out-of-google-apps-script/
[ September 22, 2017 ] Apps Script Back end platform – some thoughts on a different approach Apps Script & Java Script
follow
https://ramblings.mcpher.com/apps-script-back-end-platform-some/
[ August 3, 2017 ] Is it still worth creating blogposts ? Yearly posts
follow
https://ramblings.mcpher.com/is-it-still-worth-creating-blogposts-2/
[ March 3, 2017 ] How about free VM for Chromebook owners? Docker
follow
https://ramblings.mcpher.com/how-about-free-vms-for-chromebook-owners/
[ December 28, 2016 ] 2016 – Another year in Apps Script Yearly posts
follow
https://ramblings.mcpher.com/2016-another-year-in-apps-script/
[ December 1, 2016 ] App Maker – Build engaging custom apps on G Suite with minimal coding AppMaker
follow
https://ramblings.mcpher.com/app-maker-build-engaging-custom-apps-on/
[ August 19, 2016 ] Using an Apps Script webapp to distribute assets Apps Script & Java Script
follow
https://ramblings.mcpher.com/using-apps-script-webapp-to-distribute/
[ August 4, 2016 ] Change from project key to scriptid Apps Script & Java Script
follow
https://ramblings.mcpher.com/change-from-project-key-to-scriptid/
[ May 13, 2016 ] What I’ve learned from my first play around with BigQuery/Sheets integration BigQuery
follow
https://ramblings.mcpher.com/what-ive-learned-from-my-first-play-around-with-bigquery-sheets-integration/
[ April 13, 2016 ] Targeting training material for Google Apps Scripters Apps Script & Java Script
follow
https://ramblings.mcpher.com/targeting-training-material-for-google-apps-scripters/
[ March 14, 2016 ] A belated post – 2015 – a year in Apps Script Yearly posts
follow
https://ramblings.mcpher.com/a-belated-post-2015-year-in-apps-scrip/
[ November 6, 2015 ] Null should mean something Apps Script & Java Script
follow
https://ramblings.mcpher.com/null-should-mean-something/
[ June 25, 2015 ] Running JavaScript directly from Excel makes ‘going Google’ easier Javascript
follow
https://ramblings.mcpher.com/running-javascript-directly-from-exce/
[ March 24, 2015 ] GitHub and VBA integration GitHub
follow
https://ramblings.mcpher.com/github-and-vba-integration-2/
[ February 6, 2015 ] Some best practise notes on DbAbstraction usage Database abstraction
follow
https://ramblings.mcpher.com/some-best-practise-notes-on/
[ January 21, 2015 ] First shot at Polymer Deprecated
follow
https://ramblings.mcpher.com/first-shot-at-polymer-2/
[ January 4, 2015 ] A year in the desktop liberation blog Yearly posts
follow
https://ramblings.mcpher.com/a-year-in-desktop-liberation-blog/
[ January 1, 2015 ] A year in apps script and my bucket list Yearly posts
follow
https://ramblings.mcpher.com/a-year-in-apps-script-and-my-bucket-lis/
[ December 12, 2014 ] Google Apps Script locking and optimum wait times and the golden ratio Apps Script & Java Script
follow
https://ramblings.mcpher.com/google-apps-script-locking-and-optimu/
[ September 22, 2014 ] How many requests a second can you throw at your Google Apps Script webapp Apps Script & Java Script
follow
https://ramblings.mcpher.com/how-many-requests-second-can-you-throw/
[ July 24, 2014 ] Using universal analytics to track your Google Apps Script library usage Apps Script & Java Script
follow
https://ramblings.mcpher.com/using-universal-analytics-to-track-your/
[ May 29, 2014 ] Parse.com as a substitute for ScriptDB in Google Apps Script Apps Script & Java Script
follow
https://ramblings.mcpher.com/parsecom-as-substitute-for-scriptdb-in/
[ May 16, 2014 ] Eurovision song contest voting oddities – interactive visualization Google Visualization
follow
https://ramblings.mcpher.com/eurovision-song-contest-voting-oddities/
[ May 1, 2014 ] Universal analytics – really hotting up Google Analytics
follow
https://ramblings.mcpher.com/universal-analytics-really-hotting-up-2/
[ March 17, 2014 ] I’ve just been recognised as a Google Developer Expert Yearly posts
follow
https://ramblings.mcpher.com/ive-just-been-recognised-as-google/
[ February 6, 2014 ] Google Universal Analytics – getting insight into desktop apps too Microsoft Office & VBA
follow
https://ramblings.mcpher.com/google-universal-analytics-deaktop/
[ February 5, 2014 ] More cool stuff you can do with Google Apps ScriptDb Apps Script & Java Script
follow
https://ramblings.mcpher.com/more-cool-stuff-you-can-do-with-google/
[ January 27, 2014 ] Are the new Google Sheets faster than the old? Sheets specific
follow
https://ramblings.mcpher.com/are-new-google-sheets-faster-than-old/
[ January 8, 2014 ] Google Apps Script Content Service – Cross Domain Puzzle Apps Script & Java Script
follow
https://ramblings.mcpher.com/google-apps-script-content-service/
[ January 1, 2014 ] Get post data from Blogger into a google Spreadsheet with the Google Blogger API Sheets specific
follow
https://ramblings.mcpher.com/get-post-data-from-blogger-into-google/
[ December 30, 2013 ] Blog posts’ half life – why bother? Analytics
follow
https://ramblings.mcpher.com/blog-posts-half-life-why-bother/
[ December 13, 2013 ] Accessing parse.com and scriptDB noSQL databases from Excel Databases
follow
https://ramblings.mcpher.com/accessing-parsecom-and-scriptdb-nosq/
[ December 3, 2013 ] Dealing with Unix timestamps in Excel Microsoft Office & VBA
follow
https://ramblings.mcpher.com/dealing-with-unix-timestamps-in-exce/
[ November 28, 2013 ] Shared Encryption/decryption library for Google Apps Script. Apps Script & Java Script
follow
https://ramblings.mcpher.com/encryptiondecryption-library-for-google/
[ November 20, 2013 ] Tracking your Excel Workbooks with Google Analytics Google Analytics
follow
https://ramblings.mcpher.com/tracking-your-excel-workbooks-wi/
[ November 15, 2013 ] Mitigating for changes in REST API rules and formats Microsoft Office & VBA
follow
https://ramblings.mcpher.com/mitigating-for-changes-in-rest-api/
[ October 30, 2013 ] XML and JSON conversion in VBA Json
follow
https://ramblings.mcpher.com/xml-and-json-conversion-in-vba-2/
[ September 30, 2013 ] Excel custom functions that can lookup data in Google Apps Script ScriptDB From VBA to Google Apps Script
follow
https://ramblings.mcpher.com/excel-custom-functions-that-can-lookup/
[ September 27, 2013 ] REST access to list management cloud based functions – plus a VBA example Microsoft Office & VBA
follow
https://ramblings.mcpher.com/rest-access-to-list-management-cloud/
[ September 19, 2013 ] Validation and lookups using shared scriptDB lists scriptDB
follow
https://ramblings.mcpher.com/validation-and-lookups-using-shared/
[ September 1, 2013 ] Pinyin Tone converter – Google Apps Script custom functions Apps Script & Java Script
follow
https://ramblings.mcpher.com/pinyin-tone-converter-google-apps/
[ August 9, 2013 ] What does Google Autocomplete show all over the world ? Google Search
follow
https://ramblings.mcpher.com/what-does-google-autocomplete-show-a/
[ August 6, 2013 ] Google Docs to Excel Asynchronously Docs
follow
https://ramblings.mcpher.com/google-docs-to-excel-asynchronously-2/
[ July 9, 2013 ] Using ScriptDB as a noSQL database for non-Google Apps Script clients Databases
follow
https://ramblings.mcpher.com/using-scriptdb-as-nosql-database-for/
[ July 3, 2013 ] Concept browser for site navigation with d3 Apps Script & Java Script
follow
https://ramblings.mcpher.com/concept-browser-for-site-navigation/
[ July 1, 2013 ] Sankey diagrams direct from Excel – update Microsoft Office & VBA
follow
https://ramblings.mcpher.com/sankeyexcel2/
[ June 26, 2013 ] Exploring blogs and sites by d3 tag visualization and effect on site visits Apps Script & Java Script
follow
https://ramblings.mcpher.com/exploring-blogs-and-sites-by-d3-tag/
[ June 18, 2013 ] Google Fusion Big Data and D3 integration: flight data visualization D3
follow
https://ramblings.mcpher.com/google-fusion-big-data-and-d3/
[ June 18, 2013 ] jQuery promises and exponential backoff Apps Script & Java Script
follow
https://ramblings.mcpher.com/jquery-promises-and-exponential-backoff-2/
[ June 5, 2013 ] Playing around with Tableau Public D3
follow
https://ramblings.mcpher.com/playing-around-with-tableau-public-2/
[ June 3, 2013 ] Visualization of Sites to Tags with d3.js D3
follow
https://ramblings.mcpher.com/visualization-of-sites-to-tags-with-d3js/
[ May 28, 2013 ] Create biased random test data in VBA Microsoft Office & VBA
follow
https://ramblings.mcpher.com/create-biased-random-test-data-in-vba-2/
[ May 21, 2013 ] Digest authentication and Google Apps Script Apps Script & Java Script
follow
https://ramblings.mcpher.com/digest-authentication-and-google-apps/
[ May 14, 2013 ] parse.com and d3.js mashup D3
follow
https://ramblings.mcpher.com/parsecom-and-d3js-mashup/
[ May 8, 2013 ] Connections in electoral data – D3 and VBA follow on from oUseful post ScraperWiki
follow
https://ramblings.mcpher.com/connections-in-electoral-data-d3-and/
[ May 6, 2013 ] Mashing up electoral data – follow on from oUseful post ScraperWiki
follow
https://ramblings.mcpher.com/mashing-up-electoral-data-follow-on/
[ April 30, 2013 ] Finding nearest match and other palettes in other fixed color schemes Colors
follow
https://ramblings.mcpher.com/finding-nearest-match-and-other/
[ April 24, 2013 ] Parse.com and ScriptDB performance comparison Colors
follow
https://ramblings.mcpher.com/parsecom-and-scriptdb-performance/
[ April 19, 2013 ] More playing around with color, parse.com, scriptDb and Google Apps Script Apps Script & Java Script
follow
https://ramblings.mcpher.com/more-playing-around-with-color-parseco/
[ April 15, 2013 ] Very interesting GAS performance results – run locally using htmlservice Apps Script & Java Script
follow
https://ramblings.mcpher.com/very-interesting-gas-performance/
[ April 10, 2013 ] Executing Google Apps Script Code directly in javascript – GAS as a CDN Apps Script & Java Script
follow
https://ramblings.mcpher.com/executing-google-apps-script-code/
[ April 3, 2013 ] Google Apps Script “execution time exceeded” woes Apps Script & Java Script
follow
https://ramblings.mcpher.com/google-apps-script-execution-time/
[ April 2, 2013 ] Google Apps Script Color Space Conversions. Apps Script & Java Script
follow
https://ramblings.mcpher.com/in-google-apps-script-color-functions/
[ March 30, 2013 ] Automatic documentation from VBA – including function arguments Microsoft Office & VBA
follow
https://ramblings.mcpher.com/automatic-documentation-from-vba/
[ March 25, 2013 ] Using jSon/javaScript like structures in VBA Json
follow
https://ramblings.mcpher.com/using-jsonjavascript-like-structures-in/
[ March 23, 2013 ] VBA procedures for CIE LabLch and HSL color scheming Colors
follow
https://ramblings.mcpher.com/vba-procedures-for-cie-lablch-and-hs/
[ March 14, 2013 ] Playing around with Color on Google Apps Script Apps Script & Java Script
follow
https://ramblings.mcpher.com/playing-around-with-color-on-google/
[ March 13, 2013 ] Example of automatic code updating for VBA VBA
follow
https://ramblings.mcpher.com/example-of-automatic-code-updating-for/
[ March 12, 2013 ] VBA string manipulation optimization with custom classes Microsoft Office & VBA
follow
https://ramblings.mcpher.com/vba-string-manipulation-optimization/
[ March 8, 2013 ] Inherit link colors from cells – D3 sankey from Excel Microsoft Office & VBA
follow
https://ramblings.mcpher.com/inherit-link-colors-from-cells-d3/
[ March 6, 2013 ] Strings and the garbage collector in VBA : optimizing string concatenation VBA
follow
https://ramblings.mcpher.com/strings-and-garbage-collector-in-vba/
[ February 28, 2013 ] API of the Day: facebook fql direct from Excel and Google APPs API Specific
follow
https://ramblings.mcpher.com/api-of-day-facebook-fql-direct-fro/
[ February 23, 2013 ] Adventures in serializing VBA classes – automatically documenting your modules Microsoft Office & VBA
follow
https://ramblings.mcpher.com/adventures-in-serializing-vba-classes/
[ February 20, 2013 ] Unused tube stations: discovered via scraperwiki- mapped with Excel and Google Maps Integrating Excel with Maps and Earth
follow
https://ramblings.mcpher.com/unused-tube-stations-discovered-via/
[ February 18, 2013 ] Scraperwiki horsemeat data to Sankey, via Excel. Microsoft Office & VBA
follow
https://ramblings.mcpher.com/scraperwiki-horsemeat-data-to-sankey/
[ January 21, 2013 ] ‘Hot doughnut’ chart in Excel Colors
follow
https://ramblings.mcpher.com/hot-doughnut-chart-in-exce/
[ January 11, 2013 ] Can you make any adSense money with a blog ? adsense
follow
https://ramblings.mcpher.com/can-you-make-any-adsense-money-with-blog/
[ January 10, 2013 ] Calculating a friendly font color based on the fill color – Google Apps Script Colors
follow
https://ramblings.mcpher.com/calculating-friendly-font-color-based/
[ January 7, 2013 ] I’m awarding badges – Google Apps Script integration with Persona and Mozilla Openbadges Badges
follow
https://ramblings.mcpher.com/im-awarding-badges-google-apps-scrip/
[ December 20, 2012 ] Playing around with awarding badges on sites Badges
follow
https://ramblings.mcpher.com/playing-around-with-awarding-badges-on/
[ December 9, 2012 ] Getting physical again No category
follow
https://ramblings.mcpher.com/getting-physical-again-2/
[ December 8, 2012 ] Selecting and publishing a function from a web source Apps Script & Java Script
follow
https://ramblings.mcpher.com/selecting-and-publishing-function-fro/
[ December 7, 2012 ] Publish and prettify source directly from a url Apps Script & Java Script
follow
https://ramblings.mcpher.com/publish-and-prettify-source-directly/
[ December 2, 2012 ] Zoomable d3.js partition charts straight from Excel D3
follow
https://ramblings.mcpher.com/zoomable-d3js-partition-charts-straig/
[ November 22, 2012 ] Select, prettify publish snippets in multiple languages from within a GIST module Apps Script & Java Script
follow
https://ramblings.mcpher.com/select-prettify-publish-snippets-in/
[ November 22, 2012 ] Selecting specific Gist and GAS functions for publication Apps Script & Java Script
follow
https://ramblings.mcpher.com/selecting-specific-gist-and-gas/
[ November 20, 2012 ] Publishing and prettifying Gists through google apps script Apps Script & Java Script
follow
https://ramblings.mcpher.com/publishing-and-prettifying-gists/
[ November 17, 2012 ] Using Google Cache to persist data across function calls Apps Script & Java Script
follow
https://ramblings.mcpher.com/using-google-cache-to-persist-data/
[ November 12, 2012 ] Google Apps Script Liberation – publishing your stuff Apps Script & Java Script
follow
https://ramblings.mcpher.com/google-apps-script-liberation/
[ November 6, 2012 ] Publishing Google Apps Script code snippets Apps Script & Java Script
follow
https://ramblings.mcpher.com/publishing-google-apps-script-code/
[ November 5, 2012 ] Google Apps Script – a new day – a new feature Apps Script & Java Script
follow
https://ramblings.mcpher.com/google-apps-script-new-day-new-feature/
[ November 2, 2012 ] Delegating processing to the cloud from Excel and other platforms Apps Script & Java Script
follow
https://ramblings.mcpher.com/delegating-processing-to-cloud-fro/
[ November 1, 2012 ] Keeping all those Google Apps script ‘shortcuts’ under control Apps Script & Java Script
follow
https://ramblings.mcpher.com/keeping-all-those-google-apps-scrip/
[ October 31, 2012 ] Somewhere to keep those API keys: google apps script rest library entry Apps Script & Java Script
follow
https://ramblings.mcpher.com/somewhere-to-keep-those-api-keys-google/
[ October 31, 2012 ] API library entry of the day: use builtwith.com to see how websites are built Apps Script & Java Script
follow
https://ramblings.mcpher.com/api-library-entry-of-day-use/
Twitter
follow
https://twitter.com/brucemcpherson
Github
follow
https://github.com/brucemcpherson/
Youtube
follow
https://www.youtube.com/user/brucemcphercom/
Gitter
follow
https://gitter.im/desktopliberation/community
Slideshare
follow
https://www.slideshare.net/BruceMcPherson1
LinkedIn
follow
https://www.linkedin.com/in/brucemcpherson/
related blog
nofollow
https://ramblings.mcpher.com/2019/10/ramblings-blog.html
G+ community
follow
https://gitter.im/desktopliberation/community
free to re-use
nofollow
http://creativecommons.org/licenses/by-sa/3.0/deed.en_US
follow
https://ramblings.mcpher.com/workplace-1000/
12 Years and 1000 pages in Office,Google (Docs,Gsuite) Workplace, and other stuff
follow
https://ramblings.mcpher.com/workplace-1000/
[...]
follow
https://ramblings.mcpher.com/workplace-1000/
follow
https://ramblings.mcpher.com/datastudio/implement/
Data Studio connector for scrviz – finally connecting it up
follow
https://ramblings.mcpher.com/datastudio/implement/
[...]
follow
https://ramblings.mcpher.com/datastudio/implement/
follow
https://ramblings.mcpher.com/datastudio/coding/
Coding a connector for Data Studio (without using data studio)
follow
https://ramblings.mcpher.com/datastudio/coding/
[...]
follow
https://ramblings.mcpher.com/datastudio/coding/
follow
https://ramblings.mcpher.com/datastudio/
Creating a connector for Data Studio
follow
https://ramblings.mcpher.com/datastudio/
[...]
follow
https://ramblings.mcpher.com/datastudio/
follow
https://ramblings.mcpher.com/vizzy-scrviz/scriptid/
Finding the scriptId from Apps Script projects on github
follow
https://ramblings.mcpher.com/vizzy-scrviz/scriptid/
[...]
follow
https://ramblings.mcpher.com/vizzy-scrviz/scriptid/
follow
https://ramblings.mcpher.com/gassnippets2/fourth-fiddler-formula/
A fourth way to preserve and create formulas with Fiddler for Sheets, plus some more new methods
follow
https://ramblings.mcpher.com/gassnippets2/fourth-fiddler-formula/
[...]
follow
https://ramblings.mcpher.com/gassnippets2/fourth-fiddler-formula/
follow
https://ramblings.mcpher.com/gassnippets2/fiddler-third/
A third way to preserve formulas with fiddler, plus 2 new methods
follow
https://ramblings.mcpher.com/gassnippets2/fiddler-third/
[...]
follow
https://ramblings.mcpher.com/gassnippets2/fiddler-third/
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/proxy-graphql/
Proxy implementation of Apps Script GraphQL Class
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/proxy-graphql/
[...]
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/proxy-graphql/
follow
https://ramblings.mcpher.com/gassnippets2/formulas-fiddler/
2 ways to create and preserve formulas with fiddler for Google Apps Script
follow
https://ramblings.mcpher.com/gassnippets2/formulas-fiddler/
[...]
follow
https://ramblings.mcpher.com/gassnippets2/formulas-fiddler/
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/exchange/
Currency exchange rates library for Apps Script – optimized for the parsimonious – swop.cx
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/exchange/
[...]
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/exchange/
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/filter/
Sheets Workbook functions in Apps Script – Filter functions
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/filter/
[...]
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/filter/
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/proxy/
Resuscitating the Apps Script execution transcript – JavaScript Proxy and Reflect to the rescue
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/proxy/
[...]
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/proxy/
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/symbols/
ES6 Symbols – what on earth is all that about ?
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/symbols/
[...]
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/symbols/
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/database/
Sheets Workbook functions in Apps Script – Database functions
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/database/
[...]
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/database/
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/sql/
SQL for Apps Script – it’s here
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/sql/
[...]
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/sql/
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/array/
Sheets Workbook functions in Apps Script – Array functions
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/array/
[...]
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/array/
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/iterators/files/
Getting ‘a pile of files’ from Google Drive with Apps Script
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/iterators/files/
[...]
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/iterators/files/
follow
https://ramblings.mcpher.com/gcp/file-drive-and-cloud-storage/apps-script/
Supercharging copying files between Drive and Cloud Storage from Apps Script with Cloud Run
follow
https://ramblings.mcpher.com/gcp/file-drive-and-cloud-storage/apps-script/
[...]
follow
https://ramblings.mcpher.com/gcp/file-drive-and-cloud-storage/apps-script/
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/iterators/
A handier way of accessing Google Drive folders and files from Apps Script
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/iterators/
[...]
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/iterators/
follow
https://ramblings.mcpher.com/gcp/file-drive-and-cloud-storage/
Blistering fast file streaming between Drive and Cloud Storage using Cloud Run
follow
https://ramblings.mcpher.com/gcp/file-drive-and-cloud-storage/
[...]
follow
https://ramblings.mcpher.com/gcp/file-drive-and-cloud-storage/
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/v8-stack/
Apps Script V8: Sorting out the call stack to figure out who called
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/v8-stack/
[...]
follow
https://ramblings.mcpher.com/apps-script/apps-script-v8/v8-stack/
follow
https://ramblings.mcpher.com/gassnippets2/default-method/
JavaScript snippet to create a default method for an object
follow
https://ramblings.mcpher.com/gassnippets2/default-method/
[...]
follow
https://ramblings.mcpher.com/gassnippets2/default-method/
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/dates-and-times/
Sheets Workbook functions in Apps Script – Date and Time and Temporal primer
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/dates-and-times/
[...]
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/dates-and-times/
follow
https://ramblings.mcpher.com/apps-script/temporal-javascript/
Temporal – dates, times and timezones and the proposed new Date system for ECMAScript
follow
https://ramblings.mcpher.com/apps-script/temporal-javascript/
[...]
follow
https://ramblings.mcpher.com/apps-script/temporal-javascript/
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/
Sheets Workbook functions – converted to Apps Script
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/
[...]
follow
https://ramblings.mcpher.com/apps-script/sheets-functions/
follow
https://ramblings.mcpher.com/gassnippets2/apps-script-random-fake/
Random and fake test data in Sheets with Google Apps Script
follow
https://ramblings.mcpher.com/gassnippets2/apps-script-random-fake/
[...]
follow
https://ramblings.mcpher.com/gassnippets2/apps-script-random-fake/
follow
https://ramblings.mcpher.com/google-analytics/proplibusage/
Apps Script – How to track library and script usage
follow
https://ramblings.mcpher.com/google-analytics/proplibusage/
[...]
follow
https://ramblings.mcpher.com/google-analytics/proplibusage/
follow
https://ramblings.mcpher.com/cacheplugins/google-drive-node/
Sharing data between Apps Script and Node using Google Drive back end – 5 minute example
follow
https://ramblings.mcpher.com/cacheplugins/google-drive-node/
[...]
follow
https://ramblings.mcpher.com/cacheplugins/google-drive-node/
follow
https://ramblings.mcpher.com/cacheplugins/drive-async-iterators/
The nodejs Drive API, service account impersonation and async iterators
follow
https://ramblings.mcpher.com/cacheplugins/drive-async-iterators/
[...]
follow
https://ramblings.mcpher.com/cacheplugins/drive-async-iterators/
follow
https://ramblings.mcpher.com/cacheplugins/apps-script-and-node-gcs/
Sharing data between Apps Script and Node using Google Cloud Storage (GCS) back end – 5 minute example
follow
https://ramblings.mcpher.com/cacheplugins/apps-script-and-node-gcs/
[...]
follow
https://ramblings.mcpher.com/cacheplugins/apps-script-and-node-gcs/
follow
https://ramblings.mcpher.com/cacheplugins/apps-script-and-node-github/
Sharing data between Apps Script and Node using Github back end – 5 minute example
follow
https://ramblings.mcpher.com/cacheplugins/apps-script-and-node-github/
[...]
follow
https://ramblings.mcpher.com/cacheplugins/apps-script-and-node-github/
follow
https://ramblings.mcpher.com/cacheplugins/share-node-apps-script/
Sharing data with Upstash between Node and Apps Script – end to example in 5 minutes
follow
https://ramblings.mcpher.com/cacheplugins/share-node-apps-script/
[...]
follow
https://ramblings.mcpher.com/cacheplugins/share-node-apps-script/
follow
https://ramblings.mcpher.com/cacheplugins/
Caching across multiple Apps Script and Node projects using a selection of back end platforms
follow
https://ramblings.mcpher.com/cacheplugins/
[...]
follow
https://ramblings.mcpher.com/cacheplugins/
follow
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/github/
Github as an Apps Script cache platform
follow
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/github/
[...]
follow
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/github/
follow
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/upstash/
Upstash as an Apps Script cache platform
follow
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/upstash/
[...]
follow
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/upstash/
follow
https://ramblings.mcpher.com/apps-script/3-favourite-things/
3 Favourite things in one article – redis, apps script and graphQl
follow
https://ramblings.mcpher.com/apps-script/3-favourite-things/
[...]
follow
https://ramblings.mcpher.com/apps-script/3-favourite-things/
follow
https://ramblings.mcpher.com/vizzy-scrviz/info-card-in-scrviz/
4 ways to customize scrviz info card behavior
follow
https://ramblings.mcpher.com/vizzy-scrviz/info-card-in-scrviz/
[...]
follow
https://ramblings.mcpher.com/vizzy-scrviz/info-card-in-scrviz/
follow
https://ramblings.mcpher.com/vizzy-scrviz/library-id-scrviz/
Find an Apps Script library id in 10 seconds with scrviz
follow
https://ramblings.mcpher.com/vizzy-scrviz/library-id-scrviz/
[...]
follow
https://ramblings.mcpher.com/vizzy-scrviz/library-id-scrviz/
follow
https://ramblings.mcpher.com/vizzy-scrviz/tags/
More scrviz updates to help you enrich your profile and repos
follow
https://ramblings.mcpher.com/vizzy-scrviz/tags/
[...]
follow
https://ramblings.mcpher.com/vizzy-scrviz/tags/
follow
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/onedrive-gas-cache/
Microsoft OneDrive plugin as a cache for Google Apps Script
follow
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/onedrive-gas-cache/
[...]
follow
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/onedrive-gas-cache/
follow
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/gcs/
Google Cloud Storage platform cache plugin for Apps Script crusher
follow
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/gcs/
[...]
follow
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/gcs/
follow
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/
Apps script library with plugins for multiple backend cache platforms
follow
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/
[...]
follow
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/
follow
https://ramblings.mcpher.com/vizzy-scrviz/enrich-scrviz-repo/
Enrich your scrviz repo profiles and drive traffic to your website or blog
follow
https://ramblings.mcpher.com/vizzy-scrviz/enrich-scrviz-repo/
[...]
follow
https://ramblings.mcpher.com/vizzy-scrviz/enrich-scrviz-repo/
follow
https://ramblings.mcpher.com/vizzy-scrviz/scrviz-profile/
Enrich your developer profile on scrviz
follow
https://ramblings.mcpher.com/vizzy-scrviz/scrviz-profile/
[...]
follow
https://ramblings.mcpher.com/vizzy-scrviz/scrviz-profile/
follow
https://ramblings.mcpher.com/vizzy-scrviz/direct-scrviz/
Direct scrviz link to your Apps Script github repo, project or owner
follow
https://ramblings.mcpher.com/vizzy-scrviz/direct-scrviz/
[...]
follow
https://ramblings.mcpher.com/vizzy-scrviz/direct-scrviz/
follow
https://ramblings.mcpher.com/vizzy-scrviz/google-gapi-and-vue-together/
Google gapi, Vue and Vuex together
follow
https://ramblings.mcpher.com/vizzy-scrviz/google-gapi-and-vue-together/
[...]
follow
https://ramblings.mcpher.com/vizzy-scrviz/google-gapi-and-vue-together/
follow
https://ramblings.mcpher.com/vizzy-scrviz/vizzy-clone-apps-script-github/
Find and clone Apps Script projects from github directly into the IDE with scrviz
follow
https://ramblings.mcpher.com/vizzy-scrviz/vizzy-clone-apps-script-github/
[...]
follow
https://ramblings.mcpher.com/vizzy-scrviz/vizzy-clone-apps-script-github/
follow
https://ramblings.mcpher.com/vizzy-scrviz/vizzy-views/
Apps Script Vizzy – new views, searches and filtering examples
follow
https://ramblings.mcpher.com/vizzy-scrviz/vizzy-views/
[...]
follow
https://ramblings.mcpher.com/vizzy-scrviz/vizzy-views/
follow
https://ramblings.mcpher.com/vizzy-scrviz/get-hired-via-vizzy/
Showcase your Apps Script work and get hired via vizzy
follow
https://ramblings.mcpher.com/vizzy-scrviz/get-hired-via-vizzy/
[...]
follow
https://ramblings.mcpher.com/vizzy-scrviz/get-hired-via-vizzy/
follow
https://ramblings.mcpher.com/vizzy-scrviz/vizzy-build-apps-script/
Vizzy github data open access – how to build something with Apps Script
follow
https://ramblings.mcpher.com/vizzy-scrviz/vizzy-build-apps-script/
[...]
follow
https://ramblings.mcpher.com/vizzy-scrviz/vizzy-build-apps-script/
follow
https://ramblings.mcpher.com/vizzy-scrviz/searching-github-gas/
Searching and cataloging Apps Script projects on Github
follow
https://ramblings.mcpher.com/vizzy-scrviz/searching-github-gas/
[...]
follow
https://ramblings.mcpher.com/vizzy-scrviz/searching-github-gas/
follow
https://ramblings.mcpher.com/vizzy-scrviz/
Every Google Apps Script project on Github visualized
follow
https://ramblings.mcpher.com/vizzy-scrviz/
[...]
follow
https://ramblings.mcpher.com/vizzy-scrviz/
follow
https://ramblings.mcpher.com/5-years-in-apps-script-what-a-change-e2/
Google Apps Script – What a difference 5 years make – Episode 2
follow
https://ramblings.mcpher.com/5-years-in-apps-script-what-a-change-e2/
June 21, 2021
follow
https://ramblings.mcpher.com/2021/06/
0
follow
https://ramblings.mcpher.com/5-years-in-apps-script-what-a-change-e2/#respond
[...]
follow
https://ramblings.mcpher.com/5-years-in-apps-script-what-a-change-e2/
follow
https://ramblings.mcpher.com/5-years-in-apps-script-what-a-change/
Google Apps Script – What a difference 5 years make
follow
https://ramblings.mcpher.com/5-years-in-apps-script-what-a-change/
June 15, 2021
follow
https://ramblings.mcpher.com/2021/06/
0
follow
https://ramblings.mcpher.com/5-years-in-apps-script-what-a-change/#respond
[...]
follow
https://ramblings.mcpher.com/5-years-in-apps-script-what-a-change/
follow
https://ramblings.mcpher.com/classes/promises-in-vba/
Promises in VBA
follow
https://ramblings.mcpher.com/classes/promises-in-vba/
[...]
follow
https://ramblings.mcpher.com/classes/promises-in-vba/
follow
https://ramblings.mcpher.com/reactreduxredisfirebase/
React, Redux, Redis, Material-UI and Firebase
follow
https://ramblings.mcpher.com/reactreduxredisfirebase/
[...]
follow
https://ramblings.mcpher.com/reactreduxredisfirebase/
follow
https://ramblings.mcpher.com/color-fiesta/
Color Fiesta
follow
https://ramblings.mcpher.com/color-fiesta/
[...]
follow
https://ramblings.mcpher.com/color-fiesta/
follow
https://ramblings.mcpher.com/automatic-documentation/
Automatic documentation
follow
https://ramblings.mcpher.com/automatic-documentation/
[...]
follow
https://ramblings.mcpher.com/automatic-documentation/
follow
https://ramblings.mcpher.com/gcp/
Google Cloud Platform
follow
https://ramblings.mcpher.com/gcp/
[...]
follow
https://ramblings.mcpher.com/gcp/
follow
https://ramblings.mcpher.com/excel-to-json-and-back/
Excel to json and back
follow
https://ramblings.mcpher.com/excel-to-json-and-back/
follow
https://ramblings.mcpher.com/integratingexcelwithmapsand-earth/
Integrating Excel with Maps and Earth
follow
https://ramblings.mcpher.com/integratingexcelwithmapsand-earth/
[...]
follow
https://ramblings.mcpher.com/integratingexcelwithmapsand-earth/
follow
https://ramblings.mcpher.com/d3-js/
d3.js
follow
https://ramblings.mcpher.com/d3-js/
[...]
follow
https://ramblings.mcpher.com/d3-js/
follow
https://ramblings.mcpher.com/vbagooscript/
Learn how to transition from VBA to Google Apps Script
follow
https://ramblings.mcpher.com/vbagooscript/
Json
follow
https://ramblings.mcpher.com/tag/json/
maps
follow
https://ramblings.mcpher.com/tag/maps/
ephemeral exchange
follow
https://ramblings.mcpher.com/tag/ephemeral-exchange/
JavaScript
follow
https://ramblings.mcpher.com/tag/javascript/
apps script
follow
https://ramblings.mcpher.com/tag/apps-script/
snippets
follow
https://ramblings.mcpher.com/tag/snippets/
Sheets
follow
https://ramblings.mcpher.com/tag/sheets/
Deprecated
follow
https://ramblings.mcpher.com/tag/archived/
Oauth2
follow
https://ramblings.mcpher.com/tag/oauth2/
Scriptdb
follow
https://ramblings.mcpher.com/tag/scriptdb/
excel
follow
https://ramblings.mcpher.com/tag/excel/
github
follow
https://ramblings.mcpher.com/tag/github/
Google Cloud
follow
https://ramblings.mcpher.com/tag/google-cloud/
vba
follow
https://ramblings.mcpher.com/tag/vba/
Apps script snippets
follow
https://ramblings.mcpher.com/tag/apps-script-snippets/
colors
follow
https://ramblings.mcpher.com/tag/colors/
earth
follow
https://ramblings.mcpher.com/tag/earth/
D3
follow
https://ramblings.mcpher.com/tag/d3/
Visualization
follow
https://ramblings.mcpher.com/tag/visualization/
Kubernetes
follow
https://ramblings.mcpher.com/tag/kubernetes/
follow
https://bookauthority.org/books/best-google-books?t=5xhjwb&s=award&book=1491940468
Going GAS made it to the Best Google Books of All Time
follow
https://bookauthority.org/books/best-google-books?t=5xhjwb&s=award&book=1491940468
[...]
follow
https://bookauthority.org/books/best-google-books?t=5xhjwb&s=award&book=1491940468
follow
http://shop.oreilly.com/product/0636920048503.do
Going GAS Video
follow
http://shop.oreilly.com/product/0636920048503.do
[...]
follow
http://shop.oreilly.com/product/0636920048503.do
follow
https://shop.oreilly.com/product/0636920054115.do
Video Course for Beginners
follow
https://shop.oreilly.com/product/0636920054115.do
[...]
follow
https://shop.oreilly.com/product/0636920054115.do
follow
https://shop.oreilly.com/product/0636920045816.do#
Going GAS Book
follow
https://shop.oreilly.com/product/0636920045816.do#
[...]
follow
https://shop.oreilly.com/product/0636920045816.do#
follow
https://developers.google.com/community/experts
here
follow
https://ramblings.mcpher.com/ramblings/sitemap
Enter the blog
follow
https://ramblings.mcpher.com/ramblings-blog/
follow
http://shop.oreilly.com/product/0636920048503.do
follow
http://shop.oreilly.com/product/0636920048503.do
follow
https://shop.oreilly.com/product/0636920054115.do
Twitter
follow
https://twitter.com/brucemcpherson
Github
follow
https://github.com/brucemcpherson/
Youtube
follow
https://www.youtube.com/user/brucemcphercom/
Gitter
follow
https://gitter.im/desktopliberation/community
Slideshare
follow
https://www.slideshare.net/BruceMcPherson1
LinkedIn
follow
https://www.linkedin.com/in/brucemcpherson/