Telegram Bot. Receives a list of Amazon URLs, extracts the products, and exports them to Google Sheets

Extract product details from Amazon URLs straight to Google Sheets in a snap!

  • Instantly when the trigger is activated
  • Instantly when receiving a text message (telegrambot → webhook)
  • Get URLs from text (btztextparser → get_urls)
  • Expand multiple URLs (site_inspector → expand_multiple_urls)
  • Extract ASIN codes from multiple URLs (amazon_lightning → urls2asins)
  • 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 product info from a bunch of Amazon links is tedious, error-prone, and eats up valuable hours—especially if you’re managing affiliate lists, price monitoring, or content creation at scale. Every URL means hunting down ASINs, copying product titles, prices, and images, and then pasting everything into a spreadsheet—over and over. Skip automating this workflow and you’re draining time, risking mistakes, and slowing down your ability to share up-to-date deals, losing both money and momentum.

This Botize formula flips that grind on its head: simply drop up to 10 Amazon URLs into Telegram (short or full links—no problem), and the bot instantly extracts each product’s details (ASIN, title, price, original price, images, direct links) and neatly organizes them in your Google Sheets. No more manual parsing or copying—within seconds your spreadsheet updates and you’re ready to act or share. You retain control over when you trigger the workflow and exactly which URLs to process in each batch, making it perfect for custom research bursts, daily deals, or ongoing affiliate content—a true workflow game-changer.

See how much easier Amazon product management can be. Just follow the step-by-step setup for this formula and adjust the frequency or links as you like—or go straight to the ready-to-use automation and start saving hours today with Botize. Your new streamlined workflow begins right now.

Automate this task with 8 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

    Begin the automation as soon as the main trigger is activated

    Copy and paste this prompt into the AI editing tool.

    Start the workflow instantly whenever the main trigger is activated

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  3. 4

    Monitor the Telegram Bot for any new text messages so the automation knows when a user has sent something

    Copy and paste this prompt into the AI editing tool.

    Whenever the Telegram Bot receives a new text message, run the next steps in the process

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  4. 5

    Pull out all Amazon URLs from the message text sent by the user

    Copy and paste this prompt into the AI editing tool.

    Scan the received Telegram message and extract any Amazon URLs, both full and shortened, from the text

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  5. 6

    Expand each of the URLs to their full form in case the user sent any shortened links

    Copy and paste this prompt into the AI editing tool.

    For every extracted Amazon URL, if it's shortened, expand it to the full URL

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  6. 7

    Get the ASIN (Amazon Standard Identification Number) from each of the URLs

    Copy and paste this prompt into the AI editing tool.

    Extract the ASIN code from each of the Amazon URLs you just expanded

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  7. 8

    Retrieve product details from Amazon for each ASIN code collected

    Copy and paste this prompt into the AI editing tool.

    For each ASIN, get the product details from Amazon, including title, price, original price, product URL, and image

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  8. 9

    Save all the product details to the end of a Google Sheet for record-keeping

    Copy and paste this prompt into the AI editing tool.

    Add the details of each product (ASIN, title, price, original price, URL, and image URL) to a new row at the bottom of the first sheet in a specified Google Sheets document

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  9. 10

    Let the user know that the products have been extracted and saved successfully

    Copy and paste this prompt into the AI editing tool.

    Send a reply message on Telegram to the user confirming the products have been extracted and saved to Google Sheets, and list the extracted ASIN codes

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  10. 11

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

    Save changes

Effortless Amazon Listings Extraction

Send up to 10 Amazon product URLs to our Telegram bot. It’ll fetch the essential details and smartly place them into your Google Sheets. Fast, precise, and oh-so-easy.

Manual Botize
Finding each product info manually 3 minutes per product 0 Minutes
Log information in sheets 2 minutes per product 0 Minutes
Total 50 minutes 0 Minutes

Looking to streamline your Amazon product data entry? You're in the right place.


Ecommerce Manager

Streamline collection of product details for a weekly report.

Time Saver

Automate repetitive tasks.

Stress-Free

Forget manual data entry.

Easy Insight

Instantly get organized data.


Small Business Owner

Easily keep track of changing product prices on Amazon.

🛒

⌾︎ You manage Amazon inventory frequently.

⌾︎ You need an effective way to collate product data.

🚫

✕ You never work with Amazon.

✕ You prefer manual data slogs.


✓ Specify which product details to focus on.

✓ Choose different export formats (e.g., CSV, Excel).

✓ Set up alerts for product detail changes.




The bot accepts a maximum of 10 Amazon product URLs per message. You can send them in full or shortened format, both will work just fine

Related automations