Automate Blog Post Publishing from Airtable to Hashnode with API Integration

📝 Automated Blog Post Publishing from Airtable to Hashnode

This workflow streamlines your content publishing process by automatically creating draft blog posts on Hashnode from content stored in Airtable. Perfect for content creators, marketing teams, and developers who want to maintain a consistent publishing schedule while managing multiple Hashnode publications from a centralized database.

🎯 Who's it for

Content creators** managing multiple blog publications Marketing teams** coordinating content across different Hashnode accounts Developers** looking to automate their technical blog publishing workflow Agencies** managing content for multiple clients on Hashnode

⚙️ How it works

The workflow operates in a simple 7-step process:

Retrieves unpublished posts from your Airtable database (filtered by "Not Published" status) Processes each post individually using a loop to handle multiple posts Fetches the publication ID from Hashnode using the provided domain Validates the publication exists before proceeding with post creation Creates draft posts on Hashnode with the title and markdown content Updates post status to "Published" in Airtable upon successful creation Handles errors by marking failed posts with "Error" status for easy troubleshooting

📋 Requirements

Airtable Setup: Your Airtable table must include these columns: Title - The blog post title Content_markdown - Full blog post content in Markdown format Hashnode_Token - Your Hashnode API authentication token HashNode_Publication_Domain - Your publication's domain (e.g., "yourblog.hashnode.dev") Status - Publication status ("Not Published", "Published", or "Error")

Hashnode Requirements: Valid Hashnode account with API access Publication domain configured API token with draft creation permissions

🔧 How to set up

Configure Airtable credentials in the "Get Posts" and "Update Post" nodes Set your Airtable base and table IDs to match your setup Ensure your Airtable table contains all required columns listed above Add your content with status "Not Published" to trigger the workflow Test the workflow with a single post before processing multiple items

🎨 How to customize the workflow

Modify the filter criteria** in the "Get Posts" node to target different post statuses Add content validation** before posting (word count, required fields, etc.) Include post scheduling** by adding date/time conditions Extend with notifications** using Slack, Discord, or email nodes Add SEO optimization** by including meta descriptions and tags Create published post tracking** by storing Hashnode draft IDs in Airtable

💡 Need Help?

Join the Discord or ask in the Forum!