Automate Twitter sentiment analysis with OpenAI, Google Sheets, and Slack alerts

✅ What problem does this workflow solve?

Tracking what people say about your brand on Twitter can be overwhelming, especially when important mentions slip through the cracks. This workflow automates the process: it scrapes Twitter mentions, analyzes sentiment using OpenAI, logs everything in a Google Sheet, and sends real-time Slack alerts for negative tweets. No manual monitoring needed.

---

⚙️ What does this workflow do?

1. Runs on a schedule to monitor Twitter mentions or hashtags. 2. Uses Apify to scrape tweets based on brand keywords. 3. Filters out tweets already processed (avoids duplicates). 4. Performs sentiment analysis with OpenAI (Positive, Neutral, Negative). 5. Logs tweet content, sentiment, and reply (if any) in a Google Sheet. 6. Sends an instant Slack notification for negative tweets. 7. Generates thank-you replies for positive tweets and logs them.

---

🔧 Setup Instructions

🗓 Schedule Trigger - Use the Cron node to schedule checks (e.g., every hour, daily).