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

Blake Faulds October 1, 2021

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:

image.png

6 answers

1 accepted

3 votes
Answer accepted
Blake Faulds October 4, 2021

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 13, 2022

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 16, 2022

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

Like korina.houghtaling likes this
4 votes
Katerina Kovriga {Stiltsoft}
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 8, 2022

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 May 16, 2022

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

Like Aaron Jensen likes this
1 vote
isaiah berg April 7, 2022

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.

0 votes
Heather Stevens
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 30, 2023

This bug still exists today.... 

0 votes
Andrew Legrand December 28, 2022

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.

0 votes
Alex Koxaras _Relational_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 1, 2021

Hi @Blake Faulds 

I was able to embed the google sheets, without problem

google sheets.png

 

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

 

Let me know if that was what you wanted.

Blake Faulds October 4, 2021

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events