{"product_id":"apify-to-google-sheets-us-new-business-filings-n8n-workflow","title":"Apify to Google Sheets: US New Business Filings (n8n Workflow)","description":"\u003ch3\u003eAutomatically bring US new-business filings into Google Sheets (NY, PA, CT) with Apify + n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls official \u003cstrong\u003eUS new business filings\u003c\/strong\u003e from \u003cstrong\u003eApify\u003c\/strong\u003e and updates your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with deduplicated leads—starting with a free fictional-data demo so you can verify the exact output before connecting real accounts.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRun a built-in demo first:\u003c\/strong\u003e when imported, the workflow is \u003cstrong\u003einactive\u003c\/strong\u003e and in \u003cstrong\u003edemo mode\u003c\/strong\u003e, with both external-service nodes disabled. It generates \u003cem\u003efictional raw records\u003c\/em\u003e and makes no external requests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidate configuration:\u003c\/strong\u003e reads settings in the \u003cstrong\u003eSet Fields\u003c\/strong\u003e node and validates allowed states, real calendar dates, territory filters (including \u003cstrong\u003eConnecticut-only\u003c\/strong\u003e filtering), result limits, and the maximum \u003cem\u003eActor charge\u003c\/em\u003e before choosing the live data path.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetch live data (optional):\u003c\/strong\u003e in live mode, it runs the existing \u003cstrong\u003eUS New Business Leads Feed\u003c\/strong\u003e on \u003cstrong\u003eApify\u003c\/strong\u003e with a maximum of \u003cstrong\u003e100 records\u003c\/strong\u003e and \u003cstrong\u003eUS$0.30 per run\u003c\/strong\u003e. Demo mode instead supplies synthetic records through the same transformation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTransform and deduplicate:\u003c\/strong\u003e flattens source records into \u003cstrong\u003e18 columns\u003c\/strong\u003e, retains source attribution, guards formula-like text, validates each \u003cstrong\u003eleadId\u003c\/strong\u003e against its state and registry ID, and deduplicates the batch.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppend or update in Sheets:\u003c\/strong\u003e in live mode, it sequentially \u003cstrong\u003eappends or updates\u003c\/strong\u003e Google Sheets rows using \u003cstrong\u003eleadId\u003c\/strong\u003e with explicit column mappings and \u003cstrong\u003eRAW values\u003c\/strong\u003e. In demo mode, it outputs rows for inspection without writing to a Sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild a clean pipeline of new business leads for \u003cstrong\u003eNY, Pennsylvania, and Connecticut\u003c\/strong\u003e into Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eTest and validate data mapping and deduplication logic with fictional records before enabling live Apify access.\u003c\/li\u003e\n  \u003cli\u003eKeep Sheets current by \u003cstrong\u003eupdating rows by a stable business ID\u003c\/strong\u003e (leadId) instead of creating duplicates.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNode stack\u003c\/strong\u003e: if, set, code, no op, sticky note, http request\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Apify (US New Business Leads Feed) and Google Sheets (row append\/update in live mode)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow behavior\u003c\/strong\u003e: demo mode outputs for inspection; live mode writes sequential updates to Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003ePerfect for n8n automation engineers and SaaS operators who need reliable \u003cstrong\u003eApify to Google Sheets\u003c\/strong\u003e ingestion with controlled costs and territory filtering.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45962289348787,"sku":"N8N-18921","price":26.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/B5gVd6LCrnJ5X08qzBpGE_WAKjvC7r.png?v=1788600246","url":"https:\/\/buyflowscripts.com\/products\/apify-to-google-sheets-us-new-business-filings-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}