Storage & File Management

​

Available Storage Integrations

​

Google Drive

bp add googledrive

• File Access: Read and download files
• File Upload: Upload files to Drive
• Folder Management: Create and organize folders
• File Search: Search for files by name or content
• Sharing: Manage file permissions and sharing
• File Metadata: Access file properties and details

• Document retrieval from chat
• File upload automation
• Shared folder management
• Document search assistance
• File organization workflows

• List files and folders
• Upload files
• Download files
• Create folders
• Search files
• Update file permissions

​

Dropbox

bp add dropbox

• File Management: Upload, download, and delete files
• Folder Operations: Create and manage folder structure
• File Sharing: Generate sharing links
• Search: Find files across your Dropbox
• Metadata: Access file information and properties

• File backup automation
• Document sharing via chat
• Collaborative file management
• File organization assistance
• Cloud storage integration

• Upload files
• Download files
• List folder contents
• Create folders
• Delete files and folders
• Create sharing links

​

Notion

bp add notion

• Page Management: Create, read, and update Notion pages
• Database Operations: Query and manage database entries
• File Access: Read-only file management
• Comments: Add comments to pages
• Workspace Organization: Navigate Notion workspace structure

• Knowledge base updates
• Documentation creation
• Database entry from chat
• Meeting notes automation
• Team wiki management

• Create and update pages
• Query databases
• Add comments
• List items in folder
• Transfer files to Botpress

​

Confluence

bp add confluence

• Page Management: Create and update Confluence pages
• Space Access: Navigate Confluence spaces
• Search: Find content across Confluence
• Attachments: Manage file attachments
• Collaboration: Team documentation workflows

• Documentation automation
• Knowledge base updates
• Team wiki management
• Meeting notes creation
• Content search assistance

• Create and update pages
• Search content
• Manage attachments
• Access space information

​

Airtable

bp add airtable

• Record Management: Create, read, update, and list records
• Table Operations: Create and update table structures
• Flexible Schema: Work with custom field types
• Views: Access different table views
• Relationships: Manage linked records

• Database management from chat
• Data collection and organization
• Inventory tracking
• Project management databases
• CRM-like workflows

• Get Table Records
• Create Table
• Update Table
• Create Record
• Update Record
• List Records

​

Google Sheets

bp add gsheets

• Read Data: Query spreadsheet cells and ranges
• Write Data: Update cell values
• Append Rows: Add new data rows
• Formula Support: Use Google Sheets formulas
• Multiple Sheets: Work with multiple sheets in a workbook
• Batch Operations: Update multiple cells at once

• Data collection from chat
• Form submissions to sheets
• Report generation
• Inventory tracking
• Data analysis workflows
• Dashboard updates

• Read spreadsheet data
• Update cell values
• Append rows
• Create new sheets
• Batch updates

​

File Management Patterns

​

File Upload Workflow

// User uploads file in chat
const file = event.payload.file

// Upload to Google Drive
const driveFile = await client.callAction({
  type: 'googledrive:uploadFile',
  input: {
    name: file.name,
    content: file.url,
    folderId: 'destination-folder-id'
  }
})

// Confirm upload
await client.createMessage({
  conversationId: event.conversationId,
  userId: client.botId,
  type: 'text',
  payload: { text: `File uploaded: ${driveFile.name}` }
})

​

File Search & Retrieval

// Search for files
const results = await client.callAction({
  type: 'googledrive:searchFiles',
  input: {
    query: userSearchQuery,
    limit: 10
  }
})

// Return results to user
for (const file of results.files) {
  await client.createMessage({
    conversationId: event.conversationId,
    userId: client.botId,
    type: 'text',
    payload: { 
      text: `${file.name} - ${file.webViewLink}` 
    }
  })
}

​

Data Collection to Sheets

// Collect data from conversation
const userData = {
  name: event.state.user.name,
  email: event.state.user.email,
  response: event.payload.text,
  timestamp: new Date().toISOString()
}

// Append to Google Sheets
await client.callAction({
  type: 'gsheets:appendRow',
  input: {
    spreadsheetId: 'your-sheet-id',
    range: 'Sheet1!A:D',
    values: [[
      userData.name,
      userData.email,
      userData.response,
      userData.timestamp
    ]]
  }
})

​

Best Practices

​

Security

• Access Control: Use service accounts with minimal permissions
• Secure Credentials: Store API keys and tokens as secrets
• Data Privacy: Ensure compliance with data protection regulations
• Audit Logs: Track file access and modifications

​

Performance

• Lazy Loading: Only fetch files when needed
• Caching: Cache frequently accessed file metadata
• Batch Operations: Group multiple file operations
• Async Processing: Handle large files asynchronously

​

User Experience

• Progress Indicators: Show upload/download progress
• Error Handling: Provide clear error messages
• File Previews: Show file thumbnails when possible
• Size Limits: Communicate file size restrictions

​

Organization

• Folder Structure: Maintain organized folder hierarchy
• Naming Conventions: Use consistent file naming
• Metadata: Tag files with relevant information
• Cleanup: Regularly remove unused files

​

Multi-Storage Strategy

# Install multiple storage integrations
bp add googledrive dropbox notion

• Google Drive: Team collaboration and document sharing
• Dropbox: File sync and backup
• Notion: Knowledge base and documentation
• Confluence: Technical documentation
• Airtable: Structured data and databases
• Google Sheets: Data analysis and reporting

​

Additional Resources

• Google Drive API Documentation
• Dropbox API Documentation
• Notion API Documentation
• Confluence API Documentation
• Airtable API Documentation
• Google Sheets API Documentation