Google Sheets Macro not working with Team Drive Sheet

[Santiago Perez]

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. 

[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]

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!

[Shannon S]

Raphael,

Thank you for clarifying, I hadn't heard of the Team Drive feature before.

I found out that there's a bug reported below:

• CONFCLOUD-55650 Unable to see embedded google docs in a confluence page in case the contents are stored in Team Drives

I've included your feedback regarding the API change on the Atlassian side of the comments. Please feel free to watch the case and vote on it to help keep track of the number of users who run into this issue while using Team Drive.

The workaround at this time would be to move the file out of Team Drive and into a personal drive.

Regards,

Shannon

[Daniel Serodio]

Thanks for the explanation and the link to the bug report Shannon. As I just commented on the bug, this limitation makes this feature almost useless :(

[Shannon S]

Thank you for the feedback on the bug, Daniel! It definitely helps to know how people are using this feature and how such a bug impacts everyone.

Fingers crossed that we can see a fix on this soon.

Regards,

Shannon