Track Twitter and Reddit brand sentiment using API Direct, Google Sheets and Slack
Quick overview This workflow runs every morning to search Twitter/X and Reddit for your brand name via API Direct, includes AI sentiment and dominant emotion on each mention, and appends the results as new rows in a Google Sheets mentions log.
How it works Runs every morning on a schedule trigger. Sets the brand keyword to search for. Searches Twitter/X posts via API Direct for the newest matches and requests sentiment analysis. Searches Reddit posts via API Direct for the newest matches and requests sentiment analysis. Combines the Twitter/X and Reddit results into a single stream. Formats each mention into the columns needed for a spreadsheet row, including polarity and dominant emotion. Appends each formatted mention as a new row in a Google Sheets document.
Setup Add an API Direct credential (API key) and select it in both the Twitter/X and Reddit search steps. Update the brand value in the brand settings step to the keyword(s) you want to track. Connect your Google Sheets OAuth credentials and select the target spreadsheet and sheet. Create a Google Sheet with the header row: date, source, author, text, url, sentiment, emotion.
Requirements An API Direct API key (new accounts include free credit) A Google account for Google Sheets
Customization Use boolean search syntax for precision, e.g. "acme app" -hiring (see apidirect.io/docs/boolean-search) Add more platforms (TikTok, YouTube, news) by duplicating a search node and picking a different operation Filter on sentiment polarity = negative and pipe to Slack for instant crisis alerts
Additional info API Direct is a verified community node, available on n8n Cloud and self-hosted n8n β search "API Direct" in the nodes panel to install. One API key covers Twitter/X, Reddit, TikTok, Instagram, YouTube, Facebook, Threads, Truth Social, Google News/Maps/web search (58 operations), pay-as-you-go from $0.002/request.
Related Templates
AI Email Classifier & Auto-Delete for Gmail (SPAM/OFFER Cleaner)
This workflow is designed for freelancers, solopreneurs, and business owners who receive a high volume of irrelevant mes...
Generate Product Ad Copy & CTAs with GPT-4 for Slack and Airtable
β‘ AI Copywriter Pro: Instant Ad Copy & CTA Generator Transform product details into compelling marketing copy in second...
Auto-classify Gmail emails with AI and apply labels for inbox organization
Who is this for? Professionals and individuals who receive high volumes of emails, those who want to automatically organ...
π Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments