Job description

Microsoft Teams Bulk DM Tool (Excel, Graph, Background, Guest Support) Description Looking for a developer to build a background tool that sends 1:1 Microsoft Teams messages to many recipients read from Excel. Must use Microsoft Graph (no UI automation) & run reliably in the background Reality/Constraints (please confirm in your proposal) •Sender is a service account in our M365 tenant (work/school). • Teams DMs via Graph work for internal users and external users who are added as Guests in our tenant. • Personal/consumer (Gmail/MSA) accounts cannot be used to send via Graph. • If recipients are external and not yet Guests, tool should support a Guest-invite step (Graph POST /invitations) and track acceptance before sending. Core Requirements 1. Data source o Read from Excel: FirstName, Email, Message, optional TeamsDisplayName, Status (Invited/Accepted/Sent/Failed). 2. Messaging o Send short, templated texts (e.g., ((FirstName))). o Throttling/backoff & retries (respect Graph limits). o Resume on failure (checkpointing); idempotency per campaign. 3. Guest Onboarding (for externals) o Optional: Bulk invite external emails as Guests; write back status (Invited/Accepted). o Only DM once Accepted. Optional email fallback for non-accepted after X days. 4. Run mode o Headless/background (no desktop focus, no RPA clicking). o No monthly VM requirement. 5. Logging & Reports o Real-time progress + export (sent/pending/failed, timestamps, errors). 6. Scale/Reliability o Handle ~300 recipients per run without stalling. 7. Security/Permissions o Minimal delegated Graph scopes (e.g., Chat.Create, Chat.ReadWrite, User.Read, User.Read.All, User.Invite.All) with clear admin-consent instructions. Technical Approach (state your plan) • Preferred: Microsoft Graph (Chats). • Alternative: Teams Bot Framework for proactive 1:1 messages (explain hosting/costs if you propose this). Test Environment • If you have a dev tenant, please validate end-to-end with 10–20 dummy users and provide a screen recording (≥20 sends). • Otherwise, we can provide a tenant service account and a small set of licensed test users. Deliverables • Source code + runnable package. • Setup & usage docs (app registration, scopes/consent). • Throttling/retry strategy explained. • Delivery report output. To Apply • Confirm understanding: no consumer Gmail senders, guesting required for external DMs. • Describe your Graph vs Bot approach and prior Teams/Graph experience. • List any licenses/dependencies

Requirements