tvaras.ai

Google Workspace

Access Google Drive, Docs, and Sheets through the bot. Create spreadsheets from query results, read documents, and manage files.

Setup

  1. Create a Google Cloud service account with these APIs enabled:
    • Google Drive API
    • Google Docs API
    • Google Sheets API
  2. Download the JSON key file
  3. Share any Drive folders or files with the service account email (client_email from the key)
  4. Go to Admin → Connectors → Google Workspace
  5. Upload the JSON key
  6. Optionally set a Shared Drive ID for team drive access
  7. Click Test Connection

Capabilities

Google Drive

  • List and search files by name or content
  • Create folders
  • Upload files (CSV, JSON, SQL, Python, etc.)
  • Get file metadata (size, owners, sharing)
  • Delete files

Google Docs

  • Read document content as plain text
  • Create new documents
  • Append text to existing documents

Google Sheets

  • Read data from any range (A1 notation)
  • Write data to ranges
  • Create spreadsheets with multiple sheets
  • Populate sheets from query results in one call

Example Questions

  • "Export this query result to a Google Sheet"
  • "Find the Q4 planning doc in Drive"
  • "Create a spreadsheet with monthly revenue data"