seo-publish-article

Publishes finished SEO articles to a Supabase-backed CMS via direct PostgREST writes.

21|3|Updated Mar 6, 2026
One-click install
npx skills add https://github.com/peter-tu-zynkr/zynkr-skill-builder --skill seo-publish-article-peter-tu-zynkr
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: seo-publish-article
Source: https://github.com/peter-tu-zynkr/zynkr-skill-builder/tree/main/skills/1-brand-marketing/seo-publish-article
Command: npx skills add https://github.com/peter-tu-zynkr/zynkr-skill-builder --skill seo-publish-article-peter-tu-zynkr

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve? Publishing a finished SEO article to a website is slow when the CMS admin page is an auth-gated dashboard with no public write API. This Skill writes the article row directly into the CMS's Supabase articles table, converting the Google Doc draft into schema-validated Tiptap JSON and HTML so it goes live without corrupting on later in-CMS edits. ## Core Features & Use Cases - Doc-to-CMS conversion: Reads a Google Doc, splits the body from the 「SEO 交付物」metadata block, and builds Tiptap JSON plus content_html in house style (▋ headings, spacer paragraphs, tables flattened to lists). - Schema validation: Validates the payload against the editor's real ProseMirror schema before publishing, catching issues like unsupported table nodes. - Gated live publish: Shows a preview, requires explicit confirmation, then POSTs to Supabase with the service-role key and verifies the public URL renders. - Post-publish governance: Archives the source Doc to a shared Drive folder and updates the SEO tracker (Topic List status and Keyword Pool coverage). - Use Case: You have a proofed article in a Google Doc and want it live at /blog/<slug> — the Skill converts, validates, publishes, verifies, and logs it in one flow. ## Quick Start Publish my finished article from this Google Doc to the blog and confirm the live URL once it renders.

Frequently Asked Questions about seo-publish-article

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I publish an article to a Supabase-backed CMS without an admin API?▼

Write the article row directly into the Supabase articles table via PostgREST using the service-role key, since the CMS dashboard is auth-gated and the public API is read-only. Set status to published and include published_at so the post surfaces in the public list.

How to convert a Google Doc article into Tiptap JSON for a CMS?▼

Split the Doc into a body markdown file and a metadata JSON, then run the build_payload.mjs script to generate Tiptap ProseMirror JSON and pre-rendered content_html. Tables are flattened to bullet lists because the editor schema has no table node.

Why does content get corrupted when editing articles in a Tiptap CMS?▼

Corruption happens when content_html contains nodes the editor schema does not support, such as tables, which get dropped on load and erased by auto-save. Validate the payload against the editor's real ProseMirror schema before publishing to prevent this.

What happens if the article slug already exists in Supabase?▼

A duplicate slug insert returns HTTP 409 because the slug column is UNIQUE. Query the articles table first, then either update the existing row in place with a PATCH request or choose a new slug before publishing.

Can this publish articles to social media channels?▼

No, this only publishes to the website CMS via Supabase. Social channel posting to platforms like Threads, Instagram, or Facebook is handled by a separate Buffer-based publishing skill.