Overview
Seamlessly bridge your private financial data with powerful spreadsheet automation by integrating Google Sheets with RAILGUN Privacy Wallet. Automate shielded transaction logging, track private gas funding, and manage encrypted asset movements directly from your favorite spreadsheet interface.
Popular ways to use the Google Sheets + RAILGUN Privacy Wallet 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. 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.
Private Gas Funding
Privately fund a wallet with native token using RAILGUN shielding. Shields USDC on Arbitrum, waits for proof-of-inclusion, unshields via relayer to a fresh wallet, swaps to ETH, and bridges to the destination chain.
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: 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: 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.
RAILGUN Query Balance
ActionQuery private token balances in a RAILGUN wallet. Returns all ERC20 token balances or a specific token balance. Ideal for: pre-flight validation, UI display, balance verification, unshield planning.
Railgun Relayer Unshield
ActionGasless unshield ERC20 tokens from Railgun private balance to any public address. B3OS relayer pays gas; fee deducted from token amount. No ETH required on recipient. Ideal for: anonymous gas funding, fresh wallet funding, privacy-preserving distributions.
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'). Requires worksheetId (numeric) from a prior google-sheets-list-worksheets call. Ideal for: status updates, balance tracking, dashboard values, single-field corrections.