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?
Example:
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.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The point is to do this without using yet another app. Pretty standard functionality here.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This bug still exists today....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.