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

Parse RSS Feeds with Google Apps Script

“This snippet explains how you can read and parse RSS feeds with Google Apps Script. The script reads the feed using URLFetchApp, translates the RSS Feed and then serves it as an RSS feed using the ContentService (the mime type is set to RSS). Also, the feed content is cached for an hour to reduce the number of URL fetch requests."
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!

Google Apps Script - How to find your own files in Google Drive

" The idea is that your Google spreadsheet will connect to your Google Drive account and list down all documents with ownership information. You can easily add more columns to it like size to find documents with a large size. Once the sheet is ready, you can use Filter option (the Funnel icon) to find files owned by you. You can sort the sheet by file name to arrange them alphabetically. "
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

The Register: Hey, scammers. Google's FINE with your dodgy look-a-like apps

Google Apps scripts could fool ANYONE, warns engineer

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

Library of Apps Script Snippets & Objects - LASSO

Library of Apps Script Snippets & Objects - LASSO | Google Apps Script | Scoop.it

"Creating coding snippets is the cornerstone of the Google Apps script world, making it increasingly more accessible for JavaScript and many other coders to jump in quickly and return incredibly powerful cloud scripts. Google Sites is also an essential core cloud platform to launch and reference LASSO development."

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

Tricks with Awesome Tables, Progress Bars, custom css and filtering Numbers

Tricks with Awesome Tables, Progress Bars, custom css and filtering Numbers | Google Apps Script | Scoop.it
I am a huge fan of Romain Vialard's work especially his "Awesome Table Gadget" and use these extensively in my site for reporting.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Create a Motion Chart gadget using Google Sheets

Create a Motion Chart gadget using Google Sheets | Google Apps Script | Scoop.it
In Google Sheets, you have the option to simply create a chart and display this on your Google Site.  However, if you code this in a gadget, you have lots more potential to customise things.
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Google apps script database abstraction exposed version

Database abstraction – GoogleApps Script Desktop liberation

Via brucemcpherson
more...
brucemcpherson's curator insight, August 19, 9:52 AM

Here's a VBA API that uses Google Apps Script to access a variety of cloud based databases directly from Excel/VBA.

 

http://ramblings.mcpher.com/Home/excelquirks/dbabstraction/jsaonapivba

Scooped by Martin Hawksey
Scoop.it!

SheetConverter - Google Apps Script Examples

SheetConverter - Google Apps Script Examples | Google Apps Script | Scoop.it

"The SheetConverter Google Apps Script library provides functions that can retrieve the contents of a spreadsheet range in plain text or html, preserving the formatting that is present in the spreadsheet."

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

Google Educast #151: Google Apps Script Guru, Andrew Stillman - EdReach

Google Educast #151: Google Apps Script Guru, Andrew Stillman - EdReach | Google Apps Script | Scoop.it
"Our special guest for the show is none other than EdTech royalty, Andrew Stillman, creator of insanely useful scripts and Add-ons … most notably, Doctopus and Autocrat. Andrew talks about some of the tools you might not have heard of like siteMaestro and chromebookInventory. He also chimes in on his unique perspective on Google Classrooms."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Using Google Apps Script to proxy YouTube Analytics Channel Reports

Using Google Apps Script to proxy YouTube Analytics Channel Reports | Google Apps Script | Scoop.it

YouTube Analytics Channel Reports are restricted to the user authorizing the request must be the owner of the channel. This can cause issues in Apps Script when interacting with other services. This post highlights a workaround where the data is proxied via a separate script published as a web app.

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

Automatically updating a Google Sheet with data from Google Analytics for regular reporting

Automatically updating a Google Sheet with data from Google Analytics for regular reporting | Google Apps Script | Scoop.it

There are regular reporting features built in to Google Analytics but what if you want to do customised reporting? One answer is Google Apps Script and this post walks you through access Google Analytics data in one line of code and setting up automated collection

more...
Moneback Rusty's curator insight, July 22, 9:23 AM

Regarder film en streaming 
Film Porno en streaming 
streaming 
Film Porno 
Film en streaming 
Film streaming Vf 
Film X en streaming 
Film en streaming Gratuit 
Film X 
vk streaming 
film 
Films en streaming Gratuit

Films en streaming VF | Regarder film complet en streaming gratuit


Mots clés en Associées à: Film en streaming 
Film en streaming 
Regarder film en streaming 
Film Porno en streaming 
streaming 
Film streaming Vf 
Film X en streaming 
Film en streaming Gratuit 
Film X
Lieu de tournage streaming 
Film streaming Verser mobile Gratuit 
Film streaming Payant 
Film en streaming pour téléphone portable 
Abonnement Film en streaming 
Regarder Film X en streaming Gratuit 
Film streaming Xxl Gratuit 
Film en streaming pour portable

Film Streaming Gratuit en francais Films en streaming VF | Regarder film complet en streaming gratuit

Moneback Rusty's curator insight, July 22, 9:30 AM

Film en streaming Gratuit 
https://www.facebook.com/filmstreamsgratuits

 

Regarder film en streaming 

 

https://www.facebook.com/streaming.films7

 


Film X en streaming
Film en Streaming Gratuit
Regarder film en streaming Gratuit
Film en streaming Vk
Film en streaming
Film en streaming Vf
Film Porno en Streaming
Regarder Un Film en streaming
Voir Film en streaming
Film Erotique En streaming
Série en streaming
http://filmstreaminggratuit.net/

 

Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Datastore driver - Desktop Liberation

Datastore driver - Desktop Liberation | Google Apps Script | Scoop.it

the Google Cloud Datastore driver for Google Apps Script database abstraction.


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

How to poll a Google Doc from an add-on

How to poll a Google Doc from an add-on | Google Apps Script | Scoop.it
A documented restriction with document and sheet add-ons is that Apps Script cannot tell what a user does outside of the add-on. This tantalizing tip is given: It is possible to poll for change...
more...
No comment yet.
Rescooped by Martin Hawksey from iGeneration - 21st Century Education
Scoop.it!

Super Quiz on Google Forms - Full Guide - YouTube

Super Quiz Full Guide

Via Tom D'Amico (@TDOttawa)
more...
Jerry Johnson's curator insight, July 9, 7:57 AM

Very nice! 

Alfonso Gonzalez's curator insight, July 10, 6:00 PM

It's like Flubaroo with a few more features of automaticity.

Scooped by Martin Hawksey
Scoop.it!

Change in Apps Script's DocsListDialog

DocsListDialog is a widget used by only a small fraction of Apps Script projects to provide a Google Drive "file open" dialog in a UI service user interface. In almost all cases, using Google Picker in HTML service is preferable and more secure.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Free Technology for Teachers: Where Have My Google Spreadsheet Scripts Gone? They're Add-ons or...

Free Technology for Teachers: Where Have My Google Spreadsheet Scripts Gone? They're Add-ons or... | Google Apps Script | Scoop.it
"Over the last couple of weeks I have received a bunch of emails from readers who were looking for Google Spreadsheet scripts that they used last year, but cannot find this year. The reason for this is that when Google pushed out the updated Spreadsheets to all Google Apps for Edu domains the script gallery was removed from the "insert" menu in Google Spreadsheets. A few of those scripts are now available as Add-ons, but most are not."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

New hints feature in the Apps Script code editor

New hints feature in the Apps Script code editor | Google Apps Script | Scoop.it

"You may have noticed a new icon in the script editor a couple of weeks ago: a light bulb. This is icon will be grayed out most of the time, but when it lights up it means that our system has some useful information to share about your script, such as performance improvements or warnings about the use of deprecated methods. We collect this data as your script executes, so you won't get any hints until after the first time you've run it."

 

 - Eric Koleda - Google+

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

Google Groups Directory - Google Apps Script Examples

For Google Apps Administrators, deploy this Web App to let your users see the members of each domain Groups / mailing lists.

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

Back end performance linearity - Google Apps Script

Back end performance linearity - Google Apps Script | Google Apps Script | Scoop.it

I have a number of backends database all abstracted so they use the same code. Google Apps Script code. Here's the top 5 measured for performance linearity


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

Cloud print connector for Google Apps Script - Desktop Liberation

Cloud print connector for Google Apps Script - Desktop Liberation | Google Apps Script | Scoop.it
" Lenny Cunningham, created this handy Cloud Print Connector for Google Apps Script, using the library from EzyOauth2 - taking some pain out of Apps Script API authentication. "
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Forms: Response Email based on Selection List - Etwas Shawn

"In this example you can use this script to send an email based on a drop selection. Here the school is identified as the criteria for who receives the email. The list of schools and the email recipient are listed on a separate spreadsheet called 'Setting' and can be edited as desired. Also the email subject and message can be edited also. At the end of the email message the form items that were selected at appended to the email."

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

Send a Google Doc in an email message using Apps Script

Gist from Eric Koleda which fetches a Google Doc as HTML and then uses MailChimp API to convert CSS to inline to send in an email
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Mindset Blog: Tips for Creating a Google Apps Script/SAP Mashup

" We recently submitted our product CloudShuttle to the Chrome web store for Google Sheets add-ons.  Am I tired?  Yes.  Did I spend a few too many late nights in front of a code editor?  Yes.  

 

Would I do it again?  One hundred bajillion percent yes.

 

So, having spent the last few month with my head way inside the process to integrate Google docs with an SAP backend through NetWeaver Gateway, I humbly offer a few tips to the blogosphere for anyone wanting to do the same thing.  "

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

Relative performance - Desktop Liberation

Relative performance - Desktop Liberation | Google Apps Script | Scoop.it
In Migrate data from scriptDb to Datastore I showed how to copy over data easily from scriptdb to datastore. The good thing about abstracting the database is that code is the same regardless of which database use you are using (once you've got the handle). 
 
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Manage Chromebooks through a Google Sheet > chromebookInventory (Add-on) - New Visions CloudLab

Manage Chromebooks through a Google Sheet > chromebookInventory (Add-on) - New Visions CloudLab | Google Apps Script | Scoop.it

"This tool allows you to export and bulk update the key metadata and org units of your managed Chrome devices via a Google Sheet. "

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

Super Quiz - Google Sheets add-on

Super Quiz - Google Sheets add-on | Google Apps Script | Scoop.it
Super Quiz adds brilliant functionality and assessment tools to a quiz made with Google Forms.

Via Tom D'Amico (@TDOttawa)
more...
No comment yet.