In Dataiku you have the possibility to add a dataset which actually reads data, live, from a google spreadsheet.
It's also possible to have Dataiku write data in a google spreadsheet via the same connection.
Here is the standard process to do so :
If your work is related to a specific Google Cloud Project, then please ask the administrator of that Google Cloud Project for a service account and then follow the bellow process with that given account.
If your work is not related to a specific Google Cloud Project then you can use the following :
1 - Share your google spreadsheet with a google service account.
dss-google-spreadsheet-connect@bi-gcp-sandbox.iam.gserviceaccount.com
2 - Find the google spreadsheet document ID (gid). This can be found in the google doc URL
3 - Request via a ticket (You can use Solvia) the "Google Cloud Platform JSON Service Key for Dataiku" (This key cannot be shared here publicly).
4 - In your dataiku project, click on "+DATASET" and select "Google Sheets Connector" :
6 - In the document ID, include the GID of the document. In the JSON key, copy/paste the key that was provided to you.
The best way to get IT support is to use the new
Service One Platform.