"The integration to Virtual PBX is a custom gateway designed to harvest PBX call data logs and filter them based on calls associated with reservations extensions. I used Google Apps Script to automate the update of call data in near-real-time despite the fact that a formal API is not available from this PBX provider.

The data is stored into a 13 column spreadsheet capable of handling approximately 25,000 calls per month with a ceiling of about two years worth of data. All processes and integration with Virtual PBX is handled by Google Apps Scripts (GAS) and available as an installable service"

" There's no getting away from the fact that Apps Script is slower than the equivalent client based JavaScript processing. It is fundamentally synchronous in implementation, and also has limits on processing time and a host of other quotas. For a cloud based, free service that's about extending Drive capabilities rather than being scalable in the manner of Google App Engine, I suppose it's normal. But let's see if we can at least subvert at least these two things: * get over the 6 minute maximum execution time for Apps Script *run things in parallel "

If you are writing Apps Script webapps and accessing some of the Google JSON APIs services, you're going to need to deal with oAuth2. This library using the statetokenbuilder should help get it right first time.

"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

Following the publication of TwtrService (Google Apps Script client library for Twitter) here's a basic Google Sheet template we use at +ALT to draft tweets we send during events (instead of just sending them on a schedule we have to control to click a link to send)

If you are using the Maps.Directions API, and plotting many source/destination points, you may be hitting quota problems (too many calls in too short a time, maximum daily allowance). Here's how to automate the use of waypoints to make your quota go further - reducing the number of API calls required by as much as x 20.

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.

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.