Google Apps Script
125.4K views | +5 today
Follow
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!

Can you find your company on the Seattle Startup Map? - GeekWire

Can you find your company on the Seattle Startup Map? - GeekWire | Google Apps Script | Scoop.it

Zachary Cohn and Nick Hughes were planning out the logistics for the next Startup Crawl event in Seattle when they recognized a problem. There wasn't a go-to map to see where startup companies are located in the Seattle area. He [Cohn] wrote a Google apps script to scrape the Seattle 2.0 Index, the online directory of 476 startups in the region. Then, he ran all of the companies through the address lookup service Switchboard.com, exporting them to the Google Map via Batchgeo.

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

Create a custom CRM dashboard using Google Apps Script - Google Apps Developer Blog

Create a custom CRM dashboard using Google Apps Script - Google Apps Developer Blog | Google Apps Script | Scoop.it
"Solve360 CRM integrates with Google services to provide a two-way contact & calendar sync, email sync and a comprehensive Gmail contextual gadget. We use the standard Google Data APIs. However, some of our use cases required us to use Google documents and spreadsheets. Enter Apps Script!. What brought our attention to Google Apps Script was that it allows you to run your application code right within the Google Apps platform itself, where documents can be manipulated using a wide range of native Google Apps Script functions, changing the perspective."
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

FIXED: Issue 634 - google-apps-script-issues - Session.getActiveUser().getUserLoginId() does NOT work for EDU domains - Google Apps Script issues and feature requests - Google Project Hosting

FIXED: Issue 634 - google-apps-script-issues - Session.getActiveUser().getUserLoginId() does NOT work for EDU domains - Google Apps Script issues and feature requests - Google Project Hosting | Google Apps Script | Scoop.it

"This has been fixed/implemented. All EDU domains scripts can now use Session#getActiveUser and get the email address of the user hitting the script.

Please verify and let us know if there are any issues.

Sorry it took a little long."

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

Using Google Spreadsheet/Apps Script and Google Social Graph to get Twitter edges for visualizing in NodeXL and Gephi

Using Google Spreadsheet/Apps Script and Google Social Graph to get Twitter edges for visualizing in NodeXL and Gephi | Google Apps Script | Scoop.it

One of the things I really liked about the network analysis and visualisation tool NodeXL which I wrote about last week was the built-in tools for grabbing data from Twitter. What I didn’t mention at the time was that it can take a long time to get complex network data. Fortunately there is a way to get this information a lot quicker. A separate API is the Google Social Graph API which “makes information about public connections between people easily available and useful” and importantly includes connection information from Twitter. As I’ve already Ported: Tony Hirst’s Using Protovis to Visualise Twitter Connections which uses Social Graph to a Google Spreadsheet it was a quick hack to modify this to take a list of twitter usernames your interested in and create a two column edge list required by NodeXL, Gephi and other network visualisation tools.

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

Script for deleing blank rows in Google Spreadsheet

Here is a Google Apps Script for deleting blank or empty rows in Google Spreadsheet.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Script Project - Web Development Jobs - oDesk

I would like a google apps script written that will process a google spreadsheet which has rows of sales related data (invoice number, customer, ...https://www.odesk.com/.../Google-Apps-Script-Project_~~dbe...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

And the most engaging OUseful.info post is… « MASHe

And the most engaging OUseful.info post is… « MASHe | Google Apps Script | Scoop.it

This one Data Scraping Wikipedia with Google Spreadsheets … If you want to know how I arrived at this conclusion it’s mostly the same process as And the most engaging JISC Project is…, but as well as getting social bookmark/share counts I’m also counting the number of post comments (an important part of engagement)

 

Here’s a copy of the full spreadsheet with 771 analysed links (if you make a copy of this you can see the code in Tools > Script editor)

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

Free Google Apps Script solutions for education from simpleappssolutions.com « MASHe

One of the resources I regularly dip into when Apps Scripting is James Ferreira’s simpleappssolutions.com. When introducing people to Google Apps Script I usually promote James’s work because he offers free consultation to education and non-profits. Today James sent me the following email and with his permission I’m sharing it here

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

Google Apps Script And Getting Site Context

Google Apps Script And Getting Site Context | Google Apps Script | Scoop.it
Google Script UI services enables to create rich UI in Google Sites. There is a bug where there is no way to find out directly where Google Apps Script is embedded in Sites. If you are faced with s...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Spreadsheets as a lean mean social bookmark/share counting machine « MASHe

Yesterday I started looking at pulling social bookmark/share counts for specified urls. What I’ve come up with (or found from elsewhere) is a bunch of Google Apps Script snippets for getting social bookmark/share counts as cell formula.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Prototyping in Google Apps Script to extend functionality

Velosprinter (aka James Ferreira) demonstrates how Google Apps Script core functionality can be extended by using prototyping. In this example from the help forum James demonstrates how a findCell function can be added to getValues to return the location of search terms in an array of cells.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Analytics Data to Google Docs via Google Apps Script « Sarpdoruk TAHMAZ – Personal Blog

I’m writing a script using Google Apps Script to be able to get automated reports every week into a spreadsheet with Google Analytics data. I have been scanning Google Analytics Data Export API and there are many useful information there. Writing the whole code by yourself is a bit exhausting, believe me I’ve tried. Searching on Google, I’ve found a web site, a guy called Mikael Thuneberg written a JS which simply authorizes you with Google Analytics using oAuth and fetches the data you want from your Analytics account then returns an array of information. It is very useful and free, but of course you can donate any amount. Here is the link to that site.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Three new APIs for Google Apps Script (Tasks API, Prediction API, and URL Shortener API )

Three new APIs for Google Apps Script (Tasks API, Prediction API, and URL Shortener API ) | Google Apps Script | Scoop.it

"In January of this year we launched BigQuery integration with Google Apps Script. What we didn’t mention was that we were building this on top of our Google APIs Discovery Service. Thanks to the ease and flexibility of writing clients based on this API, today we’re announcing integration with three more APIs, and revamping our BigQuery support.

 

As of now, we have also integrated the Tasks API, Prediction API, and URL Shortener API in addition to the BigQuery API. You can now include these APIs in your scripts, apps, and sites pages. As with other Apps Script services, we handle all of the server communications as well as authorization, which makes this a great way to build mashups and workflows using our APIs."

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

Visualize Your Data: Charts in Google Apps Script! - Google Apps Developer Blog

Visualize Your Data: Charts in Google Apps Script! - Google Apps Developer Blog | Google Apps Script | Scoop.it

"Charts are a great way to communicate significant amounts of data. We’ve joined forces with the Google Chart Tools team in order to bring a new Charts API to Apps Script. Every day, millions of charts are created, updated, put into presentations, emailed to managers, and published as web pages. Our goal is to automate chart creation in Google Apps and make the sometimes-tedious tasks of chart creation and updating a little more fun!"

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

The art of discovery: Looking at how UK Web Focus, OUseful.info and MASHe interconnect using Google Spreadsheets and NodeXL « MASHe

The art of discovery: Looking at how UK Web Focus, OUseful.info and MASHe interconnect using Google Spreadsheets and NodeXL « MASHe | Google Apps Script | Scoop.it

Moving away from social networks I wanted to discover how Brian Kelly's UK Web Focus, Tony Hirst's OUseful.info and my MASHe are linked together. Previously with my other work using Google Spreadsheets to capture social engagement I’ve imported the sitemap from a site to get a list of posts. I’ve also used Google Apps Script to iterate across this list fetching each post to get additional information. It’s therefore relatively straight forward to grab each post and extract all the links the author has made. 

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

Some Google webinars exploring Google Apps Script in Education « MASHe

If your interested in learning more about Google Apps Script in Education Google are doing some webinars as part of their Google Apps for Education series.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps for EDU how would you use Session.getActiveUser ...

Thread on the Google Apps Script Forum gathering use case scenarios that use  Session.getActiveUser which is currently disabled for EDU users. 

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

Contact Sharing using Google Apps Script | Mapsys.info

Contact Sharing using Google Apps Script | Mapsys.info | Google Apps Script | Scoop.it

"You just created your own contact group in Google Apps Contact Manager and now you want to share this contact group with a few other coworkers (not the entire company). Over the last couple of years, our team at Dito often got this request from our customers. We decided to leverage Google Spreadsheets & Google Apps Script to allow sharing of user’s “personal contact group” with only a select group of coworkers."

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

How to get social share stats in Google Spreadsheet for a list of urls

How to get social share stats in Google Spreadsheet for a list of urls | Google Apps Script | Scoop.it

This post demonstrates how you can use Google Apps Script to get social share counts (Like, Tweet etc) for a list of website urls

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

Google App Engine now officially secure | ZDNet (including Apps Script

Google App Engine now officially secure | ZDNet (including Apps Script | Google Apps Script | Scoop.it
With a new SSAE-16 cloud security certification, Google App Engine is opening its doors to more enterprise customers.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Experts: Video: Creating Custom Functions in Google Spreadsheets with Apps Script

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

Gmail Snooze with Apps Script - Google Apps Developer Blog

In managing our inboxes, one feature that we really wanted was for Gmail to let you “snooze” an email. To snooze an email means to archive it for now, but to have it automatically reappear in the inbox at some specified time in the future. With Apps Script you can extend Gmail yourself to add this functionality and a lot more.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Using multiple scripts in a single project is finally there - Google Apps Script Help

Finally it's possible to use multiple scripts in a single project!
Finally it's possible to employ several people writing the same program!
And finally you don't have to scroll through 5000 lines of code to put down a forgotten semicolon!!!

Thank you Apps Script Developers!!!
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google +1 Button SEO – Getting Bulk Counts with the hidden API | Tom Anthony (in Google Spreadsheet)

Google +1 Button SEO – Getting Bulk Counts with the hidden API | Tom Anthony (in Google Spreadsheet) | Google Apps Script | Scoop.it
We know the search engines are using social shares and likes to impact the rankings. Both Facebook and Twitter have APIs for pulling in Likes and Tweets, but currently we are left without a public API for doing this with Google's +1 button.
No comment yet.