{"product_id":"classify-apify-dataset-with-openai-sync-to-google-sheets-n8n","title":"Classify Apify Dataset with OpenAI \u0026 Sync to Google Sheets (n8n)","description":"\u003ch3\u003eClassify Apify dataset items with OpenAI and sync results to Google Sheets—on demand\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow processes up to \u003cstrong\u003e1,000 items\u003c\/strong\u003e from an \u003cstrong\u003eApify dataset\u003c\/strong\u003e, classifies each item using \u003cstrong\u003eOpenAI\u003c\/strong\u003e (via the \u003cstrong\u003eglueworks\/llm-dataset-processor\u003c\/strong\u003e Actor), and then \u003cstrong\u003eupserts id, title, url, and category\u003c\/strong\u003e into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—ready for analysis, triage, and reporting.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRun on demand:\u003c\/strong\u003e Start the workflow manually in n8n (Manual Trigger).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoad configuration:\u003c\/strong\u003e Read the Apify \u003cem\u003edataset ID\u003c\/em\u003e, Google \u003cem\u003eSheet ID\u003c\/em\u003e, and the \u003cem\u003eOpenAI model name\u003c\/em\u003e from a configuration step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassify with Apify + OpenAI:\u003c\/strong\u003e Executes the \u003cstrong\u003eglueworks\/llm-dataset-processor\u003c\/strong\u003e Actor in \u003cstrong\u003eclassify\u003c\/strong\u003e mode to label each dataset item as \u003cstrong\u003eLEAD\u003c\/strong\u003e, \u003cstrong\u003eSPAM\u003c\/strong\u003e, or \u003cstrong\u003eNEUTRAL\u003c\/strong\u003e, writing the label to a \u003cstrong\u003ecategory\u003c\/strong\u003e field.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetch processed results:\u003c\/strong\u003e Retrieves the labeled items from the Actor’s output Apify dataset.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSync to Google Sheets:\u003c\/strong\u003e Appends or updates rows in Google Sheets by matching on \u003cstrong\u003eid\u003c\/strong\u003e, storing \u003cstrong\u003eid\u003c\/strong\u003e, \u003cstrong\u003etitle\u003c\/strong\u003e, \u003cstrong\u003eurl\u003c\/strong\u003e, and \u003cstrong\u003ecategory\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLead vs. spam triage:\u003c\/strong\u003e Classify inbound items and maintain a clean Google Sheets pipeline.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDataset enrichment workflow:\u003c\/strong\u003e Periodically re-run classification on an Apify dataset and keep a single source of truth in Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOps-friendly reporting:\u003c\/strong\u003e Provide SaaS operators with categorized URLs and titles for dashboards or follow-up actions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e set, sticky note, google sheets, apifyn8n-nodes-apify, manual trigger\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Apify (Actor: \u003cstrong\u003eglueworks\/llm-dataset-processor\u003c\/strong\u003e) and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuthentication:\u003c\/strong\u003e Apify API token credential + Google Sheets OAuth2 credential\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKey output columns:\u003c\/strong\u003e id, title, url, category\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eSet your Apify dataset ID, your target Google Sheet document ID, and the OpenAI model name—then run this workflow whenever you need fresh OpenAI-powered classification.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45738475323571,"sku":"N8N-17559","price":70.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/5sVW0RcyJhD-ikx5gHl6v_1xr1I7q6.png?v=1785229398","url":"https:\/\/buyflowscripts.com\/products\/classify-apify-dataset-with-openai-sync-to-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}