Overview
Automate your blockchain and crypto operations by linking Gmail and Google Sheets, enabling seamless email notifications and data tracking within B3OS workflows. This integration lets you trigger actions based on inbound messages and log transaction details directly into spreadsheets for real‑time analysis. Harness the power of automation to streamline communication and data management across your decentralized apps.
Popular ways to use the Gmail + Google Sheets integration onchain
View all templates ›Compliance: Sanctions + Illicit Finance Monitoring
This workflow monitors contracts events and screens addresses interacting with that contract to flag santions/OFAC and high risk accounts. The data and flagged accounts are auto-logged into a Gsheet and a notification is sent. This allows teams to make sure they remain compliant and block any bad actors from interacting with their platform. ### Quick Setup: 1. Connect your Gsheets account 2. Input the contract address you want monitored 3. Input the chain the contract address is deployed on 4. Drop in the Gsheet Spreadsheet URL where you want the data to be logged 5. Specify the tab you want the data to be logged in the Spreadsheet (input 0 if first tab) 6. Test and Publish!
Daily Transaction Summary
This helpful workflow will fetch transactions associated with a specified onchain address (wallet or smart contract), deduplicate them, log them to a Google Sheet, and then send you a daily summary email. ### Quick Setup 1. Specify the address (e.g. 0x****) you wish to track/summarize. 2. Choose the relevant chain or L2 associated with the contract address. 3. Enter the desired recipient email for the summary to be sent to on a daily basis. 4. Specify a maximum transaction limit per run (100 is chosen by default) 5. Choose a name for the database table that will store your transactions (this must be unique per workflow instance) 6. Test & publish!
Payments: Approve email invoices in Slack, pay in USDC
Monitors your Gmail for invoices that accept crypto. When one arrives, the workflow parses the invoice details and sends you an approval request in Slack with a one-click Approve button. Once approved, USDC is sent from your B3OS wallet automatically. ### Quick Setup: 1. Import your own or use your B3OS treasury wallet 2. Connect Gmail so B3OS can detect incoming invoices 3. Choose the Slack channel where approval requests should appear 4. Test and publish!
Payments: Distribute ERC20 to a List of Wallets
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!
Supported triggers and actions
Google Sheets: Add Row
ActionAdd a single row of data to a Google Sheet. Use this to log events, track transactions, or append data to spreadsheets. Provide cell values as an array. Ideal for: transaction logs, event tracking, data collection, audit trails.
Google Sheets: Get Values
ActionRetrieve values from a specific range in a Google Sheet. Provide the full Google Sheets URL (spreadsheet ID and sheet tab are extracted automatically from the URL). Use A1 notation for the range without sheet name prefix (e.g., 'A1:D10', 'A:E'). Ideal for: reading configuration data, fetching lookup tables, getting historical data.
Google Sheets: Add Multiple Rows
ActionAdd multiple rows of data to a Google Sheet in a single operation. Use this for batch imports or when you need to write many rows at once. More efficient than adding rows one by one. Ideal for: batch imports, bulk data exports, report generation.
Google Sheets: List Worksheets
ActionList all worksheet tabs in a Google Sheets spreadsheet. Returns each sheet's numeric ID, title, and index. Provide the full Google Sheets URL (spreadsheet ID is extracted automatically). Use this to discover available sheets before other Google Sheets actions.
Google Sheets: Update Cell
ActionUpdate a single cell value in a Google Sheet. Use this to modify specific cells, update statuses, change balances, or correct data. Provide the cell reference in A1 notation (e.g., 'B2'). Provide the full Google Sheets URL (spreadsheet ID and sheet tab are extracted automatically from the URL). Ideal for: status updates, balance tracking, dashboard values, single-field corrections.
Gmail: Send Email
ActionSend an email via Gmail. Use this to send notifications, alerts, or automated emails to users. Supports HTML body content, CC/BCC recipients, and reply threading. Ideal for: price alerts, workflow notifications, user communications, automated reports.