All Categories
Node Documentation
Fetch Google Drive Files

Fetch Google Drive Files

Fetches files from a Google Drive folder.

This node lets you fetch files from a Google Drive folder. It has the option to traverse through all sub folders to retrieve all nested files and also lets you filter which files to return based on file types and certain other filters based on the name, creation and modification dates.

Input Fields

field
schema
explanation
example
parent_folder_id
google_drive_folder_id
Select a Google Drive folder from the dropdown or manually input a folder id.
-
mime_types
google_drive_file_mime_types
Select one or more mime types from the dropdown.
image/png, video/mp4
include_sub_folders
boolean
Enable or Disable the option to also fetch files from all nested sub folders.
Disabled
filters
google_drive_file_filters
Set filters to only select files that match certain criteria.
-

Output Fields

field
schema
explanation
example
files
google_drive_files
An array of Google Drive files.
see below

Example:

[
  {
    "kind": "drive#file",
    "id": "1nGiByiwwLGwasdfjEo3gd3BOO26Y0v9",
    "name": "demo_image.png",
    "mimeType": "image/png",
    "starred": false,
    "trashed": false,
    "explicitlyTrashed": false,
    "parents": [
      "1QP688SgXcF4aZ0f9tgmdtK4TfpgkbPK6"
    ],
    "spaces": [
      "drive"
    ],
    "version": "3",
    "webContentLink": "https://drive.google.com/uc?id=1nGiByiwwLGwasdfjEo3gd3BOO26Y0v9&export=download",
    "webViewLink": "https://drive.google.com/file/d/1nGiByiwwLGwasdfjEo3gd3BOO26Y0v9/view?usp=drivesdk",
    "iconLink": "https://drive-thirdparty.googleusercontent.com/16/type/image/png",
    "hasThumbnail": true,
    "thumbnailLink": "https://lh4.googleusercontent.com/hI8f-dQ_5D3aVH_aIHwqZ-qzfaQUhd723M7bxKwddH817hN6EeBenghYtabrv1u7Rl7etEP_dwv1JZjRME=s220",
    "thumbnailVersion": "1",
    "viewedByMe": true,
    "viewedByMeTime": "2023-02-06T12:14:29.841Z",
    "createdTime": "2023-02-06T12:14:23.270Z",
    "modifiedTime": "2023-01-24T15:47:03.000Z",
    "modifiedByMeTime": "2023-01-24T15:47:03.000Z",
    "modifiedByMe": true,
    "owners": [
      {
        "kind": "drive#user",
        "displayName": "John Doe",
        "photoLink": "https://lh3.googleusercontent.com/a/default-user=s64",
        "me": true,
        "permissionId": "13017820716412739363",
        "emailAddress": "john@doe.com"
      }
    ],
    "lastModifyingUser": {
      "kind": "drive#user",
      "displayName": "John Doe",
      "photoLink": "https://lh3.googleusercontent.com/a/default-user=s64",
      "me": true,
      "permissionId": "13017820716412739363",
      "emailAddress": "john@doe.com"
    },
    "shared": true,
    "ownedByMe": true,
    "capabilities": {
      "canAcceptOwnership": false,
      "canAddChildren": false,
      "canAddMyDriveParent": false,
      "canChangeCopyRequiresWriterPermission": true,
      "canChangeSecurityUpdateEnabled": false,
      "canChangeViewersCanCopyContent": true,
      "canComment": true,
      "canCopy": true,
      "canDelete": true,
      "canDownload": true,
      "canEdit": true,
      "canListChildren": false,
      "canModifyContent": true,
      "canModifyLabels": false,
      "canMoveChildrenWithinDrive": false,
      "canMoveItemIntoTeamDrive": true,
      "canMoveItemOutOfDrive": true,
      "canMoveItemWithinDrive": true,
      "canReadLabels": false,
      "canReadRevisions": true,
      "canRemoveChildren": false,
      "canRemoveMyDriveParent": true,
      "canRename": true,
      "canShare": true,
      "canTrash": true,
      "canUntrash": true
    },
    "viewersCanCopyContent": true,
    "copyRequiresWriterPermission": false,
    "writersCanShare": true,
    "permissions": [
      {
        "kind": "drive#permission",
        "id": "00197326526535954839",
        "type": "domain",
        "domain": "kitchn.io",
        "role": "reader",
        "allowFileDiscovery": true,
        "displayName": "kitchn.io"
      },
      {
        "kind": "drive#permission",
        "id": "13017820716412739363",
        "type": "user",
        "emailAddress": "john@doe.com",
        "role": "owner",
        "displayName": "John Doe",
        "photoLink": "https://lh3.googleusercontent.com/a/default-user=s64",
        "deleted": false,
        "pendingOwner": false
      }
    ],
    "permissionIds": [
      "00197326526527954839",
      "28"
    ],
    "originalFilename": "demo_image.png",
    "fullFileExtension": "png",
    "fileExtension": "png",
    "md5Checksum": "b69c3a92e3a24f14b54244681377e112",
    "sha1Checksum": "ef03f948b0103f65d4ac7eb8ae1b9130b8161acc",
    "sha256Checksum": "6dc9b96e34fe5732aa905ef85989651843463591736384c11e39a142ce5e7656",
    "size": "20206894",
    "quotaBytesUsed": "20206894",
    "headRevisionId": "0B2tWqfXPY7VrdlVWR0gzL1FJejluZVpwNDN3WG8waXJxZjFzPQ",
    "imageMediaMetadata": {
      "width": 3847,
      "height": 5770,
      "rotation": 0
    },
    "isAppAuthorized": false,
    "linkShareMetadata": {
      "securityUpdateEligible": false,
      "securityUpdateEnabled": true
    }
  }
  ]
Did this answer your question?
😞
😐
🤩

Last updated on February 6, 2023

Clear Google Spreadsheet Rows Slack Notifier