Bot Adding Amazon products to Sheets
Easily track your Amazon products in Google Sheets, no sweat!
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
Access the Botize automated task editor.
-
2
Select the AI editing tool.
-
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. ⤵
Click the 'Apply this task' button to confirm.
-
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'. ⤵
Click the 'Apply this task' button to confirm.
-
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. ⤵
Click the 'Apply this task' button to confirm.
-
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. ⤵
Click the 'Apply this task' button to confirm.
-
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.' ⤵
Click the 'Apply this task' button to confirm.
-
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. ⤵
Click the 'Apply this task' button to confirm.
-
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. ⤵
Click the 'Apply this task' button to confirm.
-
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.