nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Google Sheets Macro not working with Team Drive Sheet

Santiago Perez_e47moq

I'm trying to use the Google Sheet Macro in a page with a Google Sheet in a Team Drive and I'm able to select it when the google file browser shows up but when I select the file I want I get the following message in the attached image. I have access to the file from google drive. I've tried deleting all cookies, and different browsers, all the same result.

Accepted answers

All comments

Shannon S

Santiago,

Do you own the document you are trying to insert? If not the same occur with any other Google Sheet document that you do own?

Regards,

Shannon

Santiago Perez_e47moq

Yes I have admin access in the google team drive. Also I have the "Findable in search results" option enabled.

Shannon S

Hi Santiago,

Sorry, I was asking if you're the physical owner of this document. Did you create it? I remember an issue in the past where this was occurring when a user wasn't the owner of the document, and I want to see if this is related.

Could you also confirm my other question, does this occur with all other Google documents?

Shannon

Raphael Bousquet

Hi Shannon,

An important detail to know about Google Team Drive is that the ownership scheme has changed compared to Google Drive. The Team Drive now owns the files, not the user. You still grant permissions for users to access the files, but the owner is the Team Drive itself.

Other products we use had to adjust their tool to the "new" Team Drive API because of the ownership change.

I hope Atlassian can do the same.

Thank you!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

google

sheet