Gemini and Exact Online: ERP meets Google Workspace
For businesses that run on Google Workspace, Google Gemini is the most logical AI assistant to connect to Exact Online. Gemini is deeply integrated into Gmail, Google Sheets, Docs and Drive — which means your ERP data flows naturally into the tools you use every day.
With Ledger Botje as the MCP bridge, Gemini gains access to your Exact Online administration. Ask questions in natural language and receive answers you can immediately use in your Google workflows.
Gemini and Google Workspace: ERP in your browser
The real power of connecting Gemini to Exact Online lies in how it integrates with your existing Google workflow:
- Google Sheets: ask Gemini for a stock overview or revenue breakdown and paste the results directly into a spreadsheet for charts and further analysis.
- Gmail: while composing an email to a supplier, ask "What is the status of our latest purchase order with Van Dijk Supplies?" and include the details in your message.
- Google Docs: generating a monthly report? Ask Gemini to pull the key figures and draft a summary paragraph.
This browser-native approach means you never have to switch to a separate application. Your ERP data comes to you, wherever you work in Google Workspace.
Setting up the connection
Follow these steps to connect Gemini to Exact Online:
- Create a Ledger Botje account on the pricing page and connect your Exact Online administration.
- Configure the MCP server in Gemini. Go to Extensions → Custom MCP → configure URL and enter:
https://www.ledgerbotje.nl/app/mcp
- Authenticate and verify the connection by asking a test question.
Full instructions are available in the MCP setup guide.
Example questions
Start with these practical prompts:
- "Give me a list of all items with stock below the reorder point — I need it for a Sheets export."
- "Which sales orders were placed last week and what is the total order value?"
- "Show the top 5 customers by revenue this quarter."
- "Are there any purchase orders with a delivery date in the next 3 days?"
Get started with Gemini and Exact Online
Google Gemini makes your Exact Online data accessible right where you work. No new tools to learn, no exports to manage. Visit the Gemini integration page, check the prompt library for more ideas, and view the plans to start today.