Bot Adding Amazon products to Sheets
Easily track your Amazon products in Google Sheets, no sweat!
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.
