Hi!
We use the Google Drive/Sheets API's to automate some core aspects of a business, in which live insights are saved to a Google Sheet that customers can view.
This process is entirely automated, to which the flow goes something like this:
- Service Worker copies template in root Google Drive, to it's own drive.
- Initial Values are set, like customer name and some other metadata to the sheet.
- Sheet is shared to other Service Workers, and to the staff of the company using a Google Org group so that they can view/edit/share as they would a regular file that they own.
This has worked with 0 issues for about 2 or 3 years now, until today. All newly copied sheets are being flagged as inappropriate, which disallows for sharing to any user, at all. Since the service worker is the technical owner of the sheet, it cannot be accessed via the Google Drive UI to request a review.
There is nothing inappropriate about the content, the sheets simply contain analytics and graphs that are updated with new entries. The API errors do not give any insight to exactly what tripped the alarm, just that it as a whole is "inappropriate".
Things I have tried so far:
- Sharing without a notification email
- Duplicating the file with a .copy() operation and re-sharing (same issue)
- Transferring ownership to a user account (rejected, for the same reason)
I am at a loss here since it seems the only way to resolve this is to request a review from the Drive UI, which isn't possible since the ownership transfer fails from the original service account owner. I wanted to post here to get any possible insight before enrolling in a support plan to get some 1on1 technical support. Any help/ideas is greatly appreciated.
LinkedIn
Twitter
