orthogonal-sh/google-drive

Google Drive

Find, create, and manage files and folders in Google Drive. Connect your Google account to search for files, create documents, organize folders, and manage your Drive storage.

Requirements

• Install the orth CLI
• Connect your Google Drive at https://orthogonal.com/dashboard/integrations
• OAuth connection must be active (HTTP 428 response means not connected)

Actions

Find File

Search for files and folders in your Google Drive.

orth run google-drive /find-file --body '{
  "q": "name contains \"project\" and mimeType = \"application/pdf\"",
  "orderBy": "modifiedTime desc"
}'

Parameters:

• q - Google Drive query using search syntax
• fields - Specific fields to return (id, name, mimeType, etc.)
• spaces - Search in specific spaces (drive, appDataFolder, photos)
• corpora - Search scope (user, domain, drive, allDrives)
• driveId - Shared drive ID to search in
• orderBy - Sort results (name, folder, createdTime, modifiedTime, quotaBytesUsed, recency, starred)
• pageSize - Number of files to return (max 1000)
• pageToken - Token for pagination
• supportsAllDrives - Include shared drives (true/false)
• includeItemsFromAllDrives - Include items from all drives (true/false)

Create File

Create a new text file in Google Drive.

orth run google-drive /create-file --body '{
  "file_name": "project-notes.txt",
  "text_content": "This is my project documentation.\n\nSection 1: Overview\nSection 2: Details"
}'

Parameters:

• file_name (required) - Name for the new file
• text_content (required) - Text content to write to the file
• mime_type - MIME type for the file (defaults to text/plain)
• parent_id - Parent folder ID to create file in

Get File

Download or retrieve information about a specific file.

orth run google-drive /get-file --body '{
  "fileId": "1abc2def3ghi4jkl5mno6pqr7stu8vwx9yz"
}'

Parameters:

• fileId (required) - Google Drive file ID
• includeLabels - Include file labels in response (true/false)
• acknowledgeAbuse - Acknowledge risk when downloading flagged files (true/false)
• supportsAllDrives - Support shared drives (true/false)
• includePermissionsForView - Include permissions info (true/false)

Create Folder

Create a new folder in Google Drive.

orth run google-drive /create-folder --body '{
  "folder_name": "Project Documents",
  "parent_id": "parent-folder-id"
}'

Parameters:

• folder_name (required) - Name for the new folder
• parent_id - Parent folder ID to create folder in (defaults to root)

Usage Examples

Search for PDF files:

orth run google-drive /find-file -b '{"q":"mimeType=\"application/pdf\"","orderBy":"modifiedTime desc","pageSize":20}'

Find files by name:

orth run google-drive /find-file -b '{"q":"name contains \"meeting notes\"","fields":"files(id,name,modifiedTime)"}'

Search in specific folder:

orth run google-drive /find-file -b '{"q":"\"folder123\" in parents and name contains \"report\""}'

Create project document:

orth run google-drive /create-file -b '{"file_name":"Project Plan.md","text_content":"# Project Plan\n\n## Overview\nThis document outlines our project plan.\n\n## Timeline\n- Phase 1: Research\n- Phase 2: Development"}'

Create file in specific folder:

orth run google-drive /create-file -b '{"file_name":"notes.txt","text_content":"Important notes here","parent_id":"folder456"}'

Download file content:

orth run google-drive /get-file -b '{"fileId":"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"}'

Create project folder:

orth run google-drive /create-folder -b '{"folder_name":"Q1 2024 Projects"}'

Create subfolder:

orth run google-drive /create-folder -b '{"folder_name":"Documents","parent_id":"parent_folder_id"}'

Google Drive Query Syntax

Use these operators in the q parameter for find-file:

File properties:

• name = "filename" - Exact name match
• name contains "text" - Name contains text
• mimeType = "application/pdf" - Specific file type
• parents in "folder_id" - Files in specific folder

File types:

• mimeType = "application/pdf" - PDF files
• mimeType = "image/jpeg" - JPEG images
• mimeType = "application/vnd.google-apps.document" - Google Docs
• mimeType = "application/vnd.google-apps.spreadsheet" - Google Sheets
• mimeType = "application/vnd.google-apps.folder" - Folders

Time filters:

• modifiedTime > "2024-01-01T00:00:00" - Modified after date
• createdTime < "2024-12-31T23:59:59" - Created before date

Other filters:

• starred = true - Starred files only
• trashed = false - Exclude trashed files
• "[email protected]" in owners - Files owned by specific user

Error Handling

• HTTP 428 - Google Drive integration not connected. Visit https://orthogonal.com/dashboard/integrations to connect your account
• 400 Bad Request - Invalid query syntax or parameters
• 403 Forbidden - Insufficient permissions to access file/folder
• 404 Not Found - File or folder does not exist
• 413 Payload Too Large - File content too large for upload
• 429 Rate Limited - Google Drive API quota exceeded

Tips

• File IDs can be found in Google Drive URLs or from find-file results
• Use specific MIME types to filter by file type
• Combine multiple conditions with "and" in queries
• Use quotes around folder IDs and exact names in queries
• Parent folder ID defaults to root if not specified
• Created files are owned by the authenticated user
• Text files support Unicode content and line breaks
• Use pageToken for large result sets with many files