Automate Content Publishing with Airtable and Postiz

This n8n workflow simplifies and automates the process of publishing content from Airtable to various social media channels via the Postiz API. It acts as a bridge, allowing you to manage your content schedule and details in Airtable and then automatically push it out for publishing.

What it does

This workflow automates the following steps:

1. Triggers on Webhook: The workflow is initiated by an incoming webhook, typically triggered by a new or updated record in Airtable.
2. Retrieves Airtable Data: It fetches content details (such as post text, image URLs, and social media channels) from a specified Airtable base and table.
3. Transforms Data: It processes and formats the retrieved Airtable data into a structure suitable for the Postiz API.
4. Sends Content to Postiz: It makes an HTTP request to the Postiz API to schedule or publish the content on the designated social media channels.
5. Waits (Optional): Includes a Wait node, which can be configured to introduce a delay in the workflow, useful for rate limiting or scheduled publishing.
6. Sends Telegram Notification: After publishing, it sends a confirmation or status update to a Telegram chat.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance (self-hosted or cloud).
• Airtable Account: An Airtable account with a base and table containing your content.
  • Airtable Credential: An n8n credential configured for your Airtable account.
• Postiz Account: An account with Postiz (or a similar social media publishing platform that offers an API).
  • Postiz API Key/Authentication: The necessary API key or authentication details for Postiz to be used with the HTTP Request node.
• Telegram Account: A Telegram account to receive notifications.
  • Telegram Bot Token: A Telegram Bot token and Chat ID for sending messages.
  • Telegram Credential: An n8n credential configured for your Telegram bot.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Update the "Airtable" node with your Airtable API Key.
   • Configure the "HTTP Request" node with your Postiz API endpoint and authentication (e.g., API key in headers or body).
   • Update the "Telegram" node with your Telegram Bot Token and Chat ID.
3. Configure Airtable Node:
   • Specify your Airtable Base ID and Table Name in the "Airtable" node.
   • Ensure the fields you want to publish (e.g., Post Text, Image URL, Channels) are correctly mapped.
4. Configure Webhook Trigger:
   • The "Webhook" node will provide a unique URL. Copy this URL.
   • Set up an automation in Airtable (or another external service) to trigger this webhook whenever a new content record is ready for publishing.
5. Configure "Edit Fields" (Set) Node:
   • Adjust the "Edit Fields" node to transform your Airtable data into the exact JSON format required by the Postiz API.
6. Activate the Workflow: Once all credentials and configurations are set, activate the workflow in n8n.

Now, whenever your Airtable automation triggers the webhook, the content will be automatically processed and sent to Postiz for publishing, and you'll receive a Telegram notification.