desktop liberation
Follow
Find
15.4K views | +4 today
 
Scooped by brucemcpherson
onto desktop liberation
Scoop.it!

Excel Liberation.: Shared Encryption/decryption library for Google Apps Script.

brucemcpherson's insight:
Amit Agarwal recently showed how to encrypt/decrypt Email messages using a Google Apps Script application in this post  The encryption method he used is SJCL, maintained by the Stanford Security Lab, and available on GITHUB here. I needed something like that for Google Apps Script version of a parse.com API (here's the VBA version) that I'm just finishing up, so I thought I may as well share out the library.
more...
No comment yet.
desktop liberation
Your new post is loading...
Your new post is loading...
Scooped by brucemcpherson
Scoop.it!

Do something in 5 with gas 7-email log

number 7 in do something useful with Google Apps script, covers how to search gmail for threads matching a topic and log recipients to a spreadsheet.
more...
No comment yet.
Rescooped by brucemcpherson from Google Apps Script
Scoop.it!

TwtrService Example: EasyTweetSheet (lets you send tweets from Google Sheet)

TwtrService Example: EasyTweetSheet (lets you send tweets from Google Sheet) | desktop liberation | Scoop.it
Very basic Google Sheet template to let you draft tweets which are published to Twitter when you click a link.

Via Martin Hawksey
more...
Martin Hawksey's curator insight, October 30, 12:21 PM

Following the publication of TwtrService (Google Apps Script client library for Twitter) here's a basic Google Sheet template we use at +ALT to draft tweets we send during events (instead of just sending them on a schedule we have to control to click a link to send)

Scooped by brucemcpherson
Scoop.it!

Do something in 5 with gas 4- Get your analytics profiles to a spread…

Another in the 'do something useful with Google Apps Script' series. This time you'll see how to use the Analytics service and use exponential backoff to mitig…
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Do something in 5 with gas 2-graduate to a database

Here's how to migrate your backend Google Apps Script spreadsheet to a parse.com database in a few minutes.
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Google apps script database abstraction exposed version

Database abstraction – GoogleApps Script Desktop liberation
brucemcpherson's insight:

Here's a VBA API that uses Google Apps Script to access a variety of cloud based databases directly from Excel/VBA.

 

http://ramblings.mcpher.com/Home/excelquirks/dbabstraction/jsaonapivba

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Datastore driver - Desktop Liberation

Datastore driver - Desktop Liberation | desktop liberation | Scoop.it

the Google Cloud Datastore driver for Google Apps Script database abstraction.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Using named locks with Google Apps Scripts - Desktop Liberation

Using named locks with Google Apps Scripts - Desktop Liberation | desktop liberation | Scoop.it
Liberate Excel data from the desktop
brucemcpherson's insight:

Here's a gas library to  enable locking of named resources. Sounds obscure, but actually very useful.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Minimizing maps directionfinder api calls

Minimizing maps directionfinder api calls | desktop liberation | Scoop.it
Liberate Excel data from the desktop
brucemcpherson's insight:

If you are using the Maps.Directions API, and plotting many source/destination points, you may be hitting quota problems (too many calls in too short a time, maximum daily allowance). Here's how to automate the use of waypoints to make your quota go further - reducing the number of API calls required by as much as x 20. 

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Parse.com as a substitute for ScriptDB in Google Apps Script

Parse.com as a substitute for ScriptDB in Google Apps Script | desktop liberation | Scoop.it
brucemcpherson's insight:

As you will know by now, ScriptDB is now deprecated. A year or so ago, I published some articles on alternatives to ScriptDB on the desktop liberation site, one of which was Parse.com. This has turned out to be one of the most popular topics. Here's how to get started and get your data off scriptDB.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Rasenball World Cup 2014 Visualization

Rasenball World Cup 2014 Visualization | desktop liberation | Scoop.it
Visualization for the World Championship (Amazing #html5 #D3.js web/mobile application - Everything you need to know about the #2014 #FIFA World Cup http://t.co/jv7HRTzw2X)...
brucemcpherson's insight:

I'm not interested in football, but this is a great viz.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Flattening and unflattening objects to spreadsheets - Desktop Liberation

Flattening and unflattening objects to spreadsheets - Desktop Liberation | desktop liberation | Scoop.it

here's how to flatten and unflatten JavaScript objects so they fit in a Google Spreadsheet

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Comment on Hacking the Google Trends API by curious

Comment on Hacking the Google Trends API by curious | desktop liberation | Scoop.it
Hi There.
Great article.
I am looking to analyze as much details I can get for the hot trending topics on the internet (google, Twitter, FB, Bing) etc. As much analytics as I can get would be awesome.
more...
No comment yet.
Rescooped by brucemcpherson from Google Apps Script
Scoop.it!

Big Data, Small Insights | LinkedIn

Big Data, Small Insights | LinkedIn | desktop liberation | Scoop.it

"The integration to Virtual PBX is a custom gateway designed to harvest PBX call data logs and filter them based on calls associated with reservations extensions. I used Google Apps Script to automate the update of call data in near-real-time despite the fact that a formal API is not available from this PBX provider.

 

The data is stored into a 13 column spreadsheet capable of handling approximately 25,000 calls per month with a ceiling of about two years worth of data. All processes and integration with Virtual PBX is handled by Google Apps Scripts (GAS) and available as an installable service"


Via Martin Hawksey
brucemcpherson's insight:

great mash up of GAS & Analytics and other stuff.

more...
Martin Hawksey's curator insight, November 27, 4:48 AM
Bill French, Founder and Editor at iPadCTO outlines how they use Google Apps Script for custom data collection and reporting
Scooped by brucemcpherson
Scoop.it!

Do something useful in Apps Script 5. Get your analytics pageviews to…

Here's how to build on previous tutorials to get your Google Analytics PageView data into a Spreadsheet.
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Do something in 5 with gas 3-simple invoicing app

quick 5 minute tutorial. join multiple databases and create personalized email invoices with google apps script
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Do something in 5 minutes with gas 1-use spreadsheet as database

Here's one in a series of tutorials where you can do something useful from scratch in 5 minutes using Google Apps Script. This example shows how to use a Googl…
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Back end performance linearity - Google Apps Script

Back end performance linearity - Google Apps Script | desktop liberation | Scoop.it

I have a number of backends database all abstracted so they use the same code. Google Apps Script code. Here's the top 5 measured for performance linearity

more...
No comment yet.
Rescooped by brucemcpherson from Google Apps Script
Scoop.it!

Parallel processing in Apps Script - Desktop Liberation

Parallel processing in Apps Script - Desktop Liberation | desktop liberation | Scoop.it

" There's no getting away from the fact  that Apps Script is slower than the equivalent client based JavaScript processing. It is fundamentally synchronous in implementation, and also has limits on processing time and a host of other quotas. For a cloud based, free service that's about extending Drive capabilities rather than being scalable in the manner of Google App Engine, I suppose it's normal. But let's see if we can at least subvert at least these two things: * get over the 6 minute maximum execution time for Apps Script *run things in parallel "


Via Martin Hawksey
more...
Martin Hawksey's curator insight, June 30, 7:54 PM
More magic from Bruce Mcpherson
Scooped by brucemcpherson
Scoop.it!

EzyOauth2 - taking some pain out of Apps Script API authentication

EzyOauth2 - taking some pain out of Apps Script API authentication | desktop liberation | Scoop.it
Liberate Excel data from the desktop
brucemcpherson's insight:
If you are writing Apps Script webapps and accessing some of the Google JSON APIs services, you're going to need to deal with oAuth2. This library using the statetokenbuilder should help get it right first time.  
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

C3.js | D3-based reusable chart library

D3 based reusable chart library (C3.js is a D3-based reusable chart library.
brucemcpherson's insight:

Another d3.js library . looks good.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Chaining JavaScript - Google Apps Script

Chaining JavaScript - Google Apps Script | desktop liberation | Scoop.it

Chaining examples for GAS

brucemcpherson's insight:

This example shows how to get data from a Fusion table, summarize and sort it, and write it out to a spreadsheet in 'one line' of code. 

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Google's Quantum Computing Playground turns your PC into a quantum computer - ExtremeTech

Google's Quantum Computing Playground turns your PC into a quantum computer - ExtremeTech | desktop liberation | Scoop.it
ExtremeTech
Google's Quantum Computing Playground turns your PC into a quantum computer
ExtremeTech
... not quite: You can simulate a quantum computer on your PC by running the Quantum Computing Playground web app for Chrome.
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

APIs.io and APIs.json Launched at Gluecon to Make API Discoverability More Like Search

APIs.io and APIs.json Launched at Gluecon to Make API Discoverability More Like Search | desktop liberation | Scoop.it
A new API Discoverability search engine and a robots.txt type-format have been launched today at Gluecon.
brucemcpherson's insight:

I hope this takes off .. discoverable APIS will be a defining feature of the future web.

more...
No comment yet.
Rescooped by brucemcpherson from Google Apps Script
Scoop.it!

Integrating import.io with Google Apps Script

An introduction into how Google Apps Script can be used with the import.io web data extraction service.


Via Martin Hawksey
more...
Martin Hawksey's curator insight, May 22, 9:23 AM

This post has resulted in a importio client library opening the way for more easy integrations http://support.import.io/knowledgebase/articles/367423