How to hire a WordPress developer: a checklist for businesses and agencies
What to ask, what to check in a portfolio, and how to scope a project so quotes are comparable.
Read the articleHow one Google Sheet and a reusable template can power dozens of local landing pages.
sheet.rows → pages

Programmatic SEO in WordPress means building many landing pages from data instead of by hand. Each row in a spreadsheet becomes a page: one for every city you serve, or every city and service combination. Done well, each page is a proper landing page. Done badly, it’s hundreds of near-duplicates that never rank. Here’s how to do it well.
It works when people search for the same thing with a different place or detail each time, and you genuinely serve each of them:
It doesn’t work when you’d be creating pages for places you don’t serve, or when every page would say exactly the same thing.
The spreadsheet is the real product. Plan one row per page and one column per piece of content that changes:
Keeping the data in Google Sheets means your team can add a city without touching WordPress.
Each kind of page gets one reusable template: a city page, a city and industry page, a service page. The template holds the layout and design; the spreadsheet fills in the words. In WordPress, a page generator plugin such as Multiple Pages Generator can connect the template to the sheet and create a page for every row.
For Authenus Staffing I built this system with Multiple Pages Generator and Google Sheets: page templates for 46 cities, plus location and industry combination pages. Adding a new city is now a new row in a spreadsheet, not a new page build.
Search engines and visitors both need each page to stand on its own. On every generated page, check for:
If you’d be embarrassed to show a generated page to someone in that city, it isn’t ready to publish.
Hundreds of pages nobody links to won’t get found. Build the internal links into the template: city pages link to their region and nearby cities, industry pages link to the cities they cover, and service pages link to both. That gives search engines a clear map and gives visitors a way around.
For Bloomin’ Blinds, location pages are generated from data with the same templates, so every franchise area gets an on-brand page with a clear enquiry path from day one.
Publish a small batch first, check that the pages are indexed and read well, then add the rest. Watch Search Console for pages flagged as duplicates, and improve the template rather than editing pages one by one.
Not if every page is useful to the person searching for it. It becomes spam when pages are created for places you don't serve or say nothing specific.
Yes. Once the template is built, adding a page is adding a row to the spreadsheet.
For Authenus Staffing and Bloomin' Blinds I used Multiple Pages Generator with Google Sheets. For other projects a custom post type and template can do the same job.
hire( wordpress_developer )
What to ask, what to check in a portfolio, and how to scope a project so quotes are comparable.
Read the articlewoo → quickbooks.sync()
When an off-the-shelf connector is enough, and when a custom OAuth 2.0 sync pays for itself.
Read the articleghl vs hubspot
A developer's comparison of features, integrations and automation, from real client set-ups.
Read the articleSend me the list of places and services. I'll plan the spreadsheet, the templates and the internal links, and build the system.
Cookies on this site
I use necessary cookies to make this site work. With your permission, I'd also like to use analytics cookies to see which pages are useful, and marketing cookies to measure any advertising. Privacy policy
Choose which cookies you're happy for me to use. Necessary cookies are always on. You can change your choice at any time with the "Cookie settings" link at the bottom of every page. Privacy policy
Needed for the site to work, for example to remember your cookie choice (yl_consent) and keep the project form secure. They can't be switched off.
Help me understand how visitors use the site, so I can improve it (Google Analytics: _ga, _ga_*). The information is grouped and doesn't identify you.
Let me measure advertising and show more relevant ads on other websites (Google Ads: _gcl_au).