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.
How It Works
Section titled “How It Works”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 500 rows per sheet.
Set Up Your Google Sheet
Section titled “Set Up Your Google Sheet”Required Columns
Section titled “Required Columns”Your sheet must include these exact column names:
| Column | Required | Description |
|---|---|---|
| SITE | Yes | WordPress site URL (e.g., example.com) |
| TITLE | Yes | Post or page title |
| CONTENT | Yes* | Post content — Markdown is supported |
| GOOGLE DOC | Yes* | Link to a Google Doc to use as content |
Optional Columns
Section titled “Optional Columns”| Column | Options | Example |
|---|---|---|
| EXCERPT | Any text | Brief post summary |
| OBJECT TYPE | post or page | post |
| STATUS | draft, publish, future, private, pending | draft |
| SLUG | URL-safe text | my-awesome-post |
| CATEGORIES | Comma-separated | tech, tutorial, google |
| TAGS | Comma-separated | wordpress, automation |
| COMMENT STATUS | open or closed | open |
| PING STATUS | open or closed | open |
| PUBLISH DATE | YYYY-MM-DD HH:MM | 2025-12-31 23:59 |
| OUTPUT FORMAT | wp_blocks or classic_html | wp_blocks |
| PRESET | balanced or preset name | balanced |
| FORMATTING | balanced or full | balanced |
Sharing a Google Doc with Tenwrite
Section titled “Sharing a Google Doc with Tenwrite”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.
Create the Automation
Section titled “Create the Automation”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.
Managing Automations
Section titled “Managing Automations”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.
Example
Section titled “Example”| SITE | TITLE | CONTENT | OBJECT TYPE | CATEGORIES | TAGS |
|---|---|---|---|---|---|
| shop.com | Red T-Shirt | Comfortable cotton… | post | Products, Clothing | product, t-shirt |
| events.com | Concert Info | Check out this event… | post | Events, Music | events, music |
| company.com | About Us | Learn about our company… | page | company, about |
Troubleshooting
Section titled “Troubleshooting”Automation doesn’t seem to be running
Section titled “Automation doesn’t seem to be running”- 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.
Posts aren’t being created
Section titled “Posts aren’t being created”- Confirm each row has SITE, TITLE, and content.
- Check that STATUS uses exact values:
draft,publish,future,private, orpending. - If using Google Doc links, make sure the doc is shared with the service account or set to public.
Scheduled posts aren’t publishing at the right time
Section titled “Scheduled posts aren’t publishing at the right time”- Use
YYYY-MM-DD HH:MMformat for PUBLISH DATE. - STATUS must be exactly
futurefor scheduled posts. - Posts are scheduled during the next automation run after the form is submitted.
Related Guides
Section titled “Related Guides”Need help? Contact support@tenwrite.com with your sheet link and a description of the issue.
Tenwrite is an independent product not affiliated with or endorsed by Google LLC, Blogger, or WordPress Foundation. Google Docs, Gmail, Google Workspace are trademarks of Google LLC. WordPress is a trademark of the WordPress Foundation.