{"product_id":"n8n-workflow-apify-aliexpress-reviews-to-google-sheets","title":"n8n Workflow: Apify AliExpress Reviews to Google Sheets","description":"\u003ch3\u003eInstantly capture AliExpress review updates into Google Sheets (with LOW_RATING flags)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls the latest reviews for a single AliExpress product using \u003cb\u003eApify\u003c\/b\u003e, writes a clean “Current” snapshot to \u003cb\u003eGoogle Sheets\u003c\/b\u003e, appends per-run “History,” and logs each import—automatically flagging \u003cb\u003e3-star-or-lower\u003c\/b\u003e reviews as \u003cb\u003eLOW_RATING\u003c\/b\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns on demand\u003c\/b\u003e and validates inputs including the AliExpress product URL, Google Sheets spreadsheet ID, item limit, optional \u003cb\u003eresumeRunId\u003c\/b\u003e, and the maximum Apify charge.\u003c\/li\u003e\n  \u003cli\u003eChecks the destination spreadsheet and creates managed tabs if missing: \u003cb\u003eCurrent\u003c\/b\u003e, \u003cb\u003eHistory\u003c\/b\u003e, and \u003cb\u003eRuns\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses a \u003cb\u003etemporary lock tab\u003c\/b\u003e to prevent overlapping runs.\u003c\/li\u003e\n  \u003cli\u003eIf \u003cb\u003eresumeRunId\u003c\/b\u003e is provided, loads an existing Apify Actor run; otherwise starts a new Apify Actor run to scrape a bounded set of AliExpress reviews.\u003c\/li\u003e\n  \u003cli\u003eSaves a checkpoint entry for the Apify run in the Google Sheets \u003cb\u003eRuns\u003c\/b\u003e log, then polls Apify until the actor run succeeds.\u003c\/li\u003e\n  \u003cli\u003eFetches the Apify run dataset, \u003cb\u003evalidates and de-duplicates\u003c\/b\u003e review items, and classifies each observation as \u003cb\u003eBASELINE\u003c\/b\u003e, \u003cb\u003eNEW\u003c\/b\u003e, or \u003cb\u003eREFRESHED\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eFlags each review with \u003cb\u003eLOW_RATING\u003c\/b\u003e when rating is \u003cb\u003e3 or lower\u003c\/b\u003e, then batch-writes updates to \u003cb\u003eCurrent\u003c\/b\u003e and appends to \u003cb\u003eHistory\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack customer sentiment for a specific AliExpress listing and monitor changes over time.\u003c\/li\u003e\n  \u003cli\u003eMaintain an audit-friendly spreadsheet: snapshot now, keep history, and record run status.\u003c\/li\u003e\n  \u003cli\u003eQuickly surface low-star feedback (3★ and below) for support, QA, or merchandising decisions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e Apify (run Actors + dataset retrieval) and Google Sheets (read\/write tabs via OAuth2).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes\/logic:\u003c\/b\u003e manual trigger, \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, sticky note, \u003cb\u003ehttp request\u003c\/b\u003e, and run-state handling.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIdeal for n8n users and automation engineers who need reliable, spreadsheet-based \u003cb\u003eAliExpress review scraping\u003c\/b\u003e with transparent run logging.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46132894531763,"sku":"N8N-20152","price":66.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/1zJZrSZZOl8gB5yP4laUS_d2rA20Eq.png?v=1790759996","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-apify-aliexpress-reviews-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}