Low-Code Database Architect & Scripting Specialist (Airtable / Google Maps API

We are launching a strict 7 day development sprint. We require a precise Airtable scripting and Google Maps API specialist to build an automated compliance guardrail. You will deal purely with anonymous data strings inside an isolated testing folder. You have zero exposure to sourcing origins or final end-buyer profiles. Your Exact Scope of Work: 1. Create a script within Airtable that monitors two variables: "Origin_Zip_Code" and "Destination_Zip_Code". 2. Link this routine directly to the Google Maps Distance Matrix API to calculate live ground transit driving mileage between coordinates. to be contued 3 Build a hard binary If Then conditional filterIF Run Tier is Standard and Distance is greater than 50 miles then Set status to ABORTED and clear row dataIF Run Tier is Exception and Distance is greater than 150 miles then Set status to ABORTED and clear row dataIF Distance sits inside these boundaries then Set status to COMPLIANT PASSEDYour only job is to hand a working script to our Senior QA Lead on Thursday They will handle all system deployment Code delivery lock is this Thursday at 1200 PM EST"