Darin Pirkey – SEO Facilitator

Download the exact spreadsheet, watch the walkthrough, and follow the full SOP to launch optimized local service pages at scale — with no coding required. If you're trying to use ZimmWriter to create city landing pages for local businesses — but find yourself stuck juggling variables, outlines, and formatting — this tool was made for you. I created a free spreadsheet system that handles everything: Local variables Custom outlines SEO CSV formatting WordPress publishing Link packs and internal linking Full ZimmWriter integration This is the exact system I use to generate dozens or hundreds of pages at a time — fully optimized for local SEO, cleanly formatted, and ready to publish. What You Get Downloadable SpreadsheetPlug in your brand, services, locations, and outlines — the formulas handle the rest. Full SOP (23 pages)Step-by-step instructions to set up every tab, avoid errors, and automate your workflow. Video WalkthroughWatch me go through the entire setup so you can follow along. Helpful Prompts IncludedBuilt-in ChatGPT prompts for: Getting nearby cities Finding GBP categories Generating custom outlines Writing global background content Author bios and citation prep Link Pack SupportAutomatically generate interlinking for pages that don’t even exist yet — and get them indexed faster. Download the Tool Click here to download the spreadsheet:https://vzp.ro/zwlocalseo No email required — just grab it and go. If you want updates later, feel free to subscribe. Watch the Setup Walkthrough Want to see how I use it in real time?Watch the video on YouTube: I Made This Free SEO Tool and It’s Insanely Useful for Local Pages! https://youtu.be/etWafF8kLYI Who This Is For SEO agencies building client sites Lead generation professionals scaling local pages Solo marketers doing city service builds ZimmWriter power users Have Questions or Ideas? This is version 2.1.5 — and I’d love to hear how you're using it or what you'd like to see added.Feel free to reply in the comments on YouTube or tag me in the Facebook group. Note: Some of the links on this page are affiliate links, including the one to ZimmWriter. If you sign up, I get a small kickback — but the tool and spreadsheet are 100 percent free to use regardless.