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)
http://[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.
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 “Get Access code”.
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