Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Import Insight Assets from google Spreadsheet


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:'+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

2 answers


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 

Another possibility is to create the import module for the Google Docs integration

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




Suggest an answer

Log in or Sign up to answer

Atlassian Community Events