n8n Training Feedback Automation with User Task and Airtable

This n8n workflow automates the process of collecting and acting on training feedback, incorporating a human-in-the-loop (HITL) step for review and decision-making. It leverages Airtable as a data source and can send emails and post to LinkedIn based on the feedback.

What it does

This workflow streamlines the feedback process by:

1. Triggering on New Feedback: Listens for new or updated records in a specified Airtable base, likely indicating new training feedback submissions.
2. Sending Review Email: Dispatches an email to a designated recipient (e.g., a manager or trainer) containing details of the new feedback. This email acts as a user task, requiring human intervention.
3. Awaiting Human Decision: The workflow pauses, waiting for the recipient to interact with the email. The email likely contains options (e.g., "Approve," "Reject," "Share on LinkedIn") that, when clicked, trigger a webhook.
4. Routing Based on Decision: Uses a Switch node to evaluate the human's decision received via the webhook.
5. Posting to LinkedIn (Conditional): If the feedback is approved for public sharing, it posts the feedback to LinkedIn.
6. Performing Other Actions (Conditional): The workflow is designed to be extensible, allowing for other actions (e.g., updating Airtable, sending internal notifications) based on different feedback decisions, though only LinkedIn is explicitly configured in this provided JSON.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Airtable Account: An Airtable account with a base configured to store training feedback. You will need an API key and the Base ID/Table Name.
• Email Sending Service: Access to an SMTP server or an email service configured in n8n for sending emails.
• LinkedIn Account: A LinkedIn account with appropriate permissions if you intend to share feedback publicly. You will need a LinkedIn credential configured in n8n.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Airtable Trigger:
   • Select your Airtable credential.
   • Specify the Base ID and Table Name where your training feedback is stored.
   • Configure the trigger to listen for new records or updates as per your needs.
3. Configure Send Email Node:
   • Select your Email Send credential (SMTP, Gmail, etc.).
   • Set the To email address for the person responsible for reviewing feedback.
   • Customize the Subject and Body of the email to include relevant feedback details and the webhook URLs for decision-making. Ensure the webhook URLs are correctly formatted to include the {{ $node["Webhook"].url }} expression for the dynamic URL.
4. Configure Webhook Node:
   • The Webhook node will automatically generate a unique URL when the workflow is activated. This URL needs to be embedded in the email sent by the "Send Email" node, with parameters indicating the decision (e.g., ?action=share or ?action=reject).
5. Configure Switch Node:
   • The Switch node will evaluate the action parameter from the incoming webhook.
   • Add cases for each possible decision (e.g., action equals share, reject, etc.).
6. Configure LinkedIn Node (if sharing):
   • Select your LinkedIn credential.
   • Configure the post type and content, pulling data from the initial Airtable trigger and potentially the email feedback.
7. Activate the Workflow: Once all nodes are configured, activate the workflow.

This workflow provides a robust foundation for automating feedback loops, ensuring that valuable insights are not missed and actions can be taken efficiently.