📊 Track positive Instagram comment sentiment with OpenAI, Google Sheets, and Gmail
⚡ 14 views · 📊 Market Research & Insights
💡 Pro Tip — Heads up — if this workflow’s Instagram scraping breaks (it happens whenever Meta updates their frontend), ScraperNode is a community node that handles profiles, posts, reels, and comments without any HTML parsing.
Description
Quick overview
This workflow runs twice daily to fetch recent Instagram post comments via the Instagram Graph API, uses OpenAI to classify sentiment, saves new positive comments to Google Sheets, and emails an HTML digest of the day’s positive comments to your team using Gmail.
How it works
- Runs every day at 9 AM to fetch the most recent Instagram media posts from the Instagram Graph API.
- Pulls up to a set number of comments per post and enriches each comment with post context like the permalink.
- Sends each comment to OpenAI Chat Completions to classify it as POSITIVE, NEUTRAL, or NEGATIVE with a score.
- Filters to keep only non-empty comments classified as POSITIVE.
- Checks Google Sheets for an existing row with the same Instagram comment ID to prevent duplicates.
- Appends new positive comments to a Google Sheets tab for later reporting.
- Runs every day at 8 PM to read the saved rows from Google Sheets, build a formatted HTML summary for today, and send the digest email via Gmail.
Setup
- Create a Facebook app with Instagram Graph API access and provide a long-lived access token plus your Instagram Business Account ID in the workflow’s configuration step.
- Add an OpenAI API credential for the Chat Completions request.
- Create a Google Sheet with a “Positive Comments” tab and columns matching the workflow fields, then add Google Sheets OAuth and replace the placeholder spreadsheet ID.
- Add a Gmail OAuth connection and set the recipient email address used for the daily digest.
🔗 Nodes Used
Google Sheets, HTTP Request, Gmail, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File