Overview
Combine Coinbase Business and Google Sheets with B3OS.
Popular ways to use the Coinbase Business + Google Sheets integration onchain
View all templates ›Coinbase Business: Create & Send Payment Link
Generate and send a new Coinbase Business payment link to a notification channel of your choosing. Quick Setup 1. Connect your Coinbase Business account. 2. Select your desired notificaiton/recipient channel. 3. Specify the amount you wish to charge via payment link, as denominated in USDC on Base. 4. Test & publish.
Coinbase Business: Payment Notifier
This workflow monitors your Coinbase Business account and sends you a notification via a preferred channel (Slack, TG, Email etc) when a vendor has paid you for your services or via a Coinbase Business issued Payment Link. This workflow works great in tandem with the automated "Coinbase Business: Create Payment Link workflow". Quick Setup: 1. Connected to your Coinbase Business account 2. Select your preferred notification channel 3. Publish!
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. 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.
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.
Get Account
ActionGet details of a specific Coinbase Business account by ID or currency code. Returns account information including balance, currency details, and account type. Ideal for: balance checks, account verification, pre-transfer validation, currency lookup.
Send Crypto
ActionSend cryptocurrency from a Coinbase Business account to an address or email. Supports all Coinbase-listed assets. Returns immediately with pending status; transaction settles asynchronously. Ideal for: payouts, treasury transfers, automated payments, partner settlements.
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.
List Addresses
ActionList all on-chain deposit addresses for a Coinbase Business account. Returns addresses that can receive cryptocurrency from external sources. Ideal for: viewing deposit addresses, finding a specific address, auditing address usage.
Google Sheets: Get Values
ActionRetrieve values from a specific range in a Google Sheet. Requires worksheetId (numeric) from a prior google-sheets-list-worksheets call. 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.