Templated Export allows users to reshape and selectively publish data from Google Spreadsheets in custom formats. The tool is powered by Google App Script which allows integration with Google Spreadsheets using existing authenticated access.
Example uses include: turning data from a spreadsheet into a RSS feed and publishing data from a spreadsheet in JSON format to be used by other tools/services.
Check out the post for installation instructions and demonstration videos
"My last post got me to thinking- if I'm going to write a slight improvement to the google calendar's view interface, what other things would I like to add?
The first thing I'd add would be HTML markup in the description portion of the event. To see what I'm talking about, go make a calendar event, edit it and add to the description. This is a good place to add (say) an assignment for that particular day, but you'll quickly see that you're limited to plain text in this interface. That's highly unsatisfying."
Geocode and get administrative details and geoHash link from a UK postcode directly into an Excel or Google Spreadsheet Following on from the Yahoo GeoCode entry here's another geoCoder - this time using UK post code as input, and providing various UK specific administrative district information. As usual it is implemented as a rest-library member. This a data query API, populating columns in a row in a spreadsheet based on a variable column in the data. You just name the columns to match any data you want to retrieve and go. Here's an example geocoding various random postcodes
"I've been playing around with Google Apps Script lately, and I thought I'd share a small class I wrote to make building user interfaces with the UI Service a little more pleasant. With this library, you can specify an interface through a simple declarative JSON syntax, rather then a lot of chained function calls (or the GUI builder). It also includes some helpers to reduce the amount of code needed to build forms." by Dan Gottlieb via Eric Koleda
Matthew Knight explains why you don’t need to be a genius to make simple digital toys – just build upon the genius of others and make use of Google Apps Script...
In this tutorial Matthew explains how you can use Apps Script to get your Gmail unread count before passing the result to a php server to update your avatar (I reckon you could do the whole thing in apps script)
"Charts are a great way to visualize information. They let you arrange data in meaningful ways, allow you to tell a story, and can really catch the reader's eye. But when dealing with large datasets, visualizing all the data at once can be somewhere between a tough to impossible mission. You usually need to filter the data and concentrate on a specific part that is of interest, and then when you want to see a different part of the data you'll need to filter it again and refresh the view. That's why we're happy to announce the introduction of dashboards in Apps Script, which allow you to compose multiple charts and filters into a single experience!"
"Many people have been asking for a simple way to put Google Analytics data into a Google Spreadsheet. Once the data is inside a Google Spreadsheet, users can easily manipulate Google Analytics data, create new visualizations, and build internal dashboards.
So today we released a new integration that dramatically reduces the work required to put Google Analytics data into any Apps Script supported product, such as Google Docs, Sites, or Spreadsheets."
"If you're creating a course website, you might want to display a calendar of events for that course. A natural consideration is Google Calendar for the actual calendar. This works fine, and has interesting benefits (easy to move events from one day to another) over the traditional "make a big table in MS Word and type dates in manually".
The bummer is, it'd be nice to display the calendar showing things to do for each day in a simple layout. If you add details to the calendar entry, the data is there, but doesn't display in the default views for embedding in your site.
Enter the calendrator. It pulls data from your calendar and formats it in a useful way. To create the calendrator, go to your Google Sites page where you want to embed your calendar. Go to Manage Site - > Apps Scripts and create a new script."
"Time to prep for the Fall semester classes. I typically create a spreadsheet of topics on Google Docs Drive, and for student-ease-of-use I would like to use that data in a Google Calendar. To get these two apps talking, I'm learning Google Apps Script. It is simple to complete https://developers.google.com/apps-script/your_first_script in a matter of minutes, the syntax is quite readable and easy to understand..."
"This app is an experiment in using crowd-sourcing methodology to surface hidden gems from the blogosphere. Topics covered include Collective Intelligence, Information Architecture, Cloud Computing, Big Data, Social Computing, Enterprise 2.0, Symbiotic Intelligence and more."
Here's a Google Spreadsheet template I've developed from some leftovers which pulls data together from comment feeds, Twitter and Delicious (with social counts for these plus Facebook, LinkedIn and Google+)...
"How can teachers harness all the awesomeness, ubiquitous access, and collaborative authoring power made possible by Google Docs without creating a document management nightmare? Solution
Written by an educator for educators, the free doctopus script gives teachers the ability to auto-generate, pre-share, and manage grading and feedback on templated Docs for group and individual projects."
Today Tony Hirst posted Data Shaping in Google Refine – Generating New Rows from Multiple Values in a Single Column. Coincidently I faced a similar problem today working with a Google Spreadsheet so thought I’d share my solution.