G Suite Developers Blog

Getting Organized with the Tasks API

May 11, 2011

Google Taskswhat they wanted to see improved with Google Tasksretrievingmodifying

Plain HTTP using JSON

Using Google API Client Library for Java

POST /tasks/v1/lists/<list-ID>/tasks
Content-Type: application/json
...
{ title: "Publish blog post" }

Task task = new Task();
task.setTitle(
    "Publish blog post");
client.tasks.insert(
    "list-ID", 
    task).execute();

Client librariesAPI ConsoleAPI Explorerdocumentation

Producteev is a task management platform that lets teams and individuals access their to-dos from a lot of different locations (web, mobile, email, calendars...). You will now have all your Producteev's tasks available in Google Tasks and vice versa!

Mavenlink's project collaboration suite allows you to communicate, share files, track time, invoice, and make or receive payments in one place. With its Google Tasks integration, your Mavenlink project tasks & Google Tasks always stay in sync.

Manymoon is the top installed social task and project management app in the Google Apps Marketplace and makes it simple to get work done online with co-workers, partners, and customers. Manymoon's users can now create and view tasks with Gmail and Google Calendar through Google Tasks.

Zoho offers a suite of online business, collaboration and productivity applications for small businesses. So far they have integrated Zoho CRM & Zoho Projects with the Tasks API.

Get StartedWant to weigh in on this topic? Discuss on Buzz

Posted by Fabian Schlup & Nicolas Garnier
Google Tasks API Team

Introducing Staff Picks on the Google Apps Marketplace

May 9, 2011

Celebrating 1 year of Integrated GoodnessTwitter#mpstaffpick

Our first staff pick

Our first staff pick is Mavenlink, a highly-rated app in the Marketplace. It is a custom-branded project management solution that allows teams to collaborate online, share files, track time, invoice, and make or receive payments, all inside one end-to-end App. Google Apps users can also easily share documents, access contacts, and track projects on their calendars.

If you happen to be at Google I/O next week, you can meet the Mavenlink team in our Developer Sandbox and ask them more about their app and integrations.
What can you do to become a staff pick?

Quality core application

Valuable and deep integrations with Google Apps, such as:

Streamlined setup and provisioning process
Auto-complete and other integrations with Google contacts
Managing Calendar events
Import, export and storage of data in Google Docs.
Provide actionable information in context using Gmail Contextual Gadgets

Great landing page on your web site explaining your Google Apps integrations to customers.

Great customer reviews, ratings, customer success stories, etc.

How can you get your app on our radar?fill out this formWant to weigh in on this topic? Discuss on Buzz

Ryan Boyd profile | twitter | events

Ryan is a Developer Advocate on the Google Apps Marketplace team, helping businesses build applications integrated into Google Apps. Wearing both engineering and business development hats, you'll find Ryan writing code and helping businesses get to market with integrated features.

Autocomplete Email Addresses in Apps Script

May 3, 2011

Editor’s Note: Guest author Steve Webster works at Dito. Dito has developed applications such as Dito Directory which is available in the Google Apps Marketplace.Defining the Requirements

Designing the Application1. Apps Script ServicesSpreadsheet ServiceUi ServiceContacts Service2. Visualize the Layout 3. Choose your widgets4. Challenges//create text box for auto-complete during email lookup in left grid
var textBox = app.createTextBox().setName('textBox')
.setWidth('330px').setId('textBox');
var tBoxHandler = app.createServerKeyHandler('search_');
tBoxHandler.addCallbackElement(textBox);
textBox.addKeyUpHandler(tBoxHandler);
...
function search_(e){
var app = UiApp.getActiveApplication();
app.getElementById('list').clear();
var searchKey = new RegExp(e.parameter.textBox,"gi");
if (searchKey == "") app.getElementById('textBox').setValue('');
var range = sheetOwner.getRange(1, 1, sheetOwner.getLastRow(), 2).getValues();
var listBoxCount = 0;
var firstOne = true;
for (var i in range){
// if first/last name available, display name and email address
if (range[i][0].search(searchKey) != -1 || range[i][1].search(searchKey) != -1){
if (range[i][0].toString()){
app.getElementById('list').addItem(range[i][0].toString()+
' .. '+range[i][1].toString(), range[i][1].toString());
var listBoxCount = listBoxCount + 1;
} else { // else just display the email address
app.getElementById('list').addItem(range[i][1].toString());
var listBoxCount = listBoxCount + 1;
}
if (firstOne) var firstItem = range[i][1].toString();
var firstOne = false;
}
}
// set the top listbox item as the default
if (listBoxCount > 0) app.getElementById('list').setItemSelected(0, true);
// if enter key is pressed in text box, assume they want to add
// the email that’s not in the list
if (e.parameter.keyCode==13 && listBoxCount < 1 && searchKey !== "") {
...herehereDito DirectoryGoogle Apps MarketplacePosted by Steve Webster, DitoWant to weigh in on this topic? Discuss on Buzz

Upload all file types to any Google Account

May 2, 2011

Google Documents List API

?convert=falsechecksumsforumPosted by Rob Wyrick, Google Documents List API TeamWant to weigh in on this topic? Discuss on Buzz

Automate Event Management using Apps Script

April 19, 2011

Editor's Note: Guest author Phil Ridout is an independent consultant specialising in Knowledge Management. He is a facilitator for the Knowledge and Innovation Network (KIN) a business to business knowledge sharing network.Google Apps Script

Create an Events page in the MemberSpace Google Site (in a standardised format)

Create a Calender Event in the Network Events Calendar maintained by facilitators

Announce the event on the MemberSpace news (announcements) page

Allow delegate self-registration

Send attendees a customized email confirmation when they register

Send joining instructions emails to all attendees immediately prior to the event

The Solution

So what’s in the script behind this?Simple Mail Merge1. Event Registration EmailSimple Mail MergeonFormSubmitMail Services2. Event Page in SitesSites Services3. Calendar entry in Events Calendar4. Email confirmation / joining instructions5. Event Announcement in SitesherePosted by Phil Ridout, independent consultantWant to weigh in on this topic? Discuss on Buzz

Grading Made Easy using Apps Script

April 1, 2011

Editor’s Note: Guest author Dave Abouav is a Google employee who is a part-time instructor for a night class in physics. He created Flubaroo as a 20% time project at Google based on his own teaching experiences.Google Apps ScriptFlubaroo

I wanted to build a simple application which can be easily integrated with Spreadsheets without the need to compile and deploy code.

I liked its ability to integrate right into the spreadsheet as a menu, easily giving teachers access to all of Flubaroo's features.

Apps Script provided UI Services which allowed me to build UI applications very easily from within a browser. I did not have to install complex tools to create a UI.

Apps Script Services makes it very easy to integrate other Google APIs such as Google Charts API for the grade histogram.

A JavaScript syntax is easy to program and without the need to learn more complex languages like Java and Python.

Apps Script gave me the ability to easily share my grading technique with other teachers through the Apps Script Gallery. It is very easy for anyone to install the Flubaroo script in their Apps Script editor.

Apps Script DocumentationSpreadsheet ServicesUi Services

Triggers

Flubaroo websitePosted by Dave Abouav, GooglerWant to weigh in on this topic? Discuss on Buzz

OAuth 2.0 for Apps APIs

March 24, 2011

announcementGoogle Apps APIscontactscalendardocsPosted by Steve Bazyl, Google Apps Marketplace TeamWant to weigh in on this topic? Discuss on Buzz

Contact Sharing using Google Apps Script

March 23, 2011

Editor's Note:This article is written by Steve Webster and Vinay Thakker who work at Dito. Dito has developed applications such as Dito Directory which is available in the Google Apps Marketplace.How does it work?

Step 1 lists all the current contact groups in user’s account. The user can select the group he/she wants to share.

Step 2 allows user to select the colleagues with whom the user wants to share his/her personal contact group with.

Step 3 lets the user submit the sharing request.

Designing using Apps Script Services1. Security (guide)2. Spreadsheet ServiceSpreadsheet Service

// grab the group titled "Sales Department"
var group = ContactsApp.getContactGroup("Sales Department");
// from that group, get all of the contacts
var contacts = group.getContacts();
// get the sheet that we want to write to
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Contact Data");
// iterate through contacts
for (var i in contacts) {
//save each of the values into their own columns
sheet.getRange(i, 1, 1, 1).setValue(contacts[i].getGivenName());
sheet.getRange(i, 2, 1, 1).setValue(contacts[i].getFamilyName());
...
sheet.getRange(i, 13, 1, 1).setValue(contacts[i].getWorkFax());
sheet.getRange(i, 14, 1, 1).setValue(contacts[i].getPager());
sheet.getRange(i, 15, 1, 1).setValue(contacts[i].getNotes());
}

3. Ui ServiceUi Services

// create app container, chaining methods to set properties inline.
var app = UiApp.createApplication().setWidth(600).setTitle('Share The Group');
// create all of the structural containers
var tabPanel = app.createTabPanel();
var overviewContent = app.createFlowPanel();
var step1Content = app.createFlowPanel();
var step2Content = app.createFlowPanel();
var step3Content = app.createFlowPanel();
// create u/i widgets
var selectLabel = app.createLabel("Select one of your Contact Groups you want to share with others.");
var contactGroupDropdown = app.createListBox().setName('groupChooser');
// add all children to their parents
overviewContent.add(selectLabel);
overviewContent.add(contactGroupDropdown);
tabPanel.add(overviewContent,"Overview");
tabPanel.add(step1Content,"Step 1");
tabPanel.add(step2Content,"Step 2");
tabPanel.add(step3Content,"Step 3");
app.add(tabPanel);
// tell the spreadsheet to display the app we've created.
SpreadsheetApp.getActiveSpreadsheet().show(app);

// create a function to execute when the event occurs. the
// callback element is passed in with the event.
function changeEventForDrowdown(el) {
Browser.msgBox("The dropdown has changed!");
}
// create event handler object, indicating the name of the function to run
var dropdownHandler = app.createServerChangeHandler('changeEventForDrowdown');
// set the callback element for the handler object.
dropdownHandler.addCallbackElement(tabPanel);
// add the handler to the "on change" event of the dropdown box
contactGroupDropdown.addChangeHandler(dropdownHandler);

4. Contacts ServiceContacts Service

var group = ContactsApp.createContactGroup(myGroupName);
for (var i = 0; i < sheet.getLastRow(); i++) {
var firstName = sheet.getRange(i, 1, 1, 1).getValue();
var lastName = sheet.getRange(i, 2, 1, 1).getValue();
var email = sheet.getRange(i, 3, 1, 1).getValue();
var myContact = ContactsApp.createContact(firstName, lastName, email);
// ...
// set other contact details
// ...
myContact.addToGroup(group);
}

hereClick hereDito DirectoryGoogle Apps MarketplacePosted by Steve Webster and Vinay Thakker from DitoWant to weigh in on this topic? Discuss on Buzz

Last Call for Google I/O: Google Apps Challenge

March 22, 2011

announcedGoogle Apps ScriptGoogle Code BlogContest SitePosted by Ryan Boyd, Google Apps TeamWant to weigh in on this topic? Discuss on Buzz