Import Insight Assets from google Spreadsheet

[Felix Weber]

Hey,

is there a way using google spreadsheet as source for directly importing assets in insight ?

I am trying to automate creating insight assests - especially when it comes to bulk imports.

Importing CSV files works

However as we are an international company google spreadsheet is a very helpful "database"

Importing CSVs to Insight requires an existing CSV - which needs manually to be exported from google.
( disadvantage with automatic export scripts:  this needs to be setup for a special account and a server to store it.  What happens if employee is leaving, furthermore Locale storage will be outdated as in the near future everything will be cloud based )

Google spreadsheets csv export can easily be used like this:

https://docs.google.com/spreadsheets/d/'+spreadsheetId+'/export?format=xlsx

run some tests like CSV imports - but got stock

1. choosing URL as source
2. using adapted link like above
3. import objects

but it fails  / no objects are imported

=> got only 1652 object without labels - even if there are only 2 items within the list

hopefully you have ideas what I am doing wrong

[Andrew Januszak]

For a recurring import where the sheet is continually updated, try using this format for the URL: https://docs.google.com/spreadsheets/d/'+spreadsheetID+'/gviz/tq?tqx=out:csv&sheet='+sheetID+'

For reference: https://stackoverflow.com/questions/33713084/download-link-for-google-spreadsheets-csv-export-with-multiple-sheets

[Ola_Melin]

Hi, 

It is a very good idea to be able to import google docs. As you have found out it is nothing you can do now out of the box. 

The link to export a spreadsheet is actually a "page" that triggers the download of the exported file and not the file itself. That is why the imported data is quite strange compared to what you would expect. 

Since this is nice feature it is a good idea to add it to the feature list https://jira.riada.se. 

Another possibility is to create the import module for the Google Docs integration https://documentation.riada.se/insight/latest/insight-advanced-usage-guide/insight-for-developers/insight-app-development/create-your-own-import-type-module

It is a more advanced option to create that but it is an alternative. In this way you are able to integrate with any kind of data source. 

But again I think it is a good feature to have so please add it as a feature request

Cheers

Ola