Keyflow

Search Keyflow

Find a shortcut, workflow, MCP server or skill

ETL pipeline for text processing

n8n template #1045
This workflow allows you to collect tweets, store them in MongoDB, analyse their sentiment, insert them into a Postgres database, and post positive tweets in a Slack channel. Cron node: Schedule the workflow to run every day Twitter node: Collect tweets MongoDB node: Insert the collected tweets in MongoDB Google Cloud Natural Language node: Analyse the sentiment of the collected tweets Set node: Extract the sentiment score and magnitude Postgres node: Insert the tweets and their sentiment score and magnitude in a Posgres database IF node: Filter tweets with positive and negative sentiment scores Slack node: Post tweets with a positive sentiment score in a Slack channel NoOp node: Ignore twee

How to set it up

  1. Open template #1045 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
  2. Create 5 credentials under Credentials → Add credential: Postgres, Slack, MongoDB, X (Formerly Twitter), Google Cloud Natural Language. Then open each of those nodes and pick the credential.
  3. Click Execute workflow and step through each node's output to confirm the data looks right.
  4. Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "ETL pipeline for text processing" (https://n8n.io/workflows/1045). It uses: Postgres, Slack, MongoDB, X (Formerly Twitter), Google Cloud Natural Language. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

PostgresSlackMongoDBX (Formerly Twitter)Google Cloud Natural Language

Questions

Yes. Lorena published it free on n8n.io as a verified creator, and it has 8,734 views. It runs on n8n Cloud or a self-hosted n8n instance.

Postgres, Slack, MongoDB, X (Formerly Twitter), Google Cloud Natural Language. The other 0 nodes are built into n8n.

Similar workflows

NameViews
  1. 🤖 Advanced Slackbot with n8n9,377
  2. Suspicious Login Detection6,442
  3. Automatically promote your YouTube video on X5,551
  4. ✨🤖Automate Multi-Platform Social Media Content Creation with AI205K
  5. Back Up Your n8n Workflows To Github80K
  6. Scrape and store data from multiple website pages80K
  7. Generate Instagram Content from Top Trends with AI Image Generation72K
  8. ✨🩷Automated Social Media Content Publishing Factory + System Prompt Composition55K