{"product_id":"apify-clutch-listings-scraper-to-track-new-agencies-in-google-sheets-n8n","title":"Apify Clutch Listings Scraper to Track New Agencies in Google Sheets (n8n)","description":"\u003ch3\u003eTrack new Clutch agencies automatically in Google Sheets with Apify + n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow uses \u003cstrong\u003eApify’s Clutch.co Listings Scraper\u003c\/strong\u003e to crawl a single public Clutch directory, detect newly observed agency profiles, and keep your \u003cstrong\u003e“current”\u003c\/strong\u003e and \u003cstrong\u003ehistory\u003c\/strong\u003e views up to date in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—with run checkpoints and recovery support.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually\u003c\/strong\u003e and asks for key inputs: the target \u003cstrong\u003eClutch directory URL\u003c\/strong\u003e, \u003cstrong\u003emaximum items\u003c\/strong\u003e, `charge limit`, \u003cstrong\u003eGoogle Spreadsheet ID\u003c\/strong\u003e, and an optional \u003cstrong\u003eresume run ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates configuration\u003c\/strong\u003e and checks the destination Google Sheet, including creating required tabs and using a \u003cstrong\u003etemporary lock\u003c\/strong\u003e to prevent overlapping writes.\u003c\/li\u003e\n  \u003cli\u003eReads and validates existing rows in the \u003cstrong\u003eCurrent\u003c\/strong\u003e, \u003cstrong\u003eHistory\u003c\/strong\u003e, and \u003cstrong\u003eRuns\u003c\/strong\u003e tabs to ensure headers and safe row limits for updates.\u003c\/li\u003e\n  \u003cli\u003eStarts a new Apify Actor run for the \u003cstrong\u003eClutch.co Listings Scraper\u003c\/strong\u003e (or resumes a specified Apify run) and records the \u003cstrong\u003eApify run ID\u003c\/strong\u003e into the Google Sheets run log as a checkpoint.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls Apify\u003c\/strong\u003e until the run succeeds, then downloads the \u003cstrong\u003ecomplete bounded dataset\u003c\/strong\u003e of scraped agency listings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and deduplicates\u003c\/strong\u003e agencies by \u003cstrong\u003eClutch profile slug\u003c\/strong\u003e, compares results to the \u003cstrong\u003eCurrent\u003c\/strong\u003e tab, and prepares updates plus appended history observations and run metrics.\u003c\/li\u003e\n  \u003cli\u003eWrites the updated \u003cstrong\u003eCurrent\u003c\/strong\u003e view, appends to \u003cstrong\u003eHistory\u003c\/strong\u003e and \u003cstrong\u003eRuns\u003c\/strong\u003e, releases the lock, and outputs a run summary with the spreadsheet link.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor a specific \u003cstrong\u003eClutch directory\u003c\/strong\u003e for \u003cstrong\u003enew agencies\u003c\/strong\u003e and maintain an always-current CRM-like list in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eBuild an audit trail of discovery events by using the \u003cstrong\u003eHistory\u003c\/strong\u003e and \u003cstrong\u003eRuns\u003c\/strong\u003e tabs for ongoing monitoring.\u003c\/li\u003e\n  \u003cli\u003eUse the optional \u003cstrong\u003eresume run ID\u003c\/strong\u003e to recover long-running or interrupted scraping runs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, \u003cstrong\u003eManual Trigger\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eApify API credentials\u003c\/strong\u003e and \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e for authenticated reads\/writes.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46132895416499,"sku":"N8N-20151","price":40.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/5YwNTSB0ZK62JWfGighji_kt9ltME0.png?v=1790760020","url":"https:\/\/buyflowscripts.com\/products\/apify-clutch-listings-scraper-to-track-new-agencies-in-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}