Log Weekly US Building Permits to Google Sheets (n8n + Apify)

Automatically log weekly US building permits into Google Sheets (n8n + Apify)

This n8n workflow runs every Monday at 7:00 AM to pull the last 7 days of US building permit records via the Apify actor make_no_mistakes/us-building-permits-scraper, then appends each permit as a new row in your Google Sheets.

What this workflow does

• Weekly schedule: Uses an n8n Schedule Trigger to run every Monday at 7:00 AM.
• Scrape the right dataset: Starts the Apify actor make_no_mistakes/us-building-permits-scraper with your configured list of cities, retrieving results for the last 7 days.
• Write to Google Sheets: Appends one row per permit into your target Google Sheets worksheet.
• Field mapping: Maps key permit fields into the sheet, including city, permit number, status, issued date, address, valuation, and a source URL.

Use cases

• Permit monitoring: Keep an always-updated spreadsheet of weekly building activity for your target markets.
• Ops reporting: Feed permit data into weekly internal reporting workflows without manual copying.
• Real estate / construction research: Maintain a reliable, timestamped dataset of issued permits by city and status.

Technical details

• n8n nodes: Schedule Trigger, Google Sheets (append rows), and the @apify/n8n-nodes-apify community node.
• Apify integration: Uses an Apify account and API token to run make_no_mistakes/us-building-permits-scraper and fetch the last-7-days results dataset.
• Google Sheets: Requires OAuth2 credentials, plus your spreadsheet ID and sheet name with headers matching the mapped permit fields.

Setup & customization

• Install @apify/n8n-nodes-apify (n8n → Settings → Community Nodes).
• Add an Apify API token credential and confirm the actor selection and inputs (e.g., cities, daysBack, maxItems).
• Add a Google Sheets OAuth2 credential and ensure your sheet headers match the mapped permit fields.
• Customize the cities array, adjust the schedule trigger, or lower maxItems to cap spend.