Content Factory

Load keywords

One per line. Duplicates are skipped. Order is kept, so put the most valuable first.

	Keyword	Status	Title / note

Find keywords

Runs the keyword generator with this client's existing list, every page on the live site (so nothing competes with a service or town page) and the client's own Search Console queries. Each idea gets a real US monthly search volume (state-level numbers round to zero on long-tail topics). About a minute; roughly a dime in API spend per run.

	Keyword	Type	US searches / mo	Site already shows for	Why

Scheduled posts flip to published on their date (checked hourly), then the publisher renders them to the live site within the hour.

Title	Status	Date	Category

Client settings

Loaded the moment you pick a client. Everything the sheet held, minus the keys, which live only on the server.

Default category (blank = let it pick)Pick per post

Call to action (one sentence at the end of the conclusion)

Tone Style Internal link pages (one path per line)

Client constraints (appended to each prompt)

Title Meta description Outline Article

Image prompts ({KEYWORD} and {TITLE} are filled in)

Featured (hero) Secondary (in the body) Closing (only when images per post is 3)

Base prompts (shared by every client)

The four prompts from the sheet. Placeholders: {KEYWORD} {TITLE} {WORD_COUNT} {SECTION_BREAKDOWN} {SEO_ENTITIES} {POST} {NICHE}. Each client's constraints are appended after these.

Title Meta description Outline Article