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

Converting blog post urls into MS Word documents using Google Apps Script #oerri JISC CETIS MASHe

Converting blog post urls into MS Word documents using Google Apps Script #oerri JISC CETIS MASHe | Google Apps Script | Scoop.it
Outlining some Google Apps Script code I've written that takes some blog post urls and makes a downloadable html/.doc report...
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

5 Useful Web Apps Built with Google Apps Script - Google Apps Developer Blog

"At Google I/O in June, we launched two new features that made it easier to build and distribute web apps with Google Apps Script. First, we added the ability to deploy web apps that run as the user. Second, we added simple integration for publishing web apps that you’ve built with Apps Script to the Chrome Web Store.


Recently we’ve come across some new and useful web apps that developers have built using Apps Script and published in the Chrome Web Store. In this blog post, we’d like to highlight a few of those."

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

Super Simple Website Checker - Uptime checker app coded in Google Apps Script by Jan Kleinert

Super Simple Website Checker - Uptime checker app coded in Google Apps Script by Jan Kleinert | Google Apps Script | Scoop.it

"Super Simple Website Checker was built using Google Apps Script and demonstrates the usage of HtmlService, ScriptDb, triggers, and UrlFetch. You can view the source code for the web app here: https://script.google.com/d/1ZA2u-HUSHx_5O9YXIKQLirrvlzXXzuvx4373G8DRUgNyGPmeUxGCIlh8/edit

 

Super Simple Website Checker is a sample app that allows you to monitor the uptime, or status, of websites. For each website you choose to monitor, the app will check the status of those websites every 15 minutes. You can view the status in the app itself, and for any websites that are not up (that is, not returning an HTTP 200 OK status), you'll get an email update to inform you of the status for those failing websites. "

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

[Failed] Embedding live data from Google Spreadsheet with Apps Script ContentService in PowerPoint using oomfo

[Failed] Embedding live data from Google Spreadsheet with Apps Script ContentService in PowerPoint using oomfo | Google Apps Script | Scoop.it
I came, I saw, I failed. This was a potentially promising hack that didn’t work out. Hopefully you’ll get as much benefit from failure, as from success.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Excel Liberation.: using Google Apps ScriptDB as a lockBox by Bruce Mcpherson

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

No Google Apps Script Required: IFTTT Recipes the if that then insert google spreadsheet row

No Google Apps Script Required: IFTTT Recipes the if that then insert google spreadsheet row | Google Apps Script | Scoop.it

Selection of recipes that let you easily connect other web services to push new rows of data to a Google https://ifttt.com/recipes/search?q=spreadsheet

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.
Suggested by Jacob Jan Tuinstra
Scoop.it!

Building a menu in Google Apps Script - Jacob Jan Tuinstra

Building a menu in Google Apps Script - Jacob Jan Tuinstra | Google Apps Script | Scoop.it

"This little snippet makes it possible to create a menu structure (horizontal and vertical) based on an array, in Google Apps Script."

 

[Editor: Also a nice example of how to layout Google Sites for Apps Script examples]

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

Collaborative Tools Project: 5.0 Building a Booking System With Google Apps Script by Tom Smith

Collaborative Tools Project: 5.0 Building a Booking System With Google Apps Script by Tom Smith | Google Apps Script | Scoop.it

"Latest update on Building a Booking System With Google Apps Script"

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

Feed+ Chrome Web Store/Apps Script that uses Apps Script to create RSS feed from Google+ by Eric Koleda

Feed+ Chrome Web Store/Apps Script that uses Apps Script to create RSS feed from Google+ by Eric Koleda | Google Apps Script | Scoop.it

"a new Apps Script web app to the Chrome Web Store! This sample app allows you to create an RSS feed of Google+ activities, and utilizes the HtmlService, ScriptDb, and the ContentService. I'll be publishing a more in depth look at the code in the coming weeks, but for now install it, use it, and let me know what you think!"

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

YOKOFAKUN: Translating a DNA sequence in Google Spreadsheet using #GoogleAppScript

YOKOFAKUN: Translating a DNA sequence in Google Spreadsheet using #GoogleAppScript | Google Apps Script | Scoop.it
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

IFTTT: IF I do THAT on {insert social network/rss feed/other} THEN add row to Google Spreadsheet (no Apps Script required)

IFTTT: IF I do THAT on {insert social network/rss feed/other} THEN add row to Google Spreadsheet (no Apps Script required) | Google Apps Script | Scoop.it
IFTTT is a web service that lets you do some basic plumbing between web services. It makes it very easy to trigger actions between different web services. One of the most recent additions is Google Drive. With Google Drive integration you can store files or, the one that interests me more, insert a new row in a Google Spreadsheet.
more...
No comment yet.
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.