How to Post Google Sheets™ KPI Tables & Charts to Microsoft Teams Channels via Webhooks

By the RangeDrop Engineering Team · 5 min read

Many organizations collaborate in Google Sheets for live modeling while using Microsoft Teams for company-wide communication. After Microsoft retired legacy Office 365 Connectors in favor of Teams Workflows (Power Automate) webhooks, many older scripts stopped working because Teams Workflows require an AdaptiveCard envelope.

Step 1: Create a Microsoft Teams Channel Webhook URL

1. In Microsoft Teams, click the ••• menu next to your target channel and select Workflows (or Connectors if on a classic tenant).
2. Select the template Post to a channel when a webhook request is received.
3. Copy the generated HTTPS URL (supports both *.webhook.office.com and *.logic.azure.com / *.api.powerplatform.com endpoints).

Step 2: Preview Your Adaptive Card Payload

You can test your exact Google Sheets range right now in our Free Sheets-to-Teams Adaptive Card Generator—just switch the Output Format dropdown to Microsoft Teams Workflows (Adaptive Card v1.4 JSON).

Step 3: Automate Recurring Delivery & Chart PNGs with RangeDrop

Instead of writing custom Power Automate expressions to parse spreadsheet rows, paste your Teams webhook URL into RangeDrop inside Google Sheets:

• Automatically formats your selected cell range (`A1:F15`) into a clean Teams card with aligned columns.
• Uploads any selected Google Sheets chart as a high-resolution PNG and embeds it directly in the Teams message on Pro ($49/year).
• Can simultaneously deliver to Slack, Microsoft Teams, and Email in the same scheduled run.