Google Spreadsheet

Owned by Juliane Wetzel
Last updated: May 18, 2022
1 min read

INFO

Google Spreadsheet lets you store and access data from anywhere. This connector lets you take Google sheets data and import it to Datameer.

Prerequisites

INFO

Make sure you have your Google instance configured accordingly. Datameer will retrieve the data with an OAuth token - without revealing a username and a password to Datameer X. 

Prepare your Google instance:

  1. Create a Client ID for Web application in your Google account.
  2. Set an authorized redirect URI for the local Datameer X instance.

Prepare the default properties in Datameer X:

  1. Open the 'default.properties' file under '/<Datameer installation folder>/conf/live.properties'
  2. Add the following lines at the end:
    #Google details for get OAuth token
system.property.webservice.google.oauth.client-id=XXXXXX
system.property.webservice.google.oauth.client-secret=ZZZZZZ

  3. Restart Datameer X. 

Configuring Google Spreadsheet as a Connector

  1. Click the + (plus) button and select Connection or right-click in the browser and select Create new > Connection.
  2. Choose Google Spreadsheet from the drop-down list.
  3. To connect to your Google Docs account, click Authorize Datameer X to retrieve data. You are then taken to a Google portal to generate an OAuth access token for Datameer. The OAuth code is automatically transferred to the appropriate field.
  4. If required, add a description and click Save.