Showing posts with label n8n. Show all posts
Showing posts with label n8n. Show all posts

Sunday, 10 May 2026

n8n Microsoft Teams Tutorial: Automate Messages, Alerts, and AI Workflows

n8n + Microsoft Teams Tutorial

How to Use n8n with Microsoft Teams for Workflow Automation

Learn how to send Teams messages, trigger workflows from Teams events, and automate business alerts using n8n.

If your team uses Microsoft Teams, connecting it with n8n can help automate alerts, reports, approvals, support updates, and internal workflows.

💡 Example: website form → n8n webhook → save lead → send Microsoft Teams notification automatically.

What You’ll Learn

  • How Microsoft Teams works with n8n
  • How to connect Teams credentials
  • How to send Teams messages
  • How to use Microsoft Teams Trigger
  • Real-world Teams automation examples

Why Use n8n with Microsoft Teams?

Microsoft Teams is used for communication, while n8n connects Teams to other tools like forms, CRMs, databases, AI agents, spreadsheets, and APIs.

  • Send automated team alerts
  • Create approval workflows
  • Notify teams when payments or leads arrive
  • Send AI-generated reports
  • Trigger automations from Teams events
  • Connect Teams with Gmail, Outlook, Google Sheets, CRM, and databases

Step 1: Connect Microsoft Teams to n8n

n8n has a built-in Microsoft Teams node for automating Teams actions. It supports a wide range of Teams features, including creating and deleting channels, messages, and tasks. n8n also has a Microsoft Teams Trigger node that can respond to Teams events.

  1. Open n8n
  2. Go to Credentials
  3. Create Microsoft Teams credentials
  4. Sign in with your Microsoft account
  5. Authorize the required permissions
  6. Save and test the credential
⚠️ Note: some Microsoft 365 organization accounts may require admin approval before n8n can access Teams.

Step 2: Send a Microsoft Teams Message

A common workflow is sending a message to a Teams channel when something important happens.

Webhook
   ↓
Set / Edit Fields
   ↓
Microsoft Teams: Send Message

Example message:

🚀 New lead received!

Name: {{ $json.name }}
Email: {{ $json.email }}
Message: {{ $json.message }}

This is useful for sales teams, support teams, school admins, LGU monitoring, and operations alerts.

Step 3: Use Microsoft Teams Trigger

The Microsoft Teams Trigger node can start a workflow when events happen in Teams. n8n lists supported events such as new channel, new channel message, new chat, new chat message, and new team member.

Microsoft Teams Trigger
   ↓
AI Agent / IF Node
   ↓
Google Sheets / CRM / Email

Example: when someone posts a message in a Teams channel, n8n can analyze it with AI, log it to a database, or create a task.

Step 4: Build an Approval Workflow

You can use Teams as the notification layer for approvals.

Form Submission
   ↓
IF Amount > 5000
   ↓
Microsoft Teams Alert
   ↓
Manager Review
   ↓
Update Database

This works well for purchase requests, project approvals, leave requests, quotation approvals, and internal business workflows.

Step 5: Combine Teams with AI

You can connect Teams with AI models using n8n. For example, an AI Agent can summarize messages, classify requests, generate reports, or create replies.

Teams Message
   ↓
AI Agent
   ↓
Summarize / Classify
   ↓
Send Teams Reply
   ↓
Save to Google Sheets

This is useful for helpdesk automation, project monitoring, customer support, and smart internal assistants.

Example Workflow: New Lead Alert to Teams

Website Form
   ↓
n8n Webhook
   ↓
Set / Format Data
   ↓
Google Sheets
   ↓
Microsoft Teams Message

Every time a lead submits a form, n8n saves the lead and sends a message to your Teams channel.

Example Workflow: AI Daily Report

Schedule Trigger
   ↓
Database / Google Sheets
   ↓
AI Summary
   ↓
Microsoft Teams Message

This workflow can generate a daily summary of sales, attendance, tasks, or monitoring data and send it to Microsoft Teams automatically.

Real Use Cases

Lead alerts
Helpdesk notifications
Approval workflows
AI daily reports
IoT and CCTV alerts
CRM updates

Common Errors and Fixes

1. Authentication failed
Reconnect your Microsoft credential and confirm the correct account is used.

2. Admin approval required
Some Microsoft 365 tenants require an administrator to approve the app permissions.

3. Channel not found
Check that your account has access to the selected Team and channel.

4. Trigger not firing
Confirm that the workflow is active and the trigger event is correctly selected.

5. Message formatting issue
Keep your first messages simple, then add formatting after testing.

Best Practices

  • Start with a simple “send message” workflow first
  • Use dedicated Teams channels for alerts
  • Keep alert messages short and readable
  • Use IF nodes to avoid unnecessary notifications
  • Log important events in Google Sheets or a database
  • Add AI summaries for long reports or busy channels

Watch My AI Automation Builds on YouTube

I share real n8n workflows, AI agents, IoT systems, and business automations on my YouTube channel.

▶ Visit My YouTube Channel

FAQ

Can n8n send messages to Microsoft Teams?
Yes. n8n has a built-in Microsoft Teams node for automating Teams actions, including messages.

Can Microsoft Teams trigger n8n workflows?
Yes. n8n has a Microsoft Teams Trigger node that can respond to Teams events like new messages, chats, channels, and members.

Can I use AI with Microsoft Teams and n8n?
Yes. You can connect AI models or AI Agent workflows to summarize, classify, and respond to Teams-related events.


SEO Title

n8n Microsoft Teams Tutorial: Automate Messages, Alerts, and AI Workflows

Meta Description

Learn how to use n8n with Microsoft Teams to send messages, trigger workflows, create alerts, build approval systems, and automate AI reports.

Suggested Labels

n8n, Microsoft Teams, Workflow Automation, AI Automation, Teams Alerts, Business Automation, Blogspot Tutorial

Friday, 8 May 2026

n8n Notion Tutorial: Automate Pages, Databases, and Workflows

n8n + Notion Tutorial

How to Use n8n with Notion for Workspace Automation

Learn how to connect n8n to Notion, create pages, update database records, trigger workflows, and automate your workspace.

If you use Notion for notes, tasks, content planning, CRM, or project tracking, connecting it with n8n can save a lot of manual work. You can automatically create pages, update database items, trigger follow-ups, and connect Notion with AI, Gmail, Telegram, Google Sheets, and more.

💡 Example: website form → n8n webhook → create Notion lead record → send Telegram alert → AI writes follow-up email.

What You’ll Learn

  • How to connect Notion to n8n
  • How to create Notion pages automatically
  • How to update Notion database records
  • How to use Notion Trigger in n8n
  • How to build real automation workflows with Notion

Why Use n8n with Notion?

Notion is great for organizing information, while n8n is great for automation. Together, they can turn your Notion workspace into a connected business system.

  • Save leads into a Notion CRM
  • Create task pages automatically
  • Build a content calendar
  • Update project status from other apps
  • Send alerts when new records are added
  • Use AI to summarize or generate Notion content

Step 1: Prepare Your Notion Database

First, create a Notion database depending on your workflow. For example, if you want a lead tracker, create fields like:

  • Name
  • Email
  • Phone
  • Message
  • Status
  • Source
  • Date Created
⚠️ Tip: keep your field names simple because you will map these fields inside n8n.

Step 2: Connect Notion to n8n

n8n has a built-in Notion node that supports operations such as searching databases, creating pages, and getting users. n8n also has a Notion Trigger node for database page events like page added or page updated.

  1. Open Credentials in n8n
  2. Create a new Notion credential
  3. Authorize your Notion workspace
  4. Make sure the selected Notion database is shared with the integration
  5. Save and test the credential

If your database does not appear in n8n, check if the Notion integration has access to that page or database.

Step 3: Create a Notion Page from n8n

Add a Notion node and choose an operation that creates a page or database page. Then map your incoming data to Notion properties.

Example field mapping:

Name: {{ $json.name }}
Email: {{ $json.email }}
Phone: {{ $json.phone }}
Message: {{ $json.message }}
Status: New
Source: Website Form

This is useful for contact forms, chatbot leads, client requests, appointment inquiries, and internal task creation.

Step 4: Search or Get Notion Database Items

You can also use n8n to search a Notion database and retrieve existing records. This is useful when you want to check if a lead already exists, update a task, or look up project information.

Search Notion Database
   ↓
IF record exists
   ├── Update existing page
   └── Create new page

Step 5: Update a Notion Database Page

When you already have a Notion page or database record, n8n can update its properties.

Example update:

Status: Contacted
Notes: Follow-up email sent
Last Updated: {{ $now }}

This is helpful after sending an email, completing a task, receiving payment, or updating a project stage.

Step 6: Use Notion Trigger

The Notion Trigger node can start workflows when a page is added to a database or updated in a database. This is useful for status-based automation and project workflows.

Notion Trigger
   ↓
IF Status = Approved
   ↓
Send Gmail / Telegram / Slack Notification

Example: when a Notion task status changes to “Approved,” n8n can notify your team or create a next-step task automatically.

Example Workflow: Notion Lead CRM Automation

Webhook
   ↓
Set / Edit Fields
   ↓
Notion Create Database Page
   ↓
Telegram Notification
   ↓
Gmail Follow-up

In this workflow, a new lead is received from a form, saved into Notion, sent to your team via Telegram, and followed up by email.

Example Workflow: AI Content Planner

Notion Trigger
   ↓
AI Agent / OpenAI
   ↓
Generate Blog Outline
   ↓
Update Notion Page
   ↓
Notify Creator

This is useful if you use Notion as your content calendar. When you add a new topic, n8n can generate an outline, title ideas, captions, and hashtags using AI.

Real Use Cases

Notion CRM system
Content calendar automation
Project task management
AI meeting summary storage
Client onboarding tracker
Approval workflow automation

Common Errors and Fixes

1. Database not showing in n8n
Make sure your Notion database is shared with the integration.

2. Authentication failed
Reconnect your Notion credential in n8n and confirm the correct workspace is selected.

3. Field mapping failed
Check if your Notion property names match the fields you are mapping in n8n.

4. Update operation failed
Make sure you are using the correct Notion page ID or database page ID.

5. Trigger not firing
Confirm the database is accessible and the workflow is active.

Best Practices

  • Use simple Notion property names
  • Create a dedicated database for automation
  • Always test with one record first
  • Use status fields like New, Contacted, Approved, or Done
  • Keep your workflow small before adding AI or multiple apps
  • Log errors during testing before going live

Watch My AI Automation Builds on YouTube

I share real n8n workflows, AI agents, database automations, and business systems on my YouTube channel.

▶ Visit My YouTube Channel

FAQ

Can n8n connect to Notion?
Yes. n8n has a built-in Notion node and Notion Trigger node.

Can I use Notion as a CRM with n8n?
Yes. You can save leads, update statuses, send follow-ups, and trigger notifications automatically.

Can n8n trigger workflows from Notion changes?
Yes. The Notion Trigger node supports database page added and database page updated events.


SEO Title

n8n Notion Tutorial: Automate Pages, Databases, and Workflows

Meta Description

Learn how to use n8n with Notion to create pages, update database records, trigger workflows, and build CRM, content, and task automations.

Suggested Labels

n8n, Notion, Workflow Automation, AI Automation, Notion API, CRM Automation, Productivity, Blogspot Tutorial

Monday, 4 May 2026

n8n Airtable Tutorial: Automate Records, Leads, and Workflows

n8n + Airtable Tutorial

How to Use n8n with Airtable for No-Code Database Automation

Learn how to connect n8n to Airtable, create records, update data, trigger workflows, and automate business processes.

If you want a simple database for your automation workflows, Airtable is a great option. It works like a spreadsheet but has database-style fields, views, and records. When combined with n8n, you can automate lead tracking, CRM updates, content planning, inventory records, project tasks, and more.

💡 Example: website form → n8n webhook → Airtable record → Telegram alert → Gmail follow-up.

What You’ll Learn

  • How to connect Airtable to n8n
  • How to create Airtable records automatically
  • How to list, filter, update, and delete records
  • How to use Airtable Trigger in n8n
  • Real-world Airtable automation workflows

Why Use n8n with Airtable?

Airtable is useful for teams that want a flexible database without building a full custom app. n8n makes it more powerful by connecting Airtable to other apps and services.

  • Save form leads automatically
  • Build a simple CRM
  • Track orders or inquiries
  • Manage content calendars
  • Trigger notifications when records change
  • Connect Airtable with AI, Gmail, Telegram, Slack, and WordPress

Step 1: Prepare Your Airtable Base

First, create an Airtable base and table. For a simple lead tracking workflow, your table can include fields like:

  • Name
  • Email
  • Phone
  • Message
  • Status
  • Created Date
⚠️ Tip: Use clear field names because you will map these fields inside n8n.

Step 2: Create Airtable Credentials in n8n

n8n supports Airtable credentials. Airtable now uses personal access tokens for API authentication. n8n recommends token scopes such as data.records:read, data.records:write, and schema.bases:read. Airtable also states that legacy API keys were deprecated and can no longer access the API.

  1. Go to Airtable Builder Hub
  2. Create a personal access token
  3. Add the needed scopes
  4. Give access to your selected base
  5. In n8n, create a new Airtable credential
  6. Paste the token and save

Step 3: Create a Record in Airtable

Add an Airtable node in n8n and select the operation for creating a record. Then choose your base and table.

Example field mapping:

Name: {{ $json.name }}
Email: {{ $json.email }}
Phone: {{ $json.phone }}
Message: {{ $json.message }}
Status: New

This is useful when your workflow starts from a Webhook, form submission, chatbot, CRM, or Google Sheet.

Step 4: List and Filter Records

n8n’s Airtable node supports listing records. You can also filter records using Airtable formulas.

Example filter formula:

{Status}='New'

This returns only records where the status is set to “New”. This is perfect for lead follow-up workflows.

Step 5: Update a Record

To update an existing record, you need the Airtable Record ID. The List operation can return the Record ID along with your fields.

Example update:

Record ID: {{ $json.id }}
Status: Contacted

This can be used after sending an email, completing a task, receiving payment, or approving a request.

Step 6: Use Airtable Trigger

n8n also has an Airtable Trigger node. It can respond to Airtable events by checking a created or last modified field in your table.

Airtable Trigger
   ↓
IF
   ↓
Telegram / Gmail / Slack / AI Agent

This is useful when you want automation to run whenever a new record is created or an existing record is updated.

Example Workflow: Lead Capture Automation

Webhook
   ↓
Set / Edit Fields
   ↓
Airtable Create Record
   ↓
Telegram Notification
   ↓
Gmail Follow-up

In this workflow, n8n receives a lead, saves it in Airtable, notifies your team, and sends a follow-up email automatically.

Example Workflow: AI Lead Scoring

Airtable Trigger
   ↓
AI Agent / OpenAI
   ↓
Update Airtable Score
   ↓
Notify Sales Team

You can use AI to analyze new leads and score them based on budget, urgency, message quality, or business fit.

Real Use Cases

Mini CRM system
Content calendar automation
Order tracking dashboard
AI lead scoring
Project request tracker
Client onboarding system

Common Errors and Fixes

1. Authentication failed
Check your personal access token and make sure the correct scopes and base access are enabled.

2. Base or table not found
Verify the base ID, table name, and token permissions.

3. Record update failed
Make sure you are using the Airtable Record ID, not just a normal field value.

4. Trigger not firing
Confirm that your table has a created time or last modified time field for the trigger to track.

5. Formula filter returns no records
Check field names, quotation marks, and exact values in your Airtable formula.

Best Practices

  • Use personal access tokens instead of old API keys
  • Limit token access only to the base you need
  • Use clear field names
  • Always save the Airtable Record ID when updating records
  • Use status fields like New, Contacted, Approved, or Done
  • Log errors during testing before going live

Watch My AI Automation Builds on YouTube

I share real n8n workflows, AI agents, database automations, and business systems on my YouTube channel.

▶ Visit My YouTube Channel

FAQ

Can n8n connect to Airtable?
Yes. n8n has a built-in Airtable node and Airtable Trigger node.

Can I use Airtable as a simple CRM with n8n?
Yes. You can store leads, update statuses, trigger follow-ups, and notify your team automatically.

Do I need an Airtable API key?
Airtable now uses personal access tokens for API authentication instead of legacy API keys.


SEO Title

n8n Airtable Tutorial: Automate Records, Leads, and Workflows

Meta Description

Learn how to use n8n with Airtable to create records, update data, filter leads, trigger workflows, and build no-code database automations.

Suggested Labels

n8n, Airtable, No Code Automation, Workflow Automation, CRM, AI Automation, Database Automation, Blogspot Tutorial

Sunday, 3 May 2026

n8n Asana Tutorial: Task Automation Guide

n8n + Asana Tutorial

How to Use n8n with Asana for Task Automation

Automate task creation, updates, and workflows using n8n + Asana ⚡

If you want to automate project management, combining n8n with Asana allows you to create tasks, assign work, and manage projects automatically.

💡 Example: New lead → n8n → create Asana task → assign team → notify via Slack.

📌 What You'll Learn

  • Connect Asana to n8n
  • Create tasks automatically
  • Update task status
  • Assign tasks dynamically
  • Build automation workflows

Step 1: Connect Asana to n8n

  1. Go to n8n → Credentials
  2. Add Asana
  3. Login and authorize
⚠️ Use secure OAuth connection.

Step 2: Create Task Automatically

  • Select Asana node
  • Operation: Create Task
  • Fill in project, name, and description
Task Name: New Client Lead
Description: {{ $json.message }}

Step 3: Assign Task

You can assign tasks dynamically using user IDs.

{{ $json.assignee }}

Full Workflow Example

Webhook → Set → Asana → Slack / Email
  • Receive data
  • Create task
  • Assign team
  • Notify stakeholders

Real Use Cases

Lead tracking
Project automation
Task reminders
Team collaboration

Common Errors

❌ Auth failed
❌ Wrong project ID
❌ Missing required fields

Pro Tips

  • Use labels and tags
  • Automate recurring tasks
  • Integrate with CRM systems
  • Combine with AI for smart task creation

🎥 Watch My Automation Builds

I share n8n workflows, AI systems, and automation tutorials.

▶ Visit My YouTube Channel

FAQ

Q: Can I automate tasks?
Yes.

Q: Can I assign users automatically?
Yes.

Q: Can I integrate AI?
Yes.


SEO Title: n8n Asana Tutorial: Task Automation Guide

Meta Description: Learn how to automate tasks using n8n and Asana.

Saturday, 2 May 2026

n8n Trello Tutorial: Automate Task Workflows

n8n + Trello Tutorial

How to Use n8n with Trello for Task Automation

Automate task creation, updates, and team workflows using n8n + Trello 📋⚡

If you're managing projects or teams, combining n8n with Trello lets you automate task creation, updates, and notifications. You can connect Trello to emails, forms, CRMs, or AI systems.

💡 Example: Form submitted → n8n → Trello card created → team notified automatically.

📌 What You'll Learn

  • Connect Trello to n8n
  • Create cards automatically
  • Update lists and tasks
  • Build automation workflows
  • Real-world use cases

Step 1: Get Trello API Key

  1. Go to Trello Developer page
  2. Generate API key
  3. Get your token
⚠️ Keep your credentials secure.

Step 2: Add Trello Credentials in n8n

  • Go to n8n → Credentials
  • Add Trello credentials
  • Paste API key + token

Step 3: Create a Trello Card

Use Trello node in n8n:

  • Operation: Create Card
  • Board ID: your board
  • List ID: target list
  • Name: task title

Full Workflow Example

Webhook → Set → Trello → Slack / Email
  • Receive data
  • Format task
  • Create Trello card
  • Notify team

Real Use Cases

Project management
Lead tracking
Bug tracking
Content planning

Common Errors

❌ Invalid API key
❌ Wrong board/list ID
❌ Permission issues

Pro Tips

  • Use labels for task categorization
  • Auto-assign members
  • Connect with AI for task generation
  • Use due dates automation

🎥 Watch My Automation Builds

I share real n8n workflows, automation systems, and AI builds.

▶ Visit My YouTube Channel

FAQ

Q: Can I automate Trello tasks?
Yes, using n8n.

Q: Can I connect AI to Trello?
Yes, for auto task creation.

Q: Can I notify team automatically?
Yes, via Slack or email.


SEO Title: n8n Trello Tutorial: Automate Task Workflows

Meta Description: Learn how to use n8n with Trello to automate tasks and workflows.

Friday, 1 May 2026

n8n PDF.co Tutorial: Automate PDF Workflows

n8n + PDF.co Tutorial

How to Use n8n with PDF.co for Document Automation

Generate, read, convert, and automate PDFs using n8n + PDF.co 📄⚡

If you're building automation systems for businesses, documents are everywhere. Combining n8n with PDF.co allows you to generate invoices, extract data from PDFs, and automate document workflows easily.

💡 Example: Form submission → n8n → PDF invoice generated → send via email automatically.

📌 What You'll Learn

  • Connect PDF.co to n8n
  • Create PDF documents
  • Extract data from PDFs
  • Convert files (PDF ↔ images/text)
  • Build automation workflows

Step 1: Get PDF.co API Key

  1. Go to PDF.co
  2. Create account
  3. Copy your API key
⚠️ Keep your API key secure.

Step 2: Setup HTTP Request in n8n

  • Method: POST
  • URL: https://api.pdf.co/v1/pdf/create

Headers:

x-api-key: YOUR_API_KEY
Content-Type: application/json

Step 3: Create a PDF

{
  "name": "invoice.pdf",
  "html": "<h1>Invoice</h1><p>Customer: John Doe</p>"
}

This generates a PDF file from HTML.

Step 4: Extract Data from PDF

{
  "url": "https://example.com/sample.pdf"
}

Use PDF.co to extract text or structured data.

Full Workflow Example

Webhook → Set → PDF.co → Gmail → Google Sheets
  • Receive form data
  • Generate PDF
  • Email document
  • Log data

Real Use Cases

Invoice automation
Report generation
Document parsing
Contracts processing

Common Errors

❌ Invalid API key
❌ Bad HTML format
❌ File URL inaccessible

Pro Tips

  • Use HTML templates for PDFs
  • Store PDFs in cloud storage
  • Combine with Stripe/Xendit for invoices
  • Use AI to generate content dynamically

🎥 Watch My Automation Builds

I share real n8n workflows, automation systems, and AI builds.

▶ Visit My YouTube Channel

FAQ

Q: Can I generate invoices automatically?
Yes, using PDF.co + n8n.

Q: Can I extract data from PDFs?
Yes, PDF.co supports parsing.

Q: Can I automate document workflows?
Yes, fully automated systems.


SEO Title: n8n PDF.co Tutorial: Automate PDF Workflows

Meta Description: Learn how to use n8n with PDF.co to generate and automate PDF documents.

Wednesday, 29 April 2026

n8n OpenRouter Tutorial: Build Multi-Model AI Automation Workflows

n8n + OpenRouter Tutorial

How to Use n8n with OpenRouter for Multi-Model AI Automation

Learn how to connect n8n to OpenRouter and use multiple AI models in one automation workflow.

If you want to build flexible AI automations, combining n8n with OpenRouter is a powerful setup. OpenRouter gives you access to many AI models through one unified API, while n8n lets you automate how those models are used.

💡 Example: user submits a question → n8n sends it to OpenRouter → AI generates a response → result is sent to Telegram, Gmail, CRM, or your website chatbot.

What You’ll Learn

  • What OpenRouter is
  • How to connect OpenRouter to n8n
  • How to call AI models using HTTP Request
  • How to use dynamic prompts from previous nodes
  • How to build real AI automation workflows

What Is OpenRouter?

OpenRouter is a unified AI model gateway. Instead of integrating many separate AI providers one by one, you can call different models through one OpenRouter API.

This is useful when you want to test different models for chatbots, AI agents, blog automation, summarization, customer support, and internal tools.

Simple explanation: OpenRouter is like a router for AI models. n8n sends the request, OpenRouter sends it to the selected AI model.

Step 1: Get Your OpenRouter API Key

  1. Create or log in to your OpenRouter account
  2. Go to API Keys
  3. Create a new API key
  4. Copy and save it securely
⚠️ Security tip: never expose your OpenRouter API key in frontend code or public pages.

Step 2: Add HTTP Request Node in n8n

OpenRouter can be connected using the n8n HTTP Request node.

HTTP Request settings:

  • Method: POST
  • URL: https://openrouter.ai/api/v1/chat/completions
  • Authentication: None or Generic Header Auth
  • Send Body: JSON

Headers:

Content-Type: application/json
Authorization: Bearer YOUR_OPENROUTER_API_KEY

Step 3: Send Your First AI Request

Example JSON body:

{
  "model": "openai/gpt-4o-mini",
  "messages": [
    {
      "role": "system",
      "content": "You are a helpful AI automation assistant."
    },
    {
      "role": "user",
      "content": "Explain n8n in simple terms."
    }
  ]
}

After executing the node, OpenRouter will return an AI-generated response from the selected model.

Step 4: Use Dynamic Data from Previous Nodes

In real workflows, your prompt usually comes from a webhook, form, chat widget, Google Sheet, or database.

Example dynamic message:

{
  "model": "openai/gpt-4o-mini",
  "messages": [
    {
      "role": "system",
      "content": "You are a helpful customer support assistant."
    },
    {
      "role": "user",
      "content": "{{ $json.message }}"
    }
  ]
}

This lets n8n send user input directly to OpenRouter and use the response in the next node.

Step 5: Extract the AI Response

The AI response is usually returned inside the output JSON. In many chat completion responses, the generated text can be found in:

{{ $json.choices[0].message.content }}

You can pass this value to Telegram, Gmail, Google Sheets, WordPress, CRM, or a website chatbot.

Example n8n + OpenRouter Workflow

Webhook / Chat Trigger
   ↓
Set
   ↓
HTTP Request (OpenRouter)
   ↓
Set / Extract AI Response
   ↓
Telegram / Gmail / Google Sheets / WordPress

This workflow receives input, sends it to an AI model through OpenRouter, extracts the AI answer, and sends it to another app.

Real Use Cases

AI chatbot replies
Blog post generation
Email auto-response
AI agent workflows
Document summarization
Customer support automation

Example: AI Support Bot with OpenRouter

You can use OpenRouter as the AI brain of a support bot. A simple workflow can look like this:

Website Chat Form
   ↓
n8n Webhook
   ↓
OpenRouter AI
   ↓
Business Logic / IF Node
   ↓
Reply to User
   ↓
Log to Google Sheets

This is useful for schools, LGUs, service businesses, online stores, and internal helpdesks.

Common Errors and Fixes

1. Unauthorized error
Check your Authorization header and make sure it uses Bearer YOUR_API_KEY.

2. Model not found
Confirm the model ID from the OpenRouter models page before using it.

3. Empty response
Check your messages array and make sure user content is not blank.

4. Wrong output expression
Inspect the HTTP Request output and adjust the expression path if needed.

5. High cost or slow response
Try a smaller model for simple tasks and reserve larger models for complex reasoning.

Best Practices

  • Start with a low-cost model for testing
  • Use clear system prompts
  • Log prompts and responses during development
  • Keep API keys inside n8n credentials or secure variables
  • Use IF nodes to handle errors or empty responses
  • Use different models depending on task complexity

Watch My AI Automation Builds on YouTube

I share real n8n workflows, AI agent builds, and automation systems on my YouTube channel.

▶ Visit My YouTube Channel

FAQ

Can n8n connect to OpenRouter?
Yes. You can use the HTTP Request node to call OpenRouter’s API directly.

Is OpenRouter compatible with OpenAI-style requests?
Yes. OpenRouter’s request and response schemas are similar to the OpenAI Chat API, which makes it easier to integrate.

Can I use OpenRouter for AI agents?
Yes. You can use OpenRouter as the model backend for AI chatbots, assistants, and agent-style workflows in n8n.


SEO Title

n8n OpenRouter Tutorial: Build Multi-Model AI Automation Workflows

Meta Description

Learn how to connect n8n with OpenRouter using HTTP Request, send AI prompts, extract responses, and build multi-model AI automation workflows.

Suggested Labels

n8n, OpenRouter, AI Automation, AI Agent, Workflow Automation, Chatbot, OpenAI API, Blogspot Tutorial

Tuesday, 28 April 2026

n8n Gemini Image Generation Tutorial: Create AI Images Automatically

n8n + Google Gemini Tutorial

How to Create AI Images with n8n and Google Gemini

Learn how to automate AI image generation using n8n, Google Gemini, Google Sheets, and Google Drive.

If you want to create images automatically for blogs, YouTube thumbnails, social media posts, product visuals, or marketing content, combining n8n with Google Gemini is a powerful workflow.

💡 Example: Google Sheets contains image ideas → n8n reads the rows → Gemini generates images → n8n saves them to Google Drive → status updates automatically.

What You’ll Learn

  • How Gemini image generation works
  • How to connect Gemini API to n8n
  • How to generate images from text prompts
  • How to save generated images to Google Drive
  • How to build a full content automation workflow

What Is Google Gemini Image Generation?

Google Gemini can generate and process images using text prompts, reference images, or a combination of both. This makes it useful for creating thumbnails, social media graphics, blog images, concept art, product visuals, and marketing assets.

Google also provides Imagen models for high-fidelity image generation. Imagen is designed to generate realistic, high-quality images from text prompts.

Simple explanation: Gemini creates the image, while n8n automates the full process around it.

Step 1: Prepare Your Google Gemini API Key

First, get your Gemini API key from Google AI Studio or your Google AI developer account.

  1. Go to Google AI Studio
  2. Create or select your API key
  3. Copy the key
  4. Store it securely in n8n credentials or environment variables
⚠️ Security tip: never expose your API key in frontend code or public blog pages.

Step 2: Create the n8n Workflow Structure

A simple image automation workflow can look like this:

Google Sheets Trigger
   ↓
Get Row / Prompt
   ↓
HTTP Request or Gemini Node
   ↓
Convert Base64 / Download Image
   ↓
Google Drive Upload
   ↓
Update Google Sheet
   ↓
Telegram Notification

This workflow is useful if you want to generate images in bulk from a spreadsheet.

Step 3: Prepare Your Google Sheet

Create a Google Sheet with these columns:

  • title – image topic or content title
  • prompt – full image prompt
  • status – pending / done / failed
  • image_url – final uploaded image link

Example prompt:

A futuristic n8n automation dashboard with glowing nodes, dark background, cinematic lighting, high-tech UI, no text

Step 4: Generate Image Using Gemini API

In n8n, you can use either a Gemini-supported node or the HTTP Request node to call the Gemini image generation endpoint.

Typical HTTP Request setup:

  • Method: POST
  • Authentication: API key or Bearer token, depending on your setup
  • Body type: JSON
  • Prompt: use dynamic value from Google Sheets

Example dynamic prompt:

{{ $json.prompt }}
💡 Tip: For blog thumbnails, add style details like “cinematic lighting,” “dark tech background,” “3D vector style,” and “no text” for cleaner output.

Step 5: Save the Generated Image

Image generation APIs often return either a downloadable image URL or base64 image data. In n8n, your next step depends on the response type.

  • If the API returns a URL, use HTTP Request to download the file.
  • If the API returns base64, convert it to binary data.
  • Then upload the file to Google Drive, Supabase Storage, or WordPress media.

Workflow sample:

Gemini Image Response
   ↓
Convert to Binary
   ↓
Google Drive Upload
   ↓
Get Share Link
   ↓
Update Google Sheet

Step 6: Update Google Sheet Status

After saving the image, update the same Google Sheet row.

Recommended values:

  • status: done
  • image_url: Google Drive or storage link
  • generated_at: current timestamp

Real Use Cases

YouTube thumbnail ideas
Blog featured images
Social media creatives
Product mockup images

Prompt Examples for n8n Automation Content

Example 1: Tech thumbnail

A premium dark tech illustration showing automation nodes connected to AI, glowing blue and purple lights, cinematic, modern SaaS style, no text

Example 2: AI agent image

A futuristic AI assistant controlling business workflows, floating automation nodes, digital dashboard, dark background, clean modern style, no text

Example 3: Blog featured image

A clean vector-style image of a workflow automation system connecting Google Sheets, AI image generation, and cloud storage, dark background, professional, no text

Common Errors and Fixes

1. API key error
Check if your Gemini API key is active and correctly added to n8n.

2. No image returned
Check if you are using an image-capable Gemini or Imagen model.

3. Base64 conversion issue
Make sure you convert the correct response field into binary data.

4. Prompt gives messy text
Add “no text” or “no typography” to your prompt if you want a clean thumbnail background.

5. Google Drive upload fails
Check your Google Drive credentials and binary property name in n8n.

Best Practices

  • Use Google Sheets to manage prompts in bulk
  • Keep prompts clear and style-specific
  • Add “no text” for cleaner blog images
  • Save outputs to Google Drive or Supabase Storage
  • Log failed generations for retry
  • Use a Wait node if generating many images

Watch My Automation Videos on YouTube

I share n8n workflows, AI automation tutorials, and real system builds on my YouTube channel.

▶ Visit My YouTube Channel

FAQ

Can I generate images automatically with n8n and Gemini?
Yes. You can use n8n to send prompts to Gemini or Imagen image models, then save the generated output to Drive, storage, or WordPress.

Can I generate images from Google Sheets rows?
Yes. A common workflow is Google Sheets → Gemini image generation → Google Drive upload → update row status.

Can I use this for YouTube thumbnails?
Yes. It is useful for thumbnail backgrounds, blog featured images, social media graphics, and marketing visuals.


SEO Title

n8n Gemini Image Generation Tutorial: Create AI Images Automatically

Meta Description

Learn how to use n8n and Google Gemini to generate AI images from prompts, save them to Google Drive, and automate content creation workflows.

Suggested Labels

n8n, Google Gemini, AI Image Generation, Automation, Google Drive, Google Sheets, Blogspot Tutorial

Friday, 24 April 2026

n8n Firecrawl Tutorial: AI Web Scraping Automation

n8n + Firecrawl Tutorial

How to Use n8n with Firecrawl for AI Web Scraping Automation

Extract website content, clean data, and build AI pipelines using Firecrawl + n8n 🚀

If you're building AI systems, RAG pipelines, or automation workflows, combining n8n with Firecrawl is a powerful solution. Firecrawl extracts clean content from websites, while n8n automates what you do with that data.

💡 Example: scrape article → clean content → send to OpenAI → publish blog → notify Telegram.

📌 What You'll Learn

  • Connect Firecrawl API to n8n
  • Scrape websites automatically
  • Extract clean content
  • Build AI workflows (RAG, blog automation)
  • Real-world use cases

What is n8n + Firecrawl?

Firecrawl is an AI-powered web scraping tool that extracts clean, structured content from websites. n8n allows you to automate how that data is processed, stored, and used.

Step 1: Get Firecrawl API Key

  1. Go to Firecrawl website
  2. Create an account
  3. Copy your API key
⚠️ Keep your API key secure.

Step 2: Setup HTTP Request Node in n8n

Firecrawl works via API, so we use the HTTP Request node.

  • Method: POST
  • URL: https://api.firecrawl.dev/v1/scrape

Headers:

Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

Step 3: Scrape a Website

{
  "url": "https://example.com",
  "formats": ["markdown"]
}

This will return clean structured content ready for AI processing.

Step 4: Crawl Multiple Pages

{
  "url": "https://example.com",
  "crawl": true,
  "limit": 10
}

This allows you to scrape entire websites automatically.

Full Workflow Example

Manual Trigger → HTTP Request (Firecrawl) → OpenAI → Set → WordPress → Telegram
  • Scrape website
  • Clean content
  • Generate article using AI
  • Publish blog
  • Send notification

Real Use Cases

AI Blog Automation
Competitor Monitoring
RAG Knowledge Base
News Aggregation

Common Errors

❌ Invalid API key
❌ Website blocking scraping
❌ Empty content returned
❌ Rate limits

Pro Tips

  • Use markdown format for AI processing
  • Combine with OpenAI for summarization
  • Store scraped data in Supabase
  • Limit crawl depth for performance

🎥 Watch My AI Automation Tutorials

I share n8n workflows, scraping systems, and AI automations on my YouTube channel.

▶ Visit My YouTube Channel

FAQ

Q: Is Firecrawl free?
Firecrawl offers limited free usage.

Q: Can I scrape multiple pages?
Yes, using crawl mode.

Q: Can I use this for AI chatbots?
Yes, perfect for RAG pipelines.


SEO Title: n8n Firecrawl Tutorial: AI Web Scraping Automation

Meta Description: Learn how to use n8n with Firecrawl to scrape websites and build AI-powered automation workflows.

Thursday, 23 April 2026

How to Use n8n with PostgreSQL for Database Automation

n8n + PostgreSQL Tutorial

How to Use n8n with PostgreSQL for Database Automation

Learn how to connect n8n to PostgreSQL, run queries, insert and update rows, and automate database workflows with triggers and notifications.

If you want to automate database tasks, combining n8n with PostgreSQL is a strong setup. PostgreSQL stores your structured data, while n8n handles the workflow logic around it.

💡 Example: when a form is submitted, n8n can save the lead to PostgreSQL, notify your team on Telegram, and send an email automatically.

What You’ll Learn

  • How to connect PostgreSQL to n8n
  • How to run SELECT queries
  • How to INSERT new rows
  • How to UPDATE existing records
  • How to DELETE rows safely
  • How to use PostgreSQL Trigger in n8n

Why Use n8n with PostgreSQL?

PostgreSQL is a powerful relational database used for apps, dashboards, internal systems, and business workflows. n8n makes it easier to automate what happens before and after your database actions.

  • Save leads or orders automatically
  • Read customer or system data on demand
  • Update statuses after payments or approvals
  • Trigger automations when rows change
  • Connect database events to email, Telegram, APIs, and CRMs

Step 1: Prepare Your PostgreSQL Database

Before connecting n8n, make sure your PostgreSQL server is ready and you have these connection details:

  • Host
  • Port
  • Database name
  • Username
  • Password

It is best to create a dedicated database user for n8n instead of using your main admin account.

⚠️ Security tip: only give the n8n database user the permissions it needs.

Step 2: Add Postgres Credentials in n8n

n8n has official Postgres credentials support. Create a new Postgres credential and enter your database connection settings.

  1. Open Credentials in n8n
  2. Create a new Postgres credential
  3. Enter host, port, database, username, and password
  4. Save and test the connection

After that, you can use the Postgres node inside your workflows.

Step 3: Read Data with SELECT

To read data from PostgreSQL, use SELECT.

SELECT id, full_name, email
FROM customers
ORDER BY id DESC;

This is useful for reading customers, orders, attendance logs, payments, and other records.

Step 4: Insert New Rows

To save new data, use INSERT.

INSERT INTO customers (full_name, email, phone)
VALUES ('John Doe', 'john@example.com', '09171234567');

This works well for form entries, lead capture, registrations, chatbot logs, and order records.

Step 5: Update Existing Records

To change existing records, use UPDATE.

UPDATE customers
SET phone = '09998887777'
WHERE id = 1;

This is useful for updating payment status, approval state, timestamps, or workflow progress.

Step 6: Delete Rows Carefully

To remove data, use DELETE. Always include a clear WHERE condition.

DELETE FROM customers
WHERE id = 1;
Warning: if you run DELETE without a WHERE clause, you can remove all rows from the table.

Step 7: Use Dynamic Data from Previous Nodes

One of the best parts of n8n is using data from earlier nodes inside your Postgres workflow.

Example expression:

{{ $json.email }}

This lets you insert, search, or update rows using form values, webhook data, chatbot output, or API responses.

Step 8: Use Postgres Trigger for Event-Based Automation

n8n also has a Postgres Trigger node that can respond to database events. According to n8n’s docs, it supports reacting to insert, update, and delete events.

Postgres Trigger
   ↓
IF
   ↓
Telegram / Gmail / HTTP Request / Google Sheets

This is useful when you want instant automation whenever a row changes in your database.

Example n8n + PostgreSQL Workflow

Webhook
   ↓
Set
   ↓
Postgres (INSERT lead)
   ↓
Postgres (SELECT saved record)
   ↓
Telegram
   ↓
Gmail

In this workflow:

  • A webhook receives incoming data
  • A Set node formats the fields
  • The Postgres node inserts the record
  • Another Postgres step reads the row
  • Telegram and Gmail notify your team

Real Use Cases

Lead capture systems
Order and invoice tracking
Attendance and RFID systems
Internal dashboards and CRMs

Best Practices

  • Use a separate PostgreSQL user for n8n
  • Test SELECT first before running UPDATE or DELETE
  • Log important outputs during development
  • Keep your SQL simple and readable
  • Use UTC and ISO 8601 dates when possible

Common Errors and Fixes

1. Connection failed
Check host, port, username, password, and whether your PostgreSQL server accepts external connections.

2. Access denied
Your database user may not have the needed privileges.

3. Query returned nothing
Review your table name, filters, and incoming data.

4. Wrong data inserted
Check your n8n expressions and field mapping.

5. Array or date issues
n8n’s Postgres common issues page recommends careful parameter handling, UTC for dates, and ISO 8601 formatting to avoid timezone confusion.

Watch My Automation Videos on YouTube

I share n8n workflows, automation tutorials, and AI system ideas on my YouTube channel.

▶ Visit My YouTube Channel

FAQ

Can I use n8n to insert data into PostgreSQL automatically?
Yes. n8n’s Postgres node supports inserting and updating rows, and it can also execute queries.

Can n8n react when PostgreSQL data changes?
Yes. n8n has a Postgres Trigger node for insert, update, and delete events.

Can I use PostgreSQL with Telegram, Gmail, or Google Sheets in the same workflow?
Yes. That is one of the main strengths of n8n.


SEO Title

n8n PostgreSQL Tutorial: How to Automate Database Workflows

Meta Description

Learn how to use n8n with PostgreSQL to automate queries, inserts, updates, deletes, and trigger-based workflows.

Friday, 17 April 2026

n8n and Apify Tutorial: How to Automate Web Scraping Workflows

n8n + Apify Tutorial

How to Use n8n with Apify for Web Scraping and Automation

Learn how to connect n8n and Apify to run Actors, scrape websites, collect structured data, and send results to apps like Google Sheets, Telegram, and CRMs.

If you want to automate web scraping and data extraction, n8n + Apify is a powerful combination. Apify handles the scraping using Actors, while n8n lets you route the output into your own workflow.

What you can build: website scrapers, lead collectors, competitor monitoring, Google Maps data extraction, content pipelines, and alert systems.

What You’ll Learn

  • What Apify does
  • How to connect Apify to n8n
  • How to run an Actor from n8n
  • How to fetch scraped results
  • How to build a simple real workflow
  • How to use HTTP Request instead of a dedicated node

What Is Apify?

Apify is a platform for running automation and web scraping tools called Actors. These Actors can extract website data, browse pages, collect structured results, and save outputs into datasets or key-value stores.

In simple terms, Apify does the scraping work, and n8n handles the automation around it.

💡 Simple explanation: Apify gets the data. n8n moves the data where you need it.

Why Use n8n with Apify?

This combo is useful because you can let Apify scrape websites and let n8n handle the business logic afterward.

  • Run scrapers on demand
  • Store results in Google Sheets or databases
  • Send Telegram or email alerts
  • Trigger AI analysis of scraped content
  • Build no-code or low-code data pipelines

How n8n Connects to Apify

There are two main ways to connect n8n and Apify:

  1. Use the Apify integration/node
  2. Use the n8n HTTP Request node with the Apify API

Apify’s official n8n integration supports actions and triggers, including running Actors and reacting to Actor or task events. If you prefer raw API control, you can also use n8n’s HTTP Request node.

Step 1: Create Your Apify Account

First, create an Apify account and choose an Actor you want to run. You can use Actors from the Apify Store or your own custom Actor.

For authentication, Apify documentation says you can connect using OAuth or an Apify API token.

Step 2: Connect Apify to n8n

In n8n, add the Apify node if available in your environment, then create the credential using your Apify login or token.

Basic flow:

Trigger → Apify → Google Sheets / Telegram / Database

If you are not using the Apify node, you can connect through HTTP Request instead.

Step 3: Run an Apify Actor from n8n

The standard Apify API pattern is:

  1. Send a POST request to run the Actor
  2. Get the run response
  3. Read the defaultDatasetId
  4. Fetch the dataset items

Example Actor run endpoint:

POST https://api.apify.com/v2/acts/YOUR-ACTOR-ID/runs?token=YOUR_API_TOKEN

Sample JSON input:

{
  "startUrls": [
    { "url": "https://example.com" }
  ],
  "maxRequestsPerCrawl": 20
}
Tip: The POST payload becomes the Actor input, usually as application/json.

Step 4: Get the Scraped Results

After the Actor starts, the response includes information about the run. Apify’s API documentation explains that you typically monitor the run and then fetch results from the dataset using the defaultDatasetId.

Dataset items example:

GET https://api.apify.com/v2/datasets/YOUR_DATASET_ID/items?token=YOUR_API_TOKEN

These items can then be sent to Google Sheets, Airtable, Telegram, Supabase, or any app connected to n8n.

n8n Workflow Example

Here is a simple workflow idea:

Manual Trigger
   ↓
HTTP Request (Run Apify Actor)
   ↓
Wait
   ↓
HTTP Request (Get Dataset Items)
   ↓
Google Sheets
   ↓
Telegram

This workflow runs an Apify scraper, waits for it to finish, fetches the scraped items, stores them in Google Sheets, and sends a Telegram notification.

Example Use Cases

Google Maps lead scraping
E-commerce product monitoring
News and article collection
AI content research pipelines

Using HTTP Request Instead of a Dedicated Apify Node

n8n’s HTTP Request node can call any REST API, so it works well with Apify if you want more direct control.

Typical HTTP Request setup:

  • Method: POST
  • URL: Apify Actor run endpoint
  • Headers: Content-Type: application/json
  • Body: Your Actor input JSON

This is a good option if you want a custom workflow or if your installed n8n environment does not include the Apify node.

Common Problems and Fixes

1. Invalid API token
Double-check your Apify API token or credential setup.

2. Actor runs but no data appears
Make sure the Actor actually writes output into the dataset.

3. Dataset fetch returns empty
The run may not be finished yet. Add a Wait node or poll the run status.

4. HTTP Request errors
Verify method, URL, headers, and JSON body.

5. Wrong Actor input
Every Actor has its own input schema, so follow the specific Actor’s documentation.

Best Practices

  • Start with one Actor and one destination app
  • Test the Actor in Apify first before wiring it into n8n
  • Log raw results before transforming them
  • Use Wait or polling when the scraper takes time
  • Store API tokens securely in credentials

Watch My n8n tuts on YouTube

I also share videos about automation, n8n workflows, and AI systems on my YouTube channel.

▶ Visit My YouTube

FAQ

Can n8n connect to Apify directly?
Yes. Apify provides an n8n integration for actions and triggers, and you can also use HTTP Request for raw API calls.

Do I need coding to use Apify with n8n?
Not much. You mainly need to understand Actor inputs, API tokens, and JSON bodies.

What is the easiest starter workflow?
Run an Actor, wait for completion, fetch dataset items, and send them to Google Sheets.

n8n + Microsoft Outlook Tutorial

n8n + Microsoft Outlook Tutorial How to Use n8n with Microsoft Outlook for Email Automation ...