This workflow runs payroll from a Google Sheet. It reads your payments sheet and a paired wallets sheet, filters out rows already marked paid, sends the specified ERC20 amount to each recipient's wallet on the chain you choose, marks the row as paid in the sheet, and posts a summary to Slack with totals and any failures. Run it manually whenever payroll is due. ### Quick Setup: 1. Import your wallet or use your B3OS Treasury Wallet 2. Make a copy of the payroll Google Sheet template and paste its URL 3. Pick the chain to send tokens on (eg Base) 4. Choose the ERC20 token to distribute (eg USDC) 5. Connect Slack and pick the channel for run summary alerts 6. Test and Publish!
Trigger: Manual → Actions: If, Filter, Get Token Metadata, Google Sheets List Worksheets, Log, For Each, Google Sheets Update Cell, Notification, Google Sheets Get Values, Google Sheets Get Values, Code Transform, Send Erc20 Token, Code Transform, Code Transform, Code Transform
This workflow runs payroll from a Google Sheet. It reads your payments sheet and a paired wallets sheet, filters out rows already marked paid, sends the specified ERC20 amount to each recipient's wallet on the chain you choose, marks the row as paid in the sheet, and posts a summary to Slack with totals and any failures. Run it manually whenever payroll is due.