"This is Part 3 in a series about an example app that I put together to demonstrate and describe the use of various Google Apps Script features. See Part 1 for an introduction. This part is “Using the UrlFetch Services to interact with the Google+ API (after all, it’s REST-based!) and grab info on articles pointed to by users in their activity stream“."
Join Scoop.it for Free
Share ideas that matter on the social web and experience
the benefits of curating the world's best content.
I don't have a Facebook, a Twitter or a LinkedIn account
Already have an account: Login
 Your new post is loading...
Scoop.it!
No comment yet.
Sign up to comment
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"I have lots of email I want to follow up on later or put aside for some time. I use Gmail these days, and I miss Outlook's built in feature for this. Well, there's a solution, the apps script team posted a script for "snoozing" email. My modified take on it is this gmail Follow Up script doc.
The implementation summary is: You can have javascript code run on a Google server at a regular interval that manipulates your gmail messages. You do so by creating a Google Docs Spreadsheet and adding script code to it. I modified the original in a few ways ..." Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Google spreadsheet has a very large collection of functions for you to use when you are developing a spreadsheet. There's functions for manipulation text, arrays, and dates, doing financial and statistical calculations and much more - you can see the whole list in the documentation. Although there's a lot of functions available you might run into a situation where you need to make your own function, and to do that you need to write a bit of JavaScript (about JavaScript in WikiPedia).
Lets look at a simple example: In a spreadsheet you need to convert calories (kcal in EU) to kilojoules (kJ), and instead of doing the calculation in cells (calories * 4.2) you like to use a function called CaloriesToKilojoules. Here's how to do that: Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
I was recently rediscovering an old Hirst post on Google Spreadsheets as a Database in which he demos an “interface for constructing URIs to query Google spreadsheets using the Google query language”. It got thinking one of the aspects of databases is getting data in. I tackled this when I was at Dev8D back in February with the post Collecting any data in a Google Spreadsheet using GET or POST. At the time I was planning a follow-up post to show a practical application but never got around to it. So here is a more refined piece of code which actually records data submitted from your own form or custom code: Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
" Over on the Google Apps Scripts articles section of the Google Code site there’s a great article “Integrating with Google APIs – Creating a simple reading list” which takes the reader through a nice example of using a couple of APIs that have recently been made available to Google Apps Script via the Google APIs Services – the UrlShortener API and the Tasks API. Inspired by the article, I decided to take the idea a little bit further and build something I could demo and then explain at our Manchester GTUG meetup."
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
'This post takes the reader through a simple application, showing the steps required, the code and the supporting setup to build an automated email-to-tasks mechanism. It uses the Gmail Services, Spreadsheet Services and the new Google APIs Services, specifically Tasks.'
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Ferris Argyle demonstrates a Apps Script snippet to read records from a Google Fusion Table Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Find a vast collection of Google Apps Script (GAS) demos and examples.GAS Tutorial, Google Apps Script Tutorial by Waqar... Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
How to use Google Spreadsheet and Google Apps script to batch collect and visualize data about social networks statistics. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"a guest post by Saqib Ali. Saqib is a Google Apps evangelist at Seagate. He has used Apps Script to create a number of applications that leverage Google Apps. His other interests include the curation of Lewis Carroll’s letter and translation of Urdu poetry to English" Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Zachary Cohn and Nick Hughes were planning out the logistics for the next Startup Crawl event in Seattle when they recognized a problem. There wasn't a go-to map to see where startup companies are located in the Seattle area. He [Cohn] wrote a Google apps script to scrape the Seattle 2.0 Index, the online directory of 476 startups in the region. Then, he ran all of the companies through the address lookup service Switchboard.com, exporting them to the Google Map via Batchgeo. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"Solve360 CRM integrates with Google services to provide a two-way contact & calendar sync, email sync and a comprehensive Gmail contextual gadget. We use the standard Google Data APIs. However, some of our use cases required us to use Google documents and spreadsheets. Enter Apps Script!. What brought our attention to Google Apps Script was that it allows you to run your application code right within the Google Apps platform itself, where documents can be manipulated using a wide range of native Google Apps Script functions, changing the perspective."
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"This has been fixed/implemented. All EDU domains scripts can now use Session#getActiveUser and get the email address of the user hitting the script. Please verify and let us know if there are any issues. Sorry it took a little long." Delete the scoop?
Are you sure you want to delete this scoop?
Yes
|
Scoop.it!
For a while I've been curating 'The GAS' which is a collection of Google Apps Script examples and news pulled together using scoop.it. I started it mainly. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"You can use this simple script which will run and add a label to your messages (in addition to existing labels which you might already have) which have attachments of 1, 5, 10, 20 or 50MB. Off course you can customize the script to allow additional/different capacities." Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
This is Part 2 in a series about an example app that I put together to demonstrate and describe the use of various Google Apps Script features. See Part 1 for an introduction. This part is “Using the Tasks API to retrieve and insert tasklists, and the Ui Services to build the tasklist chooser component“. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Slides and example links from Nicolas Garnier's (@Nivco) presentation Enterprise Workflow with Apps Script Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
As you noted, Google Apps Script is excellent for data workflows. It acts as a super glue for various data repositories (e.g. spreadsheets, sites, gdocs, gmail) in the Google Apps suite. However, I am noticing that it is not so ...
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
By setting up a Google Apps Script to monitor his gmail inbox Google Engineer Drew Csillag is able to automaticaly populate a Google Spreadsheet of his dailly calorie intake populated from emails he sends himself. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Part of the Google Apps for Education Professional Development Webinar series - www.google.com/apps/intl/en/edu/webinars.html Automating School Processes wit... Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Something I’ve been meaning to do for a while is find a way to quickly (and freely) analysis a twitter stream to identify the audience sentiment. You can pay big bucks for this type of solution but fortunately viralheat have a sentiment API which gives developers 5,000 free calls per day. To use this you push some text to their API and you’ll get back the text mood and probability that the sentiment detected is correct (more info here). So here is a second-by-second sentiment analysis of Donald and Joe’s presentations, followed by how it was done (including some caveats about the data). Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Gmail Stats!Get a monthly activity report on Gmail thanks to Google Script: number of emails send and received, Top 5 senders and recipients, average…... Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"a script that runs in Google Docs, turning inline citations into a formatted bibliography. It lets you cite using DOIs, Mendeley library IDs, or any URL that returns metadata as JSON. It's a first, basic attempt" Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"In January of this year we launched BigQuery integration with Google Apps Script. What we didn’t mention was that we were building this on top of our Google APIs Discovery Service. Thanks to the ease and flexibility of writing clients based on this API, today we’re announcing integration with three more APIs, and revamping our BigQuery support.
As of now, we have also integrated the Tasks API, Prediction API, and URL Shortener API in addition to the BigQuery API. You can now include these APIs in your scripts, apps, and sites pages. As with other Apps Script services, we handle all of the server communications as well as authorization, which makes this a great way to build mashups and workflows using our APIs." Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"Charts are a great way to communicate significant amounts of data. We’ve joined forces with the Google Chart Tools team in order to bring a new Charts API to Apps Script. Every day, millions of charts are created, updated, put into presentations, emailed to managers, and published as web pages. Our goal is to automate chart creation in Google Apps and make the sometimes-tedious tasks of chart creation and updating a little more fun!" Delete the scoop?
Are you sure you want to delete this scoop?
Yes
|
