You can use Google Sheets as a datasource to feed your CHILI publisher document with variable data.

Follow these steps 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.

Project & Organisation

Create a new project.

Choose the API and services > Enabled APIs and services

Click “+ Enable APIS and services”

We’ll need to enable Google Drive API & Google Sheets API

After enabling, check they are enabled.

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

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

The deprecation date for the v3 api is June 8, 2021.

CHILI publish has made changes in the setup to connect to this datasource, to allow you to keep using your datasource connection.

https://console.cloud.google.com/apis/dashboard
Select your application that is used in CHILI publisher (on the top there is a dropdown) and hit ENABLE APIS AND SERVICES.

Select Google Sheets API and Drive API and enable both of them.

Google Drive API

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.

On your Google Drive, make sure the source file type is Google Sheets, and not Excel.

If not open the file and select File - Save as Google Sheet.