HumationHuman + Automation
Back to Catalog

Automated content & promo tweet scheduler with Gemini AI and Google Sheets

Jay Emp0Jay Emp0
352 views
2/3/2026
LocationGeocodingGoogle PlacesAPIData Enrichment
Official Page

Twitter Automation (n8n Template)

🚀 What it does

  • Posts a unique tweet every 2 hours
  • 70% content tweets (10 proven templates)
  • 30% promo tweets pulled from Google Sheets
  • Logs past tweets to avoid duplicates

✅ Requirements

  • n8n
  • Google Sheets with 2 tabs:
    • posts → log of past tweets (PAST TWEETS, Date)
    • promo → promo source (name, last_posted, optional extra fields)
      twitterinfluencerexcel.png
  • Twitter (X) account with OAuth2 write access
  • Gemini API key (for text generation)

⚡ Results

  1. Automated motivational posts twitterautomation1.png

  2. Automated promo posts twitterautomation2.png

🔄 How It Works

  1. Triggers every 2 hours (optional: random delay up to 120 min).
  2. Randomly selects content (70%) or promo (30%).
  3. Content path: checks posts, generates tweet, logs new one.
  4. Promo path: picks row from promo, generates tweet, updates last_posted.
  5. Posts to Twitter automatically.

🎯 Content Templates

Transformation · Hook–List–Takeaway · Interesting Fact · Metaphor · Contrast · Motivation · Triad · Comparison · 80/20 Rule · Callout

⚙️ Customization

| Setting | Where | Example | |---------|-------|---------| | Ads probability | Code node | Change Math.random() < 0.3 → 0.2 for 20% | | Templates | Code node | Edit the templates array | | Cadence | Schedule Trigger | Cron or fixed hours | | Random delay | Time randomizer | Enable node (0–120 mins) |

🛠️ Troubleshooting

| Issue | Fix | |-------|-----| | Repeated tweets | Ensure posts has column PAST TWEETS | | Not posting | Reconnect Twitter creds with write access | | Promo never used | Increase ads probability (e.g., 0.4) |

n8n Automated Content & Promo Tweet Scheduler with Gemini AI and Google Sheets

This n8n workflow automates the generation and scheduling of promotional tweets using Google Gemini AI, based on content provided in a Google Sheet. It ensures that only approved content is tweeted, providing a robust system for content managers.

What it does

This workflow simplifies and automates the process of creating and publishing promotional tweets. Here’s a step-by-step breakdown:

  1. Schedules Execution: The workflow is triggered on a predefined schedule (e.g., daily, hourly) to check for new content.
  2. Fetches Content: It retrieves content from a specified Google Sheet. This sheet is expected to contain a "Tweet" column and an "Approved" column.
  3. Filters Approved Content: It checks the "Approved" column for each row. Only rows marked as "TRUE" (or equivalent) are processed further.
  4. Generates Tweets with AI (Conditional): For approved content, it uses the Google Gemini Chat Model via an AI Agent to generate or refine tweet text. This allows for dynamic and context-aware tweet creation.
  5. Prepares Tweet Data: It transforms the data to extract the generated tweet content, making it ready for posting.
  6. Posts to X (Formerly Twitter): The final, approved, and AI-generated tweet is then posted to X.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running n8n instance.
  • Google Sheets: Access to a Google Sheet containing your content and an "Approved" column.
  • Google Gemini API Key: Credentials for the Google Gemini Chat Model to power the AI agent.
  • X (Formerly Twitter) Account: An X account with API access to post tweets.

Setup/Usage

  1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
  2. Configure Credentials:
    • Google Sheets: Set up your Google Sheets credentials to access your content spreadsheet.
    • Google Gemini: Configure your Google Gemini Chat Model credentials.
    • X (Formerly Twitter): Set up your X credentials to allow the workflow to post tweets.
  3. Customize Google Sheet Node:
    • Specify the Spreadsheet ID and Sheet Name where your content is located.
    • Ensure your sheet has a column for the tweet content (e.g., "Tweet") and an "Approved" column (e.g., "Approved") with boolean values (TRUE/FALSE).
  4. Customize AI Agent (Optional): Adjust the prompt for the "AI Agent" node to guide Gemini AI in generating tweets according to your brand voice and requirements.
  5. Activate the Workflow: Enable the workflow to run on its defined schedule.

Once configured, the workflow will automatically check your Google Sheet, generate tweets for approved content using AI, and post them to X.

Related Templates

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

Create, update, and get a person from Copper

This workflow allows you to create, update, and get a person from Copper. Copper node: This node will create a new person in Copper. Copper1 node: This node will update the information of the person that we created using the previous node. Copper2 node: This node will retrieve the information of the person that we created earlier.

Harshil AgrawalBy Harshil Agrawal
603