G Suite Developers Blog: 7/1/11

Learn about Google Apps Script in NYC

July 28, 2011

Google Apps Script

Gmail Snooze with Apps Script

Content Approval Workflow

Vacation calendar management

Helpdesk Workflow

Time Booking

Google Apps Script HackathonWhatApps Script HackathonDateTimeWhereRegisterhere
For those who cannot attend in person, we invite you to try out a number of self-paced tutorials on the Apps Script documentation site.

Saurabh Gupta profile | twitter | blog

Saurabh is a Developer Programs Engineer at Google. He works closely with Google Apps Script developers to help them extend Google Apps. Over the last 10 years, he has worked in the financial services industry in different roles. His current mission is to bring automation and collaboration to Google Apps users.

Gmail Snooze with Apps Script

July 27, 2011

pre.code br { display: none; }inbox zeroWhat is Gmail Snooze?The Solutionvar MARK_UNREAD = false;
var ADD_UNSNOOZED_LABEL = false;SetupNote:setup()refreshfunction getLabelName(i) {
return "Snooze/Snooze " + i + " days";
}

function setup() {
// Create the labels we’ll need for snoozing
GmailApp.createLabel("Snooze");
for (var i = 1; i <= 7; ++i) {
GmailApp.createLabel(getLabelName(i));
}
if (ADD_UNSNOOZED_LABEL) {
GmailApp.createLabel("Unsnoozed");
}
}Moving the Snooze Queueevent triggerfunction moveSnoozes() {
var oldLabel, newLabel, page;
for (var i = 1; i <= 7; ++i) {
newLabel = oldLabel;
oldLabel = GmailApp.getUserLabelByName(getLabelName(i));
page = null;
// Get threads in "pages" of 100 at a time
while(!page || page.length == 100) {
page = oldLabel.getThreads(0, 100);
if (page.length > 0) {
if (newLabel) {
// Move the threads into "today’s" label
newLabel.addToThreads(page);
} else {
// Unless it’s time to unsnooze it
GmailApp.moveThreadsToInbox(page);
if (MARK_UNREAD) {
GmailApp.markThreadsUnread(page);
}
if (ADD_UNSNOOZED_LABEL) {
GmailApp.getUserLabelByName("Unsnoozed")
.addToThreads(page);
}
}
// Move the threads out of "yesterday’s" label
oldLabel.removeFromThreads(page);
}
}
}
}Using Snooze Label in GmailIf you don't know how to setup a script, it's pretty simple. Create a new Google Spreadsheet, and choose "Script Editor" from the "Tools" menu. Paste in all of the code from above and then click the “Save” button and give it a name. In the dropdown labeled "Select a function to run," choose "setup" and click the blue run arrow to the left of it. This will ask you to authorize the script, and will create the necessary labels in your Gmail. Then go to the "Triggers" menu and choose "current script's triggers." Click the link to set up a new trigger, choosing the "moveSnoozes" function, a "time-driven" event, "day timer," and then "midnight to 1am." Click save and you are done.

Corey Goldfeder profile

Corey is a Google software engineer on the Apps Script Project, based in New York. He has previously worked on Similar Shape search for 3DWarehouse, and as a robotics researcher before joining Google.

Updated: 7/29/2011 to add additional instructions for refreshing the Gmail window after running the setup() function

Improved Sync - Announcing the Changes Feed in the Documents List API

July 14, 2011

Changes feedapp:editedhttps://docs.google.com/feeds/default/private/changes<?xml version="1.0" encoding="UTF-8"?>
<feed xmlns="http://www.w3.org/2005/Atom"
xmlns:openSearch="http://a9.com/-/spec/opensearch/1.1/"
xmlns:docs="http://schemas.google.com/docs/2007"
xmlns:gd="http://schemas.google.com/g/2005"
gd:etag="W/"DEEMQ3w8eyt7ImA9WhZUGUo."">
<docs:largestChangestamp>5635</docs:largestChangestamp>
<link rel="next" type="application/atom+xml"
href="...?start-index=5636"/>
<entry gd:etag="W/"DUcMRHg5cCt7ImA9WhZUGUo."">
<category scheme="http://schemas.google.com/g/2005#kind"
term="http://schemas.google.com/docs/2007#change"
label="change"/>
<title>Project tasks</title>
...
<docs:changestamp value="5623"/>
</entry>
...
</feed>developer guideforum

Russ Jorgensen LinkedIn

Russ Jorgensen joined Google in 2010 and is responsible for supporting and enhancing APIs which third-party applications can use to access and manage users' collections of Google Docs. Prior to working at Google, Russ was an embedded software engineer for 22 years at Bell Labs building telecommunications products such as PBXs and wireless communication systems.

Want to weigh in on this topic? Discuss on Buzz

Using 2-legged OAuth with the Google Tasks API for Google Apps domain administrators

July 7, 2011

launchGoogle Tasks API

Any use of the Tasks API needs to reference a project in the APIs Console, as the Console is used to manage API quotas and other application settings (such as IP filters).

The Tasks API needs to be explicitly enabled for your domain OAuth key and secret.

Referencing an APIs Console ProjectAPIs ConsoleAPI Keykeyhttps://www.googleapis.com/tasks/v1/users/username/lists?key=<API_KEY>Java client libraryTasks// Initializing the Tasks API service
Tasks service = new Tasks("2-LO Tasks Test", httpTransport, jsonFactory);
service.accessKey = API_KEY;Enabling the Tasks API for your domain OAuth key and secretManage OAuth domain keyEnable this consumer keycheckedAllow access to all APIsunchecked

Setting up the domain OAuth consumer key and secretManage third party OAuth Client accesshttps://www.google.com/calendar/feeds/, https://www.googleapis.com/auth/tasksUsing 2-Legged OAuth with Google Tasks API for Google Apps domain administrators

Nicolas Garnier profile | twitter | events

Nicolas joined Google’s Developer Relations in 2008. Since then he's worked on commerce oriented products such as Google Checkout and Google Base. Currently, he is working on Google Apps with a focus on the Google Calendar API, the Google Contacts API, and the Tasks API. Before joining Google, Nicolas worked at Airbus and at the French Space Agency where he built web applications for scientific researchers.

Want to weigh in on this topic? Discuss on Buzz