WordPress Remote Control & Publishing Automation Tools

Complete Publishing Automation Toolkit

This document describes all the tools, scripts, and integrations available for sourovdeb.com.

1. Core Tools (Installed)

Python Desktop App

• File: tools/wp-desktop.py
• Type: Standalone GUI (Tkinter)
• Use case: Daily writing, non-technical users
• Features: Two modes (AI generates or you write), auto SEO fill, scheduling, post manager
• Run: python tools/wp-desktop.py
• Config storage: ~/.wp-studio/config.json

Google Sheets + Apps Script

• File: tools/sheets-publisher.js
• Type: Google Apps Script
• Use case: Batch publishing, team collaboration, scheduled content calendar
• Features: Hourly auto-run, status tracking per row, AI SEO auto-fill
• Setup: Paste into Google Apps Script, run setup functions once
• Publishing: Add row with Status=READY or SCHEDULE, wait for hourly trigger

GitHub Actions + Markdown

• File: .github/workflows/wp-publish.yml
• Type: CI/CD workflow
• Use case: Write → push → published (developers)
• Features: YAML frontmatter, automatic AI SEO, supports scheduling
• Secrets needed: WP_URL, WP_API_KEY, CLAUDE_KEY
• Usage: Create posts/my-post.md, push to GitHub

Logseq Bridge

• File: tools/logseq-bridge.py
• Type: CLI tool
• Use case: Logseq writers who export to Markdown
• Features: Converts Logseq syntax to HTML, reads inline properties, auto SEO
• Usage: python tools/logseq-bridge.py "Day 37.md" --publish

Markdown Publisher

• File: tools/publish-from-markdown.py
• Type: CLI tool
• Use case: Bulk publishing, GitHub Actions backend
• Features: YAML frontmatter parsing, Markdown→HTML conversion, AI SEO
• Usage: python tools/publish-from-markdown.py posts/ --all

2. AI Providers Supported

• Claude (Anthropic) – claude-haiku-4-5-20251001 (lightweight, fast)
• DeepSeek – open-source alternative
• Ollama (local) – free, runs on your machine

3. WordPress Plugins (Deployed)

4. External Integrations (Optional)

• n8n (self-hosted, free) – Google Docs → WordPress with AI nodes
• Activepieces (open-source) – workflow automation
• Buffer (paid) – social media + WordPress scheduling
• Zapier (paid) – email-to-post, form-to-post workflows

5. SEO & Indexing

• Auto-generated by each tool:
  • 5 relevant tags
  • SEO-optimized title (max 60 chars)
  • Meta description (120–155 chars)
  • Focus keyphrase
• IndexNow: Automatic via WordPress plugin on publish
• Google Search Console: Verify site, submit sitemap
• Bing Webmaster: Verify site, add to index

6. Recommended Workflow

1. Daily writing: Use Python Desktop App or Google Sheets
2. Batch publishing: GitHub Actions (push Markdown files)
3. Logseq integration: Export → Logseq Bridge → publish
4. Team collaboration: Google Sheets with hourly auto-run
5. Advanced automation: n8n for complex workflows

7. Configuration

• Example config: config.example.json
• Desktop app storage: ~/.wp-studio/config.json
• GitHub Secrets: WP_URL, WP_API_KEY, CLAUDE_KEY
• Google Sheets: Properties Service (encrypted)

8. Support & Troubleshooting

• Check site status: python tools/wp-manage.py status
• List scheduled posts: python tools/wp-manage.py list-scheduled
• View active plugins: python tools/wp-manage.py plugins