Smarter Week

AI and automation by role

How Procurement / purchasing specialists can use AI and automation

Below are 14 common tasks for Procurement / purchasing specialists, 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: Buyer, Purchasing Agent, Procurement Manager, Sourcing Specialist, Purchasing Coordinator, Category Manager

Task 1 · typically 30 min, every day

Turn purchase requests into purchase orders

Software featureBest fix

Run purchase requests through an intake-to-PO tool with approval rules

Coupa, Zip, Ramp Procurement, Procurify and Precoro turn a request form into an approved PO, routing approvals by amount and budget and reminding approvers.

Typically saves about 55% of the time8 h to set up
  1. 1Write approval rules by amount, department and category (e.g. IT and legal review for software).
  2. 2Set up a request form in your procurement tool or ERP.
  3. 3Turn on automatic reminders and mobile approvals.
  4. 4Let approved requests create the PO and send it to the supplier automatically.

Tools: Coupa · Zip · Ramp Procurement · Procurify · Precoro · SAP Ariba · NetSuite

One more way to fix it
Software feature

Let people buy routine items from approved catalogs without a PO

Punch-out catalogs and preferred supplier accounts with pre-set budgets let employees buy routine items directly, so purchasing only handles real sourcing.

Typically saves about 45% of the time4 h to set up
  1. 1Find the top 20 routine items and suppliers from last year's POs.
  2. 2Set up punch-out catalogs (Amazon Business, Staples, CDW, Grainger) in your procurement tool.
  3. 3Allow purchases under a threshold from catalogs without a separate PO.
  4. 4Review catalog spend monthly.

Tools: Amazon Business · Coupa or Ariba punch-out · CDW · Grainger · Staples Business Advantage

How to automate this task

Task 2 · typically 20 min, every day

Chase budget holders to approve purchase orders

Software featureBest fix

Run purchase requests through an intake-to-PO tool with approval rules

Coupa, Zip, Ramp Procurement, Procurify and Precoro turn a request form into an approved PO, routing approvals by amount and budget and reminding approvers.

Typically saves about 55% of the time8 h to set up
  1. 1Write approval rules by amount, department and category (e.g. IT and legal review for software).
  2. 2Set up a request form in your procurement tool or ERP.
  3. 3Turn on automatic reminders and mobile approvals.
  4. 4Let approved requests create the PO and send it to the supplier automatically.

Tools: Coupa · Zip · Ramp Procurement · Procurify · Precoro · SAP Ariba · NetSuite

One more way to fix it
Automation

Move approvals into a tracked workflow with reminders

Approvals in Teams/Power Automate, Slack Workflows, or your e-signature tool remind people for you and show what is stuck.

Typically saves about 60% of the time1 h to set up
  1. 1List the approvals you chase most.
  2. 2Set up an approval flow (Power Automate Approvals, Slack Workflow Builder, DocuSign or your HR/finance system).
  3. 3Add automatic reminders after 24 hours.
  4. 4Agree a default: no answer in 48 hours means it goes ahead (where safe).

Tools: Power Automate Approvals · Slack Workflow Builder · DocuSign or Adobe Acrobat Sign

How to automate this task

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

Get and compare quotes from suppliers

Process fixBest fix

Send every RFQ in the same template so quotes compare line by line

When suppliers quote in your format (same units, delivery terms, payment terms), comparing them takes minutes instead of an afternoon.

Typically saves about 35% of the time1 h to set up
  1. 1Build one RFQ template with a pricing table suppliers must fill in.
  2. 2Include specs, quantities, delivery, payment terms and a response deadline.
  3. 3Send through your sourcing tool or email with the template attached.
  4. 4Score responses against criteria agreed before quotes arrive.

Tools: Excel or Google Sheets · Coupa Sourcing or Zip

One more way to fix it
AI

Have AI put supplier quotes side by side

Upload the quotes; AI builds a comparison table on the same basis and lists differences in terms, exclusions and hidden costs.

Typically saves about 50% of the time5 min to set up
  1. 1Collect the quotes as PDFs or emails.
  2. 2Upload them to an approved AI tool with the prompt below.
  3. 3Check the totals and terms against each quote.
Prompt to copy
Compare the attached supplier quotes for [WHAT WE ARE BUYING]. Build a table with: supplier, unit price, quantity, total, delivery time, payment terms, warranty, validity date, and anything excluded. Convert to the same units and currency [CURRENCY]. Then list differences in terms that could add cost, and questions to ask each supplier. Do not recommend a winner.

Tools: ChatGPT, Claude, Gemini or Microsoft Copilot

How to automate this task

Task 4 · typically 30 min, every day

Chase suppliers for order confirmations and late deliveries

AutomationBest fix

Send automatic reminders for unconfirmed and late orders

Your ERP or a simple flow emails suppliers when a PO has not been confirmed or a delivery date is close, so you only chase the ones that stay silent.

Typically saves about 50% of the time2 h to set up
  1. 1Make sure every PO has a promised delivery date.
  2. 2Turn on PO acknowledgement and reminder features in NetSuite, Dynamics 365, SAP or your procurement tool.
  3. 3Or build a Power Automate, Zapier or Make flow: if no confirmation in 2 days, email the supplier; 3 days before due date, ask for status.
  4. 4Review an exception list daily.

Tools: NetSuite · Dynamics 365 · SAP · Power Automate, Zapier or Make

One more way to fix it
Software feature

Let suppliers update their own details and confirm orders in a portal

Supplier portals let suppliers confirm POs, update contacts and upload certificates and insurance themselves, with expiry reminders.

Typically saves about 40% of the time4 h to set up
  1. 1Check what your system offers: Coupa Supplier Portal, SAP Business Network, NetSuite supplier portal, Ariba.
  2. 2Invite your top 20 suppliers first.
  3. 3Require certificates and insurance uploads with expiry dates.
  4. 4Verify any bank detail change by phone to a known number.

Tools: Coupa Supplier Portal · SAP Business Network · NetSuite supplier portal · SAP Ariba

How to automate this task

Task 5 · typically 30 min, once a week

Keep supplier details, certificates and insurance up to date

Software featureBest fix

Let suppliers update their own details and confirm orders in a portal

Supplier portals let suppliers confirm POs, update contacts and upload certificates and insurance themselves, with expiry reminders.

Typically saves about 40% of the time4 h to set up
  1. 1Check what your system offers: Coupa Supplier Portal, SAP Business Network, NetSuite supplier portal, Ariba.
  2. 2Invite your top 20 suppliers first.
  3. 3Require certificates and insurance uploads with expiry dates.
  4. 4Verify any bank detail change by phone to a known number.

Tools: Coupa Supplier Portal · SAP Business Network · NetSuite supplier portal · SAP Ariba

One more way to fix it
Software feature

Tier vendors and run due diligence in a vendor risk tool

Vendor risk tools send the right questionnaire by risk tier, collect certificates and insurance, and remind you when they expire, so low-risk vendors do not get the full treatment.

Typically saves about 45% of the time6 h to set up
  1. 1Define three tiers (e.g. data access, spend, criticality) and what each needs.
  2. 2Use Vanta, Drata or OneTrust vendor risk, Whistic, Mitratech Prevalent or UpGuard.
  3. 3Let vendors upload documents through the portal.
  4. 4Set expiry alerts for certificates and reports.

Tools: Vanta Vendor Risk Management · OneTrust Third-Party Risk · Whistic · Mitratech Prevalent · UpGuard

How to automate this task

Task 6 · typically 60 min, once a week

Run risk and due diligence checks on new vendors

Software featureBest fix

Tier vendors and run due diligence in a vendor risk tool

Vendor risk tools send the right questionnaire by risk tier, collect certificates and insurance, and remind you when they expire, so low-risk vendors do not get the full treatment.

Typically saves about 45% of the time6 h to set up
  1. 1Define three tiers (e.g. data access, spend, criticality) and what each needs.
  2. 2Use Vanta, Drata or OneTrust vendor risk, Whistic, Mitratech Prevalent or UpGuard.
  3. 3Let vendors upload documents through the portal.
  4. 4Set expiry alerts for certificates and reports.

Tools: Vanta Vendor Risk Management · OneTrust Third-Party Risk · Whistic · Mitratech Prevalent · UpGuard

One more way to fix it
AI

Have AI summarize a vendor's SOC 2 report and flag exceptions

AI can read a 100-page SOC 2 or questionnaire and pull out scope, exceptions, carve-outs and the controls you are expected to run. You decide whether the risk is acceptable.

Typically saves about 45% of the time5 min to set up
  1. 1Use an AI tool approved for confidential documents (vendor reports are under NDA).
  2. 2Upload the report and use the prompt below.
  3. 3Check every exception it lists against the report.
  4. 4Record your decision and any follow-ups in the vendor file.
Prompt to copy
Summarize the attached [SOC 2 TYPE II / ISO / QUESTIONNAIRE] for [VENDOR]. Give: report period and scope, which systems are covered and excluded, subservice organizations carved out, every exception or qualified opinion with page reference, complementary user entity controls we must run, and anything relevant to our use case: [DESCRIBE WHAT DATA THEY WILL HANDLE]. Do not give an overall approve/reject.

Tools: Enterprise ChatGPT, Claude, Gemini or Microsoft Copilot (approved for confidential data) · Vanta or Drata AI document review

How to automate this task

Task 7 · typically 60 min, once a week

Prepare for supplier negotiations and renewals

AIBest fix

Have AI build your negotiation brief

Give AI the current contract terms, usage and market notes; it builds a one-page brief with your targets, leverage and the supplier's likely moves.

Typically saves about 40% of the time5 min to set up
  1. 1Gather current price, usage, contract end date and any performance issues.
  2. 2Use a research mode for market pricing if useful, and check sources.
  3. 3Use the prompt below.
  4. 4Agree your walk-away point with the budget owner before the call.
Prompt to copy
Prepare a negotiation brief for renewing [SUPPLIER] for [PRODUCT/SERVICE]. Current terms: [PRICE, VOLUME, TERM, END DATE]. Our usage: [DETAILS]. Issues: [PERFORMANCE OR SERVICE PROBLEMS]. Alternatives: [OTHER OPTIONS]. Give: our goals (ideal, target, walk-away), our leverage, the supplier's likely arguments and responses, five non-price asks, and an opening email. Mark any market assumptions [CHECK].

Tools: ChatGPT, Claude, Gemini or Microsoft Copilot · ChatGPT, Claude or Perplexity research mode

One more way to fix it
Automation

Get automatic alerts before renewal and notice dates

Reminders 90, 60 and 30 days before each notice date go to the contract owner, so nothing auto-renews by accident.

Typically saves about 60% of the time2 h to set up
  1. 1Get renewal and notice dates into one place (your CLM, or a tracker with an owner per contract).
  2. 2Turn on CLM reminders, or build a Power Automate, Zapier or Make flow from the tracker to email, Teams or Slack.
  3. 3Send alerts to the business owner and copy procurement or legal.
  4. 4Review upcoming renewals monthly.

Tools: CLM reminders · Power Automate, Zapier or Make · Microsoft Lists or Smartsheet

How to automate this task

Task 8 · typically 30 min, every day

Copy the same information between systems or spreadsheets

AutomationBest fix

Connect the two systems so data moves itself

A Zapier, Make, n8n or Power Automate flow copies new records from one system to the other the moment they appear.

Typically saves about 80% of the time2 h to set up
  1. 1Write down the trigger ("new row in", "new form submission", "deal marked won") and where it should go.
  2. 2Check if the two tools already have a built-in integration; turn it on if so.
  3. 3If not, build a two-step flow in Zapier, Make, n8n or Power Automate.
  4. 4Run it next to your manual process for a week, then stop copying by hand.

Tools: Zapier · Make · n8n · Microsoft Power Automate

One more way to fix it
AI

Have AI pull the details out into a table you can paste

Paste emails, PDFs or forms and get back clean rows in the exact columns your system needs.

Typically saves about 60% of the time5 min to set up
  1. 1Collect the source text (emails, PDFs, screenshots).
  2. 2Give the AI the column names you need.
  3. 3Paste the table into your spreadsheet or import file.
  4. 4Spot-check a few rows against the source.
Prompt to copy
Extract the following fields from the text below into a table with exactly these columns: [COLUMN 1], [COLUMN 2], [COLUMN 3]. One row per [ITEM]. Leave a cell blank if the value is not stated. Do not guess.

[PASTE TEXT OR ATTACH FILES]

Tools: ChatGPT, Claude, Gemini or Microsoft Copilot

How to automate this task

Task 9 · 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 10 · typically 90 min, once a month

Analyze spend and look for savings

AIBest fix

Have AI categorize spend and find savings opportunities

Upload an AP or card export; AI groups spend by category and supplier, finds duplicates and overlapping tools, and suggests where to consolidate.

Typically saves about 50% of the time10 min to set up
  1. 1Export 12 months of AP and card spend (supplier, amount, description, department).
  2. 2Upload to an approved AI tool or Copilot in Excel.
  3. 3Use the prompt below.
  4. 4Check the top findings against contracts before acting.
Prompt to copy
Analyze this 12-month spend export. 1) Group spend into categories and show total by category and top 10 suppliers. 2) Find suppliers that look like duplicates (name variations). 3) Find categories with many small suppliers (tail spend). 4) Find overlapping software subscriptions. 5) Suggest the five biggest savings opportunities with the estimated spend affected. Show the method so I can reproduce it.

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

One more way to fix it
AI

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

How to automate this task

Task 11 · typically 30 min, once a week

Track contract renewals, notice dates and obligations

AutomationBest fix

Get automatic alerts before renewal and notice dates

Reminders 90, 60 and 30 days before each notice date go to the contract owner, so nothing auto-renews by accident.

Typically saves about 60% of the time2 h to set up
  1. 1Get renewal and notice dates into one place (your CLM, or a tracker with an owner per contract).
  2. 2Turn on CLM reminders, or build a Power Automate, Zapier or Make flow from the tracker to email, Teams or Slack.
  3. 3Send alerts to the business owner and copy procurement or legal.
  4. 4Review upcoming renewals monthly.

Tools: CLM reminders · Power Automate, Zapier or Make · Microsoft Lists or Smartsheet

One more way to fix it
Software feature

Put signed contracts in a repository that reads them for you

AI contract repositories pull out parties, dates, renewal terms and key clauses so you can search "which contracts auto-renew in Q1?" instead of opening PDFs.

Typically saves about 60% of the time8 h to set up
  1. 1Gather signed contracts into one place.
  2. 2Load them into DocuSign Navigator, Ironclad, Juro, SpotDraft, Concord or Workday Contract Intelligence (formerly Evisort).
  3. 3Check the extracted data for your top 50 contracts.
  4. 4If you have none of these, ask Microsoft Copilot or Gemini over a single contracts folder.

Tools: DocuSign Navigator · Ironclad · Juro · SpotDraft · Workday Contract Intelligence · Microsoft Copilot

How to automate this task

Task 12 · typically 15 min, every day

Answer the same questions from coworkers again and again

AIBest fix

Write the answers down once and point people (or a bot) at them

Collect the questions you keep answering into one page; a workspace AI or a ChatGPT Project, Claude Project or Gem can answer from it.

Typically saves about 50% of the time1 h to set up
  1. 1For one week, paste every repeat question into a doc.
  2. 2Write the answer under each (or have AI draft it from your replies).
  3. 3Share the page, pin it in chat, and add it to a Claude Project, ChatGPT Project, Gemini Gem or Copilot agent.
  4. 4Reply to repeat questions with the link.
Prompt to copy
Below are questions coworkers keep asking me and my past answers. Turn them into a clear FAQ page grouped by topic. Keep each answer under 80 words and keep any links I gave.

[PASTE QUESTIONS AND ANSWERS]

Tools: Claude Projects · ChatGPT Projects · Gemini Gems · Copilot agents · Notion or Confluence

One more way to fix it
Software feature

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

How to automate this task

Task 13 · 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 14 · typically 120 min, a few times a week

Review and redline customer and vendor contracts

AIBest fix

Have AI do a first pass against your playbook, then a lawyer decides

Contract AI (Spellbook, LegalOn, Ironclad AI, Harvey, Legora, Copilot in Word) flags clauses that differ from your positions and suggests redlines. A qualified reviewer accepts or rejects every change; use only tools approved for confidential documents.

Typically saves about 40% of the time2 h to set up
  1. 1Write your playbook: for the 10 to 15 clauses that matter, your standard position, acceptable fallback and walk-away.
  2. 2Use a contract AI tool or an enterprise AI account your company has approved for client and counterparty data.
  3. 3Run the contract with the prompt below (or load the playbook into the tool).
  4. 4Review every flag and suggested redline yourself; do not send AI redlines unread.
  5. 5Add new positions to the playbook as you negotiate.
Prompt to copy
You are assisting an in-house lawyer. Review the attached [CONTRACT TYPE] from the perspective of [OUR COMPANY] as [CUSTOMER / VENDOR]. Compare it against our playbook below. For each clause that differs, give: clause reference, what it says, our position, risk level (high/medium/low), and a suggested redline in tracked-change style. Then list any missing clauses we normally require. Do not give a final recommendation to sign; quote the contract exactly.

Playbook:
[PASTE POSITIONS]

Tools: Spellbook · LegalOn · Ironclad AI · Harvey · Legora · Microsoft Copilot in Word · Enterprise ChatGPT, Claude, Gemini or Microsoft Copilot (approved for confidential data)

One more way to fix it
Process fix

Write a clause playbook with fallback positions

A one-page position for each key clause (preferred, fallback, never) lets contract managers handle most negotiations and makes AI review much more accurate.

Typically saves about 30% of the time8 h to set up
  1. 1Pull your last 20 negotiated contracts and list the clauses that always come up.
  2. 2For each, write the preferred wording, acceptable fallbacks and who can approve going further.
  3. 3Store it next to your templates and in your contract AI tool.
  4. 4Review it twice a year.

Tools: Word or Google Docs · CLM clause library

How to automate this task

Quick wins

Have you tried…

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 connected two apps so information copies itself between them?
Tools like Zapier, Make or Power Automate watch for something new in one app and create it in the other, so nobody retypes it.
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 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.
Have you set up a ChatGPT Project, Claude Project or Gem loaded with your team's documents?
You upload your guides and FAQs once, and the assistant answers questions using them, so you stop answering the same thing twice.
Have you used AI for a first-pass contract review against your own playbook?
Tools like Spellbook, LegalOn or Copilot in Word compare a contract with your standard positions and suggest redlines. A lawyer still reviews and decides every change.
Can you search signed contracts by renewal date or clause instead of opening PDFs?
AI contract repositories read your signed contracts and pull out parties, dates and key terms, so you can ask "what auto-renews next quarter?".
Have you had AI put supplier quotes side by side in one table?
Upload the quotes and AI lines them up on the same basis, including terms and exclusions that are easy to miss.

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.

Answers are anonymous. Leaders only see team totals.

More roles in Legal, compliance & procurement