EXAMPLE 12 OF 16 · Intermediate
Compare Raydium pools in an emailed CSV
Search a token pair, choose a liquidity threshold, turn the matching pools into rows, and email the spreadsheet.
Before you begin#
- Choose Solana mainnet and a working RPC route in runtime settings. These examples read live data; illustrative results below will differ.
- Follow email setup, select the saved connection on Email, and set emailTo to your own address.
- Set inputMint, pairMint, and minimumLiquidityUsd. These are search inputs, not an instruction to trade.
Walk through the workflow#
- Search Raydium pools returns one page of pools for the pair, filtered by your minimum liquidity.
- If checks count. A nonempty result goes to Code, while zero results produce a readable message without emailing an empty file.
- Code selects consistent columns. Write CSV turns the rows into a file and Email attaches that file automatically from its input.
What the CSV contains#
One row per returned pool, with its address, pool type, mint pair, API liquidity estimate, and price. Liquidity is a reported USD figure; pool price follows the pair’s units. This is one search page, not an exhaustive market scan.
Why If is before Write CSV#
An empty search is a valid result. The false branch makes it visible without sending a blank attachment. Do not connect the two mutually exclusive branches to Merge: Merge waits for every incoming edge.
Make one change#
Raise minimumLiquidityUsd and compare the number of rows. Add Save file after Write CSV to keep a local copy, or use Get Raydium pool to inspect one selected address on-chain.
If email fails#
Follow SMTP setup. Inspect accepted and rejected in the Email output. Provider acceptance is not a guarantee that the message reached the inbox; also check spam and the recipient address.