📥 GHL Export

Pulls all "Image Done" rows and writes them to the Blog Export and Social Export tabs in Google Sheets — ready to download as Excel and import to GHL.

When to Run This

Run this after you have a batch of rows with Status = Image Done in the Content Input tab and you're ready to import them into GoHighLevel.

How to Trigger It

Send a POST request to the webhook URL:

POST https://n8n.businessdetonator.com/webhook/ghl-export

You can do this from a browser using a tool like Hoppscotch (free, web-based) or ask Claude to trigger it for you.

What Happens

Step 1

Reads All Image Done Rows

Pulls every row where Status = "Image Done" that hasn't already been exported.

Step 2

Writes to Blog Export Tab

All blog rows go here in exact GHL Blog Importer format: URL Slug, Publish Date, Blog Post Title, Meta description, Meta Image (image URL), Author, Category, Tags, Blog Post Content. CTA link added automatically if missing.

Step 3

Writes to Social Export Tab

All social rows (Facebook, Instagram, Reel) go here in GHL Social Scheduler format: scheduled time, content, image URL, tags, platform type.

Step 4

Marks Rows as Exported

Updates Status = "Exported" and stamps the export date. These rows won't be picked up again.

Step 5

Sends You a Notification

ntfy notification with row counts and link to the sheet.

Downloading the Export Files

  1. Open the Google Sheet
  2. Click the Blog Export tab
  3. File → Download → Microsoft Excel (.xlsx)
  4. Import into GHL → Blog Posts importer
  5. Then click the Social Export tab
  6. File → Download → Microsoft Excel (.xlsx)
  7. Import into GHL → Social Planner → Import

⚠️ CLEAR both export tabs after every GHL import. Select all rows below the header row, delete them. If you skip this, the next export run will add duplicate rows on top of the old ones.

GHL Blog Import — Column Reference

ColumnWhat the machine fills
URL SlugAuto-generated slug from your title
Publish DateCurrent date/time at export
Scheduled DateEmpty (blank = saves as draft)
Blog Post TitleSEO-sharpened title (from machine)
Meta description155-char meta description (from machine)
Meta ImageFull URL to image on img.fit901.com
Meta Image Alt textDescriptive alt text (from machine)
AuthorRob Yahn
CategoryFitness
Blog Post TagsMemphis, CrossFit, Fit 901, fitness
Blog Post ContentYour article body + CTA link

GHL Social Scheduler — Column Reference

ColumnWhat the machine fills
postAtSpecificTimeCurrent date/time at export
contentFacebook Post, Instagram Post, or Reel Script text
imageUrlsFull URL to image on img.fit901.com
tagsMemphis, CrossFit, Fit 901, fitness
categoryFitness
facebook_type / instagram_typepost or reel depending on content type

Max 60 Blog Posts Per Import

GHL's blog importer handles a maximum of 60 rows per file. The export automatically caps at 60. If you have more than 60 ready blog rows, run the export twice (the second run will pick up the overflow after the first batch is marked Exported).