It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Google Sheets Not working Edited

I installed the macro, but the google sheet does not display.

 

I simply get unauthorized error 401.

 

I can click the link 'open in google drive' and I get to the document. But I can not see it on google drive.

 

 

2 answers

@Daniel Wilczynski  , Try replacing the URL link with Edit link of the Google sheets and also check for Permissions in the google sheets file. 

Hi,

 

@Haran KumarThis is already the case. The sheet is editable by the organization.  I used that editable link on the macro.

The sheet was created by me and that is the gsuite account that I gave It permission to for the plugin.

@Daniel Wilczynski  , Sounds like you have gone wrong no where. As I am not a tech guy , I leave this to some expert personnel to acknowledge. To the  best of my knowledge there may be some code issues with the plugin . Not sure. 
Will Look out for some Possible solutions . 

Regards. 

@Daniel Wilczynski  , Meanwhile you may refer to the below for some clarity. 

Google Spreadsheet embedding


After playing around a bit more I did seem to make it work by making the link world editable, not just my organization.

 

Although thats not 100% satisfactory as I would prefer to restrict access to my organization.

Like Zak Laughton likes this

I've just lost the ability to see embedded google sheets. Making them world editable works. But I can't do that.

@Jonathan Brewer  does the issue still persist. If yes, 
log out from your atlassian account. Try clearing all cookies and cache files from your browser .  Now you may try again to connect to the page, you should be able to view the embedded content after the initial log in . 

This worked for me , so I guess it should hold good for you too .

Best Wishes.

  • Just now I logged out of Confluence.
  • Cleared cache & history for "all time" from Chrome.
  • Logged in to Atlasssian using Google credentials
  • Then logged into onelogin.net by redirect.
  • Went to a Confluence page with two embedded apps: Google Sheets & Lucidchart
  • Lucidchart content displays
  • Google Sheets says: 

We can't open this document as Jonathan Brewer
The document may not exist or you might not have permission to see it.

  • Click on "Open in Google Drive" link & the sheet opens just fine.

My browser credentials are all good - there's still a problem with Confluence.

@Jonathan Brewer  , In the embedded sheet do you have an option called Switch account displayed . If so click on to it and sign in to your atlassian account then see whether you are able to find the content of the sheet in the confluence page . 

I Hope this might help you . 


Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

Introducing Confluence Cloud and Jira Software Cloud Premium

Wherever you are in your team’s journey , our goal is to support your big ambitions. We’re a cloud-first company with the mission of unleashing the potential of every team, and to address the range ...

627 views 4 17
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you