Import Google Sheet in Confluence through CSV publishing

Question

Hi !

I have issue to import a Google Sheet published as CSV in a Confluence page. I would like to do it through the macro "Table from CSV".

This is how I proceed:

* Publish the Google Sheet as CSV
* Copy the URL and put it as URL of the "Table from CSV"

Result: "400 Bad Request", as shown on the image

Maybe it is due to authentification issue ? I can only publish with "restricted access to my organization".

The import, however, work very well if I publish as HTML web page and I embed with "iFrame". I prefer to do through CSV since I would like to avoid the headers and footer of the HTML page).

Do you know how I could solve this ?

Should I set something to authorize access to the CSV published ?

Many thanks !

Stiltsoft support · Answer

No, I'm afraid, it is not possible as for now.

Only manual import/export in .csv/.xlsx formats is available.

Frédéric Wilhelm · Answer

Thanks ok,

Is it possible to link a Google Spreadsheet into Table Spreadsheet ?

(Because Google Spreadsheet will remain my working document)

Stiltsoft support · Answer

Hi @Frédéric Wilhelm ,

Indeed it's an authentication issue: once you change the restrictions as to "Anyone on the internet with the link can view", the macro will pull the data correctly. Please check our documentation.

As you need to restrict access and share the file only with your colleagues, we can suggest trying the Table Spreadsheet macro.

You'll be able to use all the basic Excel-like features right in Confluence and export the result file to share outside your organization in .xlsx and .csv formats (if required).