Back to Templates

Automate Instagram Comment Responses with Google Sheets & CRM Tracking

Created by

Created by: Akash Kankariya || akash25

Akash Kankariya

Last update

Last update 13 hours ago

Categories

Share


This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

🎯 Overview

This n8n workflow template automates the process of monitoring Instagram comments and sending predefined responses based on specific comment keywords. It integrates Instagram's Graph API with Google Sheets to manage comment responses and maintains an interaction log for customer relationship management (CRM) purposes.

🔧 Workflow Components

The workflow consists of 9 main nodes organized into two primary sections:

📡 Section 1: Webhook Verification

  • Get Verification (Webhook node)
  • 🔄 Respond to Verification Message (Respond to Webhook node)

🤖 Section 2: Auto Comment Response

  • 📬 Insta Update (Webhook node)
  • Check if update is of comment? (Switch node)
  • 👤 Comment if of other user (If node)
  • 📊 Comment List (Google Sheets node)
  • 💬 Send Message for Comment (HTTP Request node)
  • 📝 Add Interaction in Sheet (CRM) (Google Sheets node)

🛠️ Prerequisites and Setup Requirements

1. 🔵 Meta/Facebook Developer Setup

📱 Create Facebook App

📋 Action Items:

  • [ ] Navigate to Facebook Developers
  • [ ] Click "Create App" and select "Business" type
  • [ ] Configure the following products:
    • ✅ Instagram Graph API
    • ✅ Facebook Login for Business
    • ✅ Webhooks

🔐 Required Permissions

Configure the following permissions in your Meta app:
| instagram_basic | 📖 Read Instagram account profile info and media
| instagram_manage_comments | 💬 Create, delete, and manage comments
| instagram_manage_messages | 📤 Send and receive Instagram messages
| pages_show_list | 📄 Access connected Facebook pages

🎫 Access Token Generation

⚠️ Important Setup:+

  • [ ] Use Facebook's Graph API Explorer
  • [ ] Generate a User Access Token with required permissions
  • [ ] ⚡ Important: Tokens expire periodically and need refreshing

2. 🌐 Webhook Configuration

🔗 Setup Webhook URL

📌 Configuration Checklist:

  • [ ] In Meta App Dashboard, navigate to Products → Webhooks
  • [ ] Subscribe to Instagram object
  • [ ] Configure webhook URL: your-n8n-domain/webhook/instagram
  • [ ] Set verification token (use "test" or create secure token)
  • [ ] Select webhook fields:
    • comments - For comment notifications
    • messages - For DM notifications (if needed)

✅ Webhook Verification Process

The workflow handles Meta's webhook verification automatically:

  • 📡 Meta sends GET request with hub.challenge parameter
  • 🔄 Workflow responds with the challenge value to confirm subscription

3. 📊 Google Sheets Setup

Example - https://docs.google.com/spreadsheets/d/1ONPKJZOpQTSxbasVcCB7oBjbZcCyAm9gZ-UNPoXM21A/edit?usp=sharing

📋 Create Response Management Sheet

Set up a Google Sheets document with the following structure:

📝 Sheet 1 - Comment Responses:

Column Description Example
💬 Comment Trigger keywords "auto", "info", "help"
📝 Message Corresponding response message "Thanks for your comment! We'll get back to you soon."

📈 Sheet 2 - Interaction Log:

Column Description Purpose
⏰ Time Timestamp of interaction Track when interactions occur
🆔 User Id Instagram user ID Identify unique users
👤 Username Instagram username Human-readable identification
📝 Note Additional notes or error messages Debugging and analytics

🔧 Built By - [email protected]