Google Apps Script
Follow
Find
60.3K views | +33 today
 
Scooped by Martin Hawksey
onto Google Apps Script
Scoop.it!

Heatmapping Conversion Rates, Automagically (with Google Apps Script) by David Fothergill

Heatmapping Conversion Rates, Automagically (with Google Apps Script) by David Fothergill | Google Apps Script | Scoop.it

"n this post I will briefly discuss the introduction of automated Google Analytics reports, and then share with you a report I created you that quickly generates a Conversion Heatmap via the GA API" 

 

via Eric Koleda

more...
No comment yet.

From around the web

Google Apps Script
The GAS: All things related to Google Apps Script including examples, news and snippets
Curated by Martin Hawksey
Your new post is loading...
Your new post is loading...
Scooped by Martin Hawksey
Scoop.it!

Use Google Sheets for Multilingual Chat with Speakers of Different Languages

Use Google Sheets for Multilingual Chat with Speakers of Different Languages | Google Apps Script | Scoop.it
Break down the language barrier and have multi-lingual chats with speakers of different languages inside a simple Google Spreadsheet.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

TwtrService: A Twitter API client library for Google Apps Script

The TwtrService library for Google Apps Script centrally stores your Twitter access details allowing them to accessed from multiple script projects without the need for re-authentication.

Martin Hawksey's insight:

This library stores access details as user properties within the library making it easy to use in multiple projects without having to re-authenticate each time

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Displaying analytics data on site pages using Google Apps Script - Desktop Liberation

Displaying analytics data on site pages using Google Apps Script - Desktop Liberation | Google Apps Script | Scoop.it
This post from Apps Script GDE Bruce Mcpherson steps through the process of collecting and displaying page analytics. Here's the details of what's covered: Getting analytics for the site Getting the pages in the site Matching Analytics to sites pagesDealing with recursion Storing options and parameters Database abstraction of site results Retrieving page data from GAS web service Using a canvas in Google sites Working with hyperlinks in canvas Gadget preferences and parameters Light JSONP implementation
more...
Terry Elliott's curator insight, October 5, 7:24 AM

Not just more info, but actionable info.  Better info.

Scooped by Martin Hawksey
Scoop.it!

Large uptick in database abstraction users this week as scriptDB approaches D day

Large uptick in database abstraction users this week as scriptDB approaches D day | Google Apps Script | Scoop.it

"Large uptick in database abstraction users this week as scriptDB approaches D day."

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

#gde  … - Bruce Mcpherson - Google+

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Release Notes September 30, 2014 - Google Apps Script — Google Developers

September 30, 2014
 Highlights include:


* Added the LinearOptimizationService, which allows scripts to model and solve linear and mixed-integer linear programs.
* Add-ons for Google Sheets and Docs can now use most installable triggers, although they still cannot use time-driven triggers (sometimes called clock triggers).
* Added an installable open trigger for Google Docs. Like the installable open triggers for Sheets and Forms, this trigger is similar to the simple onOpen() trigger, but allows the triggered function to call services that require authorization, if the user has authorized the script ahead of time.
* Added several new ScriptApp methods, classes, and enums to support installable triggers in add-ons:
* The UiService widget DocsListDialog now requires that you call DocsListDialog.setOAuthToken(oAuthToken) before calling DocsListDialog.showDocsPicker().

Martin Hawksey's insight:

HT + Steve Webster for highlighting these

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

New Sheets add-on written by Google, Linear Optimization plus new Optimization Service

New Sheets add-on written by Google, Linear Optimization plus new Optimization Service | Google Apps Script | Scoop.it

Steve Webster - Google+:

 

"New Sheets add-on written by Google, Linear Optimization.
https://chrome.google.com/webstore/detail/linear-optimization/goadmgmjlkioggkbpbjlakbjjmlhdpen?utm_source=permalink

Plus, this API is now available in Google Apps Script documentation:
https://developers.google.com/apps-script/reference/optimization/

Read the blog announcement here:
http://googleappsdeveloper.blogspot.com/2014/09/sudoku-linear-optimization-and-ten-cent.html"

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Lessons on monetizing Google Apps Script from Romain Vialard

Lessons on monetizing Google Apps Script from Romain Vialard | Google Apps Script | Scoop.it
"It is possible to sell apps built 100% with Google Apps Script. People are ready to buy items on the add-on stores. It's easy enough to implement in-app purchases. I will certainly continue to propose apps mostly free, with some premium features / more quota for paying users."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Change in Apps Script's DocsListDialog

DocsListDialog is a widget used by only a small fraction of Apps Script projects to provide a Google Drive "file open" dialog in a UI service user interface. In almost all cases, using Google Picker in HTML service is preferable and more secure.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Free Technology for Teachers: Where Have My Google Spreadsheet Scripts Gone? They're Add-ons or...

Free Technology for Teachers: Where Have My Google Spreadsheet Scripts Gone? They're Add-ons or... | Google Apps Script | Scoop.it
"Over the last couple of weeks I have received a bunch of emails from readers who were looking for Google Spreadsheet scripts that they used last year, but cannot find this year. The reason for this is that when Google pushed out the updated Spreadsheets to all Google Apps for Edu domains the script gallery was removed from the "insert" menu in Google Spreadsheets. A few of those scripts are now available as Add-ons, but most are not."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

New hints feature in the Apps Script code editor

New hints feature in the Apps Script code editor | Google Apps Script | Scoop.it

"You may have noticed a new icon in the script editor a couple of weeks ago: a light bulb. This is icon will be grayed out most of the time, but when it lights up it means that our system has some useful information to share about your script, such as performance improvements or warnings about the use of deprecated methods. We collect this data as your script executes, so you won't get any hints until after the first time you've run it."

 

 - Eric Koleda - Google+

more...
No comment yet.
Rescooped by Martin Hawksey from iGeneration - 21st Century Education
Scoop.it!

Google Groups Directory - Google Apps Script Examples

For Google Apps Administrators, deploy this Web App to let your users see the members of each domain Groups / mailing lists.

Via Tom D'Amico (@TDOttawa)
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Back end performance linearity - Google Apps Script

Back end performance linearity - Google Apps Script | Google Apps Script | 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


Via brucemcpherson
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Cloud print connector for Google Apps Script - Desktop Liberation

Cloud print connector for Google Apps Script - Desktop Liberation | Google Apps Script | Scoop.it
" Lenny Cunningham, created this handy Cloud Print Connector for Google Apps Script, using the library from EzyOauth2 - taking some pain out of Apps Script API authentication. "
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Apps Script BetterLog tip: Highlight error rows by using Format > Conditional formatting

Apps Script BetterLog tip: Highlight error rows by using Format > Conditional formatting | Google Apps Script | Scoop.it
BetterLog tip: Highlight error rows by using Format > Conditional formatting
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Do something useful in 5 mins with Google Apps Script ... integrate with Parse.com

Do something useful in 5 mins with Google Apps Script ... integrate with Parse.com | Google Apps Script | Scoop.it
"Here's 2nd in 'do something useful in 5 mins with Google Apps Script'. The first was about how to use a spreadsheet as a database. In case you've got fed up with that by now, here's how to graduate to using a parse.com backend."
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
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…

Via brucemcpherson
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Need a better Twitter Archiving Google Sheet? TAGS v6.0 is here!

Need a better Twitter Archiving Google Sheet? TAGS v6.0 is here! | Google Apps Script | Scoop.it
Amazing to think the TAGS (Twitter Archiving Google Sheet) has been going for over 4 years now. Version 6 is a major code rewrite and the most important new feature is a better setup processes. Re...
Martin Hawksey's insight:

More news about the TwtrService library used in this project to follow

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Installable triggers in add-ons for Google Docs and Sheets - Google Apps Developer Blog

Developers told us they were eager to add installable Apps Script triggers to their add-ons. We're happy to announce that now you can do just that.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Synergyse Blog: Five important updates for Google Apps admins and devs

Synergyse Blog: Five important updates for Google Apps admins and devs | Google Apps Script | Scoop.it

"It’s only Wednesday, but already five updates have been announced this week which impact Google Apps domain admins and developers.  These aren’t the sorts of things most users will be interested in, but administrators should definitely be aware of them.  Take a look and see if your apps or domains will be affected."

Martin Hawksey's insight:

Shared with the Google Apps Script G+ Community by +Jarod King 

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Script - How to find your own files in Google Drive

" The idea is that your Google spreadsheet will connect to your Google Drive account and list down all documents with ownership information. You can easily add more columns to it like size to find documents with a large size. Once the sheet is ready, you can use Filter option (the Funnel icon) to find files owned by you. You can sort the sheet by file name to arrange them alphabetically. "
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

The Register: Hey, scammers. Google's FINE with your dodgy look-a-like apps

Google Apps scripts could fool ANYONE, warns engineer

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Library of Apps Script Snippets & Objects - LASSO

Library of Apps Script Snippets & Objects - LASSO | Google Apps Script | Scoop.it

"Creating coding snippets is the cornerstone of the Google Apps script world, making it increasingly more accessible for JavaScript and many other coders to jump in quickly and return incredibly powerful cloud scripts. Google Sites is also an essential core cloud platform to launch and reference LASSO development."

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Tricks with Awesome Tables, Progress Bars, custom css and filtering Numbers

Tricks with Awesome Tables, Progress Bars, custom css and filtering Numbers | Google Apps Script | Scoop.it
I am a huge fan of Romain Vialard's work especially his "Awesome Table Gadget" and use these extensively in my site for reporting.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Create a Motion Chart gadget using Google Sheets

Create a Motion Chart gadget using Google Sheets | Google Apps Script | Scoop.it
In Google Sheets, you have the option to simply create a chart and display this on your Google Site.  However, if you code this in a gadget, you have lots more potential to customise things.
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Google apps script database abstraction exposed version

Database abstraction – GoogleApps Script Desktop liberation

Via brucemcpherson
more...
brucemcpherson's curator insight, August 19, 9:52 AM

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