Google Drive

Explore 3 actions and their permissionsExact inputs, sign-in scopes, access limits and approval rules.

With Google Drive, a hire can:

• search files by the words in their name or content, optionally in one folder, including shared drives,
• list what's in a folder,
• read a file as text: a Google Doc or Slides deck as plain text, a Sheet as a table (its first sheet), Word, Excel, PowerPoint and OpenDocument files, and text files (the start of large ones).

Hires work with files the same way in Google Drive, OneDrive, Dropbox, Box, Nextcloud and S3. Hires can't change, move, share or delete anything in Drive. PDFs and images show their details only. Passwords and keys written inside files are hidden from hires. To add rows to a spreadsheet, connect Google Sheets too.

1. Make an app in Google CloudCopy Anchor Link

If you already made one for Gmail or Google Calendar, use the same app: turn on the Drive API, add the scope below, and use its client ID and secret here too.

1. Open console.cloud.google.com, and create a project (or pick one).
2. APIs & Services → Library: search for Google Drive API and click Enable.
3. APIs & Services → OAuth consent screen: Internal with Google Workspace; with a personal account, External, add yourself as a test user, then Publish app (in testing, Google stops the access after 7 days).
4. Add the scope https://www.googleapis.com/auth/drive.readonly.
5. Credentials → Create credentials → OAuth client ID, type Web application. Under Authorized redirect URIs, add the address Roster shows on the Google Drive connection. It ends in /api/integrations/google-drive/oauth/callback.
6. Copy the Client ID and Client secret.

2. Connect it in RosterCopy Anchor Link

1. Open Integrations → Tools → Add a tool, search for Google Drive and choose it.
2. Paste the OAuth app client ID and OAuth app client secret and click Connect.
3. Click Connect with Google Drive on the new connection, sign in and click Allow.

Hires see what that Google account can see.

3. Give hires accessCopy Anchor Link

On the hire's Tools tab, click Give access on Google Drive. Read only and Read and write give the same tools here, since nothing in Drive can be changed.

• Folders: IDs of the folders (or shared drives) the hire may look in. A folder's ID is the part after /folders/ in its address. Files in its subfolders count. Leave it empty for everything the account can see.

If something goes wrongCopy Anchor Link

• "Isn't connected yet": press Connect with Google Drive on the connection.
• A big Doc can't be read: Google gives files as text up to 10 MB.
• A file isn't found: the connected account can't see it. Share it with that account.

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "type": "object",
  "properties": {
    "text": {
      "type": "string",
      "minLength": 1,
      "maxLength": 200,
      "description": "words to look for"
    },
    "folder": {
      "type": "string",
      "minLength": 1,
      "maxLength": 1024,
      "description": "a folder's ID, in [brackets] in list_folder and search_files"
    },
    "limit": {
      "default": 20,
      "type": "integer",
      "minimum": 1,
      "maximum": 50
    }
  },
  "required": [
    "text"
  ]
}

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "type": "object",
  "properties": {
    "folder": {
      "description": "a folder (ID); leave out for the top",
      "type": "string",
      "minLength": 1,
      "maxLength": 1024
    },
    "limit": {
      "default": 50,
      "type": "integer",
      "minimum": 1,
      "maximum": 200
    }
  }
}

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "type": "object",
  "properties": {
    "file": {
      "type": "string",
      "minLength": 1,
      "maxLength": 1024,
      "description": "the file's ID, in [brackets] in list_folder and search_files"
    }
  },
  "required": [
    "file"
  ]
}