Develop API Between IBM Watson and Excel
GROWTH
Lancer :
Ideal for quick, focused engagements
Team: ≤ 2 resources
Duration: ≤ 3 weeks
Indicative Budget: ≤ $3,000 USD*
Use Cases: MVPs, prototypes, simple websites, bug-fix sprints
Indicative Pricing: ~$15–$25/hr per resource*
Growth :
Best suited for growing products or structured builds
Team: 2–5 resources
Duration: Up to 4 months
Indicative Budget: Up to $30,000 USD*
Use Cases: Feature-rich web apps, integrations, custom dashboards
Indicative Pricing: ~$15–$35/hr per resource*
Enterprise :
Tailored for high-scale, complex or long-term initiatives
Team: 5+ resources
Duration: More than 4 months
Indicative Budget: Starts from $30,000+ USD*
Use Cases: End-to-end platforms, SaaS products, compliance-heavy systems
Indicative Pricing: ~$25–$50/hr depending on roles*
(Development)
Project Description
A US-based data intelligence provider, known for automating enterprise workflows, approached Oodles to enable AI-powered batch processing in Excel using IBM Watson. The client required a seamless API integration that could process large datasets through Watson and update Excel outputs in real time with zero manual effort.
Scope Of Work
The client sought Oodles for enabling Excel to communicate directly with IBM Watson’s NLP engine for real-time batch data interpretation. It covered integration design, secure API handling, automation of Excel workflows, and simplified user interfaces for non-technical users. The goal was to reduce manual research cycles and scale cognitive automation across business teams.
Our Solution
To achieve the client’s goal of intelligent batch processing, Oodles delivered an end-to-end integration between IBM Watson Assistant and Microsoft Excel using a secure middleware API layer.
Key Features and Implementations:
- Watson Assistant Configuration: Built a tailored NLP model to process domain-specific queries and deliver structured responses for Excel consumption.
- Excel Macro Automation: Used VBA scripting to enable Excel users to send bulk queries and auto-populate results without leaving the spreadsheet.
- Middleware API with Node.js: Deployed a secure, lightweight bridge to manage API requests, data validation, and error handling between Excel and Watson.
- Batch Query Execution: Enabled Excel to process entire data columns at once, returning multiple insights per batch.
- Role-Based Access: Implemented tokenized authentication to control API access per user and maintain data confidentiality.
Share Your Requirements