My Full Make.com Blueprint For Automating a Sheets OpenAI Ghost Content Pipeline
Richard Lemon shares his blueprint for automating content creation using Make.com and Google Sheets. He transitioned from manual content assembly to a streamlined process that generates blog posts automatically. The setup integrates OpenAI for text generation and Ghost as the content management system.
- ▪Lemon's automation process uses Google Sheets as a control panel and Make.com to orchestrate content creation.
- ▪Each row in the Google Sheet corresponds to a blog post, with specific columns for status, title, and content.
- ▪The Make.com scenario polls Google Sheets for new content, generates text with OpenAI, and updates the Ghost CMS.
DEV.to (Top) files mainly under programming. We currently carry 4,924 of its stories.
Story provenance
Source · retrieval · rights · ranking — open for full record
inspect →
Story provenance
Attribution is not the same as permission. This drawer separates discovery metadata, excerpts, WeSearch-generated summaries, reuse status, and whether the publisher receives the visit. Nothing here claims a legal grant the publisher has not made.
Record
| Original publisher | DEV.to (Top) |
| Canonical URL | https://dev.to/richardlemon/my-full-makecom-blueprint-for-automating-a-sheets-openai-ghost-content-pipeline-h7d |
| Publication time | Thu, 21 May 2026 07:00:00 +0000 |
| Retrieval time | 2026-05-21T07:05:03.555Z |
| Last seen | 2026-05-21T07:05:03.555Z |
| Headline source | Publisher (no WeSearch rewrite) |
| Excerpt source | publisher body |
| Excerpt method | First ~120 words (~800 chars) of extracted publisher body, fair-use limited. |
| Summary | WeSearch · cerebras-chat (WeSearch summarizer) |
| Summary source text | contentText |
| Citation coverage | Summary is a WeSearch-generated derivative; primary citation is the original publisher URL. |
| Cluster | pyMqvmzfd2S5 |
| Cluster logic | Grouped by semantic title/content similarity across sources within a rolling window. Same-publisher template collisions are excluded from coverage comparison. |
| Ranking reason | Story pages are not engagement-ranked. Hub feeds use recency, with optional source-diversified chronological ordering (cap consecutive stories per source). No personalized ranking. |
| Publisher visit | Yes — open original |
| Substitutes article? | No — link-out required for full text |
Rights status (four layers)
WeSearch handling by dimension
| Indexing | May the item be indexed (stored, ranked, made findable)? | Allowed |
| Snippet | May a short excerpt of the publisher's text be shown? | Allowed |
| AI summary | May WeSearch generate its own short summary of the article? | Limited |
| Retrieval / RAG | May the content be exposed for third-party retrieval-augmented generation? | Not asserted |
| Model training | May the content be used to train AI models? | Not asserted |
| Commercial reuse | May the content be reused commercially? | Not permitted |
Basis: Derived from the published RSS/Atom feed. Contact: [email protected]. Reviewed: 2026-07-24.
Opening excerpt (first ~120 words) tap to expand
try { if(localStorage) { let currentUser = localStorage.getItem('current_user'); if (currentUser) { currentUser = JSON.parse(currentUser); if (currentUser.id === 3798270) { document.getElementById('article-show-container').classList.add('current-user-is-article-author'); } } } } catch (e) { console.error(e); } Richard Lemon Posted on May 21 • Originally published at richardlemon.com My Full Make.com Blueprint For Automating a Sheets OpenAI Ghost Content Pipeline #automation #nocode #openai #productivity Why I stopped hand-assembling content I got tired of copy pasting my way through content. Idea in Notion. Outline in Docs. Draft in ChatGPT. Formatting in Ghost. Images in Figma. Every post felt like a manual QA job instead of building something once and letting it run.
…
Excerpt limited to ~120 words for fair-use compliance. The full article is at DEV.to (Top).
Discussion
0 commentsMore from DEV.to (Top)
