← All N8N workflows
AI & researchAgentCodeGhostGoogle SheetsOpenAI Chat Model

[📺Complete Tutorial]({{ $env.WEBHOOK_URL }}

Configured with Agent, Ghost, Google Sheets, OpenAI Chat Model, and additional nodes. Review the connections and setup before adapting this template.

Workflow preview
TriggerWhen clicking ‘Testworkflow’Manual TriggerAI & modelsAI AgentAgentAI & modelsOpenAI Chat ModelOpenAI Chat ModelCodeClean HTMLCodeIntegrationExtract Blog PostsGhostTransformExtract Post ContentEdit FieldsData storeRecord the postsGoogle SheetsTransformMerge LinkedinMergeTransformAdd Clean HTMLMergeRoutingLoop Over PostsLoop Over Items

Node categories in this workflow

  • Trigger
  • AI & models
  • Code
  • Integration
  • Transform
  • Data store
  • Routing

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
When clicking ‘Test workflow’TriggerManual TriggerSee node parameters
AI AgentAI & modelsAgentSee node parameters
OpenAI Chat ModelAI & modelsOpenAI Chat ModelSee node parameters
Clean HTMLCodeCodeSee node parameters
Extract Blog PostsIntegrationGhostgetAll
Extract Post ContentTransformEdit FieldsSee node parameters
Record the postsData storeGoogle Sheetsappend
Merge LinkedinTransformMergeSee node parameters
Add Clean HTMLTransformMergeSee node parameters
Loop Over PostsRoutingLoop Over ItemsSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

None declared. HTTP requests and Code nodes may still need configuration.

Workflow notes

1. Workflow Trigger

1. Workflow Trigger

This workflow uses simple trigger.

How to setup?

Nothing to do.

2. Extract Blog Posts Content

2. Extract Blog Posts Content

The Ghost node extracts all the posts of your blog with content and metadata. In the second node, we extract description, URL, content and features image url.

How to setup?

3. Generate a Linkedin Post for each Post with an AI Agent

3. Generate a Linkedin Post for each Post with an AI Agent

This block loops through all the posts pulled by the Ghost Node, send the content to the AI agent that generates a Linkedin post. The results are combined and pulled in a Google Sheet.

How to setup?

  • AI Agent with the Chat Model:
    1. Add a chat model with the required credentials (Example: Open AI 4o-mini)
    2. Adapt the system prompt with your post signature and additional points you want to add in your posts Learn more about the AI Agent Node
  • Record Long Break in the Google Sheet Node:
    1. Add your Google Sheet API credentials to access the Google Sheet file
    2. Select the file using the list, an URL or an ID
    3. Select the sheet in which you want to record your working sessions
    4. Map the fields Learn more about the Google Sheet Node
[📺Complete Tutorial](https://www.youtube.com/watch?v=Lhi6hV6rWEo)
[📺Complete Tutorial]({{ $env.WEBHOOK_URL }}

[📺Complete Tutorial]({{ $env.WEBHOOK_URL }}

Purpose and structure

This folder contains the [📺Complete Tutorial]({{ $env.WEBHOOK_URL }} workflow. Its executable nodes use agent, code, ghost, googleSheets, lmChatOpenAi, manualTrigger, merge, set, splitInBatches. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

When clicking ‘Test workflow’

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Code/0844_Code_Ghost_Create_Triggered.json MIT; preserve source notices.

More in AI & research