Google sheets

Spreadsheet data publisher designed to extend processing capabilites

Overview

With Joule’s Google Sheets connector, you can seamlessly publish real-time events directly in to a spreadsheet.

Key features are:

1. Real-time dashboards Keep your spreadsheets live: insert and update events in real time for dashboards.

2. Spreadsheet analytics Enable deeper business analytics by streaming events directly into your desktop spreadsheets

Client library: com.google.api-client:google-api-client:2.7.0

Examples & DSL attributes

This configuration sets up the publisher to send events directly in a specified Google Spreadsheet.

google sheets publisher:
  application name: Joule google sheets test
  spreadsheetId: 1PNhq2t7fJ8AqJBmlSvywdpI4maFaAaUC
  range: 'Blotter!A2'
  oauth:
      credentials filepath: /home/joule/credentials.json

Setting up

1

Setup google project and enable spreadsheet API

Create a project and enable Google Spreadsheet API.

2

Configure consent and download credentials

To access the spreadsheet Joule needs the user credentials to be created and downloaded. This can be done from the Google Developers Console.

3

Create the target spreadsheet

Create the target spreadsheet and copy the spreadsheet Id.

Copy the spreadsheet id from the URL e.g. https://docs.google.com/spreadsheets/d/1PNhq2t7fJ8AqJBmlSvywdpI4maFaAaUC-BUTyIc8utg

4

Define and deploy sink configuration

google sheets publisher:
  application name: Joule google sheets test
  spreadsheetId: 1PNhq2t7fJ8AqJBmlSvywdpI4maFaAaUC
  range: 'Blotter!A2'
  oauth:
      credentials filepath: /home/joule/credentials.json

5

Now you are ready to publish events to the sheet

Deploy a use case that publishes events to the spreadsheet.

Follow the official google documentation for more information on setting up projects on GCP

Attributes schema

Attribute	Description	Data Type	Required
application name	Application name	String
spreadsheetId	Spreadsheet id that is embedded in the url.	String
range	Target sheet and start cell	String
oauth	OAuth configuration	String

OAuth Attribute

Attribute	Description	Data Type	Required
credentials filepath	Path to the google OAuth consent credentials file.	String