Telegram bot that exports product data to Google Sheets from unstructured text

Send a product link to Telegram, and—boom—get all the juicy details organized in Google Sheets in seconds. No scraping headaches. No manual copy-paste. Just real, useful info. Instantly.

  • Instantly when the trigger is activated
  • Instantly when receiving a command (telegrambot → webhook_command)
  • Perform Actions on a URL (btzscraper → execute_commands)
  • Send a Prompt for a structured response (chatgpt → completion_as_data)
  • Add a new row at the end of a sheet (gspreadsheet → add_row_to_end)
  • Reply to the user (telegrambot → reply)

Manually extracting product details from websites and organizing them into Google Sheets is tedious, error-prone, and can burn hours every single week—especially if you’re tracking deals across major marketplaces like Amazon or AliExpress. The chaos of hunting down up-to-date product names, prices, and images from raw, unstructured web pages not only slows your productivity but also clouds your view on trends and valuable opportunities. If you stick to this manual grind, you risk missed sales, outdated insights, and a backlog that drains your time and business momentum.

This ready-made Botize formula lets you simply send a /url command with any product page link via Telegram, and instantly extracts the product information you specify—current and previous prices, discounts, product names, images, and more—using the Botize Chrome scraper and GPT for smart data structuring. The captured details are flawlessly logged in your chosen Google Sheet and delivered back to you in Telegram, letting you track products from dozens of sites with no copy-pasting, no reformatting, and no missed fields. Plus, you can fine-tune the type of data you want (simply tweak the GPT prompt), run it as often as you like, and even set filters to zero in on exactly what matters for your business.

Try this automation to channel all your product research into a tidy, up-to-date spreadsheet—no tech hurdles, no repetitive work, just actionable data and instant feedback in Telegram. Follow the step-by-step guide below, or jump straight to the ready-to-use formula and start seeing results in minutes!

Automate this task with 6 simple prompts

Copy and paste the following prompts into Botize's AI task editor

  1. 2

    Select the AI editing tool.

    AI Prompt Tool
  2. 3

    Set up the automation to start whenever someone interacts with the main trigger

    Copy and paste this prompt into the AI editing tool.

    Create a step that activates the automation as soon as the main trigger is activated.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  3. 4

    Add a step to listen for the /url command in any Telegram chat or channel

    Copy and paste this prompt into the AI editing tool.

    Set up the Telegram bot to listen for the /url command followed by a product page URL, regardless of which chat or channel it's sent from.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  4. 5

    Extract visible text and all image sources from the given product page URL using a Chrome scraper

    Copy and paste this prompt into the AI editing tool.

    Use a Chrome-based web scraper to visit the provided product page URL. Extract all visible text from the page, ignoring scripts or styles, and collect all the image URLs found on the page.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  5. 6

    Send the extracted text and image URLs to an AI to pick out and structure the product details

    Copy and paste this prompt into the AI editing tool.

    Provide the AI with the extracted texts and image URLs from the web page. Ask it to identify and return the following details in a structured way: product name, current price, previous price, discount amount, discount percentage, and a product image URL.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  6. 7

    Save the structured product details as a new row in Google Sheets

    Copy and paste this prompt into the AI editing tool.

    Add a new row to a Google Sheets spreadsheet with the product name, current price, previous price, discount amount, discount percentage, and product image URL, each in their respective columns.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  7. 8

    Reply to the user on Telegram with the extracted and structured product details

    Copy and paste this prompt into the AI editing tool.

    Send a message back to the user on Telegram showing the product name, current price, previous price, discount amount, discount percentage, and product image URL.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  8. 9

    Your automation is ready to use. Click the 'Save changes' button.

    Save changes

Product Data from Any Page—Sent Right to Your Sheets

Here's the magic: You message your Telegram bot with /url plus any product page link—from Amazon, AliExpress, wherever. The automation reads the page, pulls out all the stuff you care about (product name, prices, discounts, even the image), and 1) stores it neatly in your Google Sheet and 2) replies to you in Telegram with everything extracted. So next time you spot a deal or need to track products, you only tap send.

Manual Botize
Open product page & hunt for info 2-4 minutes 0 Minutes
Copy and paste into Google Sheet (with images!) 3-5 minutes 0 Minutes
Reply with details to yourself or your team in chat 1-2 minutes 0 Minutes
Total 6-11 minutes per product 0 Minutes

Yes—this is exactly what you were looking for if you’re tired of wrangling product info from websites. Forget fiddling with plugins or fighting with Excel hacks. Welcome home.


Track Flash Deals Instantly

Forward Amazon Lightning Deals to your Telegram bot—get a price, discount, and image instantly in Sheets, shareable to the team.

Zero Manual Work

No more copying, typing or tab-switching. Just results.

Works Everywhere

Amazon, AliExpress, Miravia, Temu…if it sells, it extracts.

Instant Answers

Get clean, structured data back in chat and in your sheets in seconds.


Affiliate Product Research

Grab 20 product URLs in bulk from AliExpress, send them one by one, and let the bot organize the info. Stop tabbing back and forth for data entry.

🚀

⌾︎ You compare products or track deals and need everything logged painlessly.

⌾︎ You manage teams, influencers, reviews, or affiliate links, and want instant summaries and records.

🤷‍♂️

✕ You never need to process product details from the web. (You'd be surprised how many people do!)

✕ Your work can't use Google Sheets or Telegram at all.


✓ Specify exactly which fields you want to extract (add brand, SKU, reviews, etc.).

✓ Customize the format of the Telegram reply or Google Sheet columns for your workflows.

✓ Integrate with almost ANY product page in the world—just update the GPT prompt as needed.




This automation runs whenever you send the command /url followed by a product page URL to your Telegram bot. It uses Botize’s free Chrome scraper to extract the relevant content from the page and processes it with GPT to obtain the required information (name, current price, previous price, discount, product image URL, etc.), replying on Telegram with the extracted data and saving it to a Google Sheets spreadsheet. This method works with all kinds of product pages (Amazon, AliExpress, Miravia, Temu, Mercado Libre, etc.). You should specify in the GPT prompt the exact type of information you want to extract for your specific use case.

Related automations