​
Overview

Enable your agents to manage spreadsheet data through Google Sheets. Read rows, create new entries, update existing data, and streamline your data management workflows with AI-powered automation. Perfect for data tracking, reporting, and collaborative data management.

​
Prerequisites

Before using the Google Sheets integration, ensure you have:
  • A CrewAI Enterprise account with an active subscription
  • A Google account with Google Sheets access
  • Connected your Google account through the Integrations page
  • Spreadsheets with proper column headers for data operations

​
Setting Up Google Sheets Integration

​
1. Connect Your Google Account

  1. Navigate to CrewAI Enterprise Integrations
  2. Find Google Sheets in the Authentication Integrations section
  3. Click Connect and complete the OAuth flow
  4. Grant the necessary permissions for spreadsheet access
  5. Copy your Enterprise Token from Account Settings

​
2. Install Required Package

uv add crewai-tools

​
Available Actions

​
Usage Examples

​
Basic Google Sheets Agent Setup

from crewai import Agent, Task, Crew
from crewai_tools import CrewaiEnterpriseTools

# Get enterprise tools (Google Sheets tools will be included)
enterprise_tools = CrewaiEnterpriseTools(
    enterprise_token="your_enterprise_token"
)

# Create an agent with Google Sheets capabilities
sheets_agent = Agent(
    role="Data Manager",
    goal="Manage spreadsheet data and track information efficiently",
    backstory="An AI assistant specialized in data management and spreadsheet operations.",
    tools=[enterprise_tools]
)

# Task to add new data to a spreadsheet
data_entry_task = Task(
    description="Add a new customer record to the customer database spreadsheet with name, email, and signup date",
    agent=sheets_agent,
    expected_output="New customer record added successfully to the spreadsheet"
)

# Run the task
crew = Crew(
    agents=[sheets_agent],
    tasks=[data_entry_task]
)

crew.kickoff()

​
Filtering Specific Google Sheets Tools

from crewai_tools import CrewaiEnterpriseTools

# Get only specific Google Sheets tools
enterprise_tools = CrewaiEnterpriseTools(
    enterprise_token="your_enterprise_token",
    actions_list=["google_sheets_get_row", "google_sheets_create_row"]
)

data_collector = Agent(
    role="Data Collector",
    goal="Collect and organize data in spreadsheets",
    backstory="An AI assistant that focuses on data collection and organization.",
    tools=enterprise_tools
)

# Task to collect and organize data
data_collection = Task(
    description="Retrieve current inventory data and add new product entries to the inventory spreadsheet",
    agent=data_collector,
    expected_output="Inventory data retrieved and new products added successfully"
)

crew = Crew(
    agents=[data_collector],
    tasks=[data_collection]
)

crew.kickoff()

​
Data Analysis and Reporting

from crewai import Agent, Task, Crew
from crewai_tools import CrewaiEnterpriseTools

enterprise_tools = CrewaiEnterpriseTools(
    enterprise_token="your_enterprise_token"
)

data_analyst = Agent(
    role="Data Analyst",
    goal="Analyze spreadsheet data and generate insights",
    backstory="An experienced data analyst who extracts insights from spreadsheet data.",
    tools=[enterprise_tools]
)

# Task to analyze data and create reports
analysis_task = Task(
    description="""
    1. Retrieve all sales data from the current month's spreadsheet
    2. Analyze the data for trends and patterns
    3. Create a summary report in a new row with key metrics
    """,
    agent=data_analyst,
    expected_output="Sales data analyzed and summary report created with key insights"
)

crew = Crew(
    agents=[data_analyst],
    tasks=[analysis_task]
)

crew.kickoff()

​
Automated Data Updates

from crewai import Agent, Task, Crew
from crewai_tools import CrewaiEnterpriseTools

enterprise_tools = CrewaiEnterpriseTools(
    enterprise_token="your_enterprise_token"
)

data_updater = Agent(
    role="Data Updater",
    goal="Automatically update and maintain spreadsheet data",
    backstory="An AI assistant that maintains data accuracy and updates records automatically.",
    tools=[enterprise_tools]
)

# Task to update data based on conditions
update_task = Task(
    description="""
    1. Find all pending orders in the orders spreadsheet
    2. Update their status to 'processing'
    3. Add a timestamp for when the status was updated
    4. Log the changes in a separate tracking sheet
    """,
    agent=data_updater,
    expected_output="All pending orders updated to processing status with timestamps logged"
)

crew = Crew(
    agents=[data_updater],
    tasks=[update_task]
)

crew.kickoff()

​
Complex Data Management Workflow

from crewai import Agent, Task, Crew
from crewai_tools import CrewaiEnterpriseTools

enterprise_tools = CrewaiEnterpriseTools(
    enterprise_token="your_enterprise_token"
)

workflow_manager = Agent(
    role="Data Workflow Manager",
    goal="Manage complex data workflows across multiple spreadsheets",
    backstory="An AI assistant that orchestrates complex data operations across multiple spreadsheets.",
    tools=[enterprise_tools]
)

# Complex workflow task
workflow_task = Task(
    description="""
    1. Get all customer data from the main customer spreadsheet
    2. Create monthly summary entries for active customers
    3. Update customer status based on activity in the last 30 days
    4. Generate a monthly report with customer metrics
    5. Archive inactive customer records to a separate sheet
    """,
    agent=workflow_manager,
    expected_output="Monthly customer workflow completed with updated statuses and generated reports"
)

crew = Crew(
    agents=[workflow_manager],
    tasks=[workflow_task]
)

crew.kickoff()

​
Troubleshooting

​
Common Issues

Permission Errors
  • Ensure your Google account has edit access to the target spreadsheets
  • Verify that the OAuth connection includes required scopes for Google Sheets API
  • Check that spreadsheets are shared with the authenticated account
Spreadsheet Structure Issues
  • Ensure worksheets have proper column headers before creating or updating rows
  • Verify that column names in additionalFields match the actual column headers
  • Check that the specified worksheet exists in the spreadsheet
Data Type and Format Issues
  • Ensure data values match the expected format for each column
  • Use proper date formats for date columns (ISO format recommended)
  • Verify that numeric values are properly formatted for number columns
Filter Formula Issues
  • Ensure filter formulas follow the correct JSON structure for disjunctive normal form
  • Use valid field names that match actual column headers
  • Test simple filters before building complex multi-condition queries
  • Verify that operator types match the data types in the columns
Row Limits and Performance
  • Be mindful of row limits when using GOOGLE_SHEETS_GET_ROW
  • Consider pagination for large datasets
  • Use specific filters to reduce the amount of data processed
Update Operations
  • Ensure filter conditions properly identify the intended rows for updates
  • Test filter conditions with small datasets before large updates
  • Verify that all required fields are included in update operations

​
Getting Help

Need Help?

Contact our support team for assistance with Google Sheets integration setup or troubleshooting.