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,
Follow these steps to create the DataSource Setup in the CHILI publisher’s backoffice.
...
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.
...
Click “Create Credentials”, and choose OAuth client ID
...
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 publisher also implemented these changes.
...