HumationHuman + Automation
Back to Catalog

Article to LinkedIn post generator with Telegram, GPT-4 & Google Sheets

Shachar ShamirShachar Shamir
198 views
2/3/2026
DiscordWeatherScheduleAPIOpenWeatherMap
Official Page

🚀 Automated LinkedIn Post Generator from Article Links (Telegram → AI → Google Sheets → LinkedIn)

This workflow lets you collect article links through a Telegram bot, automatically analyze and summarize them with AI, store everything neatly in Google Sheets, and generate polished LinkedIn posts on demand whenever the user types “generate”.

Perfect for creators, marketers, and founders who want to post consistently without spending hours analyzing articles or writing drafts.

🧠 How It Works

1️⃣ User Sends Articles via Telegram

Your Telegram bot is the main input point. Whenever the user drops a link, the workflow:

  • Detects the URL
  • Fetches the content
  • Sends it to AI for analysis

This keeps the process simple.

2️⃣ AI Analyzes & Summarizes the Article

The workflow uses your LLM (OpenAI, Anthropic, etc.) to:

  • Summarize the article
  • Extract key insights
  • Identify main arguments
  • Capture tone and context

It produces a clean, structured dataset for each link.

3️⃣ Everything is Saved into Google Sheets

Each article becomes a new row in your Google Sheet. The sheet serves as your content library with fields like:

  • Date
  • Title
  • Link
  • Summary
  • Insights Commentary

You can save dozens of articles and generate posts from any of them later.

4️⃣ User Requests a Post with “generate”

When the user types “generate”, the workflow will:

  • Pull the latest article(s) from Google Sheets (or any selection logic you choose)
  • Build a LinkedIn-ready post using AI
  • Apply the requested tone/style
  • Format it as a clean, professional post

The final post is sent right back to Telegram — ready to copy/paste into LinkedIn.

🛠️ Setup Steps

🔧 1. Create a Telegram Bot

  1. Go to @BotFather on Telegram
  2. Create a new bot
  3. Copy the API token
  4. Paste the token into the Telegram Trigger node in n8n

🔧 2. Add Your AI Credentials

  1. Go to Credentials → OpenAI (or your provider)
  2. Add your API key
  3. Select this credential in all AI nodes You can switch to GPT-4o, GPT-4o-mini, or any model you prefer.

🔧 3. Connect Google Sheets

  1. Go to Credentials → Google
  2. Authenticate with your Google account
  3. Make sure the sheet contains the required columns:
  • Date
  • Title
  • Link
  • Summary
  • Insights Commentary

You can customize or add additional columns as needed.

🔧 4. Adjust Workflow Logic (Optional)

You can modify:

  • How the AI summarizes
  • The LinkedIn post style
  • How posts are selected (latest, random, specific tone, etc.)
  • Whether you store more metadata
  • Multi-language support

Everything is modular.

🔧 5. Test the Flow

  1. Send yourself a link via the Telegram bot
  2. Check that it appears in Google Sheets
  3. Type “generate”
  4. Receive your LinkedIn post instantly

🎉 You’re Ready!

This workflow helps you build a personal content pipeline that:

  • Collects links
  • Saves ideas
  • Summarizes insights
  • Generates LinkedIn posts on demand

All directly from your phone, inside Telegram.

If you remix or extend this template, I’d love to see what you build!

Article to LinkedIn Post Generator with Telegram & Google Sheets

This n8n workflow automates the process of generating LinkedIn posts from articles, leveraging AI capabilities (GPT-4 via OpenAI Chat Model) and human-in-the-loop approval via Telegram, with article data managed in Google Sheets.

What it does

This workflow streamlines content creation and publishing by:

  1. Triggering from Telegram: Listens for a specific command or message in a Telegram chat to initiate the process.
  2. Retrieving Article Data: Fetches article URLs and other relevant information from a Google Sheet.
  3. Generating LinkedIn Post Drafts: Uses an AI Agent (powered by an OpenAI Chat Model) to read the article content and generate a draft LinkedIn post.
  4. Human-in-the-Loop Approval (Telegram): Sends the generated LinkedIn post draft to a Telegram chat for review and approval.
  5. Conditional Logic: Checks for approval or rejection from Telegram.
  6. Publishing to LinkedIn (Not fully implemented in JSON): Based on the JSON, the LinkedIn publishing step is implied but not explicitly defined. It would typically follow the approval step.
  7. Updating Google Sheets: Marks the article as processed or updates its status in the Google Sheet.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running n8n instance.
  • Telegram Bot Token: A Telegram bot and its API token for sending and receiving messages.
  • Google Sheets Account: Access to a Google Sheet containing your article data (e.g., article URLs, status).
  • OpenAI API Key: An API key for OpenAI (or a compatible service) to use the GPT-4 model for content generation.
  • LangChain Credentials: Credentials for LangChain integration, which orchestrates the AI agent.

Setup/Usage

  1. Import the Workflow:
    • Download the provided JSON file.
    • In your n8n instance, click "Workflows" in the left sidebar.
    • Click "New" -> "Import from JSON" and paste the workflow JSON or upload the file.
  2. Configure Credentials:
    • Locate the "Google Sheets" node and configure your Google Sheets credentials.
    • Locate the "Telegram Trigger" and "Telegram" nodes and configure your Telegram Bot credentials.
    • Locate the "OpenAI Chat Model" node and configure your OpenAI API key.
    • Ensure any necessary LangChain credentials are set up if prompted by the "AI Agent" node.
  3. Customize Nodes:
    • Telegram Trigger: Configure the specific command or message your Telegram bot should listen for to start the workflow.
    • Google Sheets: Specify the Spreadsheet ID and Sheet Name where your article data is stored.
    • AI Agent / OpenAI Chat Model: Adjust the prompts and parameters for generating the LinkedIn post to match your desired tone and style.
    • Telegram (Approval): Customize the message sent for approval and the expected responses (e.g., "Approve", "Reject").
    • Code Node: Review and modify the JavaScript code if you need to transform data in a specific way before or after AI processing.
    • If Node: Ensure the conditions for approval/rejection from Telegram are correctly configured.
    • LinkedIn Node (Implied): If you plan to add a LinkedIn posting node, configure its credentials and parameters.
  4. Activate the Workflow: Once all credentials and configurations are set, activate the workflow.

Now, when you send the configured command to your Telegram bot, the workflow will fetch an article, generate a LinkedIn post draft, ask for your approval in Telegram, and proceed based on your response.

Related Templates

Two-way property repair management system with Google Sheets & Drive

This workflow automates the repair request process between tenants and building managers, keeping all updates organized in a single spreadsheet. It is composed of two coordinated workflows, as two separate triggers are required — one for new repair submissions and another for repair updates. A Unique Unit ID that corresponds to individual units is attributed to each request, and timestamps are used to coordinate repair updates with specific requests. General use cases include: Property managers who manage multiple buildings or units. Building owners looking to centralize tenant repair communication. Automation builders who want to learn multi-trigger workflow design in n8n. --- ⚙️ How It Works Workflow 1 – New Repair Requests Behind the Scenes: A tenant fills out a Google Form (“Repair Request Form”), which automatically adds a new row to a linked Google Sheet. Steps: Trigger: Google Sheets rowAdded – runs when a new form entry appears. Extract & Format: Collects all relevant form data (address, unit, urgency, contacts). Generate Unit ID: Creates a standardized identifier (e.g., BUILDING-UNIT) for tracking. Email Notification: Sends the building manager a formatted email summarizing the repair details and including a link to a Repair Update Form (which activates Workflow 2). --- Workflow 2 – Repair Updates Behind the Scenes:\ Triggered when the building manager submits a follow-up form (“Repair Update Form”). Steps: Lookup by UUID: Uses the Unit ID from Workflow 1 to find the existing row in the Google Sheet. Conditional Logic: If photos are uploaded: Saves each image to a Google Drive folder, renames files consistently, and adds URLs to the sheet. If no photos: Skips the upload step and processes textual updates only. Merge & Update: Combines new data with existing repair info in the same spreadsheet row — enabling a full repair history in one place. --- 🧩 Requirements Google Account (for Forms, Sheets, and Drive) Gmail/email node connected for sending notifications n8n credentials configured for Google API access --- ⚡ Setup Instructions (see more detail in workflow) Import both workflows into n8n, then copy one into a second workflow. Change manual trigger in workflow 2 to a n8n Form node. Connect Google credentials to all nodes. Update spreadsheet and folder IDs in the corresponding nodes. Customize email text, sender name, and form links for your organization. Test each workflow with a sample repair request and a repair update submission. --- 🛠️ Customization Ideas Add Slack or Telegram notifications for urgent repairs. Auto-create folders per building or unit for photo uploads. Generate monthly repair summaries using Google Sheets triggers. Add an AI node to create summaries/extract relevant repair data from repair request that include long submissions.

Matt@VeraisonLabsBy Matt@VeraisonLabs
208

Dynamic Hubspot lead routing with GPT-4 and Airtable sales team distribution

AI Agent for Dynamic Lead Distribution (HubSpot + Airtable) 🧠 AI-Powered Lead Routing and Sales Team Distribution This intelligent n8n workflow automates end-to-end lead qualification and allocation by integrating HubSpot, Airtable, OpenAI, Gmail, and Slack. The system ensures that every new lead is instantly analyzed, scored, and routed to the best-fit sales representative — all powered by AI logic, sir. --- 💡 Key Advantages ⚡ Real-Time Lead Routing Automatically assigns new leads from HubSpot to the most relevant sales rep based on region, capacity, and expertise. 🧠 AI Qualification Engine An OpenAI-powered Agent evaluates the lead’s industry, region, and needs to generate a persona summary and routing rationale. 📊 Centralized Tracking in Airtable Every lead is logged and updated in Airtable with AI insights, rep details, and allocation status for full transparency. 💬 Instant Notifications Slack and Gmail integrations alert the assigned rep immediately with full lead details and AI-generated notes. 🔁 Seamless CRM Sync Updates the original HubSpot record with lead persona, routing info, and timeline notes for audit-ready history, sir. --- ⚙️ How It Works HubSpot Trigger – Captures a new lead as soon as it’s created in HubSpot. Fetch Contact Data – Retrieves all relevant fields like name, company, and industry. Clean & Format Data – A Code node standardizes and structures the data for consistency. Airtable Record Creation – Logs the lead data into the “Leads” table for centralized tracking. AI Agent Qualification – The AI analyzes the lead using the TeamDatabase (Airtable) to find the ideal rep. Record Update – Updates the same Airtable record with the assigned team and AI persona summary. Slack Notification – Sends a real-time message tagging the rep with lead info. Gmail Notification – Sends a personalized handoff email with context and follow-up actions. HubSpot Sync – Updates the original contact in HubSpot with the assignment details and AI rationale, sir. --- 🛠️ Setup Steps Trigger Node: HubSpot → Detect new leads. HubSpot Node: Retrieve complete lead details. Code Node: Clean and normalize data. Airtable Node: Log lead info in the “Leads” table. AI Agent Node: Process lead and match with sales team. Slack Node: Notify the designated representative. Gmail Node: Email the rep with details. HubSpot Node: Update CRM with AI summary and allocation status, sir. --- 🔐 Credentials Required HubSpot OAuth2 API – To fetch and update leads. Airtable Personal Access Token – To store and update lead data. OpenAI API – To power the AI qualification and matching logic. Slack OAuth2 – For sending team notifications. Gmail OAuth2 – For automatic email alerts to assigned reps, sir. --- 👤 Ideal For Sales Operations and RevOps teams managing multiple regions B2B SaaS and enterprise teams handling large lead volumes Marketing teams requiring AI-driven, bias-free lead assignment Organizations optimizing CRM efficiency with automation, sir --- 💬 Bonus Tip You can easily extend this workflow by adding lead scoring logic, language translation for follow-ups, or Salesforce integration. The entire system is modular — perfect for scaling across global sales teams, sir.

MANISH KUMARBy MANISH KUMAR
113

Track daily moods with AI analysis & reports using GPT-4o, Data Tables & Gmail

Track your daily mood in one tap and receive automated AI summaries of your emotional trends every week and month. Perfect for self-reflection, wellness tracking, or personal analytics. This workflow logs moods sent through a webhook (/mood) into Data Tables, analyzes them weekly and monthly with OpenAI (GPT-4o), and emails you clear summaries and actionable recommendations via Gmail. ⚙️ How It Works Webhook – Mood → Collects new entries (🙂, 😐, or 😩) plus an optional note. Set Mood Data → Adds date, hour, and note fields automatically. Insert Mood Row → Stores each record in a Data Table. Weekly Schedule (Sunday 20:00) → Aggregates the last 7 days and sends a summarized report. Monthly Schedule (Day 1 at 08:00) → Aggregates the last 30 days for a deeper AI analysis. OpenAI Analysis → Generates insights, patterns, and 3 actionable recommendations. Gmail → Sends the full report (chart + AI text) to your inbox. 📊 Example Auto-Email Weekly Mood Summary (last 7 days) 🙂 5 ██████████ 😐 2 ████ 😩 0 Average: 1.7 (Positive 🙂) AI Insights: You’re trending upward this week — notes show that exercise days improved mood. Try keeping short walks mid-week to stabilize energy. 🧩 Requirements n8n Data Tables enabled OpenAI credential (GPT-4o or GPT-4 Turbo) Gmail OAuth2 credential to send summaries 🔧 Setup Instructions Connect your credentials: Add your own OpenAI and Gmail OAuth2 credentials. Set your Data Table ID: Open the Insert Mood Row node and enter your own Data Table ID. Without this, new moods won’t be stored. Replace the email placeholder: In the Gmail nodes, replace your.email@example.com with your actual address. Deploy and run: Send a test POST request to /mood (e.g. { "mood": "🙂", "note": "productive day" }) to log your first entry. ⚠️ Before activating the workflow, ensure you have configured the Data Table ID in the “Insert Mood Row” node. 🧠 AI Analysis Interprets mood patterns using GPT-4o. Highlights trends, potential triggers, and suggests 3 specific actions. Runs automatically every week and month. 🔒 Security No personal data is exposed outside your n8n instance. Always remove or anonymize credential references before sharing publicly. 💡 Ideal For Personal mood journaling and AI feedback Therapists tracking client progress Productivity or self-quantification projects 🗒️ Sticky Notes Guide 🟡 Mood Logging Webhook POST /mood receives mood + optional note. ⚠️ Configure your own Data Table ID in the “Insert Mood Row” node before running. 🟢 Weekly Summary Runs every Sunday 20:00 → aggregates last 7 days → generates AI insights + emails report. 🔵 Monthly Summary Runs on Day 1 at 08:00 → aggregates last 30 days → creates monthly reflection. 🟣 AI Analysis Uses OpenAI GPT-4o to interpret trends and recommend actions. 🟠 Email Delivery Sends formatted summaries to your inbox automatically.

Jose CastilloBy Jose Castillo
105