Pailot

Google Drive

Create, upload, and list files

Google Drive is Google's cloud storage and file synchronization service that allows users to store files, synchronize files across devices, and share files with others. As a core component of Google's productivity ecosystem, Google Drive offers robust storage, organization, and collaboration capabilities.

Learn how to integrate the Google Drive tool in Pailot to effortlessly pull information from your Drive through your workflows. This tutorial walks you through connecting Google Drive, setting up data retrieval, and using stored documents and files to enhance automation. Perfect for syncing important data with your agents in real-time.

With Google Drive, you can:

  • Store files in the cloud: Upload and access your files from anywhere with internet access
  • Organize content: Create folders, use color coding, and implement naming conventions
  • Share and collaborate: Control access permissions and work simultaneously on files
  • Search efficiently: Find files quickly with Google's powerful search technology
  • Access across devices: Use Google Drive on desktop, mobile, and web platforms
  • Integrate with other services: Connect with Google Docs, Sheets, Slides, and third-party applications

In Pailot, the Google Drive integration enables your agents to interact directly with your cloud storage programmatically. This allows for powerful automation scenarios such as file management, content organization, and document workflows. Your agents can upload new files to specific folders, download existing files to process their contents, and list folder contents to navigate your storage structure. This integration bridges the gap between your AI workflows and your document management system, enabling seamless file operations without manual intervention. By connecting Pailot with Google Drive, you can automate file-based workflows, manage documents intelligently, and incorporate cloud storage operations into your agent's capabilities.

Usage Instructions

Integrate Google Drive into the workflow. Can create, upload, and list files.

Tools

google_drive_upload

Upload a file to Google Drive with complete metadata returned

Input

ParameterTypeRequiredDescription
fileNamestringYesThe name of the file to upload
filefileNoBinary file to upload (UserFile object)
contentstringNoText content to upload (use this OR file, not both)
mimeTypestringNoThe MIME type of the file to upload (auto-detected from file if not provided)
folderSelectorstringNoSelect the folder to upload the file to
folderIdstringNoThe ID of the folder to upload the file to (internal use)

Output

ParameterTypeDescription
fileobjectComplete uploaded file metadata from Google Drive
↳ idstringGoogle Drive file ID
↳ namestringFile name
↳ mimeTypestringMIME type
↳ kindstringResource type identifier
↳ descriptionstringFile description
↳ originalFilenamestringOriginal uploaded filename
↳ fullFileExtensionstringFull file extension
↳ fileExtensionstringFile extension
↳ ownersjsonList of file owners
↳ permissionsjsonFile permissions
↳ permissionIdsjsonPermission IDs
↳ sharedbooleanWhether file is shared
↳ ownedByMebooleanWhether owned by current user
↳ writersCanSharebooleanWhether writers can share
↳ viewersCanCopyContentbooleanWhether viewers can copy
↳ copyRequiresWriterPermissionbooleanWhether copy requires writer permission
↳ sharingUserjsonUser who shared the file
↳ starredbooleanWhether file is starred
↳ trashedbooleanWhether file is in trash
↳ explicitlyTrashedbooleanWhether explicitly trashed
↳ appPropertiesjsonApp-specific properties
↳ createdTimestringFile creation time
↳ modifiedTimestringLast modification time
↳ modifiedByMeTimestringWhen modified by current user
↳ viewedByMeTimestringWhen last viewed by current user
↳ sharedWithMeTimestringWhen shared with current user
↳ lastModifyingUserjsonUser who last modified the file
↳ viewedByMebooleanWhether viewed by current user
↳ modifiedByMebooleanWhether modified by current user
↳ webViewLinkstringURL to view in browser
↳ webContentLinkstringDirect download URL
↳ iconLinkstringURL to file icon
↳ thumbnailLinkstringURL to thumbnail
↳ exportLinksjsonExport format links
↳ sizestringFile size in bytes
↳ quotaBytesUsedstringStorage quota used
↳ md5ChecksumstringMD5 hash
↳ sha1ChecksumstringSHA-1 hash
↳ sha256ChecksumstringSHA-256 hash
↳ parentsjsonParent folder IDs
↳ spacesjsonSpaces containing file
↳ driveIdstringShared drive ID
↳ capabilitiesjsonUser capabilities on file
↳ versionstringVersion number
↳ headRevisionIdstringHead revision ID
↳ hasThumbnailbooleanWhether has thumbnail
↳ thumbnailVersionstringThumbnail version
↳ imageMediaMetadatajsonImage-specific metadata
↳ videoMediaMetadatajsonVideo-specific metadata
↳ isAppAuthorizedbooleanWhether created by requesting app
↳ contentRestrictionsjsonContent restrictions
↳ linkShareMetadatajsonLink share metadata

google_drive_create_folder

Create a new folder in Google Drive with complete metadata returned

Input

ParameterTypeRequiredDescription
fileNamestringYesName of the folder to create
folderSelectorstringNoSelect the parent folder to create the folder in
folderIdstringNoID of the parent folder (internal use)

Output

ParameterTypeDescription
fileobjectComplete created folder metadata from Google Drive
↳ idstringGoogle Drive folder ID
↳ namestringFolder name
↳ mimeTypestringMIME type (application/vnd.google-apps.folder)
↳ kindstringResource type identifier
↳ descriptionstringFolder description
↳ ownersjsonList of folder owners
↳ permissionsjsonFolder permissions
↳ permissionIdsjsonPermission IDs
↳ sharedbooleanWhether folder is shared
↳ ownedByMebooleanWhether owned by current user
↳ writersCanSharebooleanWhether writers can share
↳ viewersCanCopyContentbooleanWhether viewers can copy
↳ copyRequiresWriterPermissionbooleanWhether copy requires writer permission
↳ sharingUserjsonUser who shared the folder
↳ starredbooleanWhether folder is starred
↳ trashedbooleanWhether folder is in trash
↳ explicitlyTrashedbooleanWhether explicitly trashed
↳ appPropertiesjsonApp-specific properties
↳ folderColorRgbstringFolder color
↳ createdTimestringFolder creation time
↳ modifiedTimestringLast modification time
↳ modifiedByMeTimestringWhen modified by current user
↳ viewedByMeTimestringWhen last viewed by current user
↳ sharedWithMeTimestringWhen shared with current user
↳ lastModifyingUserjsonUser who last modified the folder
↳ viewedByMebooleanWhether viewed by current user
↳ modifiedByMebooleanWhether modified by current user
↳ webViewLinkstringURL to view in browser
↳ iconLinkstringURL to folder icon
↳ parentsjsonParent folder IDs
↳ spacesjsonSpaces containing folder
↳ driveIdstringShared drive ID
↳ capabilitiesjsonUser capabilities on folder
↳ versionstringVersion number
↳ isAppAuthorizedbooleanWhether created by requesting app
↳ contentRestrictionsjsonContent restrictions
↳ linkShareMetadatajsonLink share metadata

google_drive_download

Download a file from Google Drive with complete metadata (exports Google Workspace files automatically)

Input

ParameterTypeRequiredDescription
fileIdstringYesThe ID of the file to download
mimeTypestringNoThe MIME type to export Google Workspace files to (optional)
fileNamestringNoOptional filename override
includeRevisionsbooleanNoWhether to include revision history in the metadata (default: true, returns first 100 revisions)

Output

ParameterTypeDescription
fileobjectDownloaded file data
↳ namestringFile name
↳ mimeTypestringMIME type of the file
↳ datastringFile content as base64-encoded string
↳ sizenumberFile size in bytes
metadataobjectComplete file metadata from Google Drive
↳ idstringGoogle Drive file ID
↳ namestringFile name
↳ mimeTypestringMIME type
↳ kindstringResource type identifier
↳ descriptionstringFile description
↳ originalFilenamestringOriginal uploaded filename
↳ fullFileExtensionstringFull file extension
↳ fileExtensionstringFile extension
↳ ownersjsonList of file owners
↳ permissionsjsonFile permissions
↳ permissionIdsjsonPermission IDs
↳ sharedbooleanWhether file is shared
↳ ownedByMebooleanWhether owned by current user
↳ writersCanSharebooleanWhether writers can share
↳ viewersCanCopyContentbooleanWhether viewers can copy
↳ copyRequiresWriterPermissionbooleanWhether copy requires writer permission
↳ sharingUserjsonUser who shared the file
↳ starredbooleanWhether file is starred
↳ trashedbooleanWhether file is in trash
↳ explicitlyTrashedbooleanWhether explicitly trashed
↳ appPropertiesjsonApp-specific properties
↳ createdTimestringFile creation time
↳ modifiedTimestringLast modification time
↳ modifiedByMeTimestringWhen modified by current user
↳ viewedByMeTimestringWhen last viewed by current user
↳ sharedWithMeTimestringWhen shared with current user
↳ lastModifyingUserjsonUser who last modified the file
↳ viewedByMebooleanWhether viewed by current user
↳ modifiedByMebooleanWhether modified by current user
↳ webViewLinkstringURL to view in browser
↳ webContentLinkstringDirect download URL
↳ iconLinkstringURL to file icon
↳ thumbnailLinkstringURL to thumbnail
↳ exportLinksjsonExport format links
↳ sizestringFile size in bytes
↳ quotaBytesUsedstringStorage quota used
↳ md5ChecksumstringMD5 hash
↳ sha1ChecksumstringSHA-1 hash
↳ sha256ChecksumstringSHA-256 hash
↳ parentsjsonParent folder IDs
↳ spacesjsonSpaces containing file
↳ driveIdstringShared drive ID
↳ capabilitiesjsonUser capabilities on file
↳ versionstringVersion number
↳ headRevisionIdstringHead revision ID
↳ hasThumbnailbooleanWhether has thumbnail
↳ thumbnailVersionstringThumbnail version
↳ imageMediaMetadatajsonImage-specific metadata
↳ videoMediaMetadatajsonVideo-specific metadata
↳ isAppAuthorizedbooleanWhether created by requesting app
↳ contentRestrictionsjsonContent restrictions
↳ linkShareMetadatajsonLink share metadata
↳ revisionsjsonFile revision history (first 100 revisions only)

google_drive_list

List files and folders in Google Drive with complete metadata

Input

ParameterTypeRequiredDescription
folderSelectorstringNoSelect the folder to list files from
folderIdstringNoThe ID of the folder to list files from (internal use)
querystringNoSearch term to filter files by name (e.g. "budget" finds files with "budget" in the name). Do NOT use Google Drive query syntax here - just provide a plain search term.
pageSizenumberNoThe maximum number of files to return (default: 100)
pageTokenstringNoThe page token to use for pagination

Output

ParameterTypeDescription
filesarrayArray of file metadata objects from Google Drive
↳ idstringGoogle Drive file ID
↳ namestringFile name
↳ mimeTypestringMIME type
↳ kindstringResource type identifier
↳ descriptionstringFile description
↳ originalFilenamestringOriginal uploaded filename
↳ fullFileExtensionstringFull file extension
↳ fileExtensionstringFile extension
↳ ownersjsonList of file owners
↳ permissionsjsonFile permissions
↳ permissionIdsjsonPermission IDs
↳ sharedbooleanWhether file is shared
↳ ownedByMebooleanWhether owned by current user
↳ writersCanSharebooleanWhether writers can share
↳ viewersCanCopyContentbooleanWhether viewers can copy
↳ copyRequiresWriterPermissionbooleanWhether copy requires writer permission
↳ sharingUserjsonUser who shared the file
↳ starredbooleanWhether file is starred
↳ trashedbooleanWhether file is in trash
↳ explicitlyTrashedbooleanWhether explicitly trashed
↳ appPropertiesjsonApp-specific properties
↳ createdTimestringFile creation time
↳ modifiedTimestringLast modification time
↳ modifiedByMeTimestringWhen modified by current user
↳ viewedByMeTimestringWhen last viewed by current user
↳ sharedWithMeTimestringWhen shared with current user
↳ lastModifyingUserjsonUser who last modified the file
↳ viewedByMebooleanWhether viewed by current user
↳ modifiedByMebooleanWhether modified by current user
↳ webViewLinkstringURL to view in browser
↳ webContentLinkstringDirect download URL
↳ iconLinkstringURL to file icon
↳ thumbnailLinkstringURL to thumbnail
↳ exportLinksjsonExport format links
↳ sizestringFile size in bytes
↳ quotaBytesUsedstringStorage quota used
↳ md5ChecksumstringMD5 hash
↳ sha1ChecksumstringSHA-1 hash
↳ sha256ChecksumstringSHA-256 hash
↳ parentsjsonParent folder IDs
↳ spacesjsonSpaces containing file
↳ driveIdstringShared drive ID
↳ capabilitiesjsonUser capabilities on file
↳ versionstringVersion number
↳ headRevisionIdstringHead revision ID
↳ hasThumbnailbooleanWhether has thumbnail
↳ thumbnailVersionstringThumbnail version
↳ imageMediaMetadatajsonImage-specific metadata
↳ videoMediaMetadatajsonVideo-specific metadata
↳ isAppAuthorizedbooleanWhether created by requesting app
↳ contentRestrictionsjsonContent restrictions
↳ linkShareMetadatajsonLink share metadata
nextPageTokenstringToken for fetching the next page of results
On this page

On this page

Get access
Copilot assembles the process. A manager can run it. You can install it in the company contour.
Get access