Automate Publishing from Google Sheets to WordPress
Draft in Sheets, enrich, then auto-publish to WordPress.
Tools:
1
Google Sheets
Create a content table
Columns for title, slug, excerpt, body, category, status.
2
Apps Script
Write a script to POST to WP
Use the WordPress REST API with Basic Auth or App Password, map columns to fields.
3
WordPress
Auto-publish or schedule
Parse categories/tags, set status to 'publish' or 'future', return post URL to the sheet.