# Rows MCP > Rows MCP connects your AI agent directly to your Rows.com account, treating your spreadsheets like an API endpoint. You can manage data tables, query live cell values, append new records, and organize folders using natural language commands. It turns complex spreadsheet maintenance—like updating project trackers or pulling quarterly metrics—into a simple chat conversation. ## Overview - **Category:** industry-titans - **Price:** Free - **Tags:** spreadsheets, data-queries, collaborative-data, table-management, api-integration, data-visualization ## Description This MCP lets you talk to your entire Rows workspace. Instead of clicking through tabs or writing complicated formulas, you tell your agent what data you need, and it executes the command directly against your live sheets. You can list all your managed spreadsheets and retrieve detailed metadata just by asking. Need new project data? Your agent can append values to a table or overwrite specific cell ranges instantly. The system also lets you manage the structure itself, allowing you to create brand-new spreadsheets or delete old ones. It’s like having an expert data analyst sitting next to you who never needs context switching—you just chat with it. Connecting this through Vinkius means all these powerful data orchestration tools are accessible from any AI client you prefer. ## Tools ### create_spreadsheet Generates a brand new, empty spreadsheet document in your Rows workspace. ### delete_spreadsheet Permanently removes an existing spreadsheet from your account. ### get_folder Retrieves detailed information about a specific folder within your workspace structure. ### append_values_to_table Adds one or more new rows of data to the bottom of an existing table. ### get_range_cells Gets granular details about individual cells within a specified range, including formatting and context. ### get_spreadsheet_details Retrieves structural metadata for an entire spreadsheet, such as column names or sheet tabs. ### get_range_values Pulls the actual content and values from a specified cell range (e.g., A1:B5). ### get_workspace_info Retrieves general details about your entire Rows workspace account. ### list_folders Provides a list of all the main organizational folders in your workspace. ### list_spreadsheets Returns a comprehensive list of every spreadsheet file you manage in the workspace. ### update_range_values Overwrites the content and values within a specific cell range. ## Prompt Examples **Prompt:** ``` List all spreadsheets in my Rows workspace. ``` **Response:** ``` I've retrieved your spreadsheets. You have 4 active documents including 'Sales Forecast 2024' and 'Project Tracker'. Which one would you like to retrieve values from? ``` **Prompt:** ``` Show me all spreadsheets in my workspace and pull the latest data from the Sales Dashboard. ``` **Response:** ``` 12 spreadsheets in your workspace. "Sales Dashboard" (last modified 2h ago): Q2 revenue at $1.2M (78% of target), 234 deals closed, pipeline value $3.4M. "Marketing Metrics" (modified today): 45,600 website visits this week (+12%). "Product Roadmap" (modified yesterday): 34 features tracked, 8 shipped this sprint. "HR Headcount" (modified 3 days ago): 127 employees. "Financial Model" (modified 1 week ago). 7 additional spreadsheets. Total cells with live data integrations: 2,340. ``` **Prompt:** ``` Create a new spreadsheet called Q3 Planning and populate it with department budget data. ``` **Response:** ``` Spreadsheet "Q3 Planning" created. 5 columns populated: Department, Q2 Actual, Q3 Budget, Variance, Status. Engineering: $890K actual / $950K budget. Marketing: $234K / $280K. Sales: $456K / $500K. Product: $178K / $200K. Operations: $123K / $140K. Total row: $1.88M actual / $2.07M budget (9.2% planned increase). Conditional formatting applied: green for under budget, yellow for within 5%, red for over. Chart widget added for visual comparison. ``` ## Capabilities ### Manage Files and Folders List, get details for, or create new spreadsheets, while also listing and retrieving information about your organized folders. ### Read Live Data Values Pull real-time data from specific cells or entire ranges within any connected spreadsheet. ### Update Spreadsheet Records Overwrite existing cell values in a range, or add completely new rows of information to an active table. ### Monitor Workspace Status Retrieve high-level details about your entire Rows workspace setup. ## Use Cases ### Quarterly Performance Checkup The Operations Manager needs to know if Q2 revenue hit its target. They simply ask their agent, 'What is the total Q2 revenue in the Sales Forecast 2024 sheet?' The agent executes the query and provides the exact figure instantly. ### Project Tracker Update A Data Analyst finishes a research phase. Instead of manually updating dozens of project status sheets, they instruct their agent to 'Append the final contact list for Project X' into the master tracker table. ### Workspace Audit The Business Owner is onboarding new team members and needs an overview. They ask the agent to list all folders and then retrieve details on one specific folder, giving them a complete map of the data structure. ### Emergency Data Correction A key metric in a live dashboard was accidentally overwritten. Instead of manually fixing it, the user tells their agent to 'Update the value in cell C10 of the Marketing Metrics sheet,' ensuring immediate correction. ## Benefits - Stop copy-pasting. Use the agent to read live values from a range, pulling real-time metrics directly into your conversation without needing to open the sheet. - Never manually update records again. The ability to append values to a table or overwrite specific cells means you can maintain data consistency using simple language commands. - Gain full visibility into your structure. You can list all spreadsheets and folders, giving you an immediate overview of every document in your workspace without clicking through menus. - Build files on the fly. Need a new tracker? Use the agent to create a spreadsheet or delete outdated ones, keeping your digital filing system clean and organized. - Automate complex reads. Instead of building complicated formulas like VLOOKUPs, ask the agent for specific metadata or values from a range; it delivers the answer immediately. ## How It Works The bottom line is that your AI agent acts as a dedicated coordinator, running all spreadsheet operations without you touching the browser interface. 1. Subscribe to the Rows MCP and provide your unique API Key from your Rows.com workspace settings. 2. Connect this MCP key within your preferred AI client, giving your agent permission to interact with your data. 3. Use natural language prompts (e.g., 'What is the total budget for Q3?') to trigger the necessary actions on your spreadsheets. ## Frequently Asked Questions **How do I list all spreadsheets using Rows MCP?** You ask your agent to list all spreadsheets in your workspace. It uses the list_spreadsheets tool to return every file you manage, giving you an immediate inventory of your data assets. **Can Rows MCP update cell values?** Yes, it can overwrite specific cells or ranges using the update_range_values tool. This is useful for correcting metrics or updating calculated fields across a sheet. **What if I need to add new rows of data?** Use append_values_to_table; it adds entirely new records to the bottom of an existing table. This is the fastest way to log multiple entries without manual intervention. **Does Rows MCP handle file organization?** It does. You can list folders and retrieve details for a specific folder using get_folder, helping you map out your workspace hierarchy. **What is the difference between reading values and getting metadata with Rows MCP?** get_range_values pulls the actual content (e.g., '$50,000'). get_spreadsheet_details retrieves structural information about the file itself, like column titles or sheet names.