Problem Statement

• Create a Gemini MCP that whenever, receives a request to upload an invoice, it populates the data on a google sheet. Also be able to answer user’s query based on invoice number, fetching data from google sheets and giving the needed details.

To-Do List:

Client:

• Parse invoice data (image to text) VLM (Gemini)
• Connect Gemini API with our MCP server
• Create a Robyn Server to intereact with client (Backend)

Sever:

• Upload invoice data in google sheet (Service account)
• Upload item data in google sheet
• Retrieve based on invoice number
• Allow different query strategies for model to get data for particular use-cases
• Create additional endpoints to do analysis (forecasting) on invoice data uploaded on sheets

User Interface:

• Streamlit application as an interface

Note:

To use with Claude Desktop update the configuration as below:

{ "mcpServers": { "invoice_parser": { "command": "uv", "args": [ "--directory", "/path/to/folder/with/server_file", "run", "python", "-W", "ignore", "server.py" ], "cwd": "/path/to/folder/with/server_file" } } }