Check resale deals and send buy or skip verdicts with Telegram, Apify and GPT-4o

Quick overview

This workflow accepts a product list via Telegram or reads a Google Sheets sourcing list on a daily schedule, checks current prices across Amazon, eBay, Best Buy, and Newegg using Apify, calculates profit/ROI using your rules, then sends BUY/SKIP/UNVERIFIED verdicts to Telegram and logs results to Google Sheets.

How it works

1. Triggers when you send a Telegram message to the bot or every day at 6:00 based on the schedule.
2. Applies your configured rules (target chat ID, selling marketplace, fees, shipping, and profit/ROI thresholds) and only continues for your approved Telegram chat.
3. For Telegram runs, OpenAI parses your message into a cleaned product list with optional buy prices, and for scheduled runs it reads and filters products from your Google Sheets “Sourcing list” tab.
4. Apify runs the Multi-Marketplace Price Checker actor to find matching listings and prices for each product on Amazon, eBay, Best Buy, and Newegg.
5. Calculates expected net profit, ROI, and a “pay up to” price from the collected marketplace prices and marks each item as BUY, SKIP, or UNVERIFIED when data is insufficient.
6. Sends a single formatted Telegram message with verdicts and links (nightly run only sends a message if at least one item is a BUY) and appends each check to the Google Sheets “Checks” tab.

Setup

1. Create a Telegram bot with BotFather, connect Telegram credentials in n8n, and paste your Telegram chat ID into the rules so only you can trigger checks.
2. Add an OpenAI API credential (used to turn Telegram free text into a structured product list).
3. Add an Apify credential, ensure access to the “Multi-Marketplace Price Checker” actor, and confirm your zip code and max product count settings.
4. Add Google Sheets OAuth credentials, paste your Google Sheet URL, and make sure the “Sourcing list” tab includes a Product column (optional Buy price and Status) and a “Checks” tab exists for logging.
5. Review and adjust the rule values (sellOn, sellFeePct, shippingCost, minProfit, minRoiPct, minSellListings) before activating the workflow.

Requirements

• An Apify account (https://apify.com/?fpr=youssef) and the Multi-Marketplace Price Checker Actor (https://apify.com/fayoussef/multi-marketplace-price-checker?fpr=youssef). Free Apify plans are limited.

Customization

• Set sellOn to Amazon if you sell there. Raise minProfit and minRoiPct for fewer, safer buys. Prices are what is listed now, not what has sold, so read each Check first line. Swap OpenAI for Anthropic or Gemini, or Telegram for Slack.

Additional info

Need a custom version or another data source? See automationbyexperts.com.