If you’ve ever finished a signing at 5:30–6:30 PM and panic-searched Google Maps for a FedEx, you know the problem: store hours ≠ , Express pickup cutoff, OnSite locations are inconsistent, and Google Maps doesn’t tell you what’s actually safe. I built a custom Google Map that shows FedEx Offices, Ship Centers, and FedEx OnSite locations, color-coded by late-day pickup safety, and it updates automatically every week. It answers the only question that matters late at night: where can I still safely drop off docs tonight?
What it does
• Overlays FedEx locations on Google Maps (200 km radius of Cthe hicago Metro Area)
• Separates Offices / Ship Centers / On-Site retail
• Color-codes locations:
late-safe,
depends,
risky
• Uses real pickup cutoff info from local.fedex.com (not Google hours)
• Auto-refreshes weekly
• Usable while driving (CarPlay-friendly)
I’ve been using AI and chatbots for coding, a skill I’m still learning. They’ve helped me turn my ideas into real processes. I used chatbots to create a Google Sheets Appscript and debug until all my features were live.
Tools used (all free)
Google Sheets · Google My Maps · Google Apps Script · Google Places API · Apple Shortcuts (optional)
Of course, I have access to both ChatGPT and Gemini, so the AppScript part was mostly done by the AI Agent, and I just need to QA.
High-level setup
-
Create a Google Sheet as the single source of truth (carrier, type, reference link, lat/long, risk, last checked).
-
Use Google Places API + Apps Script to pull FedEx Offices, Ship Centers, and OnSite locations (run quarterly).- This is much easier and reliable than you actually think of lol
-
Link each location to its local.fedex.com page and auto-parse “Latest Express drop-off” to assign risk (weekly).
-
Import the sheet into Google My Maps and style pins by the Risk column.
-
Add a one-tap shortcut (or Siri command) to open the map before navigation.
Refresh trigger
• Weekly: refresh pickup cutoffs
• Quarterly: refresh location list
• Manual: holidays or odd cutoffs
If anyone wants more details or a customized script, feel free to DM me — happy to share.
