AI-Based Plant Procurement Optimizer

The Workflow: When a nursery emails a spreadsheet, and i drag it into a specific folder like dropbox or google drive folder. The AI reads the mess of columns and "normalizes" it into a standard Master Sheet (e.g., Column A: Plant Name, Column B: Size, Column C: Price, Column D: Nursery Name). Input: Your Vectorworks Plant List. Logic: Compares project list against the Master Availability sheet. Results i want is It flags which nursery has the best price/availability for each item. What is best options? zapier or make.com Because I want to save on shipping, I want the system look at all active projects in JobTread. For example It totals up the "Boxwoods" needed for Project A, B, and C. It checks which vendor can fulfill the entire batch to hit a shipping minimum. then i want Drafting: The system generates a draft email for each nursery (e.g., "Hi Dave at Green Valley, we need 50 Boxwoods for delivery on March 10th..."). Approval: These drafts appear in your Gmail "Drafts" folder or as a Task in JobTread. Sending: You or your assistant give it a quick "looks good" and hit send. JobTread Update: Once you hit send, Zapier automatically creates a Purchase Order (PO) in JobTread for that specific vendor and project