WordPress - Sheet Automation
WordPress Sheet Automation lets you create multiple WordPress posts and pages automatically from Google Sheets data. Prepare your post data in Google Sheets and Tenwrite will automatically create or update the posts in WordPress for each row. Perfect for bulk content creation, programmatic SEO, and managing multiple sites.
Requirements
Section titled “Requirements”- Tenwrite add-on or Web Dashboard access
- Connected WordPress site
- Google Sheets access
Set Up Your Google Sheet
Section titled “Set Up Your Google Sheet”Required Columns
Section titled “Required Columns”Your sheet needs 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 supported) |
| GOOGLE DOC | Yes* | Google Doc link (must be shared with our service account) |
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, etc. | 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 format | 2025-12-31 23:59 |
| OUTPUT FORMAT | wp_blocks or classic_html | wp_blocks |
| PRESET | balanced or my_preset | balanced |
| FORMATTING | balanced or full | balanced |
Content Options
Section titled “Content Options”Post content can be set in two ways (choose any one):
- CONTENT column: Write directly in the CONTENT column (good for short posts)
- GOOGLE DOC column: Enter the link to your Google Doc (good for long posts)
- Share the Google Doc with our service account
automation@tenwrite-gcp.iam.gserviceaccount.com - Or make the Google Doc public (Share > “Anyone with link can view”)
- Share the Google Doc with our service account
Create the Automation
Section titled “Create the Automation”Step 1: Go to Automations
Section titled “Step 1: Go to Automations”- Open Tenwrite add-on or Web Dashboard
- Click on WordPress > Automations from the sidebar or click on the Automations button
Step 2: Create Sheet Automation
Section titled “Step 2: Create Sheet Automation”- Click on the Create Sheet Automation button
- Click Select Google Sheet and choose your sheet
- Select the correct sheet/tab
- Check Enable Automation Immediately to start right away
- Click Create Automation
Managing Automations
Section titled “Managing Automations”The Automations page shows you all your automations showing:
- Automation ID and status
- Source Google Sheet
- Post count and document processing stats
- Last run time and success status
To stop or disable an Automation, click on the Disable button. You can later enable it again by clicking on the Enable button.
How It Works
Section titled “How It Works”- Our system checks your sheet every 30 minutes
- New rows create posts, changed rows update existing posts
- Each row can target different WordPress sites using SITE column
- Skips rows missing required fields (SITE, TITLE, content)
- Maximum 500 rows per sheet
Troubleshooting
Section titled “Troubleshooting”Automation Not Working
Section titled “Automation Not Working”- Check required columns: SITE, TITLE, and either CONTENT or GOOGLE DOC
- Verify exact column names and automation is enabled
- Confirm WordPress sites are connected
Posts Not Creating
Section titled “Posts Not Creating”- Each row needs SITE, TITLE, and content
- STATUS must be
draft,publish,future,private, orpending(exact spelling) - Share Google Docs with
automation@tenwrite-gcp.iam.gserviceaccount.comor make the Google Doc public
Scheduled Posts Not Publishing
Section titled “Scheduled Posts Not Publishing”- Use format
YYYY-MM-DD HH:MMfor PUBLISH DATE - STATUS must be exactly
future - Posts publish within 30 minutes of scheduled time
Example Use Cases
Section titled “Example Use Cases”| 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 |
Conclusion
Section titled “Conclusion”Sheet Automation makes bulk content creation simple. Set up your sheet once, and Tenwrite handles the publishing automatically.
Key benefits:
- Bulk post creation from spreadsheet data
- Automatic publishing every 30 minutes
- Multi-site support from one sheet
Need help? Contact support@tenwrite.com with your sheet link and setup details.