Bot Adding Amazon products to Sheets

Easily track your Amazon products in Google Sheets, no sweat!

  • Instantly when the trigger is activated
  • Instantly when receiving a text message (telegrambot → webhook)
  • Get a row according to a column value (gspreadsheet → read_by_column)
  • Reply to the user (telegrambot → reply)
  • Reply to the user (telegrambot → reply)
  • Get product information (amazon_associates → get_product_detail)
  • Add a new row at the end of a sheet (gspreadsheet → add_row_to_end)

Manually tracking new products is exhausting: every time a product ASIN lands in your inbox, you have to check if it already exists in your database, search across Google Sheets, fetch product details from Amazon, and update your spreadsheet. This manual effort steals precious hours, is highly error-prone, and slows down your ability to quickly catalog or capitalize on fresh products. Without automation, you risk missing new opportunities, making costly duplicate entries, and losing sight of inventory accuracy—all of which drain team productivity and can directly impact revenue.

This Botize formula transforms your process by letting you register new products simply by sending a message via Telegram. Instantly, the bot checks if an ASIN is already listed in your Google Sheet, fetches full product information from Amazon Associates if it's new, and seamlessly adds all the relevant details—title, link, image, price, and discount—straight to your spreadsheet. It responds in real time to let you know if a product is already registered or has just been added. No more tedious double-checking, manual copying, or wasting time hopping between apps—instead, your product log stays fresh, accurate, and totally automated.

Ready to leave manual data entry behind? Follow the step-by-step guide to set up this formula with Botize, or jump right in with the ready-to-use automation link. Customize how and when it listens for product codes, set filters for your needs, and instantly boost your team's capacity and morale—automation made easy and reliable!

Automate this task with 7 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 initial trigger for the automation to run immediately when activated.

    Copy and paste this prompt into the AI editing tool.

    Create a trigger that starts the automation instantly when it's activated.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  3. 4

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

    Copy and paste this prompt into the AI editing tool.

    Add a step that listens for incoming text messages sent to the Telegram bot from me, and only continue if the message is a command called 'buscar'.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  4. 5

    Look for an existing product in Google Sheets by searching for the code received from Telegram.

    Copy and paste this prompt into the AI editing tool.

    Search for a row in the first Google Sheets sheet where column A matches the text from the previous Telegram message. Exclude the header row.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  5. 6

    If the product code is already in the database, notify the user right away.

    Copy and paste this prompt into the AI editing tool.

    If you found a matching entry in column A, reply in Telegram saying: 'El producto ya figura en la base de datos:' and include the value from column C.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  6. 7

    If the product code isn't found, let the user know and explain that it will be added if valid.

    Copy and paste this prompt into the AI editing tool.

    If there is no matching entry in column A, reply in Telegram: 'El código ASIN no figura en la base de datos. Si es un código ASIN válido se añadirá automáticamente a la base de datos.'

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  7. 8

    Get product information from Amazon using the code received, but only if it doesn't already exist in Sheets.

    Copy and paste this prompt into the AI editing tool.

    If the product code was not found in the spreadsheet, use the received ASIN to fetch product details from Amazon Associates.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  8. 9

    Add the product details to Google Sheets if the product code is valid and you received data from Amazon.

    Copy and paste this prompt into the AI editing tool.

    If you successfully retrieved the product details from Amazon, add a new row at the end of the first sheet in Google Sheets with the product's ASIN, title, URL, image URL, original price, display amount, and savings percentage.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  9. 10

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

    Save changes

Effortlessly Sync Amazon to Sheets

This nifty automation grabs your Amazon product data, checks if it’s already logged, and adds it to your Google Sheet only if it’s brand new. It's like having a virtual assistant that’s ultra-efficient and never sleeps.

Manual Botize
Search for product details 10 0 Minutes
Manually enter data into Sheets 15 0 Minutes
Verify existing data 5 0 Minutes
Total 30 0 Minutes

You've found the perfect solution to keep your Amazon listings perfectly organized in Sheets.


E-commerce Wizard

Track hundreds of product listings automatically without lifting a finger.

Save Time

Automate your data entry and focus on what matters.

Stay Organized

Keep all your product info neat and tidy in one place.

Be Up-to-Date

Ensure your product listings are current and complete.


Inventory Manager

Stay on top of product data updates without the hassle of manual entry.

🛒

⌾︎ You manage numerous Amazon listings.

⌾︎ You want a streamlined way to handle product data.

📄

✕ You sell one or two items occasionally.

✕ You don't use Google Sheets for tracking.


✓ Adjust which columns are filled based on your needs.

✓ Modify how product data is filtered and sorted in Sheets.

✓ Set up reminders for regular updates within Telegram.




Related automations