{"product_id":"daily-apify-building-permit-leads-to-google-sheets-gmail","title":"Daily Apify Building Permit Leads to Google Sheets \u0026 Gmail","description":"\u003ch3\u003eGet new U.S. building permit leads into Google Sheets and a Gmail digest—automatically, every morning\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls recent building permit leads from Apify (US Building Permits Actor), deduplicates them across runs, appends only new records to Google Sheets, and emails you an HTML digest of the newest permits via Gmail.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 7:00\u003c\/strong\u003e using an n8n schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches recent leads from Apify\u003c\/strong\u003e by calling the \u003cstrong\u003eApify US Building Permits Actor\u003c\/strong\u003e over HTTP, pulling permits from city open-data sources based on your configured cities, keywords, and lookback window.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates results across executions\u003c\/strong\u003e using a \u003cstrong\u003ecity + permit-number\u003c\/strong\u003e key, so previously seen permits aren’t re-added.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends new permits to Google Sheets\u003c\/strong\u003e by writing new permit records into a \u003cstrong\u003e“Permits”\u003c\/strong\u003e tab with matching column headers.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an HTML digest via Gmail\u003c\/strong\u003e with \u003cstrong\u003eup to 100\u003c\/strong\u003e newly discovered permits, sorted by valuation, to your configured recipient email.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLead tracking for real estate and construction pros\u003c\/strong\u003e who want a daily stream of building permit opportunities.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operators and automation engineers\u003c\/strong\u003e building a reliable pipeline from Apify data into Google Sheets and email reporting.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOps teams\u003c\/strong\u003e monitoring local development activity using valuation thresholds (min valuation) and targeted keywords.\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 \/ integrations:\u003c\/strong\u003e HTTP Request, Code\/Set, Google Sheets, Gmail, Schedule, Sticky Note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify authentication:\u003c\/strong\u003e add an n8n HTTP Header Auth credential using \u003cem\u003eAuthorization: Bearer \u0026lt;token\u0026gt;\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets requirements:\u003c\/strong\u003e create a spreadsheet with a \u003cstrong\u003e“Permits”\u003c\/strong\u003e sheet and matching column headers; replace \u003cem\u003ePASTE_YOUR_SHEET_ID\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup \u0026amp; customization\u003c\/h3\u003e\n\u003cp\u003eConfigure \u003cstrong\u003ecities\u003c\/strong\u003e, \u003cstrong\u003ekeywords\u003c\/strong\u003e, \u003cstrong\u003edaysBack\u003c\/strong\u003e, \u003cstrong\u003eminValuation\u003c\/strong\u003e, and \u003cstrong\u003emaxResultsPerCity\u003c\/strong\u003e in the \u003cem\u003eCONFIG\u003c\/em\u003e node, then test and activate. You can customize which markets you track by updating the city and keyword settings.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eRequirements:\u003c\/strong\u003e an Apify account (US Building Permits Actor), Google Sheets, and Gmail.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46248887189683,"sku":"N8N-21214","price":73.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Bagtk2DcZimtnGMvq3hZM_11JEE0pS.png?v=1792487220","url":"https:\/\/buyflowscripts.com\/products\/daily-apify-building-permit-leads-to-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}