Intelligenza Artificiale LLM e NLP Office

Automate Your Work with Power Automate and GPT AI | Practical Business Tutorials

Automate emails, quotes and documents with Power Automate and GPT. 7 practical business tutorials, no coding required.

Course description

Power Automate + AI: Intelligent Automation for Work

If you already use Microsoft 365 at work, Power Automate combined with GPT is probably the most powerful tool you can add to your arsenal. In this course we build seven real automations — from scratch — that read emails, analyze content with AI, generate quotes and reply automatically. All without writing a single line of traditional code.

The 7 Automations We Build Together

  • Email to Excel: an automatic flow that extracts text from incoming emails and saves it to an Excel spreadsheet (Email Trigger V3)
  • Text cleanup and IF logic: removing HTML tags from emails and using subject-based conditions to filter them
  • Classification with GPT: sending email content to GPT to automatically extract the category, with a human approval step
  • Sentiment Analysis: using GPT to determine whether an email is urgent, normal or positive — and routing the flow accordingly
  • Optimizing GPT calls: centralizing AI calls with Split and Replace for cleaner and more efficient flows
  • Quotes from Excel (part 1): retrieving prices from a price list and preparing the quote automatically
  • Automatic reply with quote: closing the loop — generating the document with GPT and sending it via email

Who This Course Is For

For those who work with Microsoft 365 and want to stop doing the same manual tasks every day. No programming knowledge required: Power Automate is visual and this course guides you step by step through every flow. The level is beginner — all you need is access to Power Automate and a Microsoft account.

Lessons list
1/7 Extract Text from Emails and Save to Excel with Power Automate

I'll show you how to build a Power Automate flow that triggers on incoming emails (Email Trigger V3) and automatically saves the extracted text to an Excel sheet — no coding required.

Contenuto riservato Accedi
2/7 Strip HTML Tags from Emails and Use IF Conditions on the Subject

Let's improve our Power Automate flow by removing HTML tags from email bodies and using an IF condition to filter messages based on the subject line.

Contenuto riservato Accedi
3/7 Extract Email Category with GPT and an Approval Step

I'll show you how to integrate GPT into a Power Automate flow to automatically classify emails by content, with a human approval step before any action is taken.

Contenuto riservato Accedi
4/7 Analyze Email Sentiment with GPT to Detect Urgency

Let's use GPT inside Power Automate to perform sentiment analysis on incoming emails — detecting whether a message is urgent, neutral, or positive — and route the flow accordingly.

Contenuto riservato Accedi
5/7 Consolidate GPT Calls with Split and Replace in a Single Flow

I'll show you how to optimize GPT API calls in Power Automate by centralizing them into one reusable flow using Split and Replace, making your automations cleaner and easier to maintain.

Contenuto riservato Accedi
6/7 Automatically Generate Quotes from an Excel Price List (Part 1)

Let's build the first part of an automated quoting system in Power Automate: I'll retrieve product prices from an Excel price list and prepare the data for document generation.

Contenuto riservato Accedi
7/7 Auto-Reply with GPT and Send the Quote from Excel (Part 2)

We'll close the full automation loop: GPT generates the quote text from the Excel data, and Power Automate automatically sends it as an email reply to the customer.

Contenuto riservato Accedi
Giovanni Pace

Giovanni Pace

Ingegnere Informatico · Pratola Peligna

  • 107 Courses
About the teacher

Sono un ingegnere informatico con oltre 15 anni di esperienza nel settore ICT. Mi occupo di sviluppo software, cybersecurity, data science e intelligenza artificiale, con particolare attenzione all’innovazione e all’automazione dei processi aziendali. Da anni svolgo anche attività di docenza e formazione, creando percorsi pratici e coinvolgenti su programmazione, DevOps, AI e sicurezza informatica.

Accedi per acquistare il corso

Questo corso richiede un accesso dedicato. Accedi o crea un account studente per completare l'acquisto.

This course includes

  • Lessons 7
  • Duration 2h 20m
  • Difficulty base
  • Language it
  • Certificate No

Recently viewed