Google Apps Script
Follow
Find
47.1K views | +89 today
Scooped by Martin Hawksey
onto Google Apps Script
Scoop.it!

Delete Attachments from Gmail without Deleting the Email via Google Docs

Delete Attachments from Gmail without Deleting the Email via Google Docs | Google Apps Script | Scoop.it
Learn how to delete only attachments from Gmail messages without deleting emails using Google Docs sans the need of desktop clients and reclaim lost space.
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...
Scooped by Martin Hawksey
Scoop.it!

Using Google Apps Script to integrate with import.io

Using Google Apps Script to integrate with import.io | Google Apps Script | Scoop.it
This post illustrates how you can integrate the structured web data scraping service import.io with Google Apps Script.
Martin Hawksey's insight:

Extracting data from HTML pages with Google Apps Script can be a bit fiddly. There are a number of web services such as import.io that turn this into a point and click expereince. I particularly like import.io because they appear to have spent time of the developer experience with lots of example code and client libraries. Here's a click look at how you can integrate Google Apps Script with the import.io service 

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

Helpouts by Google – Help with Google Apps Script

Helpouts by Google – Help with Google Apps Script | Google Apps Script | Scoop.it
Beginner to intermediate help with Google Apps Script projects.  Offering assistance with any of the Google APIs or help with UI development / web app deployment  in Google Script. 
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Docs merging with Norada's Solve360 CRM

Google Docs merging with Norada's Solve360 CRM | Google Apps Script | Scoop.it

"Our most-often recommended CRM product, Norada's Solve360, has now introduced their own add-on for Google Docs that allows you to create merged documents and labels from records that already exist in your Solve360 database."

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

Synergyse Blog: Top 10 Google Docs & Sheets Add-ons for Education

"In a follow up to our previous post, Top 10 Google Apps Script for Education we are happy to bring you our updated Top 10 Google Docs & Sheets Add-ons for Education. Google recently launched the Add-ons feature, which brings really useful Apps Script based extensions to Docs & Sheets. Add-ons are really easy to discover and install, and become available across all Docs & Sheets when they are installed."

more...
No comment yet.
Rescooped by Martin Hawksey from Excel Liberation
Scoop.it!

Database abstraction with google apps script - Desktop Liberation

Database abstraction with google apps script - Desktop Liberation | Google Apps Script | Scoop.it
brucemcpherson's insight:

"Sometimes you start with a particular database, or a spreadsheet, then you decide to use something else, and you have to refactor all your code. This is an early version of a Google Apps Script handler for database abstraction (with of course a heavy focus on Google options), to try to avoid some of that pain. "


Via brucemcpherson
more...
brucemcpherson's curator insight, April 7, 12:20 PM

Sometimes you start with a particular database, or a spreadsheet, then you decide to use something else, and you have to refactor all your code. This is an early version of a Google Apps Script handler for database abstraction (with of course a heavy focus on Google options), to try to avoid some of that pain. 

Scooped by Martin Hawksey
Scoop.it!

Lenny Cunningham - Google+ - Google Apps Script Garage Door Opener

Lenny Cunningham - Google+ - Google Apps Script Garage Door Opener | Google Apps Script | Scoop.it

"Had a couple free moments this weekend and decided to use Apps Script in part of my Home Automation.  Here you go hopefully the first #appsscript  Garage Door Opener with a +ControlByWeb Dual Relay"

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

Custom Emails from a Spreadsheet: Humanizing the Google Apps Script

Custom Emails from a Spreadsheet: Humanizing the Google Apps Script | Google Apps Script | Scoop.it

"For non-technical people venturing into the startup space, tools like Excel might be more familiar than JavaScript. The Google Apps Script is a JavaScript-based language that allows you to easily do amazing things with Google Docs, Sheets, and Forms. Google Developers has a very good tutorial on sending emails from a spreadsheet.

 

This guide expands on the script, allowing you to customize the emails to be more personal. "

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

Google Docs Add-ons: Notes for Google Apps Admins

Google Docs Add-ons: Notes for Google Apps Admins | Google Apps Script | Scoop.it
Google recently announced the release of add-ons for Google Docs and new Sheets. This post provides some notes for Google Apps admins about their use
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

[Book] Google Apps Script: Web Application Development Essentials, 2 Ed.

[Book] Google Apps Script: Web Application Development Essentials, 2 Ed. | Google Apps Script | Scoop.it

"Learn how to create dynamic web applications with Google Apps Script and take full advantage of your Google-hosted services. If you have basic coding skills and some JavaScript experience, this practical book shows you how Apps Script works, and provides step-by-step guidance for building applications you can use right away."

Martin Hawksey's insight:

James Ferreira is back with the 2nd Edition of Google Apps Script: Web Application Development Essentials. The book is in 'early release' which gives you access to it while it's been written. Given the number of Apps Script updates I imagine this will keep James busy. 

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

Will Welch - Google+ - Resource Reservation System Google Apps Script

Will Welch - Google+ - Resource Reservation System Google Apps Script | Google Apps Script | Scoop.it

Resource reserving script from Will Welch

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

Google Apps Script-let for timestamping a Google Document footer

Google Apps Script-let for timestamping a Google Document footer

Martin Hawksey's insight:

A number of ways you could improve this by adding to an 'on' event or wrapping in a add-on

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

Google Apps Script Add-ons Reviewed - YouTube

Google Apps Script Add-ons Reviewed - YouTube | Google Apps Script | Scoop.it
Martin Hawksey's insight:

In these Google Developers Live sessions Arun Nagarajan highlights some of the Add-ons already available in Google Documents and Sheets taking time to speak to their creators.

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

Bruce Mcpherson: Google Developer Expert (GDE) Apps Script

Bruce Mcpherson: Google Developer Expert (GDE) Apps Script | Google Apps Script | Scoop.it

"It's a great feeling to have your work recognised in this way, even though I do feel a little out of place in the company of the august group who make up the current GDE community. GDEs are a small, but enthusiastic group who share a passion for the family of Google APIs and products, and give generously of their time to share their knowledge and ideas with others."

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

Google Groups Directory - Google Apps Script Examples

Google Groups Directory - Google Apps Script Examples | Google Apps Script | Scoop.it
For Google Apps Administrators, deploy this Web App to let your users see the members of each domain Groups / mailing lists.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

How to use the Advanced Drive service and the MailChimp API to send Google Docs in an email.

How to use the Advanced Drive service and the MailChimp API to send Google Docs in an email. | Google Apps Script | Scoop.it

Eric Koleda: "I put together a short sample script that shows how to use the Advanced Drive service and the MailChimp API to send the contents of a Google Doc in an email. "

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

Backing off on rate limiting in Google Apps Script - Desktop Liberation

Backing off on rate limiting in Google Apps Script - Desktop Liberation | Google Apps Script | Scoop.it

"There are many rates and quotas in the Google Apps Script environment. One of the usual ways of dealing with it is to sleep between instructions, but that seems to be a rather blunt instrument. So here's a way of adapting to rate limits using an exponential backoff technique ... This is a fairly simple idea, where if something fails because of some temporary reason (for example rate limiting), you can wait a bit and try again. The exponential part is that you wait increasingly longer amounts of time between attempts. Eventually of course you give up."

more...
No comment yet.
Rescooped by Martin Hawksey from Excel Liberation
Scoop.it!

SunCalc - Apps Script library and web apps version

SunCalc -  Apps Script library and web apps version | Google Apps Script | Scoop.it

Suncalc Google Apps Script library and webapp.


Via brucemcpherson
more...
brucemcpherson's curator insight, March 31, 8:52 AM

Here's a Google Apps Script version of SunCalc. There's a  library to include in projects, and a  webapp to provide rest query responses. It calculates things like sunrise, sunset and so on given a location and a date. Created from Vladimir Agafonkin's https://github.com/mourner/suncalc.

Rescooped by Martin Hawksey from Excel Liberation
Scoop.it!

pollHandler app and library - Desktop Liberation

pollHandler app and library - Desktop Liberation | Google Apps Script | Scoop.it

Polling app based on Google Apps Script


Via brucemcpherson
more...
brucemcpherson's curator insight, April 10, 2:28 PM

Here's the all you need for a simple Poll app based on a Google Apps Script webapp handling a parse.com database, Google Charts and a javascript client.

Scooped by Martin Hawksey
Scoop.it!

Apps Script: Login Activities Dashboard - Revisited - Google Drive

"Ever wanted to have a quick glance at the distribution of login activities in your domain? Check out this revisted script with more data/fields, and more reporting time periods!


You can use this script to get valuable information about your user community including WHO is logging in, WHERE and HOW they are authenticating to Google Apps and their login challenges. You can then share this information with your Support team to prepare them for end user issues."


By +Justin Gale 

Martin Hawksey's insight:

+Justin Gale has a lovely script and setup instructions for a  'Login Activities Dashboard'. Lots of scope to extend this to selectively release slices of the data to school admins or incorporate in a wider #learninganalytics solution

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

Cache 101 with Google Apps Script: Breaking the 100kb cache limit)

"If you have used the cache service long enough in your Google Apps Script, you probably have known you could not cache anything larger than 100KB. 


Here is a simple ready-to-use wrapper which hides the complexity and still performs equally well for size under 100KB."

Martin Hawksey's insight:

From the comments of this post Chris Morris also provides a modified version https://docs.google.com/document/d/1c276AZNkicfX0PmyaZS2OSebrU84XmQHvHq9XZUMGWY/edit?usp=sharing


HT +Jacob Jan Tuinstra for highlighting

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

Developing add-ons for Google Docs/Sheets/Forms - Community - Google+

Developing add-ons for Google Docs/Sheets/Forms - Community - Google+ | Google Apps Script | Scoop.it

"Add-ons are tools created by developers that literally add on new capabilities to Google Docs and Sheets (Forms add-ons are coming soon). They should focus on the end-user and provide problem-solving solutions that help them be more productive with a beautiful and professional appearance. Besides coding, there are Google guidelines to consider, creating a professional support website, publishing to the Chrome Web Store, and strategizing a marketing plan."

Martin Hawksey's insight:

New Google+ community for everyone interested in developing add-ons for Google Drive using Google Apps Script

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

Speaking JavaScript: Free O'Reilly eBook for better Google Apps Scripting

Speaking JavaScript: Free O'Reilly eBook for better Google Apps Scripting | Google Apps Script | Scoop.it

"This book has been written for programmers, by a programmer. So, in order to understand it, you should already know object-oriented programming, for example, via a mainstream programming language such as Java, PHP, C++, Python, Ruby, Objective-C, C#, or Perl.

 

Thus, the book’s target audience is programmers who want to learn JavaScript quickly and properly, and JavaScript programmers who want to deepen their skills and/or look up specific topics."

Martin Hawksey's insight:

Given many Apps Scripters may be coming from other programming languages (and given Google Apps Script uses a JavaScript syntax) this could be an ideal resource. 

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

Sorting bookmarks in a document - Excel Liberation

Sorting bookmarks in a document - Excel Liberation | Google Apps Script | Scoop.it
"Here's how to sort bookmarks into position order in a document.  We'll use Advanced Array functions heavily here"
more...
No comment yet.
Rescooped by Martin Hawksey from iGeneration - 21st Century Education
Scoop.it!

Your First Google Apps Script

Your First Google Apps Script | Google Apps Script | Scoop.it
Google Apps Script is a JavaScript-based scripting language that you can use to automate tasks in Google Docs, Sheets, and Forms. There s no extra software to be installed, as there s a code editor provided in Google Drive.

Via Tom D'Amico (@TDOttawa)
more...
iCoachP53's curator insight, March 19, 8:43 AM

You probably have know idea what a "Google Script is"  but you should.  They can make your life much easier.  #edtech

Scooped by Martin Hawksey
Scoop.it!

Mr. Hay's Technology: Google Apps Script: Auto-Query FortiGuard Category List

"a little Google Apps Script I put together for querying FortiGuard's Web Filtering Service site category list from a spreadsheet. It takes a URL from the selected cell in a Google Spreadsheet, and replaces it with FortiGuard's category for that URL."

more...
No comment yet.