Nursing College Automation tool

Project Overview

Finding niche educational institutions across hundreds of geographic locations is time-consuming and inconsistent when done manually. This project automates the process by reading ZIP codes from an Excel file, validating their geographic coordinates, and querying the Google Places API to identify nearby nursing colleges within a defined 15km radius.

The system converts raw location inputs into a structured, analysis-ready dataset significantly reducing manual effort while improving accuracy and scalability

Our Approach

We built a geospatial automation workflow using Python, combining ZIP code validation, coordinate conversion, and API-based location queries.

The script first cleans and standardizes Excel inputs (fixing formatting issues and leading zeros), then converts each ZIP code into precise latitude and longitude coordinates using the Geocoding API. A radius-based search (15,000 meters) is executed through the Google Places API to retrieve relevant institutions.

The output is automatically formatted into a clean Excel report containing school name, address, ratings, and review counts ready for market research or outreach teams.

Key Features

• Automated ZIP code validation and formatting cleanup

• Smart geocoding for accurate latitude/longitude conversion

• 15km radius-based institution search

• API-driven data extraction via Google Places

• Excel-to-Excel workflow (raw input → structured output)

• Scalable processing across thousands of locations

• Clean, standardized output including key institutional data