n8n Workflow: Track Twitter & Reddit Brand Sentiment to Google Sheets

Track Twitter/X and Reddit Brand Sentiment—Automatically, Every Morning

This n8n workflow searches Twitter/X and Reddit for your brand keyword, analyzes the sentiment and dominant emotion for each mention, and logs everything into Google Sheets as new rows—run on a daily schedule so you always know how people feel.

What this workflow does

• Runs every morning using an n8n Schedule Trigger.
• Sets the brand keyword you want to track.
• Searches Twitter/X via API Direct for the newest matches and requests sentiment analysis for each post.
• Searches Reddit via API Direct for the newest matches and requests sentiment analysis for each post.
• Merges results from Twitter/X and Reddit into a single stream.
• Formats mentions into spreadsheet columns, including sentiment polarity and dominant emotion.
• Appends each mention to your chosen Google Sheets document as a new row.

Use cases

• SaaS operators monitoring brand perception and customer chatter across social channels.
• Automation engineers building a lightweight social listening pipeline into Google Sheets for reporting.
• Marketing teams tracking how specific campaigns or product terms (keywords) are being discussed.

Technical details

• Schedule Trigger for daily execution
• API Direct nodes (n8n-nodes-apidirect-apidirect) for Twitter/X and Reddit searches with sentiment analysis
• Merge step to combine platform results into one stream
• Google Sheets integration to append rows
• Step outputs formatted for headers: date, source, author, text, url, sentiment, emotion

Setup & customization

• Add an API Direct API key (new accounts include free credit) and select it in both Twitter/X and Reddit search steps.
• Update the brand value to the keywords you want to track (use boolean search syntax for precision, e.g., "acme app" -hiring).
• Connect Google OAuth credentials and choose the target spreadsheet and sheet.

Want more than Twitter/X and Reddit? You can add platforms like TikTok, YouTube, or news by duplicating a search step.