1.Receives BOM form submission
Integrate Zapier Forms and form submission tools to receive the submission and attachment and map the Opportunity reference to quoting data.
Create BOM quote and line items from form
Automatically monitor BOM form submissions across Zapier Forms and Salesforce. Create and update when opportunity reference resolves, CSV rows parse, or SKUs matchβso you can create quotes, add line items, and set ops intake status without manual data entry.
How this automation accelerates your BOM intake quotes
When BOM requests arrive with spreadsheet attachments, delays can stall quoting and ops intake. This automation parses CSV rows, finds the Opportunity, creates draft quotes, and builds quote line itemsβso your team can move faster without manual cleanup.
Zapier Formsor swap with your favorite app
2.Parses CSV attachment into rows
Integrate Files By Zapier and CSV parsing tools to parse the attachment into rows and map fields to quote line item properties.
Files By Zapieror swap with your favorite app
3.Finds the matching Opportunity
Integrate Salesforce and CRM lookup tools to match the Opportunity by reference and return the Opportunity record for linking.
Salesforceor swap with your favorite app
4.Creates a draft BOM Quote
Integrate Salesforce and CRM quoting tools to create the Quote, set quote type to BOM, and initialize status to Draft.
5.Finds Products by SKU
Integrate Looping by Zapier and Salesforce product lookup tools to find each Product by SKU for every CSV row.
6.Resolves pricebook entries
Integrate Looping by Zapier and Salesforce price resolution tools to find PricebookEntry and apply quantity and pricing.
Automate your work, your way
Build custom automations across your tools in minutes. Describe what you need, connect your apps, and create workflows without the manual effort.
Trusted by 3.4 million companies
Related automations
- Apps: monday.com, Microsoft ExcelSwap with your favorite apps.
Add approved ad pricing rows to quote sheet
Siloed pricing approval items leave quotes inconsistent and slow proposal preparation. It consolidates approvals into the quote workbook so sales ops can generate proposals the same day.
- Apps: Jobber, Formatter by Zapier, Google SheetsSwap with your favorite apps.
Add approved quotes as new lead rows to sheet
When approved quotes aren't tracked, your crew misses start dates and customers wait for confirmation. Capture quote details into a jobs sheet so coordinators can schedule and confirm same day.
- Apps: LeadConnector, Formatter by ZapierSwap with your favorite apps.
Add calculated window quote to new residential leads
Your residential lead records lack instant pricing, leaving reps unprepared for initial outreach. Add computed window-service estimates to lead records so reps can reply with price details same day.
- Apps: HubSpot, Filter by ZapierSwap with your favorite apps.
Add deposit and credit line items to deals
Your deals often miss deposit and meeting-room credits, causing quoting errors and handoff friction. Line items are added automatically so sales ops have accurate totals same day.
- Apps: Streak, Formatter by Zapier, Smartsheet, Google ChatSwap with your favorite apps.
Add draft quote row when deals move to Draft
Your draft CRM deals lack structured quote entries, causing manual copying and delayed proposals. Add quote rows automatically so coordinators can prepare proposals same day.
- Apps: Sub-Zap by Zapier, monday.com, Formatter by Zapier, Zapier TablesSwap with your favorite apps.
Add generated quote details and assign owner to job card
Your job cards miss quote links and numbers, leaving billing and crew coordination stalled. Quotes and owner assignment appear on the job card, enabling billing and coordinators to act same day.
- Apps: Webhooks by Zapier, Elfsquad CPQ, Filter by Zapier, Sub-Zap by ZapierSwap with your favorite apps.
Add installation timestamp to quotation and notify systems
Your quotation records lack an installation timestamp, which causes billing delays and handoff confusion. Records become ready for billing and outreach same day.
- Apps: Pipedrive, Google SheetsSwap with your favorite apps.
Add moved deals to quotes sheet for review
Deals moved into the incoming enquiries stage lack a central quote record, causing prep delays and missed follow-ups. Enables sales operations to prepare quotes and hand off details same day.
- Apps: Evoliz, Formatter by Zapier, Google SheetsSwap with your favorite apps.
Add new quotes to weekly control sheet for visibility
Your new quotes aren't added to the weekly control sheet, forcing manual copy work and missed delivery checks. It adds quote details to the sheet for same-day review and weekly reconciliation.
- Apps: Repsly, Formatter by Zapier, Google Sheets, GmailSwap with your favorite apps.
Add new quote to tracker and email sales reps
Your quote form submissions go unrecorded, leaving field reps without prioritization context and delaying follow-up. It logs each quote and notifies stakeholders for same-day attention.
- Apps: Jotform, Microsoft Excel, Formatter by Zapier, Sub-Zap by ZapierSwap with your favorite apps.
Add new quoting form submissions to quote workbook
Your quoting form submissions pile up and manual copying delays creating estimates. Collecting each submission into one quote workbook speeds handoffs and delivers job-ready details same day.
- Apps: Jobber, WhatConverts, Formatter by ZapierSwap with your favorite apps.
Add quote amounts to lead records for follow-up
Your approved quotes aren't recorded on lead profiles, leaving reps without proposal context and delaying follow-up. Get leads marked quotable with totals so reps can act with full context same day.
- View all
Explore all quote management automations
Speed up quote delivery with automated quote intake, approval routing, and CRM updates
Set up in minutes
Zapier connects your tools, triggers actions from real-time data, and streamlines workflows so your team can focus on what matters most.
Step 1
Connect your tools
Bring your apps together so information can move automatically between the tools your team already uses.
Step 2
Define the trigger
Choose the events that should start your workflow, like a new submission, updated record, completed task, or customer action.
Step 3
Automate and measure
Let your workflow handle follow-ups, updates, notifications, and reporting so your team can track progress and act faster.
See how teams are automating with Zapier (and loving it!)
Without Zapier, we would have needed well over 100 employees today just to do what we're doing. We would have been out of business by now.
David Laderberg, VP of Sales
Without having automation, we would have to at least be double our size. Doubling is a bit of a euphemism β I think we would have died or fallen back into oblivion.
Marcelo Lebre, Co-Founder
Zapier helps us close far above 50% more deals than we would without it. It is a key element of our overall strategy and, therefore, of our sales pitch.
Raphael Bochner, Founder and CIO
Zapier gives us unlimited flexibility and creativity. With Zapier, you're like an artist with a blank canvas. I don't know what we'd do without it.
Rishi Shah, CEO and Co-Founder
We don't just want to patch holes; we want to build scalable, future-proof systems. Zapier is helping us do that.
Allen Lai, Head of Customer Experience
We've been able to scale our operations while staying lean. Zapier lets us do more without needing more people.
Jacob Sirrs, Marketing Operations Specialist
Ready to automate your workflow securely?
Streamline processes, uncover new opportunities, and respond faster to change. Empower your team to get more done, without the manual work.