As of Oct 3, 2022 Google will stop supporting the current oAuth flow.
Please consult this link to read the Blog Post from Google.

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.

API enabling

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.

oAuth Consent screen

When you’ll create the DataSource on the CHILI publisher’s side, Google will show an oAuth consent Screen. The information in this wizard will show in this screen, and provide information to your API consumers.

Some fields speak for themselves, we’ll list the one’s that are important for the DataSource setup

Scopes

Define the scope for your application.

Up to you if you want to limit the scope. As for the CHILI publisher datasource, this is not necessary.

Test users

Define the users that will be able to test, while you App in Google Cloud is in testing phase.

Credentials

Define the credentials, you’ll use to connect with the datasource.

Click “Create Credentials”, and choose OAuth client ID

Choose “Web Application”.

Fill in the App name and Authorised redirect URIs.

Redirect URI

The URI should look like this.

You’ll need to fill in [your-chilipublisher-url]

And the API version (e.g. v1.2)

https://[your-chilipublisher-url]/rest-api/[api-version]/system/server/googleauthcode

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

URI in http or https?

	On premise hosting	CHILI publisher Online

	On premise hosting	CHILI publisher Online
CHILI publisher is hosted in HTTP (non secure)	You must set the return API also to HTTP Will only work when the Google Application is in Test	Can NOT be hosted in HTTP
CHILI publisher is hosted in HTTPS (secure)	You must set the return URI to HTTPS	You must set the return URI to HTTPS

CHILI publisher side

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 “Authorize”.

If you just created the Credentials, and enabled the API’s, it could take a while. Consult the Google Cloud documentation to see what appropriate times are.

Fill in the created code in the field “Your Access Code“ in the BackOffice.

You’re all set

Sharing

If the file does not appear in the list of files for your datasource, you’ll need to share it, with the user you defined.

If you work from within a Google Organisation, the file might be shared with your user already. Just make sure the other users also have access.

You could remove the restrictions, but then your files / datasource might be accessible for too many people

Know restrictions

Applies when you have more than 1 Google SpreadSheet datasources defined.

When you have an open CHILI document, and want to select the second datasource, you’ll still see the files from the first selected datasource.

To see files from the other datasource, reload the file.