Build SQL + Excel System for U.S. City Distance Lookup (Google API Integration via VBA)

I'm looking for a freelancer to build a system that:

Stores driving distances and drive times between U.S. city pairs

Uses the Google Maps Distance Matrix API to retrieve data

Allows my team to:

Input new city pairs in Excel

Automatically retrieve distance and drive time

Save results to a SQL database for future use

Pull distance data into Excel for reporting and analysis

What I will provide:

A Google Maps API key (I will handle account and billing setup)

SQL installation on my end (open to SQLite, MySQL, or SQL Server)

A starting Excel file with a few city pairs for testing

What you'll build:

A SQL database with a city_distances table (from_city, to_city, distance_miles, drive_time, last_updated)

An Excel workbook that:

Allows city pair input

Uses VBA only to connect to the Google API

Checks if distance already exists in SQL

If not, retrieves the distance and drive time and stores it in SQL

Displays the results directly in Excel

Clear documentation that includes:

Setup instructions

How to add new city pairs

How to maintain the SQL connection

How to update or manage the API key

Key requirement:
System must allow non-technical users to add new city pairs using Excel. The tool should avoid duplicate API calls and only store new records in SQL.

Bonus (not required):

Support for flight time

API usage tracking or limits

Clean error handling or logging within the VBA script

Requirements:

Fluent in English

Experience with VBA + SQL integration (no Power Query or Python)

Familiarity with Google Maps API is strongly preferred

Strong documentation and handoff experience

Timeline:
Project must be completed with fully working system and clean documentation within 7 to 10 days.

Deliverables:

SQL schema

Excel workbook with working VBA connection

Integrated Google Maps API functionality

Final .sql and .xlsm files

Step-by-step documentation for ongoing use