AI Contract Analyze & Teams Reminder Sender

Automates contract data extraction from uploaded documents, logs records in SharePoint, schedules renewal events, and runs a recurring reminder loop via email + Teams.

Power AutomateAIAzure Form RecognizerSharePointTeams

Summary

Problem
Contracts needed manual review, manual tracking, and manual follow-ups for renewal reminders.
Solution
Automated extraction + SharePoint logging + calendar scheduling + reminder workflow with Teams responses.
Result
Less manual admin work, fewer missed renewals, and clear owner accountability with responses captured.

Business impact

This automation was built to prevent missed bid opportunities caused by unstructured contract files and manual digging. When a renewal window is missed, the business can lose access to opportunities worth hundreds of thousands of dollars.

Revenue protected
Reduced the chance of missing high-value bid renewals by turning scattered documents into a searchable SharePoint system with owners, dates, and status tracking.
Risk reduced
Automated reminders (email + Teams) create a consistent follow-up loop so deadlines don’t rely on memory, inbox digging, or “someone will catch it.”
Accountability
Captures responses directly in Teams and logs outcomes back to SharePoint, creating a visible audit trail of who owns the renewal and whether the bid was submitted.

Gallery

Screenshots and artifacts from the build (sanitized where needed).

Intake flow
  • Retrieves file properties and content.
  • Analyzes document using Azure Form Recognizer.
  • Extracts contract fields using OpenAI GPT (structured output).
  • Parses + formats results and checks for duplicates in SharePoint.
  • If new: creates SharePoint record and schedules a calendar event for bid renewal.
  • Includes owner email lookup + error handling for duplicates.
Daily reminder loop
  • Runs daily and checks SharePoint for contracts needing reminders.
  • Calculates days left until renewal.
  • Sends an email to the owner and posts an Adaptive Card in Teams to capture response.
  • If bid submitted: updates status in SharePoint.
  • If not: schedules next reminder date and updates the record; repeats until resolved.