Consolidate Purchase Requests for Approval
Every Monday, WebRun reads all new purchase requests logged in Google Sheets, groups them by department and supplier, loads the consolidated list into Coupa as a single requisition, and posts an approval summary to Slack for the purchasing manager to review.
How can I automatically consolidate purchase requests for a single approval?
Every Monday, WebRun reads all new purchase requests logged in Google Sheets, groups them by department and supplier, loads the consolidated list into Coupa as a single requisition, and posts an approval summary to Slack — so the purchasing manager can sign off once instead of reviewing a dozen separate requests.
- One approval covers all weekly purchase requests instead of many
- Spend grouped by supplier to unlock bulk pricing opportunities
- Purchase requests visible and actionable in Slack every Monday
Built for purchasing managers · procurement teams · finance operations · department heads
What does WebRun do on every run?
The exact actions WebRun takes, in order — in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
docs.google.com/spreadsheetsin a real browser with your saved login — no setup, no API keys. -
1
Google Sheets — collect team purchase requests
google.com
WebRun opens Google Sheets to collect team purchase requests. - Open the Purchase Request log and filter for requests submitted this week with Status = Pending
- Group requests by department and preferred supplier
- Flag any request that exceeds the per-item budget threshold for extra scrutiny
Done when All this week's purchase requests are gathered and grouped by supplier.
-
2
Coupa — build consolidated requisition
coupa.com
WebRun opens Coupa to build consolidated requisition. - Open Requisitions and create a new draft requisition
- Add each grouped line item: description, quantity, unit price, and the requesting department
- Save the requisition as a draft — do not submit for approval
Done when A consolidated draft requisition is built in Coupa awaiting your submission.
-
3
Slack — send approval summary to purchasing manager
slack.com
WebRun opens Slack to send approval summary to purchasing manager. - Post the weekly purchase-request summary: total items, total estimated value, and a breakdown by department
- Include a link to the Coupa draft so the approver can review and submit
Done when The purchasing manager has been notified with a link to the consolidated requisition.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it submit the requisition without my approval?
Never — the requisition is saved as a draft in Coupa and only submitted once the purchasing manager reviews and approves it in Slack.
What if two departments need the same item from different suppliers?
It groups by supplier, so you can see if consolidating to one supplier would save money — but the choice is yours to make.
Can individual requestors track where their request ended up?
Yes — update the Status column in Google Sheets after approval and requestors can check their row to see if it has been processed.
Related templates
Put this on autopilot.
Turn it on in minutes — or have our team set it up for you.