n8n captures messages from Intercom and Twitter, logging them into Google Sheets for a unified view.
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.
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 }}).
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 }}).
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.
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.
Ready to transform your business with our technology solutions? Contact Us today to Leverage Our AI/ML Expertise.