📊 Google Sheet Super Agent 🤖

✨ Built with Composio

An intelligent agent that can connect to your Google Sheets, understand your data, and answer your questions in natural language. 💬

🚀 Overview

This project is a Next.js application that leverages the Vercel AI SDK to create a chat interface for interacting with Google Sheets. You can provide a Google Sheet URL, and the agent will be able to perform analysis and answer questions about the data in the sheet.

✨ Features

• Connect to any Google Sheet: Simply provide a public Google Sheet URL.
• Natural Language Queries: Ask questions in plain English.
• AI-Powered Analysis: Get insights and answers from your data using powerful AI models.
• Streaming Responses: Get real-time answers from the AI agent.
• Code Highlighting: View the code that the agent uses to analyze your data.

🛠️ Tech Stack

• Framework: Next.js
• Language: TypeScript
• Styling: Tailwind CSS
• AI: Vercel AI SDK, Google Gemini
• Component Library: shadcn/ui
• Integrations: Composio for Google Sheets connection.

🏁 Getting Started

Follow these steps to get the project up and running on your local machine.

Prerequisites

• Node.js (v20 or later)
• npm or yarn

1. Clone the repository

git clone https://github.com/shricodev/google-sheet-super-agent.git
cd google-sheet-super-agent

2. Install dependencies

npm install

3. Set up environment variables

You'll need to create a .env.local file in the root of the project and add the following environment variables. You can get these from Google Cloud Console and Composio.

# API key for Google Gemini (direct access)
GEMINI_API_KEY=

# API key for Composio (tool integrations like Google Sheets)
COMPOSIO_API_KEY=

# Composio user ID (get this from your Composio dashboard after login)
COMPOSIO_GOOGLE_SHEET_USER_ID=

# Auth config ID for Google Sheets inside Composio
GOOGLE_SHEETS_AUTH_CONFIG_ID=

# API key for Google Generative AI SDK (Gemini SDK client)
GOOGLE_GENERATIVE_AI_API_KEY=

# Secret key for signing/encrypting sessions
SESSION_SECRET=<secret_key_for_session>

4. Run the development server

npm run dev

Open http://localhost:3000 with your browser to see the result.

📜 Available Scripts

• npm run dev: Starts the development server.
• npm run build: Builds the application for production.
• npm run start: Starts a production server.
• npm run lint: Lints the codebase.

🤝 Contributing

Contributions are welcome! Please feel free to submit a pull request or open an issue.

📄 License

This project is licensed under the MIT License. See the LICENSE file for details.