Job Description
I’m looking for a developer with strong experience in Google Apps Script and APIs to help build or fix a script that generates a list of municipalities for local SEO content planning.
The tool runs inside Google Sheets and uses the U.S. Census API to pull demographic data for cities and towns within selected counties. The goal is to automatically generate a structured list of locations so our team can prioritize which city pages and blog content to create first for clients.
What the script should do:
Read configuration values from a Config tab in Google Sheets. This includes:
Client name
State abbreviation
Census API key
List of counties
Use the U.S. Census ACS API to pull data for municipalities including:
Population
Median household income
Median home value
Return all municipalities within the selected counties with a population of at least 1,000. This should include:
Cities
Towns
Villages
Boroughs
CDPs (Census Designated Places)
The script should output a new Google Sheet containing a “Places” tab with the following columns:
Type
Municipality
State
Population
Household Income
Median Home Value
County
Priority
City Page
Blog Post
Notes
Important requirements:
Municipalities must be matched to the correct county.
The script should avoid duplicates and only include each municipality once.
Municipality names should be clean. No “CCD” or other unwanted suffixes.
Only locations with population ≥ 1,000 should be included.
The script should work reliably for any state and any list of counties.
Ability to pull neighborhood level data for large cities (250k+ population).
Clean, maintainable code that can easily be reused for different clients.
Context:
This tool is used by our marketing team to plan local SEO content. Each output sheet becomes a planning document that helps us prioritize which location pages to create first.
Deliverables:
Working Google Apps Script inside a Google Sheet
Clear instructions on how to run it
Clean and well structured code
If you have experience working with Census APIs, TIGERweb, or geospatial data inside Google Apps Script, that would be a big plus.
Apply tot his job
Apply To this Job