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)

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