Google Apps Script
Follow
Find
54.6K views | +111 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!

Simplifying Migration from VBA to Google Apps Script - Google Apps Developer Blog By Bruce Mcpherson

Simplifying Migration from VBA to Google Apps Script - Google Apps Developer Blog By Bruce Mcpherson | Google Apps Script | Scoop.it

If you are new to Google Apps Script and the JavaScript programming language, migrating legacy automation code written in Microsoft's Visual Basic for Applications (VBA) can be a daunting task. This blog post describes a Google Apps Script library which mimics the behavior and calling structure of common VBA functions, allowing you to more easily convert your existing applications.

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

Google Apps Script for HTML email with Google Maps API plug-in by L. Brent Gilmore

Google Apps Script for HTML email with Google Maps API plug-in by L. Brent Gilmore | Google Apps Script | Scoop.it

"My wife and I recently moved into a new house. We needed to send an address update to our contact list but didn't want to go through a printer then stuffing, sealing, stamping and writing out addresses. Given my love of all things Google and my new found curiosity of Google Apps Scripts I wanted to use a Script to:
- Send and HTML email; nice design and picture of the house
- Email our entire contact list in one send
- I wanted it to be free and send from my personal email address
- Use personalization; Dear William
- Google Maps integration 

Queue a Google Apps Script and the deign stylings of my buddy +William Hodges. With the script I was able to:
- Create a custom HTML design
- Email our entire list from my Gmail account
- Include personalization
- Provide a Google Map and driving directions from the recipients address to our new address"


via Eric Koleda

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

Apps Script Developer Chat: Andrew Stillman — Google Developers

Apps Script Developer Chat: Andrew Stillman — Google Developers | Google Apps Script | Scoop.it

Recording of "chat with Andrew Stillman, the developer of several popular scripts in the Script Gallery, such as formMule, formMutant, autoCrat, doctopus, and more."

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

Eforcers S.A.: Building a Google Apps Script Web App (polling app), Part 1

Eforcers S.A.: Building a Google Apps Script Web App (polling app), Part 1 | Google Apps Script | Scoop.it
" the Apps Script version of the Django framework reference tutorial: the Polls web app. Doing this will help us understand how to write a complete Web application from the UI to the database.

The poll app is very very simple, it’s like a CRUD hello world. The domain model is made of a Poll class (a question) which have associated many Choices (or possible answers for the poll’s question), the user is presented with the available polls list when he click in one of them is redirected to the poll detail with the different choices as options, the users vote for the best choice and finally the results are presented, number of votes for each one of the choices."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google App Script: Scheduling timed triggers JISC CETIS MASHe

Within Google Apps Script you can create basic time-based triggers (poor mans cron) to run functions on specific date/time intervals. Recently on one of my posts someone asked: ‘Is there a way to schedule when the script runs?’. In particular they were interested in running a particular function every 10 minutes for a set period. I did briefly look at scripting time-based triggers, but quickly realised that my original plan to control a number of timed triggers from a central spreadsheet wasn’t possible because the class TriggerBuilder doesn’t allow forSpreadsheet on TimeBased triggers. Instead I came up with this code snippet

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

Google Apps Script quick hack to extract inline images from Gmail — Anonymous Gist

Google Apps Script quick hack to extract inline images from Gmail — Anonymous Gist | Google Apps Script | Scoop.it
Google Apps Script quick hack to extract inline images from Gmail
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Templated Export for Google Spreadsheets using Google Apps Script

Templated Export for Google Spreadsheets using Google Apps Script | Google Apps Script | Scoop.it

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 

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

The Normal Force: The Calendrator v2 by Eric Eslinger

The Normal Force: The Calendrator v2 by Eric Eslinger | Google Apps Script | Scoop.it

"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."

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

HAPPY BIRTHDAY Google Apps Script: 3 years ago Apps Script was launched to Premier and Education users

HAPPY BIRTHDAY Google Apps Script: 3 years ago Apps Script was launched to Premier and Education users | Google Apps Script | Scoop.it

3 years ago (August 19 2009) Google Apps Script was made available to all Google Apps Premier and Education Edition users. HAPPY BIRTHDAY APPS SCRIPT! :)

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

UK postcode geocoding API: The Daily REST library entry for Excel and GAScript

UK postcode geocoding API: The Daily REST library entry for Excel and GAScript | Google Apps Script | Scoop.it

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


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

Google Apps Script Web Store App: mLookup

Google Apps Script Web Store App: mLookup | Google Apps Script | Scoop.it

"This fairly simple Google Apps Script allows any Google Apps Business customer to provide a simple way for the users to query their groups and discover members/managers/owners of each group"

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

gotJS: UiBot - Google Apps Script User Interface Library - build UI from JSON objects by Dan Gottlieb

gotJS: UiBot - Google Apps Script User Interface Library - build UI from JSON objects by Dan Gottlieb | Google Apps Script | Scoop.it

"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

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

How to create a mail merge using Google Apps Script & Google Forms

Here's my quick guide on creating a simple mail merge using Google Apps Script and Google Forms. Certainly a lot of use-cases for this one! Just imagine what...
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Revevol Quality Dashboard - Google Apps Developer Blog by Romain Vialard Rapid Dash Development

Revevol Quality Dashboard - Google Apps Developer Blog by Romain Vialard Rapid Dash Development | Google Apps Script | Scoop.it

Romain Vialard demonstrates that with the recent addition of Apps Script Libraries and Dashboard chart objects it's possible to rapidly develop information panels all within a Google authenticated environment

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

Excel Liberation.: Using Google Apps ScriptDB to track activity by Bruce Mcpherson

Excel Liberation.: Using Google Apps ScriptDB to track activity by Bruce Mcpherson | Google Apps Script | Scoop.it

"the Idea here is that you use your scriptDb (either one linked to a particular workbook, or a shared one you use for centralized to tracking) to record when certain events start and finish using Google Apps Script. Here's an example of logging something that happened, and how long it took."

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

Three Techniques for Visualizing Data From Google BigQuery (including Google Apps Script)

Three Techniques for Visualizing Data From Google BigQuery (including Google Apps Script) | Google Apps Script | Scoop.it
" In about 50 lines of code in Google Apps Script (server-side JavaScript), I’m able to send an authorized query off to BigQuery and pull the results into the spreadsheet "

ProgrammableWeb.com keeps you up to date with web mashups and APIs: what's new, interesting, useful and important. Hundreds of mashups and APIs. Contribute, search, view, and chart them.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

0x8107D: A free Twitter buffer with Google Apps Scripts

0x8107D: A free Twitter buffer with Google Apps Scripts | Google Apps Script | Scoop.it
" You might know about Buffer, a web service where you can create a stash of tweets which will be posted to your Twitter account at regular intervals. Instead of overwhelming your followers with all the interesting things you have to say, you can configure it such that it will send out a tweet at 9am and 1pm every day (for instance). The only thing you have to worry about is to keep your buffer filled.

However, the buffer size at Buffer is only 10 tweets. If you want more you need to pay (or make your friends sign up as a referral). Because I find $10/mo a bit much for just a buffer, I decided to make my own.

We'll do this with a Google Spreadsheet and a Google Apps Script"
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

[FREE] Receive SMS messages in a Google Spreadsheet for a textwall, voting and more (UK only) JISC CETIS MASHe

[FREE] Receive SMS messages in a Google Spreadsheet for a textwall, voting and more (UK only) JISC CETIS MASHe | Google Apps Script | Scoop.it

Solution for making a free SMS inbox in a Google Spreadsheet using the IntelliSoftware SMS Gateway and 30 liines of Google Apps Script code. This particular example is used to collect votes for a poster competition but there are many other things you could use it for.

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

Automate Google Analytics reporting using Google Apps Script - Google Developers Blog

Automate Google Analytics reporting using Google Apps Script - Google Developers Blog | Google Apps Script | Scoop.it

"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."

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

Automated Access to Google Analytics Data in Google Spreadsheets - Google Analytics — Google Developers

Automated Access to Google Analytics Data in Google Spreadsheets - Google Analytics — Google Developers | Google Apps Script | Scoop.it
This tutorial describes how to access the Management and Core Reporting APIs inside a Google Spreadsheet using Apps Script.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

The Normal Force: The Calendrator v1 (using Apps Script to display course calendar) by Eric Eslinger

The Normal Force: The Calendrator v1 (using Apps Script to display course calendar) by Eric Eslinger | Google Apps Script | Scoop.it

"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."

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

gotJS: Use Any Editor with Google Apps Script by syncing scripts By Dan Gottlieb

"There's excellent syncing built into Google Drive makes it easy to create javascript files on your computer and run them within Google Apps. This approach means you can use your favorite text editor rather then the online code editor, but still easily test in Google Apps Script without needing to copy and paste repeatedly."

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

Computational Contemplations: Google Apps Script to export course topics to Calendar By Lee Stemkoski

"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..."

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

Google Apps Script Web Store App: Web Store App Crowd Curated

Google Apps Script Web Store App: Web Store App Crowd Curated | Google Apps Script | Scoop.it
"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."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

R melt for Google Apps Script and Excel/VBA: reshaping/unpivoting data By Bruce Mcpherson

R melt for Google Apps Script and Excel/VBA: reshaping/unpivoting data By Bruce Mcpherson | Google Apps Script | Scoop.it

"could consider this to be a kind of unpivot - exploding tabulated data back into transactional rows as described by Hadley Wickhams in his implementation of reshape/melt for R."

more...
No comment yet.