n8n Workflow: Apify AliExpress Reviews to Google Sheets

Instantly capture AliExpress review updates into Google Sheets (with LOW_RATING flags)

This n8n workflow pulls the latest reviews for a single AliExpress product using Apify, writes a clean “Current” snapshot to Google Sheets, appends per-run “History,” and logs each import—automatically flagging 3-star-or-lower reviews as LOW_RATING.

What this workflow does

• Runs on demand and validates inputs including the AliExpress product URL, Google Sheets spreadsheet ID, item limit, optional resumeRunId, and the maximum Apify charge.
• Checks the destination spreadsheet and creates managed tabs if missing: Current, History, and Runs.
• Uses a temporary lock tab to prevent overlapping runs.
• If resumeRunId is provided, loads an existing Apify Actor run; otherwise starts a new Apify Actor run to scrape a bounded set of AliExpress reviews.
• Saves a checkpoint entry for the Apify run in the Google Sheets Runs log, then polls Apify until the actor run succeeds.
• Fetches the Apify run dataset, validates and de-duplicates review items, and classifies each observation as BASELINE, NEW, or REFRESHED.
• Flags each review with LOW_RATING when rating is 3 or lower, then batch-writes updates to Current and appends to History.

Use cases

• Track customer sentiment for a specific AliExpress listing and monitor changes over time.
• Maintain an audit-friendly spreadsheet: snapshot now, keep history, and record run status.
• Quickly surface low-star feedback (3★ and below) for support, QA, or merchandising decisions.

Technical details

• Integrations: Apify (run Actors + dataset retrieval) and Google Sheets (read/write tabs via OAuth2).
• n8n nodes/logic: manual trigger, if, set, code, sticky note, http request, and run-state handling.

Ideal for n8n users and automation engineers who need reliable, spreadsheet-based AliExpress review scraping with transparent run logging.