Backlink Plan Generator
Client-ready backlink plans as a spreadsheet.
The problem
The original generator was lost, but a handover document and the already-delivered Ethos July 2026 workbook still defined the client-facing format. Rebuilding every client's opportunities, submission URLs, copy, pacing and tracking columns by hand would repeat the same structure with different business facts.
What it does
A reusable Python tool that produces a client-ready backlink plan spreadsheet — 13 columns, a summary sheet, and a rules-and-warnings sheet, matching the format of a report already delivered to a real client.
Rebuilt from scratch off a surviving handover document after the original script was lost. Runs three ways, including reading the client and keywords straight out of the Auto-Blogger database so app keywords become anchor texts automatically.
Why it is built this way
I rebuilt the generator from those surviving artifacts and made the business profile the only changing input. It can also read a client's keywords directly from the Auto-Blogger SQLite database without writing back, so blog targets and anchor-text rotation stay aligned; it deliberately produces a plan and drafts, not account creation or submissions, because factual outreach still needs a named reviewer.
What was hard
The original script was gone, so the implementation had to be reconstructed from the handover specification and the reference workbook rather than recovered from source.
Outcomes
- 13-column deliverable
- Reads live app data
- Three run modes