You can use Google Sheets as a datasource to feed your CHILI publisher document with variable data. This is a very handy way, to allow coworkers to provide the data.

A few steps are necessary, to create the DataSource Setup in the CHILI publisher’s backoffice.

Setup

You’ll need a Google Cloud Platform account, with sufficient rights to create API credentials.

...

Click “Create Credentials”, and choose OAuth client ID

...

Might seem a bit counter intuitive, but choose “Desktop App”. (you’ll be able to connect to CHILI publisher online or on-prem)

...

Name your OAuth 2.0 connection. This comes in handy, when you have multiple applications.

...

Once created, you’ll get a client ID and Client secret that you will need in the CHILI publisher BackOffice.

...

In the CHILI publisher BackOffice, choose DataSources, and create a new DataSource, choose “Google Spreadsheets” as the type.

...

Provide the Client ID and Secret, and click “Get Access code”.

Fill in the created code in the respective field in the BackOffice.

...

You’re all set

Important change: Google API v4 - June 8 - 2021

With the retirement of Google sheets v3 api, replaced by v4, CHILI publish publisher also implemented these changes.

...

In backoffice find your datasource and generate a new access code.

...

Push “Get new access” code, confirm your choice, copy the code into the datasource page and save the settings.

...