How to Automate Purchase Requests to POs Without Expensive Procurement Software
Most small businesses waste hours each week chasing purchase approvals through messy email chains and spreadsheets. This Airtable + Make automation creates a complete procurement workflow with tiered approvals, budget tracking, and automatic PO generation - all using tools you likely already have. No six-figure software required.
The Hidden Costs of Manual Purchase Processes
Most growing businesses reach a point where email-based purchase approvals become unsustainable. Requests get lost in inboxes, approvers don't have context, and finance teams waste hours reconciling spreadsheets. The average small business loses 12 hours per week chasing purchase approvals when using manual processes.
This automation solves three critical pain points: First, it eliminates approval bottlenecks by automatically routing requests to the right people. Second, it provides complete visibility into spending before commitments are made. Third, it automatically generates audit-ready purchase orders once approvals are complete.
Key insight: You don't need expensive procurement software to get control over purchasing. With Airtable as your system of record and Make handling workflow automation, you can build a solution tailored to your exact business needs in days, not months.
How the Airtable + Make Procurement System Works
The system uses Airtable as both the employee intake form and centralized database, while Make orchestrates all workflow logic. When an employee submits a purchase request, the automation:
- Validates the request against budget rules
- Routes to appropriate approvers based on amount and category
- Tracks approval status in real-time
- Generates POs automatically upon final approval
- Updates all reporting dashboards
At the 2:15 mark in the video, you can see how requests flow through different approval queues based on dollar thresholds. The system handles three scenarios:
- Under $1,000: Self-approved by requester
- $1,000-$5,000: Manager approval required
- Over $5,000: Full finance approval path
Configuring Smart Approval Workflows
The magic happens in Make's workflow builder where approval rules are configured. The demo shows three distinct approval paths (timestamp 3:42), but businesses can create as many as needed based on:
- Purchase amount thresholds
- Department budgets
- Category restrictions
- Supplier approval requirements
When Mary Jane submitted a $100 printing services request (7:30 in video), the system automatically marked it as self-approved since it was under the $1,000 threshold. Contrast this with the $7,000 marketing expense that required both manager and finance approval.
Pro tip: Build escalation rules into your workflows. If an approver doesn't respond within 48 hours, the system can automatically notify their manager or route to a backup approver.
Setting Up the Purchase Request Intake Form
The Airtable form (shown at 1:50) captures all necessary purchase details while enforcing data quality:
- Dropdown menus for departments, categories, and approved suppliers
- Required fields for amounts, quantities, and justification
- Attachment field for quotes or supporting documents
Since the form connects directly to your Airtable base, all submissions create structured records rather than unstructured email requests. This eliminates back-and-forth clarification emails and gives approvers complete context.
At 6:15, notice how the form automatically calculates line item totals and validates against budget rules before submission. These small validations prevent most common errors that delay approvals.
Building the Airtable Data Structure
The demo's Airtable base (shown at 2:30) uses several linked tables to maintain data integrity:
- Employees: Name, email, department, and approval rights
- Departments: Budgets and cost centers
- Categories: Spending categories with approval rules
- Suppliers: Approved vendors with contract terms
- Purchase Requests: All submissions with status tracking
- Purchase Orders: Automatically generated POs
These relationships ensure that when an employee selects "Marketing" as their department, the system knows exactly which budget to check and who should approve the request.
Key Make Automations That Power the System
Make handles all workflow logic between Airtable and other systems. Key automations include:
- Approval Routing: Analyzes each request and assigns to correct queue
- Email Notifications: Sends approvers direct links to review requests
- Status Updates: Tracks where each request is in the approval chain
- Budget Checks: Validates requests against department budgets
- PO Generation: Creates formal purchase orders after final approval
At 9:45 in the video, you can see how Make automatically updates Airtable records and sends notifications at each approval step, creating a complete audit trail.
Automatic Purchase Order Generation
Once a request receives final approval, Make automatically:
- Generates a formatted PO with all line items
- Assigns the next available PO number
- Attaches supporting documents
- Sends to the supplier and requester
- Links back to the original request
The demo at 11:20 shows how the system created PO16 automatically after finance approved the $7,000 marketing request. This eliminates manual data entry errors and ensures POs always match approved requests.
Time saver: The system reduced PO processing time from 45 minutes per request to under 2 minutes - a 96% reduction in manual work.
Spending Visibility and Reporting
The Airtable dashboards (shown at 14:50) provide real-time insights into:
- Spending by department and category
- Approval cycle times
- Supplier spending patterns
- Budget utilization
Finance teams can quickly identify spending trends, while department heads can monitor their budget burn rates. The system also tracks average approval times, helping identify process bottlenecks.
Since all data lives in Airtable, you can create custom reports or connect to BI tools like Power BI for deeper analysis.
Watch the Full Tutorial
See the complete system in action from intake form to PO generation. At 5:10, watch how the $7,000 marketing request flows through manager and finance approval before automatic PO creation.
Key Takeaways
Manual purchase processes create friction, errors, and wasted time. This Airtable + Make automation provides structure where none existed, giving growing businesses procurement controls without enterprise software costs.
In summary: You can implement tiered approvals, budget checks, and automatic PO generation using tools you likely already have. The system demonstrated was built in one afternoon and handles all three major purchase scenarios businesses face daily.
Frequently Asked Questions
Common questions about this topic
This automation can handle all types of business purchases from office supplies to marketing services. The system supports three approval tiers: self-approval for purchases under $1,000, manager approval for $1,000-$5,000, and full finance approval for purchases over $5,000.
Each category can be customized with different approval rules based on your business needs. The video shows examples handling everything from $100 printing services to $7,000 marketing expenses.
- Office supplies and equipment
- Marketing and advertising services
- Professional services and contractors
The system automatically routes purchase requests based on amount thresholds. When an employee submits a request through the Airtable form, Make checks the amount and assigns it to the appropriate approval queue.
Approvers receive email notifications with direct links to review and approve requests in Airtable. The system tracks all approval steps and updates status automatically, as demonstrated at the 9:45 mark in the video.
- Under $1,000: Self-approved instantly
- $1,000-$5,000: Routes to department manager
- Over $5,000: Requires finance + manager approval
Yes, the Airtable base includes spending dashboards that show purchases by department, category, and supplier. You can see total spend against budgets and track approval times.
The system provides visibility into vendor spending patterns and helps identify cost-saving opportunities. At 14:50 in the video, you can see sample reports tracking spending across different dimensions.
- Real-time budget utilization
- Departmental spending trends
- Vendor concentration reports
Once a purchase request receives final approval, Make automatically generates a purchase order with all relevant details. The PO includes supplier information, item descriptions, quantities, and pricing.
The system links each PO back to its original request for full auditability and sends notifications to both the requester and finance team. At 11:20 in the video, watch how PO16 was created automatically after approvals.
- Auto-incrementing PO numbers
- Professional formatted templates
- Automatic email distribution
If an approver rejects a request, the system sends an email notification to the original requester with the rejection reason. The request status updates in Airtable, and no PO is generated.
The requester can then modify and resubmit if needed, creating a complete audit trail of all changes and decisions. All rejection reasons are recorded in Airtable for reporting and process improvement.
- Detailed rejection reasons
- Full audit trail of changes
- Option to modify and resubmit
Absolutely. The approval logic is fully configurable in Make. You can set different rules based on department, purchase category, or other criteria beyond just dollar amounts.
For example, you might require IT approval for all technology purchases regardless of amount, or add extra controls for certain suppliers. The demo shows three basic rules, but businesses typically implement 5-10 customized approval paths.
- Department-specific rules
- Category-based approvals
- Supplier-specific requirements
A basic version can be implemented in as little as one day, as demonstrated in the video. The exact timeline depends on your existing tech stack and how many customizations you need.
Most businesses can have a working prototype within 2-3 business days that they can then refine over time. The system is designed to evolve as your procurement needs become more sophisticated.
- Basic version: 1 day
- Typical implementation: 2-3 days
- Ongoing refinements as needed
GrowwStacks specializes in building custom procurement automations using Airtable and Make. We'll configure the system to match your exact approval workflows, integrate with your existing tools, and train your team.
Our implementation includes all necessary forms, approval logic, PO templates, and reporting dashboards. We handle everything from initial setup to ongoing maintenance and enhancements.
- Custom approval workflows matching your policies
- Integration with your accounting/ERP system
- Ongoing support and refinements
Stop Wasting Time on Manual Purchase Approvals
Every hour your team spends chasing approvals is an hour not spent growing your business. GrowwStacks can implement this automated procurement system tailored to your exact needs in days, not months.