Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-34110

Widget Connector does not work with Google Spreadsheets or Draw documents

XMLWordPrintable

      NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

      Trying to incorporate a Google spreadsheet or Draw document into Confluence via the Widget connector results in no document being displayed and no error message.

      Workaround:

      • Enable Confluence HTML Macros by going to Confluence Admin > Add-ons > Select All Add-ons > Search for 'HTML', and finally the second HTML module of the Confluence HTML Macro add-on. (Important note: Enabling these macros can make your Confluence site vulnerable to cross-site scripting attacks. Please only enable if you trust your users.)
      • Create a page and add the HTML macro
      • Create an iframe, replacing the URL with the correct document.
      • <iframe src="https://docs.google.com/spreadsheets/d/1dxSPZ07MJaD6HqAC8yqB-10xGWfYflnv1xZR3_fc38/edit?usp=sharing" noborder="0" width="95%" height="800" scrolling="yes" seamless></iframe>

            [CONFSERVER-34110] Widget Connector does not work with Google Spreadsheets or Draw documents

            Jaehyun Kim added a comment -

            In Google Docs, Sheets, or Slides, click File and select Publish to the web. Click Publish then copy the link. 

            Paste it into the editor and Confluence will autoconvert the link and insert the macro for you.

            Jaehyun Kim added a comment - In Google Docs, Sheets, or Slides, click  File  and select  Publish to the web . Click  Publish  then copy the link.  Paste it into the editor and Confluence will autoconvert the link and insert the macro for you.

            Kim Wallace added a comment -

            when publishing a single tab from a Google sheet, the connector fails and displays only a grey box. Removing the parameters starting with "?gid=NNNNNNNNN" and "single=true" m after /pubhtml enables the display 

            Kim Wallace added a comment - when publishing a single tab from a Google sheet, the connector fails and displays only a grey box. Removing the parameters starting with "?gid=NNNNNNNNN" and "single=true" m after /pubhtml enables the display 

            Lauren Hanyok added a comment -

            As per the comments above, this is just a workaround.  I need to be able to access and edit the sheet in confluence, not just see it.  Please add the functionality, or change the description such that is does NOT include sheets.

            Lauren Hanyok added a comment - As per the comments above, this is just a workaround.  I need to be able to access and edit the sheet in confluence, not just see it.  Please add the functionality, or change the description such that is does NOT include sheets.

            Jennifer Horn added a comment -

            Not fixed. Still seeing the gray gear icon.

            Jennifer Horn added a comment - Not fixed. Still seeing the gray gear icon.

            joyadamson added a comment -

            I have the same issue, seeing the grey gear icon

            joyadamson added a comment - I have the same issue, seeing the grey gear icon

            Doug Wieand added a comment -

            Also still seeing the grey gear icon 

            Doug Wieand added a comment - Also still seeing the grey gear icon 

            Che Fisher added a comment -

            From the other thread...

            Why is this marked as resolved?

            The Widget Connector Macro specifically states it can publish Google Docs. A Google Sheet is a type of Google Doc.

            Please actually fix this bug, or make it explicitly clear that the Widget Macro does not support Google Sheets as a document type.

            Che Fisher added a comment - From the other thread... Why is this marked as resolved? The Widget Connector Macro specifically states it can publish Google Docs. A Google Sheet is a type of Google Doc. Please actually fix this bug, or make it explicitly clear that the Widget Macro does not support Google Sheets as a document type.

            deonvanniekerk added a comment -

            This is a work around not a fix?

            deonvanniekerk added a comment - This is a work around not a fix?

            Steve Pawlish added a comment -

            Unfortunately, even after publishing the google sheet to the web, I still see the gray gear icon.

            Steve Pawlish added a comment - Unfortunately, even after publishing the google sheet to the web, I still see the gray gear icon.

            GroundTruth IT added a comment -

            You need to use the Web Publishing option for the Google Doc and copy that link into the Widget. It will be read-only however. 

            GroundTruth IT added a comment - You need to use the Web Publishing option for the Google Doc and copy that link into the Widget. It will be read-only however. 

              honguyen Hoang Nguyen (Inactive)
              shaffenden Steve Haffenden (Inactive)
              Affected customers:
              32 This affects my team
              Watchers:
              73 Start watching this issue

                Created:
                Updated:
                Resolved: