Use cases

Search your Drive files
Four questions Gescon answers by querying the Google Drive folders you authorise.
Administration
«What's the latest version of this template?»
Gescon returns the current file and its modification date.
Finance
«Where's the receipt for this expense?»
Finds the file in the authorised folder and quotes it.
Management
«Who last shared this folder?»
Returns the permission change history, if Gescon has access to it.
People
«Where's the updated welcome manual?»
Searches the authorised folders and returns the current version.
What it brings
What it reads and what it doesn't touch
The connector reads authorised folders and documents without changing Google Drive.

- Authorised foldersOne by one: you choose which ones are in and which aren't.
- Documents with their current versionIdentifies which version is current when there are several.
- File metadataAuthor, modification date, and source folder.
- Citations to the source documentEvery answer links to the exact file.
- No editingThe connector is read-only. It doesn't create, move, or delete files.
Setup
Authorise, choose folders, ask
- Authorise in Google WorkspaceAdmin consent, with minimal read permissions.
- Choose the foldersStart with one. Adding the rest is adding rows, not repeating the project.
- Check the permissionsAsk the same thing with two different users and compare the answer.
Requirements
- Google Workspace admin consent
- Service account with read-only access to Drive
- Two test users with different permissions
Estimated connection time: 20 min
Same family
SharePoint
Microsoft SQL Server