"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."
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.
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...
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)
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
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.
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.
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.
If you’re running a Youtube account, how might you collect Insights data for all your videos as spreadsheet entries that can be used in the preparation of reports about your social media effectiveness?
I haven’t actually got round to getting any data out of my YouTube account and into a Google spreadsheet yet, but I have dome the first step, which is to set up the authentication using OAuth. Here’s the Google Apps script I used…
"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!"
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.
"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."
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.
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!!!
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.
The Session.getActiveUser() service is currently not available for Google Apps for Education but is if you are a Business user. So Google trusts business users not to scrape fellow employee email addresses but not students.
Details of this issue have been logged (Issue 538). Please vote for this ticket if you would like to see the feature re-enabled.