WordPress - Sheet Automation

Sheet Automation turns a Google Sheet into a publishing queue. Each row becomes a WordPress post — you define the title, content, categories, and any other metadata right inside the spreadsheet, and Tenwrite handles the rest.

Because each row can target a different WordPress site using the SITE column, a single sheet can manage content across all your sites at once. This makes it particularly useful for bulk publishing and programmatic SEO.

Tenwrite checks your sheet once every hour. New rows create new posts. Rows that have changed update the existing post. Rows that are unchanged are skipped. Rows missing required fields are skipped without error.

The maximum is 200 rows per sheet on Pro and 500 rows per sheet on Agency.

Your sheet must include these exact column names:

If you’re using the GOOGLE DOC column, the referenced document needs to be readable by Tenwrite. There are two ways to do this:

Option A — Share with the service account:

Open the Google Doc, click Share, and add automation@tenwrite-gcp.iam.gserviceaccount.com as a Viewer. Click Share anyway if prompted.

Option B — Make the doc public:

In the Share dialog, change General access to Anyone with the link (Viewer) and click Done.

Open the Tenwrite add-on or Web Dashboard, go to WordPress > Automations, and switch to the Sheets tab.

Click New Automation (or Create Sheet Automation if none exist). The create form opens.

Click Select Google Sheet, choose your spreadsheet from the picker, and select the tab that contains your data.

Check Enable Automation Immediately if you want it to start on the next hourly run, then click Create Automation.

When the automation processes your sheet, Tenwrite adds and manages two result columns on the selected tab:

• TENWRITE STATUS shows the latest WordPress state that Tenwrite confirmed for the post or page.
• TENWRITE LOGS records what Tenwrite did, when it happened, and whether the row needs attention.

These are output columns. You keep working in columns such as TITLE, CONTENT, GOOGLE DOC, and STATUS; Tenwrite writes the result columns for you.

The cells are color-coded to make large sheets easier to scan: published items are green, scheduled items are blue, review items are amber, private items are purple, and trashed or missing items are red. The written label is always the final meaning, so you do not need to rely on color alone.

Each log line includes a date and time, an action, and a simple explanation. Timestamps use your account or spreadsheet time zone when available, with UTC as the fallback. The newest entry appears at the bottom.

The cell keeps the latest 10 Tenwrite entries so a busy sheet stays readable. If older entries have been removed, the first line says so. Open Automations > View Last Run for fuller run details and errors.

• A new, updated, or newly tracked row receives its confirmed status during an automation run.
• A SCHEDULED row is checked on later hourly runs so it can change to PUBLISHED after WordPress publishes it.
• A TRASHED or MISSING row is checked on the next few eligible runs, then no more than once a day. If you restore the item, Tenwrite can detect that and update the row.
• Other rows show the latest state Tenwrite confirmed while processing them. A change made directly in WordPress may not appear until Tenwrite processes that row again.
• A temporary WordPress or connection problem does not automatically change a row to MISSING; Tenwrite keeps the last confirmed state instead.

You can sort or move existing rows without losing their Tenwrite tracking. If you clear every editable input cell from a row, Tenwrite clears its managed status and logs after confirming that the row is still empty. To create a separate item, add a fresh row rather than copying a fully processed row.

The Sheets tab lists all your automations with run stats — total runs, posts created, rows processed, failures — and when each last ran. Use the action button in each row to pause or resume.

• Check that SITE, TITLE, and either CONTENT or GOOGLE DOC are present in every row.
• Verify the exact column names match (they’re case-sensitive).
• Make sure the automation is enabled.
• Confirm your WordPress sites are connected.

• Confirm each row has SITE, TITLE, and content.
• Check that STATUS uses exact values: draft, publish, future, private, or pending.
• If using Google Doc links, make sure the doc is shared with the service account or set to public.

• Use YYYY-MM-DD HH:MM format for PUBLISH DATE.
• STATUS must be exactly future for scheduled posts.
• Posts are scheduled during the next automation run after the form is submitted.

• If a doc has a Frontmatter table, it overrides the corresponding sheet columns. This is intentional — the doc’s own metadata takes priority.

• WordPress - Document Frontmatter
• WordPress - Drive Automation
• Export Google Docs to WordPress

Need help? Contact support@tenwrite.com with your sheet link and a description of the issue.