DEV Community: AutomateHQ

The IT Project Handover Checklist That Prevents Disasters (Free Template Inside)

AutomateHQ — Thu, 21 May 2026 20:42:55 +0000

Every IT professional has inherited a system with no documentation. No runbooks, no architecture diagrams, no list of dependencies, no contact for the vendor. Just a server running something critical that nobody understands.

This happens because project handovers are treated as an afterthought. The project team is already moving on to the next thing. The person handing over is leaving the organisation. The deadline is tomorrow.

A proper IT project handover takes 4 to 8 hours to do well. The cost of a bad handover is measured in days of downtime, failed audits, and frustrated support engineers.

Here is the framework I use for every IT project handover.

The Five Components of a Complete IT Handover

1. System Overview Document

This is the one-page summary that anyone picking up the system needs to understand it in 10 minutes.

It should cover:

What the system does — In plain English, not technical jargon
Who uses it — Business owner, end users, number of users
Why it exists — The business problem it solves
Critical dependencies — What breaks if this system goes down
Business impact of downtime — Low/Medium/High, and why

This document should be written for someone who has never seen the system before. If your team's most junior member cannot understand it, rewrite it.

2. Technical Architecture

This covers the "how" — how the system is built and how it connects to other systems.

Required elements:

Architecture diagram — Even a simple Visio or draw.io diagram is better than nothing
Infrastructure inventory — All servers, VMs, databases, storage accounts, and their specs
Network configuration — IP addresses, firewall rules, DNS entries, load balancers
Integration points — Every external system this connects to, with API endpoints and authentication method
Data flows — Where data comes from, where it goes, how often it moves

3. Access and Credentials

This is the section that causes the most pain when it is missing.

Document every account and credential the support team will need:

Service accounts — Username, purpose, password location (password manager, not plaintext)
Admin accounts — Local admin, domain admin, application admin
API keys and certificates — What they are for, when they expire, how to renew
Vendor portals — URLs, account names, support contract numbers
MFA devices — Which accounts have MFA, what device/app is used

Critical: Never store passwords in the handover document itself. Use a password manager (Bitwarden, 1Password, CyberArk) and reference the vault entry in the document.

4. Operational Runbooks

Runbooks are step-by-step instructions for the most common operational tasks. They are what the on-call engineer reads at 2am when something breaks.

Every system needs runbooks for:

Starting and stopping the system — In the correct order
Common errors and how to fix them — With exact error messages and resolution steps
Backup and restore procedure — How backups are taken, where they are stored, how to restore
Scaling procedure — How to add capacity if load increases
Disaster recovery — What to do if the primary system fails completely

Runbooks do not need to be long. A good runbook is a numbered list of steps with screenshots where needed. If it takes more than 30 minutes to follow, it is too complex.

5. Support and Escalation

When something goes wrong, who do you call?

Document:

Internal support contacts — Primary and secondary contacts with phone numbers and email
Vendor support — Support portal URL, contract number, SLA, escalation path
Third-party integrations — Support contacts for every external system
On-call schedule — Who is responsible for out-of-hours incidents
Escalation matrix — At what point does a P2 become a P1, who gets called at each level

The Handover Meeting

A document alone is not enough. Schedule a 2-hour handover meeting with:

The outgoing team or developer
The incoming support team
The business owner

Walk through the system live. Ask questions. Test the runbooks. Identify gaps.

After the meeting, the incoming team should be able to answer these questions without referring to the outgoing team:

How do I restart the system if it crashes?
Where are the backups and how do I restore one?
Who do I call if the vendor's API goes down?
What is the business impact if this system is down for 4 hours?

The Handover Sign-Off

Before the outgoing team is released, get a formal sign-off from the incoming team confirming they have received and understood all documentation.

This protects both parties. The outgoing team cannot be blamed for gaps they disclosed. The incoming team has confirmed they are ready to support the system.

Ready-Made Template

I have turned this framework into a complete IT Project Handover Document Template:

IT Project Handover Document Template — $29

It includes all five sections pre-formatted, with guidance notes for each field, a sign-off page, and a checklist to verify the handover is complete. It is in Word format so you can customise it for your organisation.

If you want to start with a free resource, the 10-Minute Business Automation Audit covers the operational readiness questions you should be asking before any system goes live:

Free: 10-Minute Business Automation Audit

AutomateHQ publishes practical IT operations and Microsoft 365 guides for IT professionals.

Microsoft Power Platform for Beginners: What It Is and How to Start in 2026

AutomateHQ — Thu, 21 May 2026 20:42:17 +0000

Microsoft Power Platform is one of the most underused tools in the Microsoft 365 ecosystem. Most organisations pay for it as part of their M365 licence and never touch it.

This guide explains what Power Platform actually is, what each tool does, and how to start using it to save time and money — even if you have never written a line of code.

What Is Microsoft Power Platform?

Power Platform is a suite of four tools that let you build business applications, automate workflows, analyse data, and create chatbots — all without traditional software development.

Tool	What It Does	Best For
Power Apps	Build custom business apps	Forms, data entry, mobile tools
Power Automate	Automate repetitive tasks	Approvals, notifications, data sync
Power BI	Visualise and analyse data	Dashboards, reports, KPI tracking
Power Virtual Agents	Build chatbots	IT helpdesk, HR FAQs, customer support

All four tools connect to Microsoft 365 data (SharePoint, Teams, Excel, Outlook) and hundreds of external services (Salesforce, ServiceNow, SAP, Google Sheets).

Who Is Power Platform For?

Power Platform is designed for business users — people who understand a business problem but are not professional developers. Microsoft calls these users "citizen developers."

You do not need to know how to code. You need to know:

What problem you are trying to solve
Where the data lives (SharePoint list, Excel file, SQL database)
What the output should look like (email, Teams message, updated record, PDF)

Power Apps: Build Apps Without Code

Power Apps lets you build mobile and web applications using a drag-and-drop interface. You connect it to a data source (SharePoint, Excel, Dataverse) and it generates a working app.

Common Power Apps use cases:

IT request forms — Replace email-based IT requests with a structured app that captures all required information and routes to the right team
Inspection checklists — Field workers complete inspections on their phone, data goes straight to SharePoint
Leave request apps — Employees submit leave requests, managers approve in the app, HR sees a live dashboard
Asset tracking — Scan a barcode, update an asset record, view asset history

Getting started:

Go to make.powerapps.com
Click "Create" → "Start with data"
Connect to a SharePoint list or Excel file
Power Apps generates a basic app automatically
Customise the layout and add any additional logic

A basic functional app takes 30 to 60 minutes to build for a beginner.

Power Automate: Automate Repetitive Tasks

Power Automate (formerly Microsoft Flow) lets you build automated workflows triggered by events. When something happens in one system, Power Automate does something in another system.

The most useful Power Automate flows for beginners:

1. Email to SharePoint
When an email arrives in a specific folder → Extract attachments → Save to SharePoint → Create a record in a SharePoint list

2. Form to Approval
When a Microsoft Form is submitted → Send an approval email to the manager → If approved, add to SharePoint list and notify submitter → If rejected, notify submitter with reason

3. Scheduled Report
Every Monday at 8am → Get items from SharePoint list where Status = "Overdue" → Send a summary email to the team

4. Teams Notification
When a SharePoint item is modified → Post a message to a Teams channel with the details of what changed

Getting started:

Go to make.powerautomate.com
Click "Create" → "Automated cloud flow"
Choose a trigger (e.g., "When a new email arrives")
Add actions (e.g., "Create item in SharePoint")
Test and save

Power BI: Turn Data Into Dashboards

Power BI connects to your data sources and creates interactive visual dashboards. Instead of sending Excel spreadsheets by email, you publish a live dashboard that updates automatically.

Common Power BI use cases:

Sales performance dashboards
IT ticket volume and resolution time tracking
Finance dashboards (budget vs. actual)
HR headcount and turnover reports

Getting started:

Download Power BI Desktop (free) from microsoft.com
Click "Get Data" → Connect to your data source (Excel, SharePoint, SQL)
Drag fields onto the canvas to create charts
Publish to Power BI Service to share with your team

Where to Start

If you are new to Power Platform, start with Power Automate. It has the fastest time-to-value — you can build a useful flow in under an hour and immediately see the time it saves.

Recommended first flow:
Build an approval workflow for a process that currently happens by email. Leave requests, purchase approvals, and document sign-off are all good candidates.

Ready-Made Templates

If you want to skip the learning curve and start with working templates, I have put together a complete Power Platform Starter Kit:

Microsoft Power Platform Starter Kit — $29

It includes 5 ready-to-use Power Automate flows, 2 Power Apps templates, and a setup guide for each. Everything is documented with step-by-step instructions.

There is also a free automation audit to help you identify which processes in your organisation are best suited for automation:

Free: 10-Minute Business Automation Audit

AutomateHQ publishes practical Microsoft Power Platform guides for business users and IT professionals.

How to Build a SharePoint Intranet That People Actually Use (2026 Guide)

AutomateHQ — Thu, 21 May 2026 19:21:58 +0000

Most SharePoint intranets fail. Not because SharePoint is bad, but because they are built by IT teams for IT teams, filled with compliance documents nobody reads, and abandoned within six months.

I have built and rebuilt SharePoint intranets for organisations ranging from 50 to 5,000 employees. The ones that succeed share five characteristics. The ones that fail share the same three mistakes.

This guide covers both.

Why Most SharePoint Intranets Fail

Mistake 1: Starting with structure instead of use cases

The first question most IT teams ask is "How should we organise the navigation?" The right first question is "What do employees need to do every day, and how can the intranet make that easier?"

A SharePoint intranet should solve real problems: finding HR policies, submitting IT requests, accessing project documents, onboarding new starters. If it does not solve a real problem, nobody will use it.

Mistake 2: Treating it as a document dump

SharePoint is not a file server. An intranet that is just a collection of folders with PDFs is not an intranet — it is a slightly better shared drive. Nobody bookmarks a document dump.

Mistake 3: No ownership after launch

An intranet needs a content owner. Not IT. A communications or HR person who is responsible for keeping it current. Without this, the intranet becomes outdated within 90 days and people stop trusting it.

The Five Characteristics of a Successful SharePoint Intranet

1. A compelling home page

The home page is the first thing employees see. It should show:

Company news and announcements (updated at least weekly)
Quick links to the 5-10 most-used tools and resources
A search bar that actually works
A "What's new" section

Use SharePoint's News web part for announcements and the Quick Links web part for the top navigation shortcuts. Keep the design clean — no more than 3 columns.

2. Department hubs, not a flat structure

Organise content by department (HR, Finance, IT, Operations) using Hub Sites. Each department owns their section and is responsible for keeping it updated.

The IT team should own the overall governance and template, but content ownership must be distributed. This is the single biggest factor in long-term intranet success.

3. A working search experience

SharePoint search is powerful but requires configuration. Out of the box, it searches everything — including old files, draft documents, and content nobody should see.

Configure search to:

Prioritise intranet pages over document libraries
Exclude archived content from results
Surface people profiles in search results (employees searching for colleagues)

4. Mobile-first design

In 2026, a significant percentage of employees access the intranet from their phone. SharePoint's modern pages are responsive by default, but you need to test every page on mobile and ensure navigation works on small screens.

Use the SharePoint mobile app to preview your intranet during design. If it is hard to navigate on a phone, fix it before launch.

5. Integration with Microsoft 365 tools

The best SharePoint intranets are not standalone — they are connected to the rest of Microsoft 365:

Teams: Embed Teams channels in SharePoint pages for department discussions
Power Apps: Embed apps for IT requests, expense submissions, or leave requests directly in the intranet
Viva Connections: Surface the intranet in Teams so employees do not need to navigate to a separate URL

A Practical Build Plan

Here is a realistic timeline for building a SharePoint intranet from scratch:

Week	Activity
Week 1	Stakeholder interviews — identify top 10 use cases
Week 2	Information architecture design — navigation, hub structure
Week 3	Home page build and department hub templates
Week 4	Content migration from old systems
Week 5	User testing with 10-15 employees
Week 6	Refinements based on feedback
Week 7	Launch communications and training
Week 8	Post-launch review and governance setup

Governance: The Part Everyone Skips

The intranet will decay without governance. Before launch, define:

Who can create new pages? (Recommended: only department content owners)
Who approves news articles? (Recommended: communications team)
How often is content reviewed? (Recommended: quarterly review of all pages)
What happens to outdated content? (Recommended: archive, not delete)

Document this in a one-page governance policy and get sign-off from department heads before launch.

Ready-Made Templates

Building a SharePoint intranet from scratch takes weeks. I have put together a complete setup guide with templates, governance documents, and step-by-step configuration instructions:

SharePoint Intranet Setup Guide — $39

It includes the home page template, department hub structure, governance policy template, and a launch communications plan. Everything you need to go from blank SharePoint to a working intranet in a week.

AutomateHQ publishes practical Microsoft 365 and SharePoint guides for IT professionals and business owners.

Azure is Draining Your Budget: 8 Cost Cuts You Can Make This Week

AutomateHQ — Thu, 21 May 2026 19:19:07 +0000

Azure bills are notoriously hard to predict. You spin up a VM for a test, forget about it, and three months later you are paying $300/month for a server nobody is using.

I have helped organisations cut their Azure spend by 30 to 60 percent without decommissioning anything critical. Here are the eight changes that deliver the fastest results.

1. Delete Orphaned Resources Immediately

The fastest win in any Azure cost audit is finding and deleting resources that are no longer attached to anything.

In the Azure Portal, navigate to Cost Management + Billing → Cost Analysis. Filter by resource type and sort by cost descending. Look for:

Unattached managed disks — Disks that were created with a VM but the VM was deleted. The disk keeps billing even with no VM attached. Typical cost: $10 to $80/month per disk.
Unused public IP addresses — Static IPs that are reserved but not assigned to any resource. Cost: $3.65/month each. Sounds small, but organisations often have dozens.
Empty resource groups — Not a direct cost, but a signal that cleanup is needed.
Stopped (deallocated) VMs — The compute is free when stopped, but the managed disk, public IP, and NIC still bill.

Action: Run this query in Azure Resource Graph Explorer to find all unattached disks:

Resources
| where type == "microsoft.compute/disks"
| where properties.diskState == "Unattached"
| project name, resourceGroup, properties.diskSizeGB, location
| order by properties.diskSizeGB desc

2. Right-Size Your Virtual Machines

Most VMs in Azure are over-provisioned. An organisation buys a D4s_v3 (4 vCPUs, 16GB RAM) because it sounds safe, but the actual CPU utilisation averages 8 percent.

In Azure Monitor, check the CPU percentage and Available Memory Bytes metrics for all your VMs over the last 30 days. If average CPU is below 20 percent and memory utilisation is below 50 percent, the VM is a candidate for downsizing.

Downsizing a D4s_v3 ($140/month) to a D2s_v3 ($70/month) saves $70/month per VM. In a 20-VM environment, this single change can save $1,400/month.

Tool: Azure Advisor automatically identifies right-sizing opportunities. Check it at Advisor → Cost in the Azure Portal.

3. Switch Dev/Test VMs to B-Series

Development and test environments do not need consistent high CPU performance. They need occasional bursts.

The B-series (burstable) VMs are 40 to 60 percent cheaper than equivalent D-series VMs because they use CPU credits rather than dedicated compute. A B2s (2 vCPU, 4GB RAM) costs $34/month versus $70/month for a D2s_v3.

For any VM that is used for development, testing, staging, or non-production workloads, switch to B-series. The performance is identical for most workloads.

4. Use Azure Hybrid Benefit

If your organisation has existing Windows Server or SQL Server licences with Software Assurance, you can apply them to Azure VMs through Azure Hybrid Benefit — saving up to 40 percent on Windows VMs and up to 55 percent on SQL Server VMs.

This is one of the most commonly missed savings in enterprise Azure environments. Check your licence entitlements and apply Hybrid Benefit in the VM settings.

5. Reserve Instances for Stable Workloads

For any VM or SQL Database that runs 24/7 and will continue to do so for at least a year, Reserved Instances offer 30 to 60 percent savings versus pay-as-you-go pricing.

A 1-year reservation for a D4s_v3 VM saves approximately $840/year. A 3-year reservation saves approximately $1,680/year.

Rule of thumb: If a resource has been running for 3+ months with no plans to decommission it, buy a reservation.

6. Enable Auto-Shutdown for Dev/Test VMs

Development VMs that run overnight and on weekends are pure waste. A VM running 730 hours/month costs 3x more than one running 250 hours/month (business hours only).

Enable Auto-shutdown on all dev/test VMs (VM settings → Auto-shutdown). Set shutdown for 7pm and require manual restart each morning. This alone typically cuts dev/test compute costs by 60 percent.

7. Move Cold Data to Cool or Archive Storage

Azure Blob Storage has three tiers:

Hot: $0.018/GB/month — for frequently accessed data
Cool: $0.01/GB/month — for data accessed less than once per month
Archive: $0.00099/GB/month — for data accessed less than once per year

Most organisations store everything in Hot tier by default. Audit your storage accounts and move backups, logs, and old data to Cool or Archive. For 10TB of cold data, moving from Hot to Archive saves $170/month.

8. Set Budget Alerts

None of the above matters if costs creep back up over time. Set budget alerts in Azure Cost Management to notify you when spending exceeds thresholds.

Create alerts at 80 percent and 100 percent of your monthly budget. Add a forecast alert at 100 percent of budget to catch runaway costs before the month ends.

The Audit Checklist

If you want a structured approach to finding all of these savings (and more) in your Microsoft 365 and Azure environment, I have put together a comprehensive audit checklist:

Microsoft 365 Tenant Audit Checklist — $12

It covers Azure cost optimisation, M365 licence management, security settings, and compliance — 47 checkpoints that most IT admins complete in under two hours.

AutomateHQ publishes practical Azure and Microsoft 365 cost guides for IT professionals and finance teams.

How to Cut Your Microsoft 365 Bill by 40% Without Losing Any Features

AutomateHQ — Thu, 21 May 2026 19:16:46 +0000

Most organisations are overpaying for Microsoft 365 by 20 to 40 percent. Not because they are being charged incorrectly, but because they are paying for licences and features they are not using.

I have audited Microsoft 365 environments for dozens of organisations over the past three years. The same patterns appear every time. This article covers the exact steps I follow to find and eliminate waste — and how you can do the same.

The Four Sources of M365 Overspend

Before diving into the fixes, it helps to understand where the money is going:

1. Orphaned licences — Licences assigned to former employees, shared mailboxes, or service accounts that no longer need a full licence. In a 200-person organisation, this typically accounts for 8 to 15 percent of the total licence bill.

2. Licence over-provisioning — Assigning E3 or E5 licences to users who only need Frontline Worker (F1/F3) licences. A receptionist or warehouse worker rarely needs full Teams, SharePoint, and Power BI capabilities.

3. Duplicate tool spend — Paying for third-party tools that replicate features already included in your Microsoft 365 subscription. The most common examples are Zoom (Teams does the same job), Dropbox (OneDrive is included), and Docusign (Adobe Sign is included in E3+).

4. Unused add-ons — Audio conferencing, Phone System, and Microsoft Defender add-ons that were enabled during a project and never turned off.

Step 1 — Run a Licence Audit

The first step is to get a clear picture of what you are paying for versus what is being used.

In the Microsoft 365 Admin Centre, navigate to Billing → Licences. Export the full licence report to Excel.

For each licence type, check:

How many licences are purchased
How many are assigned
When each assigned user last signed in

Any user who has not signed in within 90 days is a candidate for licence removal or downgrade.

Quick win: Run this report right now. In most organisations, 5 to 10 percent of licences are assigned to accounts that have never been used or have not been used in over six months.

Step 2 — Identify Licence Downgrade Opportunities

Not everyone in your organisation needs the same licence tier. Use the Microsoft 365 Usage Reports (Admin Centre → Reports → Usage) to see which features each user is actually using.

A user who only uses Outlook and Teams for chat does not need an E3 licence at $36/user/month. They can be moved to an F3 licence at $8/user/month — a saving of $28/user/month.

For a 50-person team where 20 users are Frontline Workers, this single change saves:
20 users × $28/month = $560/month or $6,720/year

Step 3 — Audit Third-Party Tool Overlap

Pull your last three months of software invoices and map each tool against Microsoft 365 features:

Third-Party Tool	M365 Equivalent	Included In
Zoom	Microsoft Teams	E1, E3, E5
Dropbox / Box	OneDrive for Business	E1, E3, E5
Docusign / HelloSign	Microsoft Syntex eSignature	E3+
Slack	Microsoft Teams	E1, E3, E5
Trello / Asana	Microsoft Planner / To Do	E1, E3, E5
Miro	Microsoft Whiteboard	E1, E3, E5
LastPass / 1Password	Microsoft Entra ID (basic SSO)	E3, E5
Webex	Microsoft Teams	E1, E3, E5

In most organisations, eliminating duplicate tools saves $15 to $40 per user per month on top of the licence savings.

Step 4 — Review and Remove Unused Add-Ons

In the Microsoft 365 Admin Centre, go to Billing → Your products and review every add-on subscription.

Common add-ons that accumulate and are forgotten:

Microsoft 365 Audio Conferencing ($4/user/month) — Was this enabled for a specific event or project? Is it still needed?
Microsoft Teams Phone ($8/user/month) — Are all assigned users actually making calls?
Microsoft Defender for Business — Is this overlapping with an existing endpoint security solution?

Remove any add-on that cannot be justified with active usage data.

Step 5 — Negotiate Your Renewal

If you are on a Microsoft 365 Enterprise Agreement or CSP agreement, your renewal is negotiable. Microsoft's list prices are rarely what organisations actually pay.

Key negotiation points:

True-up timing: If you are growing, negotiate a flat rate for the year rather than paying for growth mid-year
Multi-year commitment: A 3-year commitment typically gets you 10 to 20 percent off list price
Bundle discounts: If you are adding Azure spend, negotiate a combined discount across both

The Numbers

Here is a realistic example for a 100-person organisation:

Saving Category	Monthly Saving
10 orphaned licences removed (E3 at $36)	$360
20 users downgraded from E3 to F3	$560
Zoom cancelled (replaced by Teams)	$200
Dropbox cancelled (replaced by OneDrive)	$150
5 unused Audio Conferencing add-ons removed	$20
Total monthly saving	$1,290
Annual saving	$15,480

Start With a Proper Audit

The fastest way to find your savings is to run a structured audit of your M365 environment. I have put together a comprehensive checklist that covers licences, security settings, compliance, and cost optimisation:

Microsoft 365 Tenant Audit Checklist — $12

It is a 47-point checklist that walks you through every area of your M365 environment, identifies waste, and flags security gaps. Most IT admins complete it in under two hours and find savings that pay for it thousands of times over.

AutomateHQ publishes practical Microsoft 365 and cloud cost guides for IT professionals and finance teams.

The 10 Best AI Tools for Small Business in 2026 (That Actually Save Money)

AutomateHQ — Thu, 21 May 2026 19:10:29 +0000

The AI tools landscape has exploded. There are now over 10,000 AI products on the market, and most of them are either overpriced, overhyped, or both.

I have spent the last 18 months testing AI tools for small business use cases. This is my honest, no-affiliate list of the tools that actually deliver ROI — ranked by the time and money they save per week.

The Criteria

Before I list anything, here is how I evaluated each tool:

Time saved per week (minimum 2 hours to make the list)
Cost vs. value (must pay for itself within 30 days)
Learning curve (must be usable by a non-technical person)
Reliability (must work consistently, not just in demos)

1. Claude (Anthropic) — Best for Writing and Analysis

Cost: $20/month | Time saved: 8-12 hours/week

Claude is the best AI writing assistant available in 2026. It outperforms ChatGPT for long-form content, contract review, email drafting, and data analysis. The key advantage is its 200,000-token context window — you can paste an entire contract, report, or dataset and ask questions about it.

Best use cases for small business:

Drafting client proposals and SOWs
Reviewing contracts for risky clauses
Summarising long email threads
Writing job descriptions and performance reviews

2. Notion AI — Best for Knowledge Management

Cost: $10/month add-on | Time saved: 4-6 hours/week

If your business runs on documents, Notion AI is a game-changer. It can summarise meeting notes, generate action items, draft SOPs from bullet points, and answer questions about your internal knowledge base.

The killer feature is Ask AI — you can ask questions like "What did we decide about the pricing strategy in Q1?" and it will search your entire Notion workspace and give you an answer.

3. Make.com (formerly Integromat) — Best for Automation

Cost: $9-$29/month | Time saved: 10-20 hours/week

Make.com is the automation platform that Power Automate users switch to when they need more flexibility. It connects 1,500+ apps and can automate almost any repetitive business process.

High-ROI automations for small business:

Auto-create invoices from form submissions
Sync CRM data between HubSpot and your accounting software
Auto-post social media content from a Google Sheet schedule
Send Slack alerts when a new lead fills out your website form

4. Otter.ai — Best for Meetings

Cost: $10/month | Time saved: 3-5 hours/week

Otter.ai transcribes your meetings in real time, identifies speakers, and generates a summary with action items automatically. The integration with Zoom, Teams, and Google Meet means it joins your calls automatically.

The ROI calculation is simple: if you spend 5 hours per week in meetings and currently spend 30 minutes writing up notes after each one, Otter saves you 2.5 hours per week at $10/month.

5. Jasper — Best for Marketing Copy

Cost: $39/month | Time saved: 5-8 hours/week

Jasper is purpose-built for marketing content. It has templates for ads, landing pages, email sequences, social posts, and product descriptions. The brand voice feature means it learns your tone and writes consistently.

For small businesses spending $500+/month on copywriting, Jasper pays for itself in the first week.

6. Fireflies.ai — Best for Sales Teams

Cost: $10/month | Time saved: 3-4 hours/week

Fireflies records and transcribes sales calls, then uses AI to identify objections, next steps, and competitor mentions. The CRM integration automatically logs call summaries to Salesforce or HubSpot.

7. Midjourney — Best for Visual Content

Cost: $10-$30/month | Time saved: 4-6 hours/week

If your business needs regular visual content — social media images, presentation graphics, product mockups, or website illustrations — Midjourney produces professional-quality images in seconds.

The learning curve is steeper than other tools on this list, but the output quality is unmatched.

8. Reclaim.ai — Best for Scheduling

Cost: $8/month | Time saved: 2-3 hours/week

Reclaim automatically schedules your tasks, habits, and meetings around your priorities. It blocks focus time, reschedules meetings intelligently, and ensures you always have time for deep work.

For founders and managers who spend half their day in reactive mode, Reclaim is transformative.

9. Gamma — Best for Presentations

Cost: $10/month | Time saved: 3-5 hours/week

Gamma creates professional presentations from a text prompt in under 2 minutes. The output is genuinely good — not the generic AI presentation look. It handles the design, layout, and content structure automatically.

For client pitches, board decks, and team presentations, Gamma eliminates the hours spent on PowerPoint formatting.

10. Zapier AI — Best for No-Code Automation

Cost: $19.99/month | Time saved: 5-10 hours/week

Zapier's AI features allow you to describe an automation in plain English and it builds the workflow for you. Combined with Zapier's 6,000+ app integrations, this makes automation accessible to anyone in your business.

The Total Picture

If you implement all 10 tools, you are looking at:

Tool	Monthly Cost	Hours Saved/Week
Claude	$20	10
Notion AI	$10	5
Make.com	$29	15
Otter.ai	$10	4
Jasper	$39	6
Fireflies	$10	3.5
Midjourney	$30	5
Reclaim	$8	2.5
Gamma	$10	4
Zapier AI	$20	7.5
Total	$186/month	62.5 hours/week

At a conservative $50/hour value of your time, 62.5 hours saved per week = $3,125/week in recovered productivity for $186/month in tools. That is a 16x return on investment.

Want to Automate Your Business Without the Learning Curve?

If you want to implement AI agents and automation in your business but do not know where to start, I have put together a complete step-by-step guide:

AI Agent Setup Guide — $97

It covers choosing the right tools, building your first AI agent, connecting it to your existing systems, and measuring ROI. Everything you need to go from zero to a working AI-powered business in a weekend.

AutomateHQ publishes practical AI and automation guides for small business owners and IT professionals.

How to Build a Power Automate Approval Workflow in 15 Minutes (Step-by-Step)

AutomateHQ — Thu, 21 May 2026 19:09:52 +0000

If you have ever spent hours chasing someone for a signature on a document, a purchase order, or a leave request — this article will change your life.

Power Automate's approval workflow is one of the most underused features in Microsoft 365. In this guide, I will walk you through building a complete, production-ready approval workflow from scratch in under 15 minutes.

What You Will Build

By the end of this tutorial, you will have a working approval workflow that:

Triggers automatically when a new item is added to a SharePoint list
Sends an approval request email to the designated approver
Notifies the requestor whether their request was approved or rejected
Logs the outcome back to SharePoint with a timestamp

Prerequisites

A Microsoft 365 account (any plan that includes Power Automate)
A SharePoint site with a list (we will create one in Step 1)
15 minutes of uninterrupted time

Step 1 — Create Your SharePoint List

Navigate to your SharePoint site and create a new list called Purchase Requests. Add the following columns:

Column Name	Type	Purpose
Title	Single line of text	Request name
Amount	Number	Purchase amount in USD
Requestor	Person	Who is making the request
Status	Choice	Pending / Approved / Rejected
Notes	Multiple lines	Approver notes

Set the default value of the Status column to Pending.

Step 2 — Open Power Automate

Go to make.powerautomate.com and click Create → Automated cloud flow.

Name your flow Purchase Request Approval and search for the trigger When an item is created (SharePoint). Select it and click Create.

Step 3 — Configure the SharePoint Trigger

In the trigger settings:

Site Address: Select your SharePoint site
List Name: Select Purchase Requests

Step 4 — Add the Approval Action

Click + New step and search for Start and wait for an approval. Select it.

Configure the approval:

Approval type: Approve/Reject — First to respond
Title: New Purchase Request: [Title] (use dynamic content for Title)
Assigned to: Enter the email of your approver (or use a dynamic field)
Details: Requestor: [Requestor Display Name] | Amount: $[Amount] | Please review and approve or reject.

Step 5 — Handle the Approval Outcome

Click + New step and add a Condition action.

Set the condition:

Value: Outcome (from the approval dynamic content)
Operator: is equal to
Value: Approve

In the YES branch, add Update item (SharePoint):

Set Status to Approved
Set Notes to the approver's response comments

Then add Send an email (V2):

To: The requestor's email
Subject: Your purchase request has been APPROVED ✓
Body: Great news! Your request for [Title] ($[Amount]) has been approved.

In the NO branch, add Update item (SharePoint):

Set Status to Rejected

Then add Send an email (V2):

To: The requestor's email
Subject: Your purchase request was not approved
Body: Your request for [Title] has been rejected. Reason: [Outcome]

Step 6 — Save and Test

Click Save and then Test → Manually → Run flow.

Go to your SharePoint list and add a new item. Within seconds, the approver will receive an email. Click Approve or Reject in the email, and watch the SharePoint item update automatically.

Common Errors and Fixes

Error: "The approval could not be sent"
This usually means the approver's email address is incorrect or they do not have a Microsoft 365 licence. Verify the email and try again.

Error: "Item not found"
This happens when the SharePoint list ID changes. Re-select the list in both the trigger and the update actions.

The flow runs but emails are not received
Check the approver's junk/spam folder. Microsoft approval emails sometimes get filtered. Add no-reply@microsoft.com to the safe senders list.

Taking It Further

Once your basic approval workflow is running, here are three upgrades worth adding:

Escalation: Add a parallel branch that sends a reminder if the approval is not actioned within 48 hours
Multi-level approval: Chain two approval actions for requests over a certain threshold (e.g., require a second approver for amounts over $5,000)
Teams notification: Replace the email notification with an Adaptive Card sent to a Teams channel for faster response times

Ready-Made Templates

If you want to skip the setup and get 20 pre-built Power Automate flows (including approval workflows, automated reports, and Teams notifications) that you can import directly into your environment, I have put together a complete pack:

Power Automate Flow Templates Pack — $49

It includes approval workflows, HR onboarding flows, invoice processing, and more — all documented and ready to deploy.

AutomateHQ publishes practical Microsoft 365 and automation guides for IT professionals and business owners. Follow for weekly tutorials.

5 ChatGPT Prompts That Will Save You 10 Hours a Week in 2026

AutomateHQ — Thu, 21 May 2026 18:31:09 +0000

Most professionals use ChatGPT like a highly advanced Google search. They ask simple questions and get generic, robotic-sounding answers.

The real power of AI unlocks when you stop treating it like a search engine and start treating it like a senior analyst or an executive assistant. To get high-quality output, you need high-quality inputs (prompts).

Here are 5 advanced prompt structures that will immediately save you hours of busywork this week.

1. The Meeting Summariser & Action Item Extractor

Stop reading through pages of messy meeting transcripts. Feed your transcript to ChatGPT with this prompt to instantly generate a professional follow-up email.

The Prompt:

"Act as an executive assistant. Review the following meeting transcript. Provide: 1) A 3-bullet executive summary of the main decisions made. 2) A clearly formatted table of action items, including the assignee and the deadline. 3) A professional follow-up email drafted to all attendees summarising this information. Tone: Professional but warm."

2. The Aggressive Proofreader

Grammarly is great for catching typos, but it won't fix a weak argument or a confusing structure. Use this prompt for important proposals or client emails.

The Prompt:

"Act as a ruthless but constructive senior editor. Review the following text. Do not just fix grammar. Identify any logical gaps, weak arguments, or repetitive phrasing. Rewrite the text to be 20% shorter, punchier, and more persuasive. Provide the rewritten version, followed by bullet points explaining the major structural changes you made."

3. The Data Analyst

If you have a CSV file or a messy table of data, don't spend hours building pivot tables. Paste the raw data into ChatGPT and use this prompt.

The Prompt:

"Act as a senior data analyst. Review the provided raw sales data. 1) Identify the top 3 trends or anomalies in the data. 2) Calculate the month-over-month growth rate. 3) Write a short, executive-level paragraph explaining what this data means for the business and recommending two actionable next steps based on the findings."

4. The Difficult Email Responder

We all get emails that make us want to respond aggressively. Let AI draft a diplomatic, boundary-setting response that maintains professionalism.

The Prompt:

"I received an email from a client who is demanding work that is outside the scope of our contract. They are frustrated. Act as an experienced account manager. Draft a response that is empathetic and professional, but firmly enforces our boundaries and explains that this additional work will require a new change order. Keep it under 150 words."

5. The Project Scope Generator

Starting a new project is the hardest part. Use AI to build the initial framework so you aren't staring at a blank page.

The Prompt:

"Act as a senior project manager. I am starting a project to [insert project goal]. Generate a comprehensive project initiation document. Include: 1) 5 key deliverables. 2) A 4-phase timeline with estimated durations. 3) The top 3 risks associated with this type of project and mitigation strategies for each."

Stop Writing Prompts from Scratch

Writing good prompts takes time, and keeping track of them in a messy Notion doc or Word file is inefficient.

If you want a library of tested, production-ready prompts designed specifically for business professionals, you don't need to build it yourself.

Get the Ultimate Business Prompt Library
The AI Business Automation Prompt Pack contains 42 highly-engineered prompts specifically designed for Microsoft 365 users, managers, and consultants. It covers everything from advanced data analysis to automated reporting and email triage.

Stop treating AI like a toy and start using it as leverage. Try these prompts today and watch your productivity skyrocket.

How to Perform a Complete Microsoft 365 Security Audit in 2026

AutomateHQ — Thu, 21 May 2026 18:24:45 +0000

Microsoft 365 is the backbone of most modern enterprises, but out-of-the-box, it is not secure enough to protect against today's sophisticated phishing, ransomware, and data exfiltration attacks.

If you are an IT administrator or an MSP taking over a new tenant, your first priority must be a comprehensive security audit. A single misconfigured SharePoint sharing setting or legacy authentication protocol can lead to a catastrophic breach.

Here is the blueprint for auditing a Microsoft 365 tenant effectively.

1. Identity and Access Management (Azure AD)

Identity is the new perimeter. If an attacker compromises an account, they have the keys to the kingdom.

What to check:

MFA Status: Ensure Multi-Factor Authentication is enforced for all users, with zero exceptions for VIPs.
Conditional Access Policies: Verify that policies block logins from high-risk countries and require compliant devices for accessing sensitive data.
Legacy Authentication: Ensure legacy protocols (IMAP, POP3) are completely blocked across the tenant, as they bypass MFA.
Global Admins: Restrict Global Administrator roles to a maximum of 3-5 dedicated, cloud-only accounts that are not used for daily email.

2. Exchange Online Security

Email remains the number one attack vector for businesses.

What to check:

Email Authentication: Verify that SPF, DKIM, and DMARC are properly configured in DNS and enforced in Exchange to prevent domain spoofing.
Anti-Phishing & Anti-Spam: Review the default threat policies in Microsoft Defender for Office 365. The "Standard" preset is often too lenient for high-target industries.
Mail Forwarding Rules: Audit the tenant for any auto-forwarding rules sending company emails to external domains (a common sign of a compromised account).

3. SharePoint and OneDrive Governance

Data leakage often happens internally through poorly managed sharing settings.

What to check:

External Sharing: Ensure the default sharing link is set to "Specific people" rather than "Anyone with the link" (Anonymous).
Guest Access: Review which external domains are allowed to collaborate in your tenant. Consider implementing an allow-list for B2B collaboration.
Site Permissions: Audit high-value SharePoint sites (Finance, HR, Legal) to ensure permissions are granted via Groups, not individual user assignments.

4. Microsoft Teams Configuration

Teams sprawl can lead to uncontrolled data sprawl.

What to check:

External Communication: Verify if external federation is open to all domains or restricted.
Guest Access in Teams: Check if guests are allowed to share files, delete messages, or create channels.
App Permissions: Review the list of allowed third-party apps in Teams. Users should not be able to install unvetted applications that request access to company data.

The Fastest Way to Audit a Tenant

Performing this audit manually by clicking through the Microsoft 365 Admin Center, Azure AD, Exchange Admin Center, and Teams Admin Center takes days and it is incredibly easy to miss a critical setting.

If you want to ensure you don't miss a single vulnerability, you need a structured framework.

Get the Complete Audit Framework
Stop guessing what to check. Use the Microsoft 365 Tenant Audit Checklist — a comprehensive 150-point security and compliance checklist used by IT admins at global enterprises. It covers every critical setting across Azure AD, Exchange, SharePoint, Teams, and Intune.

Securing a tenant isn't a one-time event, but a thorough initial audit is the foundation of a secure environment. Don't leave your company's data to chance.

Make.com vs Power Automate: Which Automation Tool is Best for Your Business in 2026?

AutomateHQ — Thu, 21 May 2026 18:24:42 +0000

If you are looking to automate your business in 2026, you have likely narrowed your choices down to two heavyweights: Make.com and Microsoft Power Automate.

Both tools are incredibly powerful, but they serve completely different types of businesses and workflows. Choosing the wrong one will result in broken processes, security risks, or wasted subscription fees.

Here is the definitive breakdown of Make.com vs Power Automate, and exactly which one you should choose based on your tech stack.

The Short Answer

Choose Power Automate if your business runs on Microsoft 365 (Teams, SharePoint, Outlook, Excel) and you need enterprise-grade security and governance.
Choose Make.com if your business uses a fragmented tech stack (Slack, Google Workspace, Stripe, Shopify, custom APIs) and you need highly visual, complex branching logic.

Microsoft Power Automate: The Enterprise Standard

Power Automate is deeply integrated into the Microsoft ecosystem. If you are already paying for Microsoft 365 Business Premium or Enterprise licenses, you already have access to Power Automate.

Where Power Automate Excels:

Microsoft Ecosystem Integration: Nothing moves data between SharePoint, Teams, and Outlook faster or more securely than Power Automate.
Security and Governance: IT administrators can apply Data Loss Prevention (DLP) policies to ensure sensitive company data isn't accidentally tweeted or emailed outside the organisation.
Approval Workflows: The built-in approval engine makes it incredibly easy to route documents for manager sign-off.

The Downside:

The interface can feel clunky compared to modern no-code tools, and connecting to non-Microsoft services often requires expensive "Premium" connectors.

Want to get started with Power Automate today?
Instead of building from scratch, you can import production-ready flows directly into your tenant. Check out the Power Automate Flow Templates Pack which includes 5 ready-to-use flows for document approvals, email triage, and Teams notifications.

Make.com: The Visual Powerhouse

Make.com (formerly Integromat) is the Swiss Army knife of automation. It connects to almost everything and has the most intuitive visual builder on the market.

Where Make.com Excels:

Complex Branching Logic: Make's visual canvas allows you to build incredibly complex flows with multiple paths, error handlers, and iterators that are easy to understand at a glance.
Third-Party Integrations: It connects natively to thousands of modern SaaS apps, from Notion and Airtable to Stripe and Shopify.
AI Agent Integration: Make is currently the best platform for connecting OpenAI or Anthropic APIs to your business apps to build autonomous AI agents.

The Downside:

Make requires a separate subscription, and managing security and data governance across a large team is much harder than in the Microsoft ecosystem.

Want to build an AI Agent using Make.com?
If you want to automate customer support or lead qualification, Make.com + OpenAI is the best stack. Learn exactly how to build this in the AI Agent Setup Guide (Step-by-Step).

The Verdict

If you are a corporate IT team or a business heavily invested in Microsoft, stick with Power Automate. The security and native integrations are unbeatable.

If you are a startup, agency, or modern business using a mix of different SaaS tools and you want to leverage AI heavily, Make.com is the superior choice.

Not sure where to start with automation? Take the Free 10-Minute Business Automation Audit to find the hidden bottlenecks costing your business time and money.

Why Your Small Business Needs an AI Agent in 2026 (And How to Build One)

AutomateHQ — Thu, 21 May 2026 17:36:05 +0000

If you’re running a small business in 2026 and you don’t have an AI agent working for you, you’re essentially paying a human to do robot work.

I’m not talking about a basic chatbot that answers FAQs. I’m talking about a fully integrated, autonomous AI agent that can read your emails, update your CRM, draft proposals, and even chase down unpaid invoices while you sleep.

As an automation architect at AutomateHQ, I’ve spent the last few years building these systems for clients. The results are always the same: massive time savings and increased revenue.

Here is exactly why you need an AI agent and how you can get started today.

What Exactly is an "AI Agent"?

Unlike ChatGPT, which waits for you to ask it a question, an AI Agent is proactive. It connects to your existing tools (like Gmail, HubSpot, Shopify, or QuickBooks) and executes multi-step workflows based on triggers.

For example, a Lead Generation Agent can:

Detect a new form submission on your website.
Research the company online to find their industry and pain points.
Draft a highly personalized outreach email.
Send the email and log the interaction in your CRM.
Set a reminder to follow up in 3 days if there's no reply.

All of this happens without you lifting a finger.

3 AI Agents Every Business Should Have

If you're wondering where to start, here are the three highest-ROI agents you can build right now:

1. The Inbox Triage Agent

Stop drowning in emails. An Inbox Agent reads every incoming message, categorizes it (e.g., Support, Sales, Spam), drafts a context-aware reply based on your company knowledge base, and saves it as a draft for your review. It can also automatically extract invoices and send them to your accounting software.

2. The Customer Onboarding Agent

When a new client signs up, this agent automatically creates their project folder in Google Drive or SharePoint, sends them a welcome email with onboarding documents, and sets up a dedicated Slack/Teams channel for communication.

3. The Competitor Analysis Agent

This agent scrapes your competitors' websites and social media weekly, summarizing any new product launches, pricing changes, or marketing campaigns into a concise report delivered to your inbox every Monday morning.

How to Build Your First Agent

Building an AI agent used to require a team of developers. Today, you can build powerful agents using no-code platforms like Make.com, Zapier, or Microsoft Power Automate, combined with APIs from OpenAI or Anthropic.

Step 1: Map the Workflow
Don't touch any software until you've mapped out the exact steps of the process you want to automate on a whiteboard or piece of paper.

Step 2: Choose Your Stack
For Microsoft-heavy businesses, Power Automate is the way to go. If you use a mix of SaaS tools, Make.com offers incredible flexibility for AI integrations.

Step 3: Connect the Brain
Integrate the OpenAI or Anthropic API into your workflow. You'll need to write a strong "System Prompt" that tells the AI exactly what its role is, what tone of voice to use, and what rules it must follow.

Step 4: Test and Refine
AI can hallucinate. Always start by having the agent save its output as a draft or send it to a private Slack channel for human review before letting it send emails directly to clients.

Don't Want to Build It Yourself?

I get it. You're busy running your business, and learning API integrations isn't on your to-do list.

That's exactly what we do at AutomateHQ. We design, build, and deploy custom AI agents tailored to your specific business needs. Whether you need a simple inbox manager or a complex lead generation machine, we handle the technical heavy lifting so you can focus on growth.

👉 Check out our AI Business Automation Prompt Pack to get started

👉 Need a custom AI Agent built for your business? Explore our services and templates here

The businesses that adopt AI agents now will outpace their competitors by a mile. Don't get left behind.

How I Automated My Weekly Reports in Power BI Using Power Automate

AutomateHQ — Thu, 21 May 2026 17:29:26 +0000

Every Friday at 3:00 PM, thousands of professionals around the world do the exact same thing: they open an ERP system, export a CSV, paste it into an Excel template, refresh a pivot table, save it as a PDF, and email it to their boss.

It takes 45 minutes. It is mind-numbingly boring. And it is completely unnecessary.

If you are using Microsoft 365, you have all the tools required to make this happen automatically while you are drinking your Friday afternoon coffee. Here is exactly how I automated my weekly reporting using Power BI and Power Automate.

The Goal

We want to achieve a zero-touch reporting pipeline:

Data updates automatically.
A snapshot of the dashboard is captured.
The snapshot is emailed to stakeholders on a schedule.

Step 1: Automate the Data Refresh (Power BI)

The first step is getting your data into Power BI and ensuring it stays fresh.

If you are exporting CSVs manually, stop. Connect Power BI directly to your data source. Power BI has native connectors for Salesforce, Dynamics, SQL databases, SharePoint lists, and hundreds of other platforms.

Once connected:

Publish your report to the Power BI Service (online).
Go to the dataset settings.
Set up Scheduled Refresh.
Configure it to refresh every Friday at 2:00 PM (giving it time to complete before the 3:00 PM email).

Note: You will need a Power BI Pro license and potentially an On-Premises Data Gateway if your database is not in the cloud.

Step 2: Build the Power Automate Flow

Now that the data is refreshing automatically, we need to distribute it. We will use Power Automate to handle the delivery.

Open Power Automate and create a Scheduled cloud flow.
Set the schedule to run every Friday at 3:00 PM.
Add the action: Export To File for Power BI Reports.

Configuring the Export Action

Workspace: Select the workspace where your report lives.
Report: Select your report.
Export Format: Choose PDF (or PPTX if they prefer slides).
Pages: You can specify exactly which page of the dashboard to export if you don't want to send the whole thing.

Crucial Requirement: The "Export To File" action requires your Power BI workspace to be backed by a Premium capacity or Premium Per User (PPU). If you only have a standard Pro license, this specific action will fail.

Step 3: Deliver the Report

The final step is getting that PDF into the hands of your stakeholders.

Add a new action: Send an email (V2) (Office 365 Outlook).

To: Add your boss, the team, or a distribution list.
Subject: Weekly Performance Report - @{utcNow('yyyy-MM-dd')} (Using dynamic content to add today's date).
Body: Add a brief, professional message. "Hi team, please find attached the automated weekly performance report."
Attachments Name: WeeklyReport.pdf
Attachments Content: Select the File Content dynamic variable from the previous Power BI export action.

The "Poor Man's" Alternative (No Premium Required)

If you read Step 2 and realised you don't have Power BI Premium, don't panic. There is a built-in feature in Power BI Service that does something very similar without Power Automate.

It's called Email Subscriptions.

Open your report in the Power BI Service.
Click Subscribe to report in the top toolbar.
Click Add new subscription.
Enter the email addresses, set the schedule (Friday at 3:00 PM), and choose to include an image preview and a link to the report.
If you have a Pro license, you can also attach a full PDF.

It is less customisable than Power Automate, but it takes 60 seconds to set up and works brilliantly.

Take Your Automation Further

Automating reports is the gateway drug to business automation. Once you realise you don't have to do manual data entry, you start looking at every process in your business differently.

If you want to automate more than just your reports, I have packaged my best workflows, templates, and governance guides into one bundle.

Get the Complete Microsoft 365 Automation Bundle ($39)

It includes ready-to-use Power Automate flows that will save you hours every week.

What is the most tedious manual report you have to run right now? Let me know in the comments.