​
Overview

​
Tool Name

google_drive_tools

​
Purpose

The google_drive_tools section provides integration with Google Drive to manage files and folders, allowing workflows to seamlessly interact with cloud-based storage. This includes uploading files, retrieving file details, and organized file management for collaborative projects.

​
Key Features & Functions

  1. google_drive

    • Handles file-based operations within Google Drive.

    • Supports uploading, organizing, and managing files for cloud storage.

​
Input Parameters for Each Function

​
google_drive

Parameters

NameDefinitionFormat
actionSpecifies the action to perform (e.g., "upload", "create_folder", "delete_file").String (required)
file_pathPath to the file in the local system or Google Drive destination. (required for uploads)String
folder_id(Optional) ID of the target Google Drive folder to store files.String
mime_type(Optional) MIME type of the file being uploaded (e.g., "text/csv", "application/pdf").String

Genbot Tip
When uploading files to Google Drive, always confirm or create the destination folder (folder_id) in advance for organized storage.

​
Use Cases

  1. Cloud-Based Storage Integration

    • Upload files (e.g., reports, flat files) from local directories into shared Google Drive folders for distributed workflows.

    • Example: A daily ETL job exports CSV output and automatically uploads it to a Drive folder for team review.

  2. File Collaboration

    • Manage project files and organize them into appropriate shared folders for easy collaboration.

    • Example: Upload generated reports from Snowflake into Google Drive, enabling external teams to access polished dashboards.

  3. Backup and Archive

    • Use Google Drive to back up critical files or archive old data from completed projects.

    • Example: Archiving quarterly performance reports or snapshots of database states.

NOTE: Ensure folders are properly shared with relevant team members or service accounts to avoid access issues when automating file uploads or downloads.

​
Workflow/How It Works

  1. Step 1: Initiate File Uploads

    • Define source files to upload and specify destination folders (folder_id) within Google Drive.

  2. Step 2: Validate Upload Success

    • Retrieve file metadata after the action completes to confirm successful upload.

  3. Step 3: Manage Folders and Files

    • Organize folders or remove outdated files as workflow requirements evolve.

  4. Step 4: Share Resources

    • Enable collaboration by adjusting folder/file permissions or sending links to relevant stakeholders.

IMPORTANT: Deleting files from Google Drive is irreversible—confirm whether backups exist before removal.

​
Integration Relevance

  • Snowflake Workflows: Pair with snowflake_tools to export processed data or analytics-ready files into Google Drive.

  • Project File Management: Complements project_manager_tools to centralize documents for specific projects or tasks.

  • Data Delivery: Works with email or Slack integrations to distribute file links for stakeholder review.

​
Configuration Details

  • Ensure the correct Google Drive API credentials and permissions are configured.

  • Validate folder IDs or create the necessary folders before automated uploads.

  • Confirm mime_type to prevent issues with unreadable files or unwanted Google Docs conversions.

​
Limitations or Notes

  1. File Size Limits

    • Large uploads may exceed Google Drive free-tier storage limits; partition data if necessary.

  2. Folder Permissions

    • Inadequate permissions can block automated uploads or downloads—assign correct share settings.

  3. MIME Type Handling

    • Define MIME types accurately to maintain file integrity upon upload.

​
Output

  • File Operations

    • Confirmation messages regarding file uploads, folder creation, or deletions.

  • Metadata Results

    • JSON-formatted objects detailing file names, IDs, and folder paths upon successful actions.

  • Error Handling

    • Error messages if uploads fail due to insufficient storage, invalid folder IDs, or permissions.
Git ActionHarvest Control Tools