Smarter Week

AI and automation by role

How Consultants can use AI and automation

Below are 14 common tasks for Consultants, most common first. For each one you get the best fix (AI, automation, a feature in software you already have, or a simpler process), the steps to set it up and, for AI fixes, a prompt to copy.

Also called: Consultant, Management Consultant, Senior Consultant, Business Analyst, Associate, Advisor, Strategy Consultant

Find your own hour leaks, free See the fixes

Task 1 · typically 180 min, once a week

Build analysis and slides for client deliverables

Software featureBest fix

Use AI in your slide tool to build the first version of the deck

Copilot in PowerPoint, Gemini in Slides, Gamma and Beautiful.ai turn an outline or document into draft slides in your template; think-cell and similar tools speed up charts.

Typically saves about 30% of the time15 min to set up
  1. 1Write the storyline as headline sentences, one per slide.
  2. 2Use Copilot in PowerPoint or Gemini in Slides with your firm template to build the draft.
  3. 3Use think-cell or your chart tool for data slides.
  4. 4Spend your time on the analysis and the key message.

Tools: Copilot in PowerPoint · Gemini in Google Slides · Gamma · Beautiful.ai · think-cell

One more way to fix it
Process fix

Keep a library of your best slides to reuse

Teams rebuild the same method, team and case study slides for every client. A shared library cuts that to copy and adjust.

Typically saves about 25% of the time2 h to set up
  1. 1Collect the slides you rebuild most (methodology, team, case studies, standard charts).
  2. 2Put them in one shared library file or tool (SharePoint, Google Drive, or a tool like Templafy or UpSlide).
  3. 3Name them clearly and keep one owner.
  4. 4Start each deck by pulling from the library.

Tools: SharePoint or Google Drive · Templafy · UpSlide

How to automate this task

Task 2 · typically 120 min, once a week

Turn interview and workshop notes into findings

AIBest fix

Have AI pull themes and quotes across all your interview notes

Upload transcripts or notes from all interviews; AI groups them into themes with supporting quotes, which you check and sharpen into findings.

Typically saves about 50% of the time10 min to set up
  1. 1Record and transcribe interviews with consent (Teams, Zoom, Otter or Granola).
  2. 2Remove names if your client agreement requires it.
  3. 3Upload all transcripts to an approved AI with the prompt below.
  4. 4Check quotes against transcripts and write the "so what" yourself.
Prompt to copy
Here are transcripts of [NUMBER] interviews with [WHO] about [TOPIC]. Identify the main themes. For each theme: a one-line finding, how many interviews mentioned it, two or three direct quotes with the interview ID, and any disagreement between interviewees. Then list surprises and open questions. Do not invent quotes; use exact wording only.

[ATTACH OR PASTE TRANSCRIPTS]

Tools: ChatGPT, Claude, Gemini or Microsoft Copilot · Dovetail · NotebookLM

One more way to fix it
AI

Let an AI notetaker write the notes and the recap

A notetaker records the meeting, writes the summary and action items, and you send the recap in one click.

Typically saves about 75% of the time15 min to set up
  1. 1Check which notetaker your company allows: Copilot in Teams, Zoom AI Companion, Google Meet "Take notes for me", Otter, Fireflies or Granola.
  2. 2Turn it on for your recurring meetings and tell attendees it is on.
  3. 3After the meeting, review the action items and fix names or owners.
  4. 4Send the recap straight from the tool, or paste it into email or chat.

Tools: Copilot in Microsoft Teams · Zoom AI Companion · Google Meet "Take notes for me" · Otter, Fireflies or Granola

How to automate this task

Task 3 · typically 60 min, a few times a week

Run client calls and status meetings

Process fixBest fix

Replace some status calls with a written update and keep calls for decisions

Many weekly client calls repeat what a short written update could say. Sending the update first lets you shorten or skip the call.

Typically saves about 30% of the time20 min to set up
  1. 1Send a short written update before each regular call: done, next, needs from client.
  2. 2Offer to make the call 25 minutes or every other week.
  3. 3Use the call only for decisions and open questions.
  4. 4Let an AI notetaker send the recap.

Tools: Email, Slack Connect or Teams · AI notetaker

One more way to fix it
AI

Let an AI notetaker write the notes and the recap

A notetaker records the meeting, writes the summary and action items, and you send the recap in one click.

Typically saves about 75% of the time15 min to set up
  1. 1Check which notetaker your company allows: Copilot in Teams, Zoom AI Companion, Google Meet "Take notes for me", Otter, Fireflies or Granola.
  2. 2Turn it on for your recurring meetings and tell attendees it is on.
  3. 3After the meeting, review the action items and fix names or owners.
  4. 4Send the recap straight from the tool, or paste it into email or chat.

Tools: Copilot in Microsoft Teams · Zoom AI Companion · Google Meet "Take notes for me" · Otter, Fireflies or Granola

How to automate this task

Task 4 · typically 30 min, a few times a week

Research a topic, company or question online

AIBest fix

Use AI research mode and check the sources

Deep Research modes in ChatGPT, Claude, Gemini and Perplexity read dozens of pages and give you a cited summary.

Typically saves about 55% of the time5 min to set up
  1. 1Write the exact question and what you will use the answer for.
  2. 2Run it in a research mode (ChatGPT Deep Research, Claude Research, Gemini Deep Research or Perplexity).
  3. 3Open the two or three key sources it cites and confirm them.
  4. 4Save the summary where your team can find it.
Prompt to copy
Research [QUESTION]. I need this to [DECISION OR USE]. Give me a one-paragraph answer first, then the key facts as bullets with a source link for each, then what is uncertain or disputed.

Tools: ChatGPT Deep Research · Claude Research · Gemini Deep Research · Perplexity

How to automate this task

Task 5 · typically 20 min, a few times a week

Take notes and send recaps after meetings

AIBest fix

Let an AI notetaker write the notes and the recap

A notetaker records the meeting, writes the summary and action items, and you send the recap in one click.

Typically saves about 75% of the time15 min to set up
  1. 1Check which notetaker your company allows: Copilot in Teams, Zoom AI Companion, Google Meet "Take notes for me", Otter, Fireflies or Granola.
  2. 2Turn it on for your recurring meetings and tell attendees it is on.
  3. 3After the meeting, review the action items and fix names or owners.
  4. 4Send the recap straight from the tool, or paste it into email or chat.

Tools: Copilot in Microsoft Teams · Zoom AI Companion · Google Meet "Take notes for me" · Otter, Fireflies or Granola

How to automate this task

Task 6 · typically 120 min, once a week

Write proposals and statements of work

AIBest fix

Have AI draft the proposal from past proposals and discovery notes

Load your best past proposals and standard text into a Claude Project, ChatGPT Project or Copilot agent; it drafts the new one from your discovery notes.

Typically saves about 45% of the time30 min to set up
  1. 1Collect three strong past proposals, your rate card and standard terms.
  2. 2Add them to a Claude Project, ChatGPT Project, Gemini Gem or Copilot agent.
  3. 3Paste discovery notes or the call transcript with the prompt below.
  4. 4Check scope, price and timeline yourself; never let AI set the price.
Prompt to copy
Using our past proposals and standard text as a guide, draft a proposal for [CLIENT]. Discovery notes or call transcript: [PASTE]. Include: their situation in their words, objectives, our approach in phases, deliverables, timeline, team, what is not included, and assumptions. Leave pricing as [PRICE] for me to fill in. Flag anything unclear with [CHECK].

Tools: Claude Projects · ChatGPT Projects · Gemini Gems · Copilot agents

One more way to fix it
Software feature

Build proposals from templates with e-signature built in

PandaDoc, Proposify, Qwilr, Better Proposals and Ignition keep your standard sections, pricing tables and terms, and collect the signature, so you only write the custom parts.

Typically saves about 40% of the time2 h to set up
  1. 1Turn your best proposal into a template with reusable sections.
  2. 2Set up pricing tables and standard terms.
  3. 3Create each new proposal from the template and edit only the client-specific parts.
  4. 4Send for e-signature and get notified when it is viewed and signed.

Tools: PandaDoc · Proposify · Qwilr · Better Proposals · Ignition

How to automate this task

Task 7 · typically 60 min, once a week

Build or update spreadsheet reports by hand

AIBest fix

Let AI build the formulas, pivots and summary

Copilot in Excel, Gemini in Sheets, or uploading the file to ChatGPT or Claude can build the pivot, the chart and the commentary in minutes.

Typically saves about 50% of the time10 min to set up
  1. 1Export or open the data.
  2. 2Ask Copilot in Excel or Gemini in Sheets, or upload the file to an approved AI assistant.
  3. 3Describe the report you want, including the breakdowns.
  4. 4Check the totals against the source before you share.
Prompt to copy
Here is [DESCRIBE THE DATA]. Build a summary that shows [THE NUMBERS YOUR MANAGER WANTS] by [BREAKDOWN], compared with [LAST PERIOD]. Give me the Excel formulas or pivot setup to reproduce it, and three sentences on what changed and why it matters.

Tools: Copilot in Excel · Gemini in Google Sheets · ChatGPT or Claude with file upload

One more way to fix it
Automation

Build the report once so it refreshes itself

Connect the spreadsheet or dashboard straight to the source so next week's report is already done.

Typically saves about 80% of the time4 h to set up
  1. 1List where each number comes from.
  2. 2Use Power Query (Excel), a connected sheet, or a Google Data Studio or Power BI dashboard pulling from the source.
  3. 3Schedule the refresh and send the link instead of an attachment.

Tools: Excel Power Query · Power BI · Google Data Studio (formerly Looker Studio) · Google Sheets connectors

How to automate this task

Task 8 · typically 15 min, every day

Fill in timesheets and log billable hours

Software featureBest fix

Let a time tracker build your timesheet from your activity

Timely, Laurel, Clio's time capture, Harvest with calendar sync and Toggl record what you worked on, and AI suggests entries you approve instead of reconstructing your day.

Typically saves about 50% of the time30 min to set up
  1. 1Check what your firm already uses (Clio, Harvest, Productive, Karbon, Toggl) and whether it has automatic capture or calendar sync.
  2. 2Turn on capture for your calendar, email and documents.
  3. 3At the end of each day, review the suggested entries and approve them.
  4. 4Fix the client or matter code on anything it guessed wrong.

Tools: Timely · Laurel · Clio time capture · Harvest calendar integration · Toggl Track

One more way to fix it
Process fix

Log time at the end of each task, not at the end of the week

Reconstructing a week of time from memory is slow and loses billable hours. A timer or a two-minute end-of-day habit is faster and more accurate.

Typically saves about 35% of the time10 min to set up
  1. 1Start a timer in your time tool when you switch clients, or add a note after each task.
  2. 2Block five minutes at the end of each day to tidy entries.
  3. 3Keep a short list of standard descriptions for common work.
  4. 4Submit daily; managers stop chasing timesheets on Friday.

Tools: Harvest, Toggl, Clio or your time system

How to automate this task

Task 9 · typically 60 min, once a week

Write documents, proposals or long emails from scratch

AIBest fix

Start from an AI first draft, never a blank page

Give the AI your notes, the audience and an example you liked; you spend your time editing, which is faster and better.

Typically saves about 45% of the time5 min to set up
  1. 1Gather your notes, bullet points and a past document you liked.
  2. 2Tell the AI who it is for and what it must achieve.
  3. 3Ask for an outline first, adjust it, then ask for the full draft.
  4. 4Edit for facts and your voice.
Prompt to copy
You are helping me write a [TYPE OF DOCUMENT] for [AUDIENCE]. The goal is [WHAT IT MUST ACHIEVE]. Here are my notes: [PASTE]. Here is an example I like the style of: [PASTE]. First give me an outline. After I approve it, write the full draft. Don't invent facts; mark anything you are unsure of with [CHECK].

Tools: ChatGPT, Claude, Gemini or Microsoft Copilot

How to automate this task

Task 10 · typically 45 min, every day

Sort through and reply to email

AIBest fix

Have AI draft replies to routine email

Paste the thread and a one-line instruction; edit the draft instead of writing from a blank page. Most routine replies take a minute instead of five.

Typically saves about 35% of the time5 min to set up
  1. 1Open the AI assistant your company allows (or the one built into Outlook or Gmail).
  2. 2Paste the email thread, or use the built-in "draft reply" button.
  3. 3Tell it the point you want to make in one line.
  4. 4Read the draft, fix anything wrong, and send.
Prompt to copy
Draft a reply to the email below. My point: [WHAT YOU WANT TO SAY IN ONE LINE]. Keep it under 120 words, friendly and direct, and match the tone of the sender. Do not invent facts or commitments.

Email:
[PASTE THE EMAIL]

Tools: ChatGPT, Claude, Gemini or Microsoft Copilot · Gmail "Help me write" or Outlook Copilot

One more way to fix it
Process fix

Batch email twice a day and let rules file the noise

Rules move newsletters, notifications and CCs out of your inbox, and checking at set times stops email from cutting your day into pieces.

Typically saves about 25% of the time20 min to set up
  1. 1Create rules that move notifications, newsletters and emails where you are only CC'd into folders.
  2. 2Turn off desktop and phone notifications for email.
  3. 3Pick two or three set times a day to process the inbox to zero.
  4. 4Tell your team that anything urgent should come by phone or chat.

Tools: Outlook or Gmail rules

How to automate this task

Task 11 · typically 45 min, once a week

Sit in status or update meetings

Process fixBest fix

Replace the status meeting with a written update

Everyone posts three lines in a shared thread before a set time; you only meet when something is blocked.

Typically saves about 60% of the time15 min to set up
  1. 1Agree a format: done, next, blocked.
  2. 2Create a channel or a thread that repeats every week.
  3. 3Ask everyone to post by a set time; the lead reads them and replies to the blockers.
  4. 4Keep a shorter meeting only for the blockers, or cancel it outright.

Tools: Slack, Teams or email

How to automate this task

Task 12 · typically 90 min, once a week

Build the weekly or monthly client report

Software featureBest fix

Use a client reporting tool that pulls the data and refreshes itself

AgencyAnalytics, DashThis, Whatagraph, Swydo and Google Data Studio connect to ad, SEO, social and analytics accounts and build a branded report for each client automatically.

Typically saves about 60% of the time3 h to set up
  1. 1Pick one tool and connect each client's data sources once.
  2. 2Build one report template and copy it for every client.
  3. 3Schedule the report to send monthly with a live link.
  4. 4Spend your time on the three-line commentary at the top (AI can draft it).

Tools: AgencyAnalytics · DashThis · Whatagraph · Swydo · Google Data Studio (formerly Looker Studio)

One more way to fix it
AI

Turn your rough notes into the weekly update with AI

Jot bullet points through the week; AI turns them into a clean update in the format your manager expects.

Typically saves about 60% of the time5 min to set up
  1. 1Keep a running note of what you did and what is blocked.
  2. 2Paste the note and last week's update (for format) into the AI assistant.
  3. 3Use the prompt below and check every fact.
  4. 4Send it or post it.
Prompt to copy
Turn my rough notes into this week's status update. Match the format and length of last week's update. Group by project, lead with results, flag anything blocked and what I need. Do not add anything that is not in my notes.

Last week's update:
[PASTE]

My notes this week:
[PASTE]

Tools: ChatGPT, Claude, Gemini or Microsoft Copilot

How to automate this task

Task 13 · typically 20 min, every day

Hunt for files, numbers or answers someone already has

Software featureBest fix

Ask your workspace AI instead of searching folders

Microsoft Copilot (formerly Microsoft Copilot), Gemini in Google Workspace, Glean, Notion AI and Slack AI can answer questions from your company's own files, chats and email.

Typically saves about 50% of the time10 min to set up
  1. 1Check whether your company already pays for Copilot, Gemini in Google Workspace, Glean, Notion AI or Slack AI.
  2. 2Ask it the question in plain words, e.g. "What did we quote Acme for the Q3 renewal?"
  3. 3Open the source it cites to confirm.
  4. 4If you have none of these, ask IT. It is often cheaper than the hours lost.

Tools: Microsoft Copilot · Gemini in Google Workspace · Glean · Notion AI · Slack AI

One more way to fix it
Process fix

Agree one home for each kind of file

Most searching comes from the same thing living in three places. Pick one place per type and link to it.

Typically saves about 35% of the time1 h to set up
  1. 1List the five things people search for most.
  2. 2Pick one home for each (one folder, one wiki page, one system).
  3. 3Pin the links in your team channel.
  4. 4Move or delete the copies.

Tools: SharePoint, Google Drive, Notion or Confluence

How to automate this task

Task 14 · typically 30 min, once a month

Do expense reports and receipts

Software featureBest fix

Snap receipts into an expense app as you go

Expensify, Ramp, Brex, Navan, SAP Concur and most corporate cards read the receipt photo and fill in the report for you.

Typically saves about 70% of the time15 min to set up
  1. 1Ask finance which expense app or card app the company uses.
  2. 2Install it and turn on receipt capture.
  3. 3Photograph each receipt when you get it, or forward email receipts to the app's address.
  4. 4Submit the auto-built report at month end.

Tools: Expensify · Ramp · Brex · Navan · SAP Concur

How to automate this task

Quick wins

Have you tried…

Have you let an AI notetaker write your meeting notes and action items?
Tools like Copilot in Teams, Zoom AI Companion or Otter join the call, write the summary and list who owes what. You just check it and send.
Have you had AI draft a reply to a tricky or routine email?
You paste the email and say the point you want to make; the AI writes a draft you edit. Outlook and Gmail now have this built in.
Have you asked AI to build a spreadsheet formula, pivot or chart for you?
You describe the result you want in plain words, and Copilot in Excel or Gemini in Sheets builds it. ChatGPT or Claude can also analyze an uploaded file.
Have you used an AI "deep research" mode that reads dozens of sources for you?
Research modes in ChatGPT, Claude, Gemini and Perplexity spend a few minutes reading the web and return a summary with links to every source.
Have you asked an AI that can see your company files a question, instead of digging through folders?
Microsoft Copilot (formerly Microsoft Copilot), Gemini in Google Workspace, Glean and similar tools search your email, chats and files and answer with links to the source.
Do you start long documents from an AI first draft built on your own notes?
Give the AI your notes, the audience and an example you like. Editing a draft is much faster than writing from a blank page.
Have you tried running your standup as a written check-in in chat instead of a call?
Bots like Geekbot or a Slack or Teams workflow ask everyone the same three questions each morning and post the answers. You only meet when someone is blocked.
Have you used a time tracker that suggests your timesheet from your calendar and files?
Tools like Timely, Laurel or Clio's time capture record what you worked on in the background. At the end of the day you approve the suggested entries instead of reconstructing them.

HourLeak · the 8-minute work audit

Find out which of these cost your team the most

Each person picks their role, taps the tasks they really do and says how long each takes. The free check gives you your own top fixes; the team scan adds up the hours across everyone and turns them into a 30-day plan.

Take the free check Scan my team, $49

Answers are anonymous. Leaders only see team totals.

More roles in Agency & Professional Services

Agency Account / Client ManagerAgency Project ManagerAccountant / Bookkeeper (firm)Paralegal / Legal AssistantAttorney / Lawyer (firm)Insurance Agent / BrokerAgency / Staffing RecruiterAll roles