Manual 1:1 Teams messaging for outreach — slow, error-prone, and lacked an audit trail.
Node.js + Azure Functions running Microsoft Graph API with MSAL (device-code), ExcelJS for recipient input/output.
Saved ~3.25 hours/week, reduced message errors by ~90%, estimated €18,460 annual savings.
Technology Stack
Implementation Approach
Here's how we designed and built this solution:
- Interactive device-code sign-in using MSAL so messages are sent as a delegated user (no bot onboarding required).
- Excel-driven recipients input (recipients.xlsx) parsed with ExcelJS to support non-technical client workflows.
- Microsoft Graph integration to resolve users, create 1:1 chats, and post messages programmatically.
- Status logging back into the Excel file (messageId, status) plus basic retry handling for transient API failures.
Solution Showcase
💡 Want to see this in action? Book a demo to explore the full solution.
Could This Work for Your Business?
Manual processes eating 10+ hours/week
Microsoft 365 (Teams, SharePoint, Excel)
Similar results in 5-20 days
Then yes — let's talk.
Book Free 30-Min AuditSimilar Projects You Might Like
More automation case studies
QualifyLeadAutomation — Faster Lead Qualification (≈4.2 hrs/week saved)
Canvas Power App + Power Automate flow that speeds up lead qualification in Dataverse, reducing manual work and errors.
End-to-End Azure Data Pipeline — Nightly ETL Automation (≈8.5 hrs/week saved)
Scheduled ADF pipelines + monitoring that ingest CSVs, transform them in Databricks, and load to Synapse — replacing manual ETL runs and monitoring.
Get Similar Results for Your Business
Book a free 30-minute discovery scan to uncover quick wins in your processes, data, and automation opportunities.