Review NFT sales when your collection query changes
Let a meaningful change in your research query prompt a fresh look at sales for the collection you are tracking.
Trigger
Table Query Result Changed
Triggers when the result set of a saved table query changes in Google Sheets. Detects rows added, removed, or updated in the query output. This trigger monitors the result of a SQL query against a Google Sheets table and fires when changes are detected.
Action
Get NFT Sales
This tool will retrieve nft sales data across various marketplaces. it allows users to query historical nft sales data with filtering options such as fromblock, toblock, order, marketplace, and limit in order to track nft sales activity, analyze historical data, monitor specific collections, and get real-time updates on nft transactions.
Why this helps
Collection activity can change while your attention is elsewhere, leaving a useful research signal buried in a table update.
- Use query result changes as a cue for a sales review.
- Summarize returned sales activity for the relevant collection.
- Keep research follow-up attached to a change you already monitor.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Alchemy once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it for collection sales review.
- 3Tell Notis which collection contract to use for an NFT sales lookup and how to summarize the returned activity.
- 4Choose Table Query Result Changed as the trigger and select where run reports should go.
- 5Test with one real query result change and a supported collection address.
Questions about this workflow
Does the table query provide the NFT contract address automatically?
The trigger detects changes in a saved query result. Your instruction must identify a collection address from the available data or specify a contract address to use.
Can I narrow the sales lookup?
The Alchemy action supports filters such as block range, order, marketplace, and limit. Describe the criteria in your instruction when the needed values are available.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Alchemy. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Alchemy actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Get NFT Contract Metadata
This tool retrieves metadata for a given nft smart contract. essential for obtaining basic nft collection details such as contract name, symbol, total supply, token type (erc721 vs erc1155), contract deployer address, deployed block number, opensea metadata, and contract verification status.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get NFT Sales
This tool will retrieve nft sales data across various marketplaces. it allows users to query historical nft sales data with filtering options such as fromblock, toblock, order, marketplace, and limit in order to track nft sales activity, analyze historical data, monitor specific collections, and get real-time updates on nft transactions.
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Get NFTs for Contract
This tool retrieves all nfts for a given contract address. it is designed to return a complete list of nfts from a specific nft collection by accepting parameters such as contractaddress (required), withmetadata (optional), pagesize (optional), and pagekey (optional). the tool is useful for analyzing collections, building nft marketplaces, and creating collection analytics.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Get NFT Owners
This tool retrieves the owner(s) for a specific nft token, supporting both erc721 and erc1155 tokens on ethereum and several layer 2 chains such as polygon, arbitrum, optimism, and base. it requires the contract address and tokenid, and returns a list of owner addresses along with an optional pagination key for further results.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Get Token Balances
This tool retrieves erc20 token balances for a specified ethereum address. it can either return balances for all tokens an address has ever interacted with or for a specific set of token contract addresses. it is useful for checking token balances for wallets, monitoring erc20 token holdings, portfolio tracking, and defi applications.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Get Token Metadata
This tool retrieves metadata for a given token contract address, including the token's name, symbol, decimals, and logo url if available. it is essential for applications that need to display token information, handle token transfers, or manage token listings.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Get Transaction Count
This tool retrieves the number of transactions sent from a specific address (also known as the nonce). it uses the eth gettransactioncount endpoint to return the transaction count for an address at a specified block tag (latest, pending, earliest, or a hex block number), which is essential for determining the nonce for subsequent transactions.
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Connect any two apps with Notis in the middle.
Google Sheets and Alchemy, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Alchemy.