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

Neo4j Blog: Gmail Email analysis with Neo4j - and spreadsheets

Neo4j Blog: Gmail Email analysis with Neo4j - and spreadsheets | Google Apps Script | Scoop.it

"In this blog post, we’ll take a look at how we can actually use Romain’s [Gmail Meter] output, and generate a neo4j database that will allow us to visually and graph-ically explore the email traffic in our gmail inboxes - without doing doing any coding of course"

more...
luiy's curator insight, April 27, 2013 2:33 PM

A bunch of different graphistas have pointed out to me in recent months that there is something funny about Graphs and email. Specifically, about graphs and email analysis. From my work in previous years at security companies, I know that Email Forensics is actually big business. Figuring out who emails whom, about what topics, with what frequency, at what times - is important. Especially when the proverbial sh*t hits the fan and fraud comes to light - like in the Enron case. How do I get insight into email traffic? How do I know what was communicated to who? And how do I get that insight, without spending a true fortune?

So a couple of days ago I came across an article or two that features Gmail Meter. This is of course not one of these powerful enterprise-ready forensics tools, but it is interesting. Written by Romain Vialard, it provides you with a really straightforward way to get all kinds of stats and data about your use of Gmail. It does so using a Google Apps Script, that is available to anyone using Google Docs’ spreadsheet functionality. In this blog post, we’ll take a look at how we can actually use Romain’s output, and generate a neo4j database that will allow us to visually and graph-ically explore the email traffic in our gmail inboxes - without doing doing any coding of course. Because I don’t know how to do that - but I do do spreadsheets, as you know by now.

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!

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

TwtrService Example: EasyTweetSheet (lets you send tweets from Google Sheet) | Google Apps Script | Scoop.it
Very basic Google Sheet template to let you draft tweets which are published to Twitter when you click a link.
Martin Hawksey's insight:

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)

more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
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

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

A Google Apps Script to make a QR code for every document in a Google Drive Folder

A Google Apps Script to make a QR code for every document in a Google Drive Folder | Google Apps Script | Scoop.it
" Someone shared this on G+ the other day, and I thought it was really wonderful. Just make a copy of this spreadsheet and you will be able to designate a Google Drive folder to pull from in order to create a QR code for every document in that folder."
Martin Hawksey's insight:
Given the number of files I have in some folders this may time out for me ;)
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Call for Google Apps Script 5 minute tutorials

Call for Google Apps Script 5 minute tutorials | Google Apps Script | Scoop.it
Bruce McPherson: "I'm looking for your submissions to this series.. Anybody want to do a tutorial on something useful you can do in 5 minutes with apps script ?" 
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Developer Blog: Introducing Add-ons for Google Forms

" Google Forms is a free and simple way to collect information — from quickly polling your friends about who'll be attending your trip to the haunted hayride, to getting thousands of responses to an awareness survey for work. Over the last few months, Forms has been getting a bunch of updates to help you make good looking surveys, like new theme choicesand the ability to create your own personalized themes. To give you even more flexibility and options, we’re introducing add-ons for Forms—new tools, created by developer partners, that deliver even more features to your surveys (just like add-ons for Docs and Sheets)."
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!

Orange Coding: GmailSearchBuilder - A Google Apps Script Library

Orange Coding: GmailSearchBuilder - A Google Apps Script Library | Google Apps Script | Scoop.it
A Google Apps Script service for building Gmail search queries
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Awesome Table + Templates = more awesomeness - Google Apps Script Examples

Awesome Table + Templates = more awesomeness - Google Apps Script Examples | Google Apps Script | Scoop.it

"Awesome Table lets you easily display data from a Google Sheet in many different ways. You can even put some HTML tags in your spreadsheet cells to create beautiful views of those data and display a nice People Directory, Job Board, Training Offering or whatever list you need to display on a site."

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

Free Technology for Teachers: How to Enable and Set Limits on Your Google Forms

Free Technology for Teachers: How to Enable and Set Limits on Your Google Forms | Google Apps Script | Scoop.it
" FormLimiter allows you to set a time for a form to automatically stop accepting responses. You can also use FormLimiter to set a limit on number of responses a form will accept."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

New Google Apps Script Add-on: g(Math) for Forms

New Google Apps Script Add-on: g(Math) for Forms | Google Apps Script | Scoop.it

"g(Math) for Forms has the same functionality as g(Math) for Docs and Sheets. You can create math expressions, graphs, and statistical displays and insert them directly into your Form questions."

more...
No comment yet.
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.