Skip to content
English
Sign in
Go to glamadelaide.com.au
  • There are no suggestions because the search field is empty.

Market Listing Automation Part 2: Creating the Weekly Guide

Weekly Market Listing Guide Automation System

Why it exists...

This part of the system is responsible for turning submitted customer market listings into a draft Weekly Market Listing Guide article for the editorial team.

What it does...

It is not customer-facing. Its role is to take the information already submitted through the market listing form, identify which listings are relevant for the upcoming week, use ChatGPT to draft the content, and then create a draft post in WordPress ready for editorial review.

This automation begins after the customer has already purchased, validated their access code, and submitted the market listing form.

At that point, the form submission has already done several things:

  • updated the customer’s open HubSpot ticket

  • marked the access code as used in WordPress

  • sent the submitted form contents into Notion, which becomes the source material for the weekly guide automation.

Systems involved

This part of the workflow uses:

  • HubSpot for the original form submission

  • Zapier for the automation steps

  • Notion as the structured content source

  • ChatGPT to draft the article content

  • WordPress to receive the final compiled draft post

How it works

Due to limitations with Zapier's looping functionality, this Zap is broken into two parts: Zap 3a is found here and Zap 3b is found here.

1. Form submission content is stored in Notion

  • Once a customer submits the market listing form, the submission data is sent into Notion, which acts as the content staging area for submitted market listings.

2. Zap 3a runs on a weekly schedule

  • Zap 3a is triggered automatically once per week at a scheduled time. Its job is to begin the article-building process for the upcoming Weekly Market Listing Guide.

  • Zap 3a searches Notion using a custom date filter, designed to find all market listing submission records that relate to markets occurring within the following 7 days.

  • Once Zap 3a has identified the relevant Notion records, it sends information to ChatGPT to begin drafting the opening section of the article.

3. Zap 3a loops through the matching Notion records

  • After the opening has been drafted, Zap 3a loops through each matching Notion record one by one.

  • Each record is then passed into Zap 3b for individual content drafting.

4. Zap 3b drafts each market listing

  • Zap 3b evaluates the content of each submitted Notion record and sends that information to ChatGPT.

  • ChatGPT uses the submission details to generate a draft listing for that individual client.

  • Once all relevant Notion records have been processed and each listing has been drafted, Zap 3b combines everything into one full article.

5. Zap 3b sends the compiled article to WordPress

  • After the full article has been assembled, the content is sent to WordPress and created as a draft post.

  • Once the draft post exists in WordPress, editorial staff take over.

Editorial team's role 

Although much of the article draft is automated, this is still an editorial workflow, not a fully autonomous publishing system. The final draft still requires human review.

Editorial staff are responsible for:

  • reviewing the structure and flow of the draft article
  • removing awkward, repetitive or unclear wording
  • identifying any submissions that need trimming or clarification
  • ensuring the tone matches editorial standards
  • checking facts, dates and formatting
  • maintaining overall quality control
  • making sure the Weekly Market Guide is publication-ready

What each system is responsible for

Notion

Notion stores the submitted market listing records in a structured format and acts as the source database for the weekly guide automation.

Zap 3a

Zap 3a is responsible for:

  • running on schedule

  • finding the relevant Notion records for the coming week

  • generating the article opening

  • sending each qualifying record into Zap 3b

Zap 3b

Zap 3b is responsible for:

  • drafting each individual market listing

  • combining all generated listings with the article opening

  • creating the final draft post in WordPress

ChatGPT

ChatGPT is responsible for:

  • drafting the article introduction

  • drafting each submitted market listing in article-ready language

  • supporting the assembly of the final compiled draft

WordPress

WordPress is the final destination for the compiled draft article and is where the editorial team reviews and publishes it.