How do I add a google drive macro to a confluence page

I have followed the instructions on this page: https://confluence.atlassian.com/confcloud/google-drive-macros-737182322.html 

 

to add a google sheet into a confluence page.

When I add, all I get is an image. I am unable to click through to the google sheet

Ideally I want to embed the google sheet into the confluence page if possible

 

The instructions mention:

Show link to open in Google Driveyes

 

But I don't see that option on the macro page

 

Is anyone able to help?

 

Thanks

 

Lisa 

2 answers

0 vote

Hi Lisa,

If you just paste the link to the sheet in Google Drive in the editor, then it will embed a window in Confluence that displays the sheet, along with a button automatically in the top-right corner to open in Google Drive. 

Can you give that a try and let me know how it goes?

Kind regards,

Shannon

Hi Shannon

 

Yes, that is what I have been doing, Pasting the link to the google drive in the 'Widget Connector' Macro in the field Web Site's Widget URL *

 

Then publish and all I get is 2 cogs icon with docs.google.com

Cheers

Lisa

Hi Shannon

 

Yes, that is what I have been doing, Pasting the link to the google drive in the 'Widget Connector' Macro in the field Web Site's Widget URL 

 

Then publish and all I get is 2 cogs icon with docs.google.com

Cheers

Lisa

Lisa,

Are you on Cloud? The documentation you sent was for Cloud so I want to be sure.

I tested this on my current Cloud instance with a Sheets document and it did ask me to login but other than that, the spreadsheet displayed.

Could you also show us what you're seeing with the 2 gears image?

Kind regards,

Shannon

Hi, 

I am having the same issue. I see only the gears but not the sheet itself. 

Hi Deepak,

Your screenshot didn't attach. Could you try to send it again?

Can you also confirm which add-on you're using? The original one doesn't seem to be offered anymore on Marketplace so I want to be sure.

Lastly, can you confirm if you're the author of the document you're trying to embed?

Shannon

Hi Deepak & Shannon,

I found out the issue was due to the Google sheet I was trying to embed was a locked document.

 

It worked fine with a document that was available for all to see

Cheers,

 

Lisa

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

861 views 23 12
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you