What it is
CSV content generation is the most flexible way to drive volume on AutoPublish. You build a spreadsheet — one row per article — and each row carries the data that makes its article specific: the target keyword, plus whatever distinguishing facts the article needs (a product's real specs, a city's real landmarks, a comparison's real differences, an industry's real pain points). You map your columns to the brief once. AutoPublish then generates one article per row, drafting each against the real data in that row. This is the mechanism that separates a useful batch from a spun one: the quality of the articles is the quality of the spreadsheet. Rich, specific rows produce specific articles; generic rows produce generic ones the quality gate will flag. Every article in the batch is scored individually, so what you publish is what passed.
Why it matters
Your data, in every article
Each row's real data — specs, facts, local detail — feeds that article's brief, so the articles are grounded in your information, not hallucinated.
Distinct, not spun
Because each article is drafted against its own row, the batch is genuinely differentiated. The quality gate flags any item that still came out templated.
Map columns once
Set which CSV columns feed which parts of the brief a single time, and AutoPublish applies the mapping across every row in the upload.
Spreadsheet-simple at scale
Producing hundreds of articles is editing a spreadsheet — a format every operator already knows — not learning a new bulk-content interface.
How it works
CSV content generation takes a spreadsheet upload, maps your columns to the brief, and runs the full generation pipeline per row.
- 1
Build the CSV
Create a spreadsheet with one row per article — a target keyword column plus whatever data columns make each article specific.
- 2
Upload and map columns
Upload the CSV into AutoPublish and map each column to its role in the brief — keyword, supporting data, target site, and more.
- 3
Generate per row
AutoPublish builds a brief from each row's data and drafts that article individually, against your brand voice and Business Brain.
- 4
Quality-gate every article
Each generated article is scored by the 14-signal quality gate. Articles below threshold are flagged and held back.
- 5
Review or throttle-publish
Send the batch to the review queue, or publish it on a throttled schedule across the connected sites named in your rows.
Example CSV layout
One row per article. The keyword column is required; the rest are your data, mapped to the brief at upload time.
keyword,product,key_specs,target_site,category best running shoes for flat feet,Arch Pro 2,"motion control, wide toe box",blog-a.com,Guides best trail running shoes 2026,Trail X,"grip lugs, rock plate",blog-a.com,Guides running shoes for marathon training,Endur 5,"carbon plate, 38mm stack",blog-b.com,Training Column mapping in AutoPublish: keyword -> target keyword (required) product -> brief: product name key_specs -> brief: distinguishing facts target_site -> publish destination category -> CMS category
What you can do with it
- Generate one article per row from a CSV upload
- Map your own columns to brief fields
- Feed per-row data into each article's brief
- Route rows to different connected sites in one batch
- Set the CMS category per row
- Quality-gate every generated article individually
- Send the batch to review or throttled publishing
- Re-upload an updated CSV to refresh or extend a set
Frequently asked questions
What goes in the CSV?
One row per article. A target keyword column is required; beyond that, you add whatever data columns make each article specific — product specs, local detail, comparison facts — plus optional columns for the target site and CMS category.
How do my columns become article content?
You map each CSV column to a role in the brief at upload time — keyword, supporting data, destination, category. AutoPublish then builds each article's brief from that row's data and drafts against it.
Why does the CSV quality matter so much?
The data in your rows is the ceiling on article quality. Rich, specific rows produce specific, useful articles; generic rows produce generic articles the 14-signal quality gate will flag. Investing in the spreadsheet is investing in the output.
Can one CSV publish to multiple sites?
Yes. Include a target-site column and AutoPublish routes each row's article to the connected site named in that row, so one upload can feed an entire portfolio.
How does this relate to the data ingestion page?
The /data-ingestion page covers AutoPublish's broader data-import capabilities; this page documents CSV content generation specifically — the spreadsheet-to-articles workflow, column mapping, and per-row generation.
When AutoPublish is not the answer
We would rather you know now than sign up and churn. AutoPublish is not the right tool if any of these describe you:
- You need a few deeply original thought-leadership pieces — that is a job for a specialist writer with real lived experience, not a volume tool.
- You will not review AI output at all. The 14-signal quality gate is a safety net, not a replacement for editorial judgment.
- You want to publish thin content fast to game search. The quality gate is built specifically to stop that — you would be fighting your own tool.
- Your content needs licensed expertise — medical, legal, or financial advice — without a qualified expert reviewing it before publish.
- You need original news reporting or investigative journalism, which depends on primary sourcing AutoPublish does not do.
Related pages
Put csv content generation to work
Free tier with 3 credits. No credit card. Connect a CMS and publish your first article in under 10 minutes.