"This was an experiment in learning how to use Google Spreadsheets in combination with Google App Scripts to create a localization table that can be accessed via JSON/JSONP. This is useful because there’s still no useful built-in JSON publishing option for individual spreadsheets."
Martin Hawksey's insight:
Nice way to crowd source translations for your Apps Script projects
"If you still have some old small projects written for ScriptDB that you didn't get round to converting yet, then here's a library that's a complete recreation of the ScriptDB syntax, except that it uses dbAbstraction back end - so you pick whatever platform you prefer and your old ScriptDB code should work with not a lot of modification."
"This is a case study illustrating the use of Google Apps Script to drive Finance Change. The application allows businesses to efficiently manage their expenses saving on processing time and reducing mileage fraud. "
"You can get all your apps scripts, libraries and dependencies up to git hub and documented automatically with this apps script project. No need for local files as everything happens on drive, and no need for local git software or any particular OS as it all happens with the github API." - Bruce MacPherson
" This afternoon I was asked if I could put together a list of my favorite Google Docs, Sheets, and Forms Add-ons. In the past I had put together lists of Sheets scripts, but most of those lists are outdated as Add-ons have mostly replaced scripts. Here's my updated list of my favorite Google Docs, Sheets and Forms Add-ons."
" Using Google Analytics and Google Sheets, you can set up a dashboard to see search terms that people are looking for more than usual. By filtering out searches that are popular all the time, you can focus on what’s new or noteworthy."
"OAuth is the de facto standard for authorization today and is used by most modern APIs. Apps Script handles the OAuth flow automatically for dozens of built-in and advanced services, but until recentlyonly had limited support for connecting to other OAuth-protected APIs such as Twitter, etc. The URL Fetch service’s OAuthConfig class only works with the older OAuth 1.0 standard and only allows the developer of the script (not its users) to grant access to their data. To address this, we’ve create two new open source libraries"
The bad news:
"We believe that these open libraries are a better alternative to our previous solution, and therefore we are deprecating the OAuthConfig class. The class will continue to function until June 26, 2015, after which it will be removed completely and any scripts that use it will stop working We’ve prepared a migration guide that walks you through the process of upgrading your existing scripts to use these new libraries."
Martin Hawksey's insight:
Steve Webster kindly highlights "you can open Google Drive and search for "OAuthConfig" to find stand-alone Google Apps Scripts that you need to perform the migration" Note: this won't work for container bound scripts you have included in Forms, Sheets, Docs or Sites
A question came in on the Google Apps Script Google+ Community which in part was asking about parsing .csv files into a Google Sheet. I initially pointed the asker to some dated documentation so for my penance I've updated it.
"Debbie and John take it to the next level with Google Apps Script. With Apps Script, you can create add-ons for Google Sheets, Docs, or Forms, automate your workflow, integrate with external APIs, and more."
"Introducing inactiveAccountInventory - a very simple Add-on for GAFE domain admins to identify users who just aren't logging in! This Add-on was primarily built to help schools serving high-needs student populations identify and intervene around inequities in student account usage."
Sharing your scoops to your social media accounts is a must to distribute your curated content. Not only will it drive traffic and leads through your content, but it will help show your expertise with your followers.
How to integrate my topics' content to my website?
Integrating your curated content to your website or blog will allow you to increase your website visitors’ engagement, boost SEO and acquire new visitors. By redirecting your social media traffic to your website, Scoop.it will also help you generate more qualified traffic and leads from your curation work.
Distributing your curated content through a newsletter is a great way to nurture and engage your email subscribers will developing your traffic and visibility.
Creating engaging newsletters with your curated content is really easy.