Home / Integrations / n8n / Amazon and AliExpress product search to Google Sheets

Amazon and AliExpress product search to Google Sheets

The same keywords searched on both marketplaces, written to one sheet with shared columns. Uses Amazon Product & Best Sellers Scraper and AliExpress Search Scraper.

Download workflow.json

This workflow searches the same keywords on Amazon (Amazon Products Scraper, arcadium/amazon-products) and on AliExpress (AliExpress Search Scraper, arcadium/aliexpress-search) and writes both result lists into one sheet with the same columns, for a quick price and demand check before you source or list a product.

Manual trigger ─┬→ Apify: Amazon search     → Code: to rows ─┐
                └→ Apify: AliExpress search → Code: to rows ─┴→ Google Sheets: Append row

File: workflow.json (n8n workflow export format). It starts on demand; replace Run now with a Schedule Trigger to run it weekly.

What you need

Credential	Where	Placeholder in the file
Apify API token	Apify Console → Settings → API & Integrations	`REPLACE_WITH_YOUR_APIFY_CREDENTIAL_ID` (credential type Apify API, both Apify nodes)
Google Sheets	n8n's Google Sheets OAuth2 credential	`REPLACE_WITH_YOUR_GOOGLE_SHEETS_CREDENTIAL_ID`
A spreadsheet	Your Google Drive	`REPLACE_WITH_YOUR_SPREADSHEET_ID` in the sheet URL

The Apify node is Apify's official n8n node, package @apify/n8n-nodes-apify (checked against version 0.9.0, node version 2, operation Run actor and get dataset). On n8n Cloud search for "Apify" in the nodes panel. On self-hosted n8n: Settings → Community nodes → Install → @apify/n8n-nodes-apify.

Import

Create a Google Sheet with a tab named Products and this header row: source | searchTerm | position | productId | title | price | currency | rating | ratingCount | sold | sponsored | url | scrapedAt
n8n → Workflows → Import from File → workflow.json.
Run Amazon search: pick your Apify credential and edit searches, marketplace (US, GB, DE, ...) and maxResultsPerSearch.
Run AliExpress search: same credential; edit searchTerms and maxResultsPerTerm. Optional filters: minPrice, maxPrice, shipFrom, freeShipping.
Append to Google Sheets: pick your credential and paste your sheet URL.
Execute the workflow and check the sheet.

Cost per run

Pay per event. Prices are each actor's Store pricing at the time of writing (Free plan; paid Apify plans pay less). Live prices: Amazon, AliExpress.

Actor	Event	Price	In this template
Amazon	Actor start	$0.001	1
Amazon	Search result card	$0.00054 ($0.54 per 1,000)	2 keywords × 20 = 40 cards, $0.0216
AliExpress	Actor start	$0.001	1
AliExpress	Product	$0.00225 ($2.25 per 1,000)	2 keywords × 20 = 40 products, $0.09
Both	Error rows	free

About $0.11 per run. Each Apify node caps its run at $0.50 (maxTotalChargeUsd).

What to expect

sold is Amazon's "bought in past month" text or AliExpress's sold-count text, as the site shows it.
sponsored marks ads; set includeSponsored (Amazon) or includeAds (AliExpress) to false to drop them.
Amazon prices are in the marketplace's currency, AliExpress prices in US dollars (currency column).