Google Apps Script
Follow
Find
72.6K views | +15 today
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!

XML changes in Apps Script - Google Apps Developer Blog

"Many developers have come to prefer JSON for data serialization, but we recognize that good ol' XML is still an important format for many Apps Script users. Our existing XML service is good at parsing XML, but has limited ability to create or alter existing documents. In order to provide a more complete and consistent experience, we have created a new XML service, which launches today. The new service is accessed using XmlService, in contrast to the old service which was simply called Xml."

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

MySQL exporter for Google Sheets using Apps Script

If anyone is looking for a MySQL exporter for Google Sheets +Ralf Haring has extended +Pamela Fox 's JSON exporter

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

Canvas API Sheet - Google Apps Script Library/Template to interact with Canvas VLE

Canvas API Sheet - Google Apps Script Library/Template to interact with Canvas VLE | Google Apps Script | Scoop.it

"This is a script to let you populate Google Spreadsheets with Canvas API data" 


Template with the code is here https://docs.google.com/spreadsheet/ccc?key=0AqXrX8DLjV-DdEhTcFVDSTRtOHJsbmQ2VE5IVTBoamc#gid=1


Via @whitmer

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

Andrew Stillman - Help crowdsource fun "Learn to Code" project ideas for MS/HS students in Apps Script!

Andrew Stillman - Help crowdsource fun "Learn to Code" project ideas for MS/HS students in Apps Script! | Google Apps Script | Scoop.it

"Apps Script Comrades::  Help crowdsource fun "Learn to Code" project ideas for MS/HS students in Apps Script!"

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

Requesting Google Groups in a Domain through Apps Script - Google Apps Developer Blog

"During a recent Google Apps migration project, we received several requests to create custom groups of contacts so that users could more easily email frequent collaborators. Before switching to Google Apps, users created their own private distribution lists — but this approach led to overlapping groups that quickly fell out of sync.

 

The problem was a perfect case for Google Apps Script. We built a great solution that gives users as much power as possible with just a quick administrator review."

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

This Script Converts Google Documents to Markdown for Easy Exporting

This Script Converts Google Documents to Markdown for Easy Exporting | Google Apps Script | Scoop.it
"We've shown you the wonders of Markdown as great for your to-do lists and notes. If you love Markdown too but you're stuck with a bunch of Google docs that aren't in the format (but need to be), this Google Apps Script converts them instantly."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Script BetterLog Library - extend the native Logger with one line of code - Google Apps Script Examples

Google Apps Script BetterLog Library - extend the native Logger with one line of code - Google Apps Script Examples | Google Apps Script | Scoop.it
"The BetterLog library extends the native Logger with one line of code and gives you additional features like logging to a spreadsheet and more."
more...
brucemcpherson's curator insight, June 4, 2013 3:33 AM

Nice addition for published scrapps web apps

Scooped by Martin Hawksey
Scoop.it!

Google Apps Script Quickstart - Schemas in Gmail — Google Developers

"

Gmail uses schema.org markup to accelerate user actions and to highlight the most important information users need from an email.

Gmail supports 4 types of actions and 1 interactive card:

RSVP Action for eventsReview Action for restaurants, movies, products and servicesOne-click Action for just about anything that can be performed with a single clickGo-to Action for more complex interactionsFlight interactive cards

"

Martin Hawksey's insight:

This tutorial shows how you can use Schema in Gmail with Apps Script

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

Using Google Apps Script for automation of small tasks | Nimble Gecko

" My goal was simple – get a search results page from seek.com.au, load it as DOM, run a CSS select to find the element that I need and write the value of that element into a spreadsheet that I use for tracking/analysis."
more...
brucemcpherson's curator insight, May 29, 2013 6:57 AM

very straightforward intro to scraping with GAS

Scooped by Martin Hawksey
Scoop.it!

Google Apps Script Playlist for I/O Presentations, Unscripted sessions and other videos

Google Apps Script Playlist for I/O Presentations, Unscripted sessions and other videos | Google Apps Script | Scoop.it

"Recordings of Google Apps Script office hours, I/O presentations, and other videos for developers."

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

Chris Raymond - Google+ QuizPresenter - Google Apps Script in Education

Chris Raymond - Google+ QuizPresenter - Google Apps Script in Education | Google Apps Script | Scoop.it

"The goal is to make a test component that pulls questions from a bank based on tags and assigned student.  You can make questions from a UI or in the spreadsheet.  I think with the hints, answers, reference, explanation widgets I'm (will) building, it will still be better than what can be built in the new FormApp tools. Please offer feedback or let me know if someone has already built a tool like this."

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

Playing with Google Docs sidebar using Google Apps Script

Playing with Google Docs sidebar using Google Apps Script | Google Apps Script | Scoop.it
The Google Apps Script team have recently announced a host of new features. The three that caught my eye were: Script editor added to Google Docs and Forms Addition of the Forms Service which lets ...
Martin Hawksey's insight:

Thought I'd try out sidebar in Google Docs by replicating the MS Word Navigation Pane/Document Map. Didn't get jump navigation to work but reckon with a bit of jQuery I could get it to change document structure. Useful to find the current limitations.

more...
brucemcpherson's curator insight, May 19, 2013 4:42 AM

it's only onlybeen available for 2 days, and already Martin Hawksey has fiddled with it... ;)

Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

cDataSet primer - Abstracting Excel and Google Spreadsheet data from physical location

These VBA and Google Apps Script classes abstract data from its location on its underlying worksheet. This means that all procedures that use that data no longe

Via brucemcpherson
more...
brucemcpherson's curator insight, July 4, 2013 7:45 AM

data abstraction primer slides for cDatset classes on VBA and Google Apps Script 

Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Using ScriptDB as a noSQL database for non-Google Apps Script clients

"Here's how to query a scriptDB using 'query by example' and get jSonp results back to any web app."


Via brucemcpherson
more...
brucemcpherson's curator insight, July 9, 2013 1:17 PM

Here's how to query a scriptDB using 'query by example' and get jSonp results back to any web app. 

Scooped by Martin Hawksey
Scoop.it!

Using Google Spreadsheets as a Google Analytics Data Bridge

Using Google Spreadsheets as a Google Analytics Data Bridge | Google Apps Script | Scoop.it

"Access control to Google Analytics data is very coarse. Via the web interface you can have full access or none at all. Given the growing interest in data driven decision making at all levels of the institution I thought it would be beneficial to demonstrate how Google Spreadsheets and Google Apps Script could be used to selectively distribute Google Analytics data."

more...
brucemcpherson's curator insight, July 3, 2013 4:00 AM

Well constructed analytics and google spreadsheets mash up from Martin hawksey

Scooped by Martin Hawksey
Scoop.it!

Apps Script Crash Course: Import/Export Apps Script Code

"In this special GDL, you'll learn how to use the new Drive API capability to import and export Apps Script code. This will allow developers to write tools to work in other development environments other than the Script Editor and also integrate with source controls."

more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Exploring blogs and sites by d3 tag visualization and effect on site visits

Exploring blogs and sites by d3 tag visualization and effect on site visits | Google Apps Script | Scoop.it

Via brucemcpherson
more...
brucemcpherson's curator insight, June 26, 2013 1:27 PM

A few weeks ago I showed a way of navigating sites using a d3,js visualization generated from Google Apps Script. Now I see a big jump in sites visits coming from that source. Now I've added blogger navigation, and combined navigation of multiple sites. Here's the background

Scooped by Martin Hawksey
Scoop.it!

Exporting a Google Spreadsheet as JSON

Exporting a Google Spreadsheet as JSON | Google Apps Script | Scoop.it
" I frequently use Google Spreadsheets as a lightweight database, by setting up some columns, encouraging my colleagues to update it, and subscribing to notifications of changes. Then I export the spreadsheet as JSON and update a json file in our codebase. Sometimes I also just use the jsonp output of a published spreadsheet, but if I'm worried about performance or the information getting mis-updated, then I'll use the export-and-update approach. In order to export it as JSON, I used to use a Google Spreadsheets Gadget but now that those are deprecated, I use a Google Apps Script."
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Excel Liberation.: Visualization of Sites to Tags with d3.js (Google Apps Script)

Excel Liberation.: Visualization of Sites to Tags with d3.js (Google Apps Script) | Google Apps Script | Scoop.it

Here's the complete implementation of site explorer using d3.js, and tag data generated by Google Apps Script from a Google Site


Via brucemcpherson
more...
brucemcpherson's curator insight, June 3, 2013 2:23 PM

This can be generated directly from Excel, or not.

Scooped by Martin Hawksey
Scoop.it!

Learning Technologies: Getting Stuff Done with Google Apps Scripts

Learning Technologies: Getting Stuff Done with Google Apps Scripts | Google Apps Script | Scoop.it

"A while back Jo Gilham wrote a blog post about using Google App Scripts to automate certain process related to the university VLE. App scripts are little bits of code that are inserted into an app such as Google Docs, Spreadsheets or Forms that will trigger certain events: for example, it will send a templated email/document when certain conditions are fulfilled such as someone completing a form. I remember reading it and thinking I would love to try this but I’ve always been put off by anything that looks remotely like programming code."

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

Analyzing site content with Google Apps Script - Excel Liberation

Analyzing site content with Google Apps Script - Excel Liberation | Google Apps Script | Scoop.it
"One the things I wanted to play around with was visualizing this site content with d3. But first I needed to create something which would generate data from the site (any domain site actually). It's easy enough to modify for non-domain sites but I'm starting with domains, since that's what I have."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Down with file attachments! Hail to the Google Docs API update

Down with file attachments! Hail to the Google Docs API update | Google Apps Script | Scoop.it
With massively refreshed Google Docs/Drive APIs, use JavaScript to integrate to your heart's content, create new apps
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Creating a 'full fat' RSS feed for Google Gmail labels (enabling some dark social judo)

Creating a 'full fat' RSS feed for Google Gmail labels (enabling some dark social judo) | Google Apps Script | Scoop.it

In this post I want to cover three things. First I want to introduce a little app I’ve developed which allows you to create a RSS feed for any of your Gmail labels (with the option to remove certain links – useful if you don’t want others unsubscribing you from mailing lists). Secondly I explain how it was made and how you can use it yourself. Finally I want to discuss how this could be used in an open course environment, utilising the vast processing power from services like Twitter and reusing there target marketing emails to your benefit with a bit of ‘dark social judo’.

more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Digest authentication and Google Apps Script

Digest authentication and Google Apps Script | Google Apps Script | Scoop.it

"The other day I was looking around for an example of how to do digest authentication in Google Apps Script (or even plain javascript). I found plenty of theoretical discussions on it, but no actual examples. So here's an implementation walkthrough. ...

What is Digest AuthenticationWorking with GAS, you'll probably be more familiar with oAuth2, which is supported well through the UrlFetchApp class. However some APIS still use Basic authentication, or the slightly more secure Digest Authentication"
Via brucemcpherson
more...
brucemcpherson's curator insight, May 21, 2013 7:03 PM

The other day I was looking around for an example of how to do digest authentication in Google Apps Script (or even plain javascript). I found plenty of theoretical discussions on it, but no actual examples. So here's an implementation walkthrough and code.