AI/ML

    Automation Workflow Setup for Multi Channel Support in n8n


    Overview

    n8n captures messages from Intercom and Twitter, logging them into Google Sheets for a unified view.

    Prerequisites

    • n8n installed.
    • Intercom account with webhook support.
    • Twitter account with API access.
    • Google Sheets API enabled.

    Workflow Setup

    1. Prepare n8n Environment

      • Navigate to http://localhost:5678 (or your n8n URL) and log in with your credentials. In the sidebar, click “Workflows,” then select “+ New” and name it (e.g., “Channel Sync”). Click “+” on the canvas to open the node selector.

    2. Trigger Node 1: Intercom Webhook

      • Node: Webhook

      • Settings:

        • Path: intercom-message

        • Intercom Webhook: https://<n8n-host>/webhook/intercom-message for new messages

      • Output: Intercom message (e.g., {{ $json.body.data.item.user.email }}).

    3. Trigger Node 2: Twitter

      • Node: Twitter

      • Settings:

        • Credentials: Twitter API OAuth

        • Resource: Direct Message

        • Operation: Get

        • Polling: Every 5 minutes

      • Output: Twitter DM (e.g., {{ $json[0].sender.screen_name }}).

    4. Log Intercom Node: Google Sheets

      • Node: Google Sheets

      • Settings:

        • Operation: Append

        • Spreadsheet ID: Support log

        • Range: A:C

        • Values: {{ ["Intercom", $node["Webhook"].json.body.data.item.user.email, $node["Webhook"].json.body.data.item.body] }}

      • Output: Intercom message logged.

    5. Log Twitter Node: Google Sheets

      • Node: Google Sheets

      • Settings:

        • Operation: Append

        • Spreadsheet ID: Same as above

        • Range: A:C

        • Values: {{ ["Twitter", $node["Twitter"].json[0].sender.screen_name, $node["Twitter"].json[0].text] }}

      • Output: Twitter message logged.

    Workflow Summary

    • Flow: Webhook/Twitter → Google Sheets (dual paths).

    • Execution: ~10 seconds per message.  

    Benefits

    • Unifies support data in one place.

    • Reduces missed messages by ~30%.

    • Improves response consistency.  

    Troubleshooting

    • Webhook Fail: Verify Intercom URL
    • Twitter Error: Check API rate limits.

    Ready to transform your business with our technology solutions? Contact Us  today to Leverage Our AI/ML Expertise. 

    Experts in AI, ML, and automation at OneClick IT Consultancy

    AI Force

    AI Force at OneClick IT Consultancy pioneers artificial intelligence and machine learning solutions. We drive COE initiatives by developing intelligent automation, predictive analytics, and AI-driven applications that transform businesses.

    Share

    facebook
    LinkedIn
    Twitter
    Mail
    AI/ML

    Related Center Of Excellence