Automated Publication Workflow for Posting 14 Pieces of Content per Week

For my Awesome Info Products project I share 2 new posts every day.

Here's how I created a custom automation workflow to make my life easier...

The process:

• finding & analysing products
• capturing the details
• composing & scheduling
• publishing to twitter & website

1️⃣ Content

• To easily add new products to the workflow, I use Notion to capture the links & add them to the backlog.

• For example this Video Course by David Vassallo I shared from my phone directly to Notion.

• Notion has 5 stages:
  NEW⇢ INBOX⇢ COMPOSE⇢ SCHEDULE⇢ SENT

2️⃣ Compose

• NEW & INBOX are used to filter the backlog.

• When a product moves to COMPOSE, an Integromat process is triggered that fetches meta data (title, description, image) for the product.

• Once meta data is populated in Notion, the post can be edited & composed.

3️⃣ Schedule

• Notion is handy for composing the post, adding author, media url, and a formulae to calculate the tweet length.

• When the post is completed, the schedule date & time is set, and the status is changed to SCHEDULE

4️⃣ Publish Tweet

• An Integromat process monitors for SCHEDULED posts and publishes the tweet at the specified time.

• If successful, the status is set to SENT

5️⃣ Publish to Website

• Once the tweet is SENT, a third process adds a record to Airtable.

• If a product also exists on Product Hunt, the categories are fetched via the PH API in a Pipedream NodeJS process.

• From Airtable the post is available on the website built with Softr.

🛠 Tools used:

• Notion: Publication workflow (capture, compose, schedule)
• Integromat: Integrations & Automation
• Airtable: Database
• Softr: Website
• Pipedream: Call ProductHunt API
• OneSimpleApi: Fetch meta data

If you enjoyed this post let's also connect on twitter: twitter.com/bruce_v3