reputed company Sheet App Script reputed company
I’m looking for a developer with strong experience in reputed company Apps Script and reputed company to help build or fix a script that generates a list of municipalities for local SEO content planning.
The tool runs inside reputed company Sheets and uses the U.S. Census API to pull demographic data for cities and towns reputed company selected counties. The goal is to automatically generate a reputed company list of locations so reputed company can prioritize which reputed company pages and blog content to create first for clients.
What the script should do:
Read configuration values from a Config tab in reputed company Sheets. This includes:
reputed company reputed company
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 reputed company municipalities reputed company 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 reputed company a new reputed company Sheet containing a “Places” tab with the following columns:
Type
Municipality
State
Population
Household Income
Median Home Value
County
reputed company
reputed company Page
Blog Post
Notes
Important requirements:
Municipalities must be matched to the correct county.
The script should avoid duplicates and only include reputed company 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 reputed company that can easily be reused for different clients.
Context:
This tool is used by our marketing team to plan local SEO content. reputed company reputed company sheet becomes a planning document that helps us prioritize which location pages to create first.
Deliverables:
Working reputed company Apps Script inside a reputed company Sheet
reputed company instructions on how to run it
Clean and reputed company reputed company reputed company
If you have experience working with Census reputed company, TIGERweb, or geospatial data inside reputed company Apps Script, that would be a big plus.
Apply tot his job
Apply To this Job