Telegram bot that extracts URLs from the text you send, retrieves each product's details from Amazon, and saves them in consecutive rows in Google Sheets

Turn chaotic URLs into structured Amazon data in Google Sheets, all from your trusty Telegram bot.

  • Instantly when the trigger is activated
  • Instantly when receiving a text message (telegrambot → webhook)
  • Get URLs from text (btztextparser → get_urls)
  • Get 10 products by ASIN code (amazon_associates → get_items)
  • Add a list of items to the end of a sheet (gspreadsheet → append_list_of_rows)
  • Reply to the user (telegrambot → reply)

Manually extracting URLs from Telegram messages, searching for Amazon product details, and logging each item into Google Sheets can easily eat up hours every week—hours that could be spent on analysis or actual selling. Each step saps energy as you bounce between apps, risking lost links, missed deals, and data-entry errors. If you don’t automate this, you’re likely to fall behind on tracking trends, waste valuable time on repetitive tasks, and lose visibility into the products your audience actually cares about.

This Botize automation connects your Telegram bot to Amazon and Google Sheets in a seamless workflow: every time you send a text with URLs to your Telegram bot, it instantly extracts those links, fetches the full product details from Amazon (title, price, savings, image, and more), and saves them in neat, consecutive rows on your Google Sheet. The setup is flexible—you decide when to trigger it, which chats or channels it listens to, and what text filters to use, keeping you in control of the flow and format. Suddenly, all your Amazon product data is always organized and up-to-date, without lifting a finger.

Ready to see your product tracking and affiliate workflow transformed? Follow the simple step-by-step instructions to set up this formula with Botize, or take the shortcut and use the preconfigured version to start saving time and boosting your sales insights today.

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

    Start the automation whenever the main trigger is activated

    Copy and paste this prompt into the AI editing tool.

    Set up the automation so that it begins immediately when the main trigger is activated —

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  3. 4

    Process any incoming text message sent to the Telegram bot

    Copy and paste this prompt into the AI editing tool.

    Add a step that listens for any text message sent to the Telegram bot, regardless of who sent it or which chat it came from —

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  4. 5

    Extract all URLs from the text message received

    Copy and paste this prompt into the AI editing tool.

    Include a step that scans the message text and pulls out any URLs that are present —

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  5. 6

    For each URL found, look up product details on Amazon using their ASIN codes

    Copy and paste this prompt into the AI editing tool.

    Add a step that, for each URL extracted, finds the corresponding ASIN code and retrieves the product’s details from Amazon (up to 10 products per message) —

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  6. 7

    Save the retrieved product information in a new row for each product in a Google Sheets spreadsheet

    Copy and paste this prompt into the AI editing tool.

    Add a step to take each product’s details—such as ASIN, title, price, original price, savings amount, URL, and image URL—and add them as new consecutive rows to a Google Sheet —

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  7. 8

    Notify the user in Telegram that the process is done

    Copy and paste this prompt into the AI editing tool.

    Finish by sending a simple reply message—like 'Done!'—back in the Telegram chat where the message was first received —

    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

Effortlessly Extract and Organize with Telegram and Amazon

Just send your text to Telegram, let the bot fetch product details from Amazon, and watch them neatly land in Google Sheets. It's like magic, but real and practical!

Manual Botize
Manually checking product details online 30 0 Minutes
Copying and pasting data into Sheets 20 0 Minutes
Total 50 0 Minutes

You've found the solution to seamlessly manage Amazon product data with ease.


Affiliate Marketer's Dream

Automatically get product info for your campaign straight into Google Sheets, ready to analyze.

Save Time

Automate tedious data extraction tasks.

Stay Organized

Keep your product info structured and accessible.

Easy Setup

No tech skills needed to get going.


Streamline Market Research

Need to check multiple products quickly? This setup does the hard work for you.

đŸ›ïž

⌟ Amazon affiliates needing organized data.

⌟ Marketers streamlining product analysis.

🌐

✕ Folks uninterested in Amazon.

✕ Those avoiding digital workflows.


✓ Adjust the frequency of bot checks to suit your needs.

✓ Modify the Google Sheets setup to fit your data analysis style.

✓ Personalize bot responses to match your team's tone.




Related automations