Google Apps Script
Follow
Find
46.7K views | +24 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...
Scooped by Martin Hawksey
Scoop.it!

Automate MailChimp reporting with Google Apps Scripts and Google Spreadsheets

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

Google Apps Script Sprint - 100 Scripts to Get You Started

"This spreadsheet contains an index of 100 scripts you can use to get started with Google Apps Script.

 

Most of the scripts are short, snippets you can customize and combine together. "

Martin Hawksey's insight:

Click title of scoop to open Sheet and make a copy.

more...
No comment yet.
Rescooped by Martin Hawksey from iGeneration - 21st Century Education
Scoop.it!

Archive post - worth a revisit - Top 10 Google Apps Scripts for Education

Archive post - worth a revisit - Top 10 Google Apps Scripts for Education | Google Apps Script | Scoop.it
Top 10 Google Apps Script for Education provided by Synergyse Google Apps Training.

Via Tom D'Amico (@TDOttawa)
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Developer Blog: More Apps Script APIs and Features (including new Document functionality)

Google Apps Developer Blog: More Apps Script APIs and Features (including new Document functionality) | Google Apps Script | Scoop.it
Including new Document Service for named ranges, bookmarks, setting cursor or selection, and undo
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Choosing between Google Apps Script and Google App Engine | Google Apps Experts

"Choosing between Google Apps Script and Google App Engine is not always a clear choice. These two tools are not mutually exclusive in their functionality and could, in many cases, be used conjointly. Fundamentally, they are very similar. Both are platforms on which to build applications, both run within Google's infrastructure and both allow for integration into other Google services. Similarities abound."

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

Google App Scripts for Educators - some starter scripts

Google App Scripts for Educators - some starter scripts | Google Apps Script | Scoop.it
"Recently I went to an ‘Advance Google Session’ at a conference that was conducted by John Warf.  The session was mostly about Google Apps Script (GAS). GAS is a JavaScript cloud scripting language that provides easy ways to automate tasks across Google products and third party services and build web applications.*  GAS lets you do more with Google Apps for Education (GAFE) such as drive and calendars. There a tons of already created scripts that help educators but you can also create your own by opening a Google Doc, spreadsheet etc and clicking on tools, script editor. [Here] is a complied list of the most helpful scripts for educators and links to how-to’s for each one"
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Arun Nagarajan – Google+ - Sidebars in Google Docs and Sheets to be fixed to be 300px

Arun Nagarajan – Google+ - Sidebars in Google Docs and Sheets to be fixed to be 300px | Google Apps Script | Scoop.it
"Quick update - going forward sidebars in Google Docs and Sheets will be forced to be 300px. If you have code that sets width of a sidebar, that call will be ignored. Please update your UI accordingly. This change has already been rolled out to new Sheets and will be in Docs next week.  If you were never setting width, then you'll notice no difference as the default was 300px. "
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Collaborative Tools Project: A Simple Example Booking Project in Google Spreadsheets

Collaborative Tools Project: A Simple Example Booking Project in Google Spreadsheets | Google Apps Script | Scoop.it
more...
No comment yet.
Rescooped by Martin Hawksey from Excel Liberation
Scoop.it!

Are the new Google Sheets faster than the old?

Are the new Google Sheets faster than the old? | Google Apps Script | Scoop.it

Via brucemcpherson
Martin Hawksey's insight:

What's interesting is in the new Sheets known issues it states "Some methods, most notably batch-set methods like Range.setValues(), are currently slow in the new version of Sheets." https://developers.google.com/apps-script/migration/sheets#performance ... so slow but still faster???

more...
brucemcpherson's curator insight, January 27, 2:03 PM

Good speed improvement for writing data in the new Google Sheets.

Rescooped by Martin Hawksey from iGeneration - 21st Century Education
Scoop.it!

Take control of Gmail, only check it once per hour with Google Apps Script | Google Gooru

Take control of Gmail, only check it once per hour with Google Apps Script | Google Gooru | Google Apps Script | Scoop.it

"This script tricks Gmail into thinking that no emails have come through, then finally allowing you to see unread messages at pre-determined intervals."


Via Tom D'Amico (@TDOttawa)
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Fun But Learn: Conduct Poll in Google+ and Display Result in Your Site

Fun But Learn: Conduct Poll in Google+ and Display Result in Your Site | Google Apps Script | Scoop.it
A nice tutorial to conduct polls on Google+ and how you can extract the counts and display them on your web page. This is definitely a nice way to reach to maximum people and get maximum votes.
more...
brucemcpherson's comment, January 26, 4:50 AM
Haven't tried this yet, but it looks like a smart idea.
Martin Hawksey's comment, January 28, 4:24 AM
@brucemcpherson the developer was getting some stick along lines of 'why don't you use forms' ... shame they didn't see some of the creative thinking that went into this
brucemcpherson's comment, January 28, 5:30 PM
Yep.. I was really impressed by the lateral thinking here. I'm sure this idea can be applied to other problems.
Rescooped by Martin Hawksey from Excel Liberation
Scoop.it!

Apps Script custom functions - Excel Liberation

Apps Script custom functions - Excel Liberation | Google Apps Script | Scoop.it
Liberate Excel data from the desktop

Via brucemcpherson
Martin Hawksey's insight:

Highlighting the difference between VBA and App Script functions

more...
brucemcpherson's curator insight, January 17, 9:49 AM

I'm putting together a primer on how to do some of the more common things you do in custom excel functions, but would like to do in Google Apps Script. Register some suggestions here.

Rescooped by Martin Hawksey from Excel Liberation
Scoop.it!

A simple Google Apps Script RestQuery - Excel Liberation

A simple Google Apps Script RestQuery - Excel Liberation | Google Apps Script | Scoop.it

"Liberate Excel data from the desktop"

 

"If you follow this site, you'll know there is a lot of content that shows how to convert VBA projects to Google Apps Script. Eventually, you'll want to leave VBA behind. 

 

Here's a 'no dependency' example of the kind of thing GAS does really well." by Bruce McPherson


Via brucemcpherson
more...
brucemcpherson's curator insight, January 14, 2:21 PM

If you follow this site, you'll know there is a lot of content that shows how to convert VBA projects to Google Apps Script. Eventually, you'll want to leave VBA behind. 

 

Here's a 'no dependency' example of the kind of thing GAS does really well.

malek's comment, January 16, 2:22 PM
True: time to kiss VBA goodbye.
Scooped by Martin Hawksey
Scoop.it!

Recreate SharePoint lists in Google Apps, with both bulk editing and edit form functionality

Recreate SharePoint lists in Google Apps, with both bulk editing and edit form functionality | Google Apps Script | Scoop.it

"This solution came about from a requirement to recreate SharePoint lists in Google Apps, taking across large numbers of list items, with each item needing to have  its own edit form populated with the appropriate data. Additionally, users should be able to edit the Google Sheet, and have those changes reflected in the edit forms. This attempts to give the same functionality as SharePoint where items can be edited in edit form, or in bulk via datasheet view"

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

Building a Google Apps Script Polling App | Eforcers S.A.

Building a Google Apps Script Polling App | Eforcers S.A. | Google Apps Script | Scoop.it
Martin Hawksey's insight:

Nice tutorial to help new users understand the Apps Script coding environment

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

Eric Koleda - Google+ - Google Apps Script: How to determine if a range within a Google Doc contains a given position

Eric Koleda - Google+ - Google Apps Script: How to determine if a range within a Google Doc contains a given position | Google Apps Script | Scoop.it

"Wanted to share a little code snippet I cooked up today. It provides a function you can use to determine if a given Position with a Google Doc is contained within a given Range. This can be useful when using the new NamedRange functionality we launched yesterday (http://goo.gl/eiCXXP) and want to determine if the user's cursor falls within one of those ranges."

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

Tracking Google Sheet views with Google Analytics using GA Beacon

Tracking Google Sheet views with Google Analytics using GA Beacon | Google Apps Script | Scoop.it
This post describes how you can use the IMAGE formula as a Google Analytics Beacon for tracking Google Sheets views
Martin Hawksey's insight:

I've got quite a few Google Sheet templates in the wild and was looking for a way to track usage (even just a basic view count). Recently I came across +Ilya Grigorik 's Google Analytics Beacon project which lets you use an image as a GA webbug. The result basic Google Analytics tracking of sheets without jumping through potential Google Apps Script authorisation and quota issues  

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

Arun Nagarajan - Google+ - early announcement deprecation of Finance and Property Service

Arun Nagarajan - Google+ - early announcement deprecation of Finance and Property Service | Google Apps Script | Scoop.it

"Finance Service - we are deprecating the Finance Service in Google Apps Script. It will remain available for the next six months but will be turned off on September 26, 2014. Please start considering alternatives for the financial data right away. 

Properties Service - we are launching a new properties service with a notion of Document level properties and more. Due to this, we will be deprecating the current properties service. Again, stay tuned for more details tomorrow! We think you'll like the new Properties service look. This is more of a heads up. No action needed till after tomorrow's blog post. "

Martin Hawksey's insight:

Also some goodies to be announced tomorrow on http://googleappsdeveloper.blogspot.com/

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

Amit Agarwal – Google+ - More resources for learning Google Apps Script

Amit Agarwal – Google+ - More resources for learning Google Apps Script | Google Apps Script | Scoop.it

0. https://developers.google.com/apps-script/case-studies ;
1. http://www.scoop.it/t/gas - by +Martin Hawksey  
2. http://www.labnol.org/internet/google-scripts/28281/ - by +Amit Agarwal 
3. scriptsexamples - by +Romain Vialard 
4. http://shop.oreilly.com/product/0636920032557.do - by +James Ferreira 
5. http://www.youtube.com/playlist?list=PLB18FD78D51BDF5D3 - by +Eric Koleda and +Arun Nagarajan 

Martin Hawksey's insight:

Thank you Amit Agarwal for highlighting 'The GAS'

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

Google Docs/Drive - auto number Document headings

Google Docs/Drive - auto number Document headings | Google Apps Script | Scoop.it

Stackoverflow answer for auto numbering Google Documents headings with Google Apps Script

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

GAS Library Box - Google Apps Script Hacks

GAS Library Box - Google Apps Script Hacks | Google Apps Script | Scoop.it
GAS Library Box is a Chrome Extension for managing Apps Script libraries. Install the extension and get an auto-complete box when adding a managed library to your Script project.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Reduced quota on emails you can send per-day with Apps Script on free accounts

Reduced quota on emails you can send per-day with Apps Script on free accounts | Google Apps Script | Scoop.it

"We've just reduced the quota on the number of emails you can send per-day with Apps Script.

Consumer and non-paid Google Apps users are now limited to 100 email recipients per day, which is reflected on the Apps Script dashboard"

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

Big arrays and scriptDB in Google Apps Script - Excel Liberation

"Like most Google Services, there are various quotas that apply to scriptDb. One of these is the maximum object size. Here's how to split up large arrays to help get round that."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

How to Send Confirmation Emails with Google Forms

How to Send Confirmation Emails with Google Forms | Google Apps Script | Scoop.it
Learn how to send automatic confirmation emails to the user's email address after they submit a Google form. You may also CC a copy of the form to yourself.
more...
No comment yet.
Suggested by Shunmugha Sundaram
Scoop.it!

Track Product Price Drops on Top Indian E-commerce Websites

Track Product Price Drops on Top Indian E-commerce Websites | Google Apps Script | Scoop.it
Learn how to use Indian online shopping price tracker to get free email alerts when product's price drop in Flipkart, Snapdeal, Jabong, Myntra and Yebhi.
more...
No comment yet.