Overview
Automate your compliance monitoring by syncing Chainalysis Sanctions screening results directly with Google Sheets. Build seamless workflows that flag high-risk blockchain addresses and update your compliance logs in real-time without manual intervention.
Popular ways to use the Chainalysis Sanctions + 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. 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.
Screen Address for Sanctions
ActionCheck whether a blockchain address is on any sanctions list tracked by Chainalysis (OFAC SDN, EU, UN, etc.). Returns a boolean sanctioned flag, unique categories, and the full identifications list with source URLs. Chain-agnostic (EVM, BTC, Solana). Ideal for: compliance workflows, pre-transaction screening, counterparty risk checks, AML monitoring, 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.
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.
Google Sheets: List Worksheets
ActionList all worksheet tabs in a Google Sheets spreadsheet. Returns each sheet's numeric ID, title, and index. Use this to discover available sheets and resolve sheet names to numeric worksheetIds for downstream actions (get-values, add-row, update-cell, etc.).