Stop Losing Vendor Quotes - Auto-Save Every Quote to Airtable
Design studios waste 3-5 hours weekly manually tracking vendor pricing changes. Missed updates lead to inaccurate proposals and lost margins. This Make.com automation captures every quote email, saves attachments to Dropbox, and logs them in Airtable - automatically eliminating spreadsheet chaos.
The Hidden Cost of Manual Vendor Quote Tracking
Creative agencies and design studios typically work with dozens of vendors - printers, fabricators, photographers - each updating their pricing multiple times per year. Without automation, someone must manually check emails, download attachments, and update spreadsheets - a process prone to errors and oversights.
At 1:15 in the video, Raina highlights how easy it is to miss price updates when relying on manual tracking. "You might be working off quotes that are six months old without realizing it," she explains, "until a client questions why your proposal doesn't match current market rates."
68% of design firms report sending proposals with outdated vendor pricing at least once per quarter, according to industry surveys. These errors directly impact profitability when projects get priced using old numbers.
How the Make.com Automation Works
This workflow solves the vendor quote tracking problem through a seamless integration between Gmail, Dropbox, and Airtable. When a vendor email arrives with an attachment (quote, estimate, or invoice), the automation:
- Identifies the email using configured filters
- Extracts all attachments
- Saves them to a designated Dropbox folder
- Creates a detailed record in Airtable with metadata and file links
The entire process happens automatically within minutes of receiving the email, with no manual intervention required. At 2:30 in the tutorial, Raina demonstrates how the system captures all relevant details - vendor name, date, subject line, and file link - in a structured Airtable base ready for reporting and analysis.
Step-by-Step Setup Guide
Step 1: Create Your Make.com Scenario
Begin by logging into your Make.com account and creating a new scenario. Name it something descriptive like "Vendor Quote Tracker" so you can easily identify it later among your automations.
Step 2: Add the Gmail Trigger
Add your first module by selecting Gmail > Watch Emails. Connect your Google account and configure the filter to look for emails with attachments from your vendor domains or containing specific keywords in the subject line.
Step 3: List Email Attachments
Add a second Gmail module to extract all attachments from matched emails. This step ensures you capture PDF quotes, Excel price lists, or any other document formats your vendors might use.
Pro Tip: Set a reasonable limit (like 10 emails per run) to prevent processing too many historical messages during initial testing.
Gmail Configuration for Quote Capture
Precise Gmail filtering ensures the automation only processes genuine vendor quotes while ignoring other emails. The tutorial shows how to set up filters using:
- Sender domains (e.g., "@printvendor.com")
- Subject keywords ("quote", "estimate", "pricing")
- Attachment presence (must have files attached)
- Label matching (if you pre-tag vendor emails)
At 3:45 in the video, Raina demonstrates the exact filter syntax that catches 98% of vendor quotes while excluding irrelevant messages. This configuration significantly reduces false positives that could clutter your Airtable base.
Dropbox File Storage Setup
The automation needs somewhere to store the actual quote documents for long-term access. Dropbox provides secure cloud storage with these advantages:
- Automatic versioning if vendors update files
- Access control for team members
- Reliable uptime and fast retrieval
After connecting your Dropbox account in Make.com, specify the folder path where quotes should be saved. Consider organizing by vendor type (e.g., "/Vendors/Printing/") or year to maintain order as your library grows.
Critical: Enable "Create share links" in the Dropbox module to generate accessible URLs that will be stored in Airtable. Without this step, your team won't be able to view the actual documents.
Airtable Record Creation Process
The final piece logs all captured data in Airtable for easy reference. Configure the Create Record module to map:
- Vendor name (from email "From" field)
- Email subject line
- Received date
- Attachment filename
- Dropbox share link
At 5:20 in the tutorial, Raina shows how to set up the Airtable base with these fields pre-configured. The result is a searchable database of all vendor quotes that your entire team can access - no more digging through old emails or asking "who has the latest numbers?"
Testing and Troubleshooting
Before running the automation on real emails, send yourself test messages with attachments to verify:
- The Gmail filter correctly identifies your test as a "vendor quote"
- Attachments save properly to Dropbox
- Airtable records contain all expected fields
Common issues include incorrect filter syntax (missing valid quotes) or permission errors when accessing Dropbox. The scenario history in Make.com provides detailed logs to diagnose any failures.
Measurable Business Benefits
Implementing this automation delivers tangible improvements:
- Time savings: 3-5 hours weekly no longer spent manually tracking quotes
- Accuracy: Eliminates human errors in transferring pricing data
- Visibility: Entire team accesses current vendor rates from Airtable
- Audit trail: Historical record of all price changes by vendor
At 6:50 in the video, Raina emphasizes how having this system in place builds client trust. "When you can instantly pull up the exact vendor quote you based a proposal on, it demonstrates professionalism and attention to detail that clients appreciate."
Watch the Full Tutorial
See the complete setup process in action from 2:15-4:30 where Raina demonstrates configuring the Gmail filters and Airtable field mappings. The visual walkthrough makes it easy to replicate each step in your own Make.com account.
Key Takeaways
Manual vendor quote tracking creates unnecessary work and risks using outdated pricing in proposals. This Make.com automation eliminates those problems by:
- Automatically capturing quote emails with attachments
- Saving documents to organized Dropbox folders
- Creating searchable Airtable records with all relevant details
In summary: This workflow gives design studios always-current vendor pricing at their fingertips, saving hours per week while improving proposal accuracy and profitability.
Frequently Asked Questions
Common questions about this topic
This Make.com workflow can capture any vendor document sent via email including quotes, estimates, invoices, and pricing sheets. The system checks for attachments in emails matching your specified filters, then processes and logs them automatically.
Common file types like PDFs, Excel sheets, Word docs, and image files are all supported. The automation preserves the original file format while making it accessible through your Airtable interface.
- Handles multiple attachment types in a single email
- Preserves original file formats and content
- Logs each document as a separate Airtable record
The system uses Gmail filters to identify emails containing vendor quotes. You configure specific criteria that define what constitutes a "vendor quote" email for your business.
In the tutorial, we set up a filter for emails with attachments labeled as vendor communications. This ensures only relevant documents get processed while ignoring personal emails or other business correspondence.
- Filters can use sender domains, subject keywords, or labels
- Attachment presence is a required condition
- Multiple filter criteria can be combined for precision
While this tutorial demonstrates the workflow with Gmail, Make.com supports integration with Outlook, Office 365, and other email providers. The core functionality remains the same regardless of your email platform.
The setup process is similar - you would use the appropriate email module for your provider instead of the Gmail module. All subsequent steps involving Dropbox and Airtable work identically across email systems.
- Works with Microsoft 365/Outlook email accounts
- IMAP-supported providers can also be configured
- Same attachment processing and Airtable logging
The automation creates a new Airtable record for each unique email attachment it processes. If a vendor sends multiple versions, each will be logged separately with timestamps.
The system includes the original email date and subject line to help you identify related quotes from the same vendor. You can easily sort or filter in Airtable to see all versions of a particular quote.
- Each revision gets its own timestamped record
- Original email metadata helps track revisions
- Airtable views can show quote history by vendor
Yes, Make.com supports numerous cloud storage options including Google Drive, OneDrive, and AWS S3. The choice of storage provider doesn't affect the core functionality of the automation.
You would simply replace the Dropbox module with your preferred storage service's module. The Airtable record will still contain a link to the stored file regardless of which storage provider you use.
- Google Drive is a popular alternative
- OneDrive works well for Microsoft-centric businesses
- S3 suits organizations with existing AWS infrastructure
The Gmail watch emails trigger can check for new messages as frequently as every 5 minutes. The actual interval depends on your Make.com plan and performance needs.
In practice, we recommend setting it to run every 15-30 minutes to balance responsiveness with system efficiency. You can adjust this interval in the scenario settings based on your business needs and email volume.
- Minimum interval depends on your Make.com plan
- 15-30 minutes works well for most businesses
- Can be adjusted anytime in scenario settings
Each Airtable record captures the vendor name (from email sender), date received, email subject, attachment filename, and a shareable link to the stored document.
You can easily extend this to include additional fields like project codes, priority flags, or custom tags by modifying the Create Record module in your scenario. The basic setup provides all essential tracking metadata.
- Core fields: Vendor, Date, Subject, Filename, Link
- Custom fields can be added for your specific needs
- All data remains searchable and filterable in Airtable
GrowwStacks specializes in building custom automation solutions like this vendor quote tracker. We understand the unique challenges creative agencies face with vendor management and pricing accuracy.
Our team can implement this exact workflow for your business or create a customized version that integrates with your existing tools and processes. We'll handle all the technical setup so you can focus on your creative work.
- Free consultation to assess your vendor management needs
- Customized implementation for your email and storage systems
- Ongoing support and optimization as your needs evolve
Stop Wasting Time Chasing Vendor Quotes
Every hour spent manually tracking pricing updates is an hour not spent on billable creative work. Let GrowwStacks implement this automation for you in under 48 hours - complete with your custom Airtable dashboard and team training.