{"product_id":"n8n-twitter-etl-sentiment-pipeline-mongodb-to-postgres-slack","title":"n8n Twitter ETL Sentiment Pipeline: MongoDB to Postgres + Slack","description":"\u003ch3\u003eTurn Twitter chatter into a daily sentiment feed—saved to MongoDB \u0026amp; Postgres, and shared in Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow collects tweets every day, stores them in \u003cstrong\u003eMongoDB\u003c\/strong\u003e, analyzes sentiment with \u003cstrong\u003eGoogle Cloud Natural Language\u003c\/strong\u003e, writes the results to \u003cstrong\u003ePostgres\u003c\/strong\u003e, and posts \u003cstrong\u003epositive tweets\u003c\/strong\u003e to a \u003cstrong\u003eSlack\u003c\/strong\u003e channel—while ignoring negative ones.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCron node (daily schedule):\u003c\/strong\u003e Runs the pipeline once per day.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTwitter node:\u003c\/strong\u003e Collects tweets for your defined query.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMongoDB node:\u003c\/strong\u003e Inserts the collected tweets into MongoDB.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Cloud Natural Language node:\u003c\/strong\u003e Analyzes each tweet’s sentiment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSet node:\u003c\/strong\u003e Extracts the \u003cem\u003esentiment score\u003c\/em\u003e and \u003cem\u003emagnitude\u003c\/em\u003e from the analysis.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePostgres node:\u003c\/strong\u003e Inserts tweets plus sentiment \u003cstrong\u003escore\u003c\/strong\u003e and \u003cstrong\u003emagnitude\u003c\/strong\u003e into a Postgres database.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIF node:\u003c\/strong\u003e Filters tweets based on sentiment (positive vs. negative).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack node:\u003c\/strong\u003e Posts tweets with a positive sentiment score to a Slack channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNoOp node:\u003c\/strong\u003e Ignores tweets with a negative sentiment score.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor public reactions to a product and surface “good news” instantly in your team’s Slack.\u003c\/li\u003e\n  \u003cli\u003eBuild a lightweight sentiment history by persisting tweets and sentiment signals in MongoDB and Postgres.\u003c\/li\u003e\n  \u003cli\u003eAutomate daily social listening for SaaS operations without manual spreadsheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e Cron, Twitter, MongoDB, Google Cloud Natural Language, Set, Postgres, IF, Slack, NoOp\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData flow:\u003c\/strong\u003e Twitter → MongoDB → sentiment analysis → extract score\/magnitude → Postgres storage → IF filter → Slack post\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45756678963379,"sku":"N8N-1045","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/cKkU_e_xGMA4lz3XuPOMc_OS2yOhWG.png?v=1785748365","url":"https:\/\/buyflowscripts.com\/products\/n8n-twitter-etl-sentiment-pipeline-mongodb-to-postgres-slack","provider":"N8N Commerce","version":"1.0","type":"link"}