Gemini Exact Online Workspace: why this combination works
Google Gemini is the AI assistant that is fully integrated into Google Workspace. If you work daily with Gmail, Google Sheets and Google Docs, then Gemini is the fastest way to bring your Exact Online data within reach. Via Ledger Botje you connect Gemini to your administration using the MCP protocol — without technical knowledge or custom development.
The major advantage of Gemini compared to other AI assistants is its seamless integration with your existing Google tools. You can process results directly in a spreadsheet, include them in an email or add them to a presentation. This makes Gemini particularly suitable for teams already working in Google Workspace.
Connect Gemini to Exact Online via MCP
Setting up the connection is straightforward and takes less than five minutes. Follow these steps:
- Create a free Ledger Botje account and connect your Exact Online administration.
- Go to the MCP setup guide and follow the steps for Gemini.
- Add the MCP server in your Gemini settings within Google Workspace.
- Ask your first question and verify the connection works.
After setup, Gemini automatically recognises when you need Exact Online data and calls the appropriate Ledger Botje tools.
Practical workflows: Gemini and Google Sheets
A powerful workflow is combining Gemini with Google Sheets. Imagine you need a weekly stock overview. Instead of manually exporting data from Exact Online, you ask Gemini: "Give an overview of all items with fewer than 20 units in stock." You can paste the result directly into a spreadsheet for further analysis.
Other useful combinations:
- "Show all open sales orders from this week" — the AI uses the
salesorders.searchtool and provides a structured overview. - "Which customers have invoices outstanding for more than 30 days?" — ideal for your weekly debtor review meeting.
- "Give the stock value per warehouse" — via the
items.stocktool you get the figures directly for your management report.
Gemini and Gmail: ERP data in your emails
Do you communicate frequently with customers or suppliers by email? Gemini can help you quickly look up relevant data while composing an email. For example, ask: "What is the order status for customer Jansen BV?" and include the answer directly in your reply. No more switching between Exact Online and your inbox.
Get started with Gemini and Exact Online
The combination of Google Gemini, Google Workspace and Exact Online via Ledger Botje makes your daily work significantly more efficient. You retrieve ERP data without opening Exact Online, process results in your Google apps and save valuable time every day.
Check the setup guide to start right away, or view the plans to choose the right subscription. Have questions? The FAQ answers the most common questions.