Can anyone embed a google sheet chart to a confluence page?

[Blake Faulds]

I can embed the entire google sheet into a confluence page but I only want to include the chart. Seems simple enough so I did the following. 

1. Created my chart from the sheet data
2. clicked the chart and published it with full public access
3. confirmed I can access said chart when not logged in to anything
4. copied the link into the confluence page to only receive "restricted link, try another account"

Can anyone successfully embed a chart from google sheets? I can't imagine its an access issue as it is fully public. I also tried restricting it to company only but that didn't change anything. I also tried using the widget connector macro which does nothing.

Any ideas on how to solve this?

Example:

[Blake Faulds · Accepted solution]

So I found a solution to embed only the chart but I feel that the link itself should work and should not display as restricted.

When publishing your google sheet chart use embed and not link. Then copy the embed code and use the default iframe widget to insert it into your confluence page. Once you insert it the iframe will be blank but once you publish the page you will be able to see the chart.

I hope this helps someone else who has this issue.

[Shae Janzen]

This worked perfectly for me!! Thank you so much. I just had to remove some of the iframe code at the beginning and end of the embed content google sheets gave me and fool around with the width and height until it fit!

[Dominic Lunanuova]

Big help!

One clarification I needed after blindly copy/paste: copy only the URL portion of the embed code into the URL field of the iframe

[Katerina Kovriga {Stiltsoft}]

Hi @Blake Faulds @isaiah berg ,

If it happens so that you use our Table Filter and Charts for Confluence app, you may use the following workaround:

• recreate the table from the Google Spreadsheet via URL using the Table from CSV macro;
• create the required chart based on the recreated table right in Confluence using the Chart from Table macro;
• hide the source table and chart controls in the page view mode and leave only the chart itself.

All the changes made to the table in the Google Spreadsheet are passed to the recreated table immediately and the chart is also updated.

Hope that helps your case.

[Blake Faulds]

The point is to do this without using yet another app. Pretty standard functionality here.

[isaiah berg]

Same outcome here - I wanted to ensure that only my team could view the chart URL, and the URL itself generated the same "Restricted" error described above.

The only solution was to use the /iframe widget within Confluence, copy/paste the URL from the "Embed" option within the chart's Publish menu into the URL field, and then set the other parameters (like height and width) of the iframe appropriately.

Not as easy / smooth as the Embed for other Google docs or sheets - would love to see this error / bug addressed so it is as easy as a copy/paste of the URL into a standard block on Confluence.

[Heather Stevens]

This bug still exists today.... 

[Andrew Legrand]

This helped, thanks!

14 months later this bug is still here, but the workaround still works. I receiving the same "restricted link" error message, but was able to embed an iframe as described here.

[Alex Koxaras _Relational_]

Hi @Blake Faulds 

I was able to embed the google sheets, without problem

Just make sure that when you share this document, then it should have this on:

Let me know if that was what you wanted.

[Blake Faulds]

Hi @Alex Koxaras _Relational_ :D

Thanks for the response! Embedding the Google Sheet document works for me but I want to only embed the "chart" from the document. Google allows you to publish a chart to a custom URL so that you can include the chart graphic without having to include the entire spreadsheet. This can be an interactive chart or a static image. I have tried both with no success. :(

To embed only the chart try the steps below and let me know if you were able to do it or if your getting the same error I am. 

Publish a chart

• On your computer, open a spreadsheet in Google Sheets
• Click your chart.
• At the top right of the chart, click More its the three little dots.
• Click Publish chart.
• Choose a publishing option:
  • Link: Copy and drop the link into Confluence. 
    • I made my links public.
• Click Publish.