You already plan social media posts in a Google Sheet — the source link, a caption, an image. AutoAuthor Sheets reads each row, matches it to the right voice for the story — breaking news, feature, explainer, or column — and drafts the article with AI. Then it publishes straight to WordPress and writes the live URL back to the sheet. No copy-paste, no drafts stuck in a queue.
Published
Straight to WordPress
Live posts, not drafts stuck waiting for review
The right voice
Matched to each story
AI picks the best-fit author from your voice library
Zero copy-paste
Sheet in, URL out
The published link is written back to your sheet
Editorial and social teams already map out the week in a shared Google Sheet — a sortable, collaborative content calendar the whole team can see, comment on, and rearrange. It's where the social strategy lives: which story runs when, what the headline is, which image goes with it. AutoAuthor Sheets plugs into that habit instead of replacing it. You fill in rows the way you already do, and each one becomes a published article. Every row is one planned piece:
Source post
The social post or link the article is based on
Headline
The angle or working title for the piece
Caption / notes
Any extra context to steer the draft
Image
The photo to feature on the post
Link
Where the published URL is written back
Queue a week of content in one place and the spreadsheet doubles as your publishing dashboard — the live link lands right back in the row when the post goes out.
You keep working in the sheet. AutoAuthor Sheets does the rest and reports back in the column you point it at.
| Source post | Headline | Link |
|---|---|---|
| facebook.com/…/9241 | City council approves transit plan | ↩ /city-transit-plan |
| facebook.com/…/9255 | School board sets new calendar | writing… |
City council approves transit plan after months of debate
By your columnist · in their voice
The city council approved the new transit plan late Tuesday, capping months of debate over how to fund the expansion…
Fair question. Anyone can prompt an AI chatbot. What AutoAuthor Sheets adds is the rest of the pipeline — the part that turns a chat window into a publishing workflow.
Reads straight from your Google Sheet
Map your columns once. Every new row is picked up automatically — source material in, draft out.
You paste each item by hand
Automatic, row by row
Writes in the right voice for each story
Keep a library of voices, each a style guide built from real posts. AutoAuthor matches the best-fit voice to each story automatically — or you can pin one.
One generic voice, drifts over time
Voice library, best fit per story
Publishes to WordPress for you
A signed companion plugin publishes the post live — no copy-paste, no formatting loss, no Application Password to share.
Copy/paste out of the chat
Native plugin, published live
Writes the live URL back to your sheet
The published link lands in the column you choose, so your spreadsheet stays the source of truth.
You track links yourself
Automatic write-back
Picks category, tags, and SEO meta
The AI chooses a category from your site's own list, adds tags, and fills Yoast / Rank Math / Heirloom SEO fields.
You set all of it manually
From your site's taxonomy
Built-in monetization
Publish sponsored posts and drop in-article inserts — ad-network tags and affiliate-post teasers — after any paragraph, from the same dashboard.
Out of scope
Affiliate posts + in-article inserts
From a spreadsheet to a published article in three steps.
Connect
Link a Google Sheet and your WordPress site with one signed plugin — no Application Password. Map your columns and pick an author voice.
Draft
On each new row, AI reads your source material and writes the article in the best-fit author voice for that story, then picks a category, tags, and SEO meta from your site.
Publish
The post goes live on WordPress and the published URL is written back to your sheet. Errors stay in the dashboard, never in your spreadsheet.
Your team plans the week the way it always has — a row per story. AutoAuthor Sheets turns each one into a finished, on-brand article in the right voice and publishes it live, while you're already onto the next idea. No copy-paste, no bottleneck, no drafts waiting on anyone.