Need an app that a user can run that provides a couple of lists of Drive files & folders
1) Items in My Drive shared with others
2) Items Shared with Me showing the sharer
(run-time option for including/excluding Team Drives)
For both lists, the output should go to a Google Sheet on two different tabs. The lists should include item name, item type, last editor, last edit date/time. For items in MyDrive, the list should also include the path to the item and the email address of each person and their privileges (sorted by access permission, then email address). For items Shared with Me, the list should also include the owner of the item, date/time it was shared with me, and my access rights.
I'm open to suggestions on formatting and layout for easiest reading and analyzing.
Hi there,
There is no need for an app to do that. The actual spreadsheet can have a schedules task that will write/update the data. I will create an Google app script that will do all this.
Best wishes,
Lucian
Hi,
This whole exercise call be done using Google scripts itself.
there is no need to install/run any external scripts or applications. everything can be done by scripting google sheets itself.
I have quite a bit of experience in Google scripts. I have done my projects (2 are on freelancer itself). Do check out the 2 projects I have completed successfully.
Would be glad to work on this.
Hi, by app you mean a program that runs on a Windows/MacOS/Linux? if so I can do this using Python. Google offers REST API interface that we can do through python. Would like to discuss more, please send me a message
Hi there
We are a development company specialized in Google Apps Script and G Suite development.
The app you require can be created on Google Apps Script residing on your G Suite without having the need of any other server.
I have understood your requirement and have worked on similar applications in the past and so expect the project to progress quickly and without any roadblocks.
Please feel free to contact me if you have any questions.