Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,465,953
Community Members
 
Community Events
176
Community Groups

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

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

5 answers

1 accepted

3 votes
Answer accepted

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!

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

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.

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

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.

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

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.

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

Atlassian Community Events