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,945
Community Members
 
Community Events
176
Community Groups

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.

 

 

3 answers

0 votes

I had a similar issue with a 403 error and the root of the problem was blocking 3rd party cookies in Chrome. Once I allowed 3rd party cookies, I was able to see the embedded google content correcty.

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 . 


0 votes

@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

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events