{"product_id":"sync-austin-commercial-permit-use-changes-to-google-sheets","title":"Sync Austin Commercial Permit Use Changes to Google Sheets","description":"\u003ch3\u003eSync Austin Commercial Permit Use Changes to Google Sheets—Automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically pulls Austin commercial permit use-change updates (including prior\/planned uses and supporting quotes) and syncs them into your Google Sheets tab—updating existing rows on each rerun using the matching \u003cstrong\u003epermitKey\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules and on-demand runs:\u003c\/strong\u003e Executes every Monday at \u003cstrong\u003e7:00 AM America\/Chicago\u003c\/strong\u003e (or you can start it manually).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDefines a reporting window:\u003c\/strong\u003e Calculates the last \u003cstrong\u003e14 fully completed UTC dates\u003c\/strong\u003e ending yesterday to determine the date range.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches permit change records:\u003c\/strong\u003e Calls the \u003cstrong\u003eApify API\u003c\/strong\u003e to run the \u003cstrong\u003eRecord Foundry Austin commercial use-change\u003c\/strong\u003e actor and retrieves report items for that date range.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and flattens results:\u003c\/strong\u003e Validates the returned structure and dates, then flattens each permit’s described use transitions into single-row fields (including \u003cstrong\u003eprevious uses\u003c\/strong\u003e, \u003cstrong\u003eplanned uses\u003c\/strong\u003e, and \u003cstrong\u003eevidence quotes\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites to Google Sheets with RAW formatting:\u003c\/strong\u003e Updates your sheet by matching the single \u003cstrong\u003epermitKey\u003c\/strong\u003e column to existing rows on sequential reruns.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAvoids duplicates:\u003c\/strong\u003e Designed to keep \u003cstrong\u003eone execution at a time\u003c\/strong\u003e to prevent concurrent duplicate updates.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack \u003cstrong\u003eproposed changes\u003c\/strong\u003e in how Austin commercial properties are used for internal review or compliance workflows.\u003c\/li\u003e\n  \u003cli\u003eMaintain a historical log in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with official record links and evidence quotes for faster case work.\u003c\/li\u003e\n  \u003cli\u003eEnsure your team always sees the latest permit use-change information after each Monday run.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n trigger:\u003c\/strong\u003e Manual Trigger \/ scheduled run (Monday 7:00 AM America\/Chicago)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used:\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\u003eGoogle Sheets\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eApify API\u003c\/strong\u003e (via \u003cstrong\u003eAuthorization: Bearer YOUR_APIFY_TOKEN\u003c\/strong\u003e) and \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSheet requirement:\u003c\/strong\u003e A tab named \u003cstrong\u003ePermits\u003c\/strong\u003e with the exact tab-separated header row; keep \u003cstrong\u003epermitKey\u003c\/strong\u003e as the matching column.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45995012653235,"sku":"N8N-19426","price":50.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/c2aOXGbXcbsDxgzd6fqgD_8tsMB2Ak.png?v=1789031240","url":"https:\/\/buyflowscripts.com\/products\/sync-austin-commercial-permit-use-changes-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}