Telegram bot that extracts and saves product data to Google Sheets when receiving a URL or ASIN

Let our bot do the heavy lifting, while you focus on what matters.

  • Instantly when the trigger is activated
  • Instantly when receiving a command (telegrambot → webhook_command)
  • Get product information (amazon_associates → get_product_detail)
  • Add a new row at the end of a sheet (gspreadsheet → add_row_to_end)

If you manually collect product details from Amazon every time someone sends you a URL or ASIN on Telegram, you know the frustration: hunting for links, opening tabs, copying and pasting ASINs, extracting prices and images, and inputting everything into Google Sheets eats up your day. One missed entry could throw off your price analysis, delay affiliate updates, or make it impossible to track deals in real-time. Each delay not only wastes time and increases errors but could cost opportunities if you’re competing on speed.

Botize solves this by connecting your Telegram bot directly to Google Sheets. The moment you or anyone in your chat sends a product URL or ASIN, the automation springs to life—instantly grabbing all product info like title, image, updated price, and even Prime status directly from Amazon, then logs it into your Google Sheet in organized columns. The flow is seamless and fully hands-off, letting you control which chats or commands trigger the action and allowing you to customize which columns you want—transforming a labor-intensive, error-prone task into a streamlined process that’s always accurate and always current.

Ready to see how easy it is to automate your product tracking? Follow the clear step-by-step to connect your Telegram, Amazon, and Sheets, or use the ready template in Botize for a head start. This is how you save hours, boost your team’s visibility, and get back in control—let’s dive in!

Automate this task with 4 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 trigger every time an event is initiated.

    Copy and paste this prompt into the AI editing tool.

    Create a main trigger that starts the automation instantly when activated. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  3. 4

    Listen for a specific command sent to a Telegram bot by the user.

    Copy and paste this prompt into the AI editing tool.

    Configure the Telegram bot to activate when it receives the /product command from any chat. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  4. 5

    Extract product details from Amazon using the ASIN or URL provided by the user.

    Copy and paste this prompt into the AI editing tool.

    Add a step to fetch detailed product information from Amazon when given a product URL or ASIN, including fields like title, price, image URL, and more. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  5. 6

    Add a new row to a Google Sheets spreadsheet with the extracted product information.

    Copy and paste this prompt into the AI editing tool.

    Insert the product data (ASIN, title, URL, image URL, price, and original price) as a new row at the end of Sheet 1 in Google Sheets. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  6. 7

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

    Save changes

Automate Your Product Data Management

Imagine sending a simple message to a Telegram bot and instantly having detailed product data organized neatly in your Google Sheets. That's precisely what our automation does for you.

Manual Botize
Extracting product data manually 30 minutes per product 0 Minutes
Inputting data into Google Sheets 10 minutes per product 0 Minutes
Total 40 minutes per product 0 Minutes

Yes, you're in the right place to streamline your product data management!


E-commerce Retailer

Automatically extract and log data of hundreds of products, saving hours every week.

Save Time

Automate tedious data entry and focus on growing your business.

Accuracy

Eliminate human error with consistent data extraction.

Simplicity

No technical setup needed. Just send a link or ASIN and enjoy the results.


Product Researcher

Effortlessly compile product details for comparison and analysis.

âś…

⌾︎ This system is ideal if you're constantly managing product data from different sources.

⌾︎ Perfect for those who need an efficient way to compile product information into Google Sheets.

❌

âś• Not useful if you only manage a small number of products manually.

âś• Another situation where it doesn't make sense is if you prefer to keep all data offline.


âś“ Customize which fields of product data you store in your sheet.

âś“ Set up multiple bots for managing various categories of products.

âś“ Choose your preferred Google Sheet format and columns.




Related automations