Find Dropshipping Products From Amazon
Analyze Amazon Best Sellers to find profitable dropshipping opportunities, source them on AliExpress, and automatically log new product listings to Google Sheets.
DropshippingProduct ResearchAmazonAliExpress
Drop-shipping Product Research & Listing Generator
This workflow helps drop-shipping sellers identify promising products from Amazon's Best Sellers lists and find sourcing options on AliExpress. It combines AI analysis, web browsing, and Google Sheets integration to streamline product research and listing creation.
It does 7 things:
- Fetches the Amazon Best Sellers page based on your selected region.
- Uses an AI agent to analyze top products and identify the best drop-shipping opportunities with key product details.
- Parses the AI output, extracting ASINs and crafting AliExpress search URLs.
- Browses AliExpress to find the cheapest matching supplier product including price and link.
- Combines Amazon and AliExpress data, calculating estimated profit margins.
- Filters out products already listed in your Google Sheets inventory.
- Automatically adds new unique product listings to your Google Sheets document.
What You Need
- A Needle platform account with access to AI and web browsing nodes.
- A Google Sheets account with a spreadsheet prepared to receive product data.
- Google Sheets connector set up in Needle with required authentication.
- Optional: Familiarity with Amazon marketplace regions for customizing the URL.
How the Flow Works
| Node | Description |
|---|---|
| Scheduled Trigger | Runs the workflow every Monday at 8 AM to keep the product list fresh. |
| Browse Web Page (Amazon) | Loads Amazon Best Sellers page for the specified region. |
| AI Analysis | Analyzes the Amazon page content and returns a curated JSON array of top drop-shipping product candidates. |
| Parse AI Output (Code) | Extracts ASINs and builds AliExpress search URLs from the AI results. |
| Browse Web Page (AliExpress) | For each product, browses AliExpress and finds the cheapest matching item with its price and URL. |
| AI Enrichment | Combines Amazon and AliExpress info, calculates profit margin, and adds SEO and audience data. |
| Read Google Sheets Rows | Reads existing product listings from Sheets to avoid duplicates. |
| Merge Outputs | Merges AI product data with sheet data for deduplication. |
| Filter Duplicate Products | Removes products already in your Google Sheet based on ASIN. |
| Add Rows to Google Sheets | Appends new unique product listings to your spreadsheet. |
Output Fields
Each new product row added to your Google Sheet includes the following fields:
| Field | Description |
|---|---|
| ASIN | Amazon Standard Identification Number for the product |
| Product Amazon Link | Direct URL to the Amazon product page |
| AliExpress Link | URL to the cheapest matching AliExpress listing |
| Product Name | Name of the product |
| Category | Product category |
| Amazon Price | Listed price on Amazon |
| AliExpress Price | Cheapest price found on AliExpress |
| Profit Margin | Estimated margin between Amazon and AliExpress prices |
| AliExpress Query | Search query used to find the product on AliExpress |
| Score | Opportunity score (1–10) |
| Store Title | Suggested title for your store listing |
| Store Description | Suggested product description |
| SEO Tags | Recommended keywords for marketing |
| Target Audience | Suggested target audience for the product |
Setup Steps
- Connect your Google Sheets account in the Needle connector settings.
- Create a Google Sheet with column headers matching the output fields listed above.
- Update the two Google Sheets nodes in the workflow with your spreadsheet ID (replace the placeholder
YOUR_SPREADSHEET_ID). - Set the
amazon_regionvariable to target your preferred Amazon marketplace (e.g.,.com,.fr,.de). - Adjust the scheduled trigger timing if needed.
Notes
- The workflow automatically skips products that already exist in your Google Sheet, keeping your list clean.
- You can customize the
amazon_regionvariable to target different Amazon marketplaces. - Since AliExpress pricing can fluctuate, consider reviewing supplier prices regularly.
- Make sure your Google Sheets columns match the expected fields to avoid data misalignment.
- The AI agent prioritizes lightweight, high-margin, trending products suitable for international shipping.
This template significantly cuts down manual research time and helps you discover and add drop-shipping products faster and smarter.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.