Setup — UAGC Weekly Digest Pilot
One thing for you to set up in Teams so the automated weekly digest can start posting. Total time: ~3 minutes.
TL;DR: Create one Workflow in the Alchemy-UAGC → General channel, copy the webhook URL it generates, send it to Shane. The digest will start posting there every Monday at 7:00 AM. That's it.
The pilot scope
For this test run, the digest will post to just one channel: Alchemy-UAGC → General. That channel already has the right audience (you, Craig, Kara, Nina, Shane) and is limited — so this is a safe, low-stakes way to validate the format before we expand.
A single post will go up every Monday with all 4 courses in it, each as its own section. Once we're happy with how it looks, we can split it into per-course channels if you want — but that's a later decision, not required now.
Why the setup step is needed
Shane is a guest in the UAGC Teams tenant, so he can't create Workflows in UAGC-owned channels. You can. The Workflow you create generates a unique URL that Shane plugs into his Power Automate flow in the Nectar tenant. That flow is what pulls from Asana, builds the card, and posts via the URL.
One-time setup. After you send Shane the URL, nothing more is required on your end.
Before you start
- You need to be an owner of the Alchemy-UAGC team (you already are)
- About 3 minutes
- Somewhere to paste the URL briefly (Notes, a draft email, etc.)
Steps
1Open the Alchemy-UAGC → General channel
In Teams, navigate to Teams and channels →
Alchemy-UAGC →
General.
2Open the channel's "More options" menu
Click the
··· (three dots) next to "General" in the left rail, or at the top right of the channel header.
3Choose "Workflows"
Select
Workflows from the menu.
(Microsoft is phasing out the older "Connectors" option. If you see both, use Workflows — that's the supported path.)
4Pick the webhook template
In the Workflows dialog, search for
webhook. Select the template titled
"Post to a channel when a webhook request is received."
5Name the workflow and confirm the target
Name it something clear, e.g.
UAGC Weekly Digest. Confirm the Team is
Alchemy-UAGC and the channel is
General. Click
Next or
Add workflow.
6Copy the webhook URL
Teams will show you a URL starting with
https://prod-xx.westus.logic.azure.com/....
Copy it immediately. (You can retrieve it later via
Manage workflows, but it's easier now.)
7Send the URL to Shane
Email or Teams DM it to Shane (
smerritt@nectar.inc). Format:
UAGC Weekly Digest — General channel
https://prod-xx.westus.logic.azure.com/...
After setup
What Shane will do
- Plug the URL into the Power Automate flow on his end
- Run a manual test post — you'll see a card labeled "[TEST]" appear in General
- If it looks right, enable the weekly schedule (Mondays, 7:00 AM PT)
What you do after setup
Nothing. The Workflow runs on Microsoft's infrastructure; Shane's Power Automate flow runs on Microsoft's infrastructure. Neither needs your computer to be on. Just watch for the test post, then the weekly cadence.
Success looks like: Every Monday morning, a single "Weekly Digest" card posts in the General channel with all 4 courses. You review, faculty reviewers react/reply in thread if needed, the week continues.
If you want to stop or change it
In the General channel → ··· → Manage workflows. From there you can pause, rename, or delete. Deleting invalidates the URL — Shane would need a new one if we restart.
If the pilot goes well
If you'd like per-course channels afterward (so Ted only sees CRJ310, Marcella only sees CRJ 3XX, etc.), we'd repeat steps 1–7 for each course channel — ~3 minutes per channel. But that's a decision for later. The pilot intentionally lives in General only.
FAQ
Does this notify everyone in General?
The card posts as a regular message in the channel feed. People in General who have the channel set to "Show in channel list" will see it. It doesn't force a notification unless the card contains @mentions — which V1 doesn't.
What will the card actually look like?
See the
In Teams preview — that's exactly what posts. Four course sections, each with role-by-role items for the next two weeks, plus items flagged "needs tracking" where reviews exist in the process but aren't scheduled in Asana yet.
Does the data stay current?
The flow queries Asana live every Monday morning, so each post reflects that moment's data. If someone updates a task Sunday night, the Monday post reflects it.
What if the data looks wrong?
The digest is a mirror of Asana — fix is always in Asana. If a task is unassigned, the card shows it. If the date is wrong, update the task. If an entire review type is missing, that's the "needs tracking" gap the tool highlights.
Is the URL secret?
Yes — anyone with the URL can post to General. Don't share it beyond Shane. If it leaks, delete the workflow and create a new one.
What's the rollback if we hate it?
Delete the Workflow. The post stops, no cleanup needed. Or ask Shane to pause his Power Automate flow — same effect.