refaha.blogg.se

This course is designed for the absolute beginner, meaning no previous experience with Google Apps Script is required. 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. Somewhere to keep those API keys: google apps script rest library entryĪPI library entry of the day: use to see how websites are built Keeping all those Google Apps script ‘shortcuts’ under control

Google Apps Script – a new day – a new featureĭelegating processing to the cloud from Excel and other platforms Publishing Google Apps Script code snippets Google Apps Script Liberation – publishing your stuff Using Google Cache to persist data across function calls Publishing and prettifying Gists through google apps script Selecting specific Gist and GAS functions for publication Select, prettify publish snippets in multiple languages from within a GIST module Zoomable d3.js partition charts straight from Excel Publish and prettify source directly from a url Selecting and publishing a function from a web source Playing around with awarding badges on sites I’m awarding badges – Google Apps Script integration with Persona and Mozilla Openbadges Scraperwiki horsemeat data to Sankey, via Excel.Ĭan you make any adSense money with a blog ?Ĭalculating a friendly font color based on the fill color – Google Apps Script Unused tube stations: discovered via scraperwiki- mapped with Excel and Google Maps Strings and the garbage collector in VBA : optimizing string concatenationĪPI of the Day: facebook fql direct from Excel and Google APPsĪdventures in serializing VBA classes – automatically documenting your modules Inherit link colors from cells – D3 sankey from Excel VBA string manipulation optimization with custom classes Playing around with Color on Google Apps ScriptĮxample of automatic code updating for VBA VBA procedures for CIE LabLch and HSL color scheming Using jSon/javaScript like structures in VBA Google Apps Script Color Space Conversions.Īutomatic documentation from VBA – including function arguments Google Apps Script “execution time exceeded” woes Very interesting GAS performance results – run locally using htmlserviceĮxecuting Google Apps Script Code directly in javascript – GAS as a CDN More playing around with color,, scriptDb and Google Apps Script Mashing up electoral data – follow on from oUseful postįinding nearest match and other palettes in other fixed color schemes Visualization of Sites to Tags with d3.jsĭigest authentication and Google Apps ScriptĬonnections in electoral data – D3 and VBA follow on from oUseful post

Google Fusion Big Data and D3 integration: flight data visualization Sankey diagrams direct from Excel – updateĮxploring blogs and sites by d3 tag visualization and effect on site visits Using ScriptDB as a noSQL database for non-Google Apps Script clientsĬoncept browser for site navigation with d3 What does Google Autocomplete show all over the world ? Pinyin Tone converter – Google Apps Script custom functions Validation and lookups using shared scriptDB lists REST access to list management cloud based functions – plus a VBA example Mitigating for changes in REST API rules and formatsĮxcel custom functions that can lookup data in Google Apps Script ScriptDB Tracking your Excel Workbooks with Google Analytics Shared Encryption/decryption library for Google Apps Script.

Get post data from Blogger into a google Spreadsheet with the Google Blogger APIĪccessing and scriptDB noSQL databases from Excel Google Apps Script Content Service – Cross Domain Puzzle More cool stuff you can do with Google Apps ScriptDbĪre the new Google Sheets faster than the old? Google Universal Analytics – getting insight into desktop apps too I’ve just been recognised as a Google Developer Expert as a substitute for ScriptDB in Google Apps ScriptĮurovision song contest voting oddities – interactive visualization Using universal analytics to track your Google Apps Script library usage How many requests a second can you throw at your Google Apps Script webapp Google Apps Script locking and optimum wait times and the golden ratio Some best practise notes on DbAbstraction usage Running JavaScript directly from Excel makes ‘going Google’ easier Targeting training material for Google Apps ScriptersĪ belated post – 2015 – a year in Apps Script What I’ve learned from my first play around with BigQuery/Sheets integration Using an Apps Script webapp to distribute assets Use a spreadsheet as a database in 5 minutesĢ018 – yet another year in and out of Google Apps ScriptĪpps Script Back end platform – some thoughts on a different approachĪpp Maker – Build engaging custom apps on G Suite with minimal coding Google Apps Script – What a difference 5 years make Google Apps Script – What a difference 5 years make – Episode 2