Decoding Pattern

Website

Decoding Pattern In this page we are going to learn everything about Microsoft Excel and Power BI for Business Intelligence. Stay tuned for the latest updates.

24/08/2026

How to Build an AI Email Classifier using n8n?

If you are a business owner, you may receive a lot of messages everyday. Some may be related to sales, some may be related to reviews, some may be related to complaint. There might be some other categories such as general and spam.

So you have to hire someone to find out the important messages or you have to invest some time by yourself.

But what if I tell you that everything can be done by AI Automation.

In this video, I will build an AI Automation using n8n will go to your inbox in gmail after every minute and find out new messages. And it will automatically classify into one of the 6 categories. And not only that, it will also give you the priority, summary of the messages and recommmended action and create a log in google sheets so that you can make decision by just simply looking at the google sheets.

In this step-by-step n8n tutorial, you'll learn how to:

Create a Gmail-triggered workflow
Receive incoming emails automatically
Pass email data to an AI model
Build an effective AI classification prompt
Use Structured Output Parser in n8n
Generate structured JSON from an LLM
Classify emails based on business intent
Determine email priority
Generate AI summaries and recommended actions
Connect n8n with Google Sheets
Map data between different n8n nodes
Store AI-generated results automatically
Test your AI workflow with different types of emails

If you're interested in n8n, AI automation, AI agents, and building solutions for real business problems, subscribe and follow the series.

16/08/2026

I Let AI Manage My Email Inbox and Here's What Happened | n8n + Gemini Automation

Gmail Integrations: https://docs.n8n.io/integrations/builtin/credentials/google/oauth-single-service?_gl=1*1428kjg*_gcl_au*NDAyNzYyODk5LjE3ODQxOTM0MzA.*_ga*MTU1Njk5OTYwLjE3ODQxOTM0MzI.*_ga_0SC4FF2FH9*czE3ODY4NDEwNjAkbzIkZzAkdDE3ODY4NDEwNjAkajYwJGwwJGgw

Gemini Integration: https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-langchain.googlegemini?_gl=1*bqjhea*_gcl_au*NDAyNzYyODk5LjE3ODQxOTM0MzA.*_ga*MTU1Njk5OTYwLjE3ODQxOTM0MzI.*_ga_0SC4FF2FH9*czE3ODY4NDEwNjAkbzIkZzEkdDE3ODY4NDExNDIkajM5JGwwJGgw

For Business Inquiry:
๐Ÿ“ง [email protected]

Connect with me:
https://www.linkedin.com/in/md-zakir-hussain-khan-easy-analysis/
https://www.facebook.com/rayaaal

What if your business could receive an email, understand the information inside it, process it with AI, organize the results, and automatically send back a professional response?

In this video, I build exactly that using n8n + Google Gemini + Gmail.

We will create an AI-powered workflow that:

๐Ÿ“ง Receives an email containing code
๐Ÿค– Uses Gemini AI to analyze the code line by line
๐Ÿง  Uses a second AI workflow to explain the code
๐Ÿ”€ Combines the outputs from multiple AI branches
๐Ÿ“ฆ Aggregates and organizes the information
โœจ Uses AI to generate a professional HTML-formatted response
๐Ÿ“จ Automatically sends the final result through Gmail

The important part isn't just explaining code.

This workflow demonstrates how businesses can use AI automation and workflow automation to eliminate repetitive manual work.

Imagine applying the same architecture to:

โ€ข Customer support automation
โ€ข Lead qualification and follow-up
โ€ข Automated business reports
โ€ข Document processing
โ€ข Email automation
โ€ข Data extraction and summarization
โ€ข Sales workflow automation
โ€ข Customer service workflows
โ€ข AI-powered internal operations
โ€ข Business process automation

The goal is to move beyond simply using AI as a chatbot and start using AI as part of an automated business process.

๐Ÿ› ๏ธ Tools Used

โ€ข n8n
โ€ข Google Gemini
โ€ข Gmail
โ€ข Basic LLM Chain
โ€ข Merge Node
โ€ข Aggregate Node
โ€ข Edit Fields
โ€ข HTML generation
โ€ข AI-powered workflow automation

๐Ÿš€ What You'll Learn

By the end of this video, you'll understand how to build a practical AI automation workflow in n8n, how to connect multiple AI tasks together, and how to turn raw input into a structured, ready-to-use business output.

If you're a business owner, ask yourself:

"What repetitive process is my team doing manually every day that AI could automate?"

That is where AI automation becomes really valuable.

If you have a repetitive business process you'd like to automate using n8n, AI agents, LLMs, or workflow automation, feel free to get in touch.

Subscribe for more practical videos about AI automation, n8n workflows, AI agents, and building AI-powered business solutions.

14/08/2026

See you on 16 August, 2026๐Ÿคฃ

09/07/2026

Secrets Behind Fast Excel Dashboard

Most small and medium businesses struggle with Data Strategy related issues. And the most common issue of them all is slow loading dashboard or non interactive dashboard.

Why this problem occurs?

Because the owner could not afford an experienced Business Intelligence Developer who can perform Data Strategy best practices. They build the whole solution on a single flat table and when the data gets bigger many issues arises. One of them is slow loading Dashboard.

In this video, I have shown what is the very first thing you need to do after importing data into Microsoft Excel.

Yes, I have used most underrated tool yet very much powerful to demonstrate one of the best data strtegies theory. By the end of the video, you will understand what is data normalization and star schema data model and with these understanding you can also easily optimize your Excel Dashboard.

But if you need any kind of help, please reach out to one of these links:

Email: [email protected]
LinkedIn: linkedin.com/in/md-zakir-hussain-khan-easy-analysis

02/05/2026

Everyone who works with Excel has faced this problem frequently.
And the problem is ๐ƒ๐€๐“๐„ related issue.

Let's say you have a date (06/03/2025) in Excel.

In your computer the date is ๐Ÿ”แต—สฐ ๐จ๐Ÿ ๐Œ๐š๐ซ๐œ๐ก, ๐Ÿ๐ŸŽ๐Ÿ๐Ÿ“

But sometimes when you send that Excel file to someone this date turns out to be ๐Ÿ‘สณแตˆ ๐จ๐Ÿ ๐‰๐ฎ๐ง๐ž, ๐Ÿ๐ŸŽ๐Ÿ๐Ÿ“

In that video, I have described --

1. Why that issue happens?
2. How you can address that issue?
3. ๐€๐ง๐ ๐š ๐จ๐ง๐ž ๐ฌ๐ญ๐จ๐ฉ ๐ฌ๐จ๐ฅ๐ฎ๐ญ๐ข๐จ๐ง ๐ญ๐จ ๐ฌ๐จ๐ฅ๐ฏ๐ž ๐ญ๐ก๐ข๐ฌ ๐ข๐ฌ๐ฌ๐ฎ๐ž ๐Ÿ๐จ๐ซ๐ž๐ฏ๐ž๐ซ.

01/04/2026

A common issue happens every time when someone opens an excel file in UK but the file is coming from the USA.

Use local option in Power Query to solve this issue.
Now it doesn't matter from where you are opening that power bi report or excel file.

It will work just fine even if you open it from the MOON..

In this short video, I have shown how you can solve this problem.

15/03/2026

Everyone who works with Excel has faced this problem frequently.
And the problem is ๐ƒ๐€๐“๐„ related issue.

Let's say you have a date (06/03/2025) in Excel.

In your computer the date is ๐Ÿ”แต—สฐ ๐จ๐Ÿ ๐Œ๐š๐ซ๐œ๐ก, ๐Ÿ๐ŸŽ๐Ÿ๐Ÿ“

But sometimes when you send that Excel file to someone this date turns out to be ๐Ÿ‘สณแตˆ ๐จ๐Ÿ ๐‰๐ฎ๐ง๐ž, ๐Ÿ๐ŸŽ๐Ÿ๐Ÿ“

I have created a video on this issue.

In that video, I have described --

1. Why that issue happens?
2. How you can address that issue?
3. ๐€๐ง๐ ๐š ๐จ๐ง๐ž ๐ฌ๐ญ๐จ๐ฉ ๐ฌ๐จ๐ฅ๐ฎ๐ญ๐ข๐จ๐ง ๐ญ๐จ ๐ฌ๐จ๐ฅ๐ฏ๐ž ๐ญ๐ก๐ข๐ฌ ๐ข๐ฌ๐ฌ๐ฎ๐ž ๐Ÿ๐จ๐ซ๐ž๐ฏ๐ž๐ซ.

This is just the Intro part of that video.

Video will come out tomorrow InsaAllah.

Subscribe and press the bell icon to get the notification when I will be uploading the video.

YT Channel Link: https://www.youtube.com/

04/03/2026

This is the intro footage from my recent video on YT.

Recently I closed a project with one of my clients. He is an ecommerce business owner. He asked me to predict the future sales so that he can compare the actual sales with the predicted year.

In this video, I am going to show how I have solved this problem using statistics and data visualization!

Color coding and icons are great way if you want to communicate your data properly.But using a lot of color and icons in...
02/03/2026

Color coding and icons are great way if you want to communicate your data properly.

But using a lot of color and icons increase clatter into the visualization.

If you look at the image attached you can immediately identify --

โ€ข Blue line is representing actual sales whereas orange line is representing forecasted sales

โ€ข The orange line is not a solid line as of the blue line, it is a dashed line

โ€ข And if you see the label at the top you can see whenever there is an increase in the actual sales compared to the forecasted sales, it is representing as โฌ† arrow and with green color.

โ€ข And if there ia a drop in the actual sales, it is representing as โฌ‡ arrow with red color.

โ€ข And a toggle button to select the year.

This image is taken from my recent YouTube video.
If you haven't watch that video,
Here's the link of that video: https://youtu.be/WcTiWndXyno

There is a new quote everywhere that -- DATA is the new OILIf you can analyze the data you have properly, you can unlock...
28/02/2026

There is a new quote everywhere that
-- DATA is the new OIL

If you can analyze the data you have properly, you can unlock a lot of new insights for your business.

Recently I closed a project with one of my clients. He is an ecommerce business owner. He asked me to predict the future sales so that he can compare the actual sales with the predicted year.

In this video, I am going to show how I have solved this problem using statistics and data visualization!

Video link in the first comment.

Address

House #133, Road #03, Alamnagar Rangpur
Rangpur
5402

Website

Alerts

Be the first to know and let us send you an email when Decoding Pattern posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share

Category