You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
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?
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.
If it happens so that you use our Table Filter and Charts for Confluence app, you may use the following workaround:
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.
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.
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