Using the Flogo Connector for Google Sheets

[William Karasz]

Quickstart on using the Flogo Connector for Google Sheets

The Flogo Connector for Google Sheets allows you to edit spreadsheets in real-time.

The purpose of this document is to help developers build their first Google Sheets integration, with a primary focus on addressing the prerequisite configuration of the Google environment including from the creation of a Google Project to Service Account Key.

In this document, youll:

 

Create a Google Project

Configure a Service Account with appropriate role

Authorize the Service Account to a Google Sheets resource

Add a Google Connector to TCI Flogo

Implement a Google Sheets activity in Flogo

 

Create a Google Project

Head over to https://console.cloud.google.com. Click on the dropdown at the top of the page. Then select NEW PROJECT.

 

Give the project a name and then click CREATE.

 

Create a Google Service Account and Service Account Key

Follow side navigation: >> IAM & admin >> Service accounts

 

Create a service account

Click on + CREATE SERVICE ACCOUNT

 

Fill out the details, giving a descriptive label for easy recognition later on. The Service account ID (email address) will be the identifier when authorizing this ID for specific Google Sheets.

 

 

Select the role Service Account User from the dropdown

 

Click on CREATE KEY and download the JSON file.

 

 

 

Authorize Service Account User for a Google Sheets Resource

In the target Google sheet, click on Share

 

Add the service account user email

 

Add Google Connector to TCI App

Login to your TIBCO Cloud account, https://cloud.tibco.com, and open TIBCO Cloud Integration. Navigate to the Connections page and click on + Add Connection

 

 

Search and select the Google connector

 

Give the connector an easy to remember label when using or re-using the connector in future applications. Browse to your Google Service Account Key (json format)

 

Create a new Flogo app and select a Google Sheets activity

 

On the Configuration tab, select your Google Connector.

On the Input tab, provide the spreadsheetid and sheetid.

The Spreadsheet ID is in the path of the Sheets URI.

 

The Sheet ID is the name of the tab in the Google Sheet resource.

[Stephen Outram]

Thanks for this article.

 

What's required to get the data (from a CRM source) that can be used to update a Google sheet Similar to an integration app where data is retrieved from fields in a CRM and mapped to fields (cells) in the target sheet

 

Cheers!