Google Apps Script
Follow
Find
65.7K views | +81 today
 
Suggested by Shunmugha Sundaram
onto Google Apps Script
Scoop.it!

Get Read Receipt Notification for your Emails in Gmail with Google Docs

Get Read Receipt Notification for your Emails in Gmail with Google Docs | Google Apps Script | Scoop.it
Learn how to use Google Docs to get read receipt alerts when your Email has been read in Gmail. Available to Non-Google Apps Account holders too.
more...
No comment yet.
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!

Edit All Your Calendar Events at Once with This Google Script

Edit All Your Calendar Events at Once with This Google Script | Google Apps Script | Scoop.it
Editing individual events on Google Calendar isn't difficult at all, but changing all of the events? Pretty hard without some sort of program, like this bulk edit calendar script.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Simplify your Google Analytics Reporting with Add-ons for Google Sheets - Analytics Blog

Simplify your Google Analytics Reporting with Add-ons for Google Sheets - Analytics Blog | Google Apps Script | Scoop.it

"It's common for Google Analytics users to use spreadsheets to analyze their Google Analytics data or combine it with another data source. But exporting your data from Google Analytics to Google Sheets is a manual process, and it can be tedious if you run reports frequently or manage multiple accounts. With the release of Add-ons for Google Sheets, getting your Google Analytics data into Google Sheets has never been easier!

 Add-ons allow you to extend the power of Google Sheets by automating common tasks and integrating with external services. The Google Analytics Spreadsheet Add-on allows you to access your Google Analytics data, right from within a spreadsheet!"

Martin Hawksey's insight:

Great to see Google Apps Script being used and promoted by other Google product teams :)

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

Early work from Andrew Stillman on recording and saving audio files using Google Apps Script

Early work from Andrew Stillman on recording and saving audio files using Google Apps Script | Google Apps Script | Scoop.it
I recently tested a small JS library for handling the recording and download of audio files in Chrome and it uses an HTML web "Worker," which fails in… - Andrew Stillman – Google+
Martin Hawksey's insight:

Check the comments thread to see how this is developing

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

Release notes for update to Google Apps Script DbAbstraction libraries

Release notes for update to Google Apps Script DbAbstraction libraries | Google Apps Script | Scoop.it

"Release notes for update to Apps Script DbAbstraction libraries. 

Lots of changes - a brief summary of the highlights..
* transactions now implemented, with rollback for selected drivers
* a new driver - scratchDB - this is a transient database that sticks around for as long as you use it, otherwise it cleans itself away
* updates to Orchestrate to be able to same complex queries as other back ends"

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

Some minimal UiApp to HtmlService conversions...…

Some minimal UiApp to HtmlService conversions...… | Google Apps Script | Scoop.it

Some minimal UiApp to HtmlService conversions... - Bryan Patterson – Google+

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

Using Drive API within Google Apps Script to create a file/folder skipping root

"For those interested in using Drive API within Google Apps Script to create a sub folder and file within a specified Drive folder that skips the "root""

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

How to make Google Spreadsheet editable only at certain times - Web Applications Stack Exchange

How to make Google Spreadsheet editable only at certain times - Web Applications Stack Exchange | Google Apps Script | Scoop.it
"With the following script you can restrict access (view only) to your Google Spreadsheet."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Script locking and optimum wait times and the golden ratio

Google Apps Script locking and optimum wait times and the golden ratio | Google Apps Script | Scoop.it

"You are probably familiar with the Google Apps Script Lock Service, which is a way of preventing concurrent access to sections of code. It works well, but the problem is that it's a fairly blunt instrument.


Let's say that you want to use the same code to deal with multiple resources - say a spreadsheet tab. With lock service you'd  lock  all spreadsheet tabs that were accessed by that code.  This is especially a problem if you are using shared libraries which may be accessed by many people accessing many resources."

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

Flattening and unflattening objects to spreadsheets with Google Apps Script - Desktop Liberation

"In Flattening an object with dot syntax I showed how to take a an object of more than 1 level deep and flatten it so it could be represented in a two dimensional object like a spreadsheet. Now here's the opposite, unflattening an object created that way. I also provide a library you can use for flattening and unflattening, as well as processing objects to and from spreadsheets"

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

ScriptDB Going Read-Only Tomorrow - Eric Koleda – Google+

ScriptDB Going Read-Only Tomorrow - Eric Koleda – Google+ | Google Apps Script | Scoop.it

"ScriptDB was officially shut down on November 20th, but we decided to wait until after Thanksgiving to pull the plug. We're going to start by making the service read-only tomorrow, perhaps for a couple of hours to start but eventually permanently. This should help ferret out any places you are still using the service and give you time to export your data" - Eric Koleda – Google+

Martin Hawksey's insight:

For an alternative flow worth checking out @brucemcpherson's DbAbstraction http://ramblings.mcpher.com/Home/excelquirks/dbabstraction

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

+David Bingham: Apps Script Gmail Utilities (including sending mails from draft)

"Using the GMail service provided by Google Apps Script you can script many GMail capabilities. One thing you cannot do is directly send existing draft messages.

 

This script contains a few utilities (maybe the foundation of a library, someday) that deal with draft emails, including using the GMail API to retrieve and send draft messages.

 

No more need to resort to generating a whole new copy of a draft, send the copy, delete the draft... instead:"

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

AppsScript Color: Chrome extension to change the color style of the google apps script editor

AppsScript Color: Chrome extension to change the color style of the google apps script editor | Google Apps Script | Scoop.it
This extension change the color style of the google apps script editor
Martin Hawksey's insight:

via +Romain Vialard 

 

https://plus.google.com/+RomainVialard-public/posts/Duqkva519xq

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

Turn Google Sheets into an Amazon Price Tracker with Google Apps Script

Turn Google Sheets into an Amazon Price Tracker with Google Apps Script | Google Apps Script | Scoop.it
You can use Google Sheets to keep track of prices of products listed on the Amazon shopping website and get email alerts when the prices go down or up.
Martin Hawksey's insight:

Another great script project from Amit Agarwal, this one integrating with the Amazon’s Product Advertising API 

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

Barcode scanning with Google Apps Script  and Chromebook

Barcode scanning with Google Apps Script  and Chromebook | Google Apps Script | Scoop.it

Demonstration by +Lenny Cunningham of some Google Apps Script he's developed to handle inventory using a barcode scanner interfacing with Google Sheets 

Martin Hawksey's insight:

if you look in the sheets shared at top of the original post you can see the script for barcode handling e.g. See Location 1 Medical Inventory sheet Tools > Script Editor

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

Free Technology for Teachers: How to Use Doctopus and Goobric to Grade Google Classroom Assignments

Free Technology for Teachers: How to Use Doctopus and Goobric to Grade Google Classroom Assignments | Google Apps Script | Scoop.it

"Doctopus and Goobric are Google Sheets Add-ons. In the videos ... Justin Brink demonstrates how to use Doctopus and Goobric with Google Classroom."

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

Bruce Mcpherson: A year in apps script and my bucket list

Bruce Mcpherson: A year in apps script and my bucket list | Google Apps Script | Scoop.it

2014 has been an eventful year for Google Apps Script with some great new capabilities arriving (add-ons), as well some useful ones (ScriptDB) being deprecated. In this post I'll cover my highlights and lowlights of the Apps Script year, and would love to have your opinions on

* did I miss anything significant this year, and do you agree with my comments?

* what do you think the best thing that happened this year in Apps Script?

* .. and the worst ?

* what an 'apps script bucket list' should contain.

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

Mark Archived Gmail as Read with Apps Script

Mark Archived Gmail as Read with Apps Script | Google Apps Script | Scoop.it
A while back, Android added the ability for some of its notifications to be directly acted upon from the notification shade, such as archiving a Gmail message. More recently, this same functionality came to Android Wear.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

gdcmdtools command line tool for Google Apps Script

"If you like to deploy your GAS project with command line tools, you can check the tool, gdcmdtools. It supports the GAS project import and export. After that you can manage your GAS project easily with version control system(ex: git)."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Speeding up HtmlService in Apps Script - Google Apps Developer Blog

Speeding up HtmlService in Apps Script - Google Apps Developer Blog | Google Apps Script | Scoop.it

"Apps Script's HTML service is a great way to easily build user interfaces for Docs, Sheets, and Forms add-ons. However, HTML service is S-L-O-W. And until today there have been quite a few restrictions on using HTML service, including the inability to use a variety of JavaScript libraries.

Today, we are introducing an update to HTML service — IFRAME sandbox mode. Using this sandbox mode, you can significantly improve the performance. There are three key benefits.

 

1. Your UI loads up much faster

2. Standard HTML, JavaScript, and CSS features are now available without any restrictions.

3. It requires very few code changes: just set the SandboxMode to IFRAME:

Martin Hawksey's insight:

Post also notes UI and DocsList service is deprecated.

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

Hour of code: Google Apps Script Educators

Bjorn Behrendt and Charlie MacFayden, Vermont Educators share how they use Google Apps Script in teaching and learning. 
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Parallel Processing GmailApp.search() in Google Apps Script - Jacob Jan Tuinstra

Parallel Processing GmailApp.search() in Google Apps Script - Jacob Jan Tuinstra | Google Apps Script | Scoop.it

"For a few of my answers on Web Applications, I’m constantly busy finding a solution to retrieve all information via the GmailApp.search() method. As explained in the text, this method is only usable for small amounts of threads. If you query a label containing 1000 emails for example, you will only get 500 items back. 


In the meantime, Bruce McPherson, was hitting the road with his awesome posts, starting with the Running things in parallel using HTML service. ... made me think of a way to incorporate some sort of while loop. Basically, I'm re-starting the script to continue working on retrieving the information untill all information is fetched. Read below to find out how I did that""

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

Simulating multiuser testing in Google App Script - Desktop Liberation

Simulating multiuser testing in Google App Script - Desktop Liberation | Google Apps Script | Scoop.it

"When developing Database abstraction with google apps script I had real trouble simulating multiuser interactions, especially when there wasn't a real database behind (like sheets and drive). I had a mechanism in Using named locks with Google Apps Scripts to be able to lock from updating, but it was really hard to get a good multiuser test going. 


Using this parallel running mechanism is of course perfect - since it executes as many threads as I want in parallel with each other. If I get then all to hit the same back end at once, then I have a pretty intensive multi user test. "

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

Function to convert an XML string to a JSON object in Apps Script

A function to convert an XML string to a JSON object in Apps Script, using logic similar to the sunset method Xml.parse(). - Gist is a simple way to share snippets of text and code with others.
more...
No comment yet.