link The Transparency Paradox
DAOs run on the promise of transparency. Yet, their financial data is often locked in silos that regular members cannot access.
search
Etherscan
Too technical for the average member to read daily.
description
PDF Reports
Too slow. By the time it's published, the market has moved.
table_view
Google Sheets
Powerful logic, but nobody checks a spreadsheet for fun.
link The "Push" Architecture
We don’t want to build a custom bot. Bots require hosting, maintenance, and API keys. We want a Serverless Push system.
table_chart
Treasury Sheetbolt
Notify Triggerwebhook
#treasury-loglink Setup Guide
link 1. Get the Webhook
1
Go to Server Settings → Integrations.
2
Click Webhooks → New Webhook.
3
Name it "TreasuryBot" and pick a channel (e.g.
#treasury-updates).4
Copy Webhook URL. Do not share this URL publicly.
link 2. Structure Your Data
Notify works best when your data is structured. For a DAO, you likely have a “Transactions” tab.
| Date | Type | Amount | To/From | Description | Status |
|---|---|---|---|---|---|
| 2025-01-14 | Grant | $5,000 | @DevTeam | Q1 Grant | Pending |
| 2025-01-12 | Expense | $120 | @Infra | Server Costs | Paid |
You want to trigger an alert when the Status changes to Paid.
link 3. Crafting the Embed
Discord messages support Markdown, which makes them look great.
Notify Config
Trigger
Status = "Paid"
Template
**💸 Payment Sent**
> **Amount:** {{Amount}}
> **To:** {{To/From}}
> **For:** *{{Description}}*
> **Amount:** {{Amount}}
> **To:** {{To/From}}
> **For:** *{{Description}}*
Discord Preview
TreasuryBot BOT Today at 2:30 PM
💸 Payment Sent
Amount: $5,000
To: @DevTeam
For: Q1 Grant
To: @DevTeam
For: Q1 Grant
link Advanced: Role Tagging
Want to ping the core team only for large transactions? Discord uses syntax for mentions: <@&ROLE_ID>.
1 Enable Developer Mode in Discord settings.
2 Right-click your "Core Team" role and Copy ID.
3 In Google Sheets, use this formula:
=IF(C2 > 10000, "<@&987654321>", "")link Conclusion
Automation isn't just about saving time; it's about building trust.
When your community sees the treasury moving in real-time, they feel involved. Start small. Automate one sheet. Watch the engagement grow.