Automates publication for a network of 10+ multilingual WordPress sites. Input — Google Doc from the editor, output — an SEO-optimized article with an image, published after confirmation in Telegram. A person presses a button, the pipeline does the rest.
What it can do:
1. Catches a new or modified document in Google Drive and parses the structure of the Google Doc (headings, meta block, body) via pandoc.
2. Maintains configuration for 9 sites in Google Sheets — site, language, category, access. To change behavior, edit the table, not the workflow.
3. Generates an SEO package via Claude (OpenRouter): title, meta-description, focus keyword for Yoast.
4. Generates a featured image via Seedream 4.5 (OpenRouter) based on the article's theme.
5. Publishes in two languages via Polylang.
6. Displays an approval card in Telegram (image, text, buttons). Nothing is published on WordPress until the person confirms.
7. Publishes via WordPress REST API: post, Yoast meta, category through mu-plugin.
8. Avoids content duplication.
9. Handles failures with Error workflow — classifies the error and sends an alert in Telegram.
Technologies: n8n, PostgreSQL, Docker Compose, Google Drive/Docs/Sheets API (OAuth2), WordPress REST API + Application Passwords, Yoast SEO, Polylang, OpenRouter (Claude + Seedream 4.5), Telegram Bot API.
Architecture: queue-driven pipeline, configuration as data in Google Sheets, distributed lock.
#n8n #automation #wordpress #ai #openrouter #claude #seedream #google-api #telegram-bot #seo #yoast #polylang #postgresql #docker #rest-api #content-automation #multisite
What it can do:
1. Catches a new or modified document in Google Drive and parses the structure of the Google Doc (headings, meta block, body) via pandoc.
2. Maintains configuration for 9 sites in Google Sheets — site, language, category, access. To change behavior, edit the table, not the workflow.
3. Generates an SEO package via Claude (OpenRouter): title, meta-description, focus keyword for Yoast.
4. Generates a featured image via Seedream 4.5 (OpenRouter) based on the article's theme.
5. Publishes in two languages via Polylang.
6. Displays an approval card in Telegram (image, text, buttons). Nothing is published on WordPress until the person confirms.
7. Publishes via WordPress REST API: post, Yoast meta, category through mu-plugin.
8. Avoids content duplication.
9. Handles failures with Error workflow — classifies the error and sends an alert in Telegram.
Technologies: n8n, PostgreSQL, Docker Compose, Google Drive/Docs/Sheets API (OAuth2), WordPress REST API + Application Passwords, Yoast SEO, Polylang, OpenRouter (Claude + Seedream 4.5), Telegram Bot API.
Architecture: queue-driven pipeline, configuration as data in Google Sheets, distributed lock.
#n8n #automation #wordpress #ai #openrouter #claude #seedream #google-api #telegram-bot #seo #yoast #polylang #postgresql #docker #rest-api #content-automation #multisite