Turn a quote request into a QuickBooks estimate
Quote requests land in QuickBooks as estimates against a named customer, ready for you to price and send.
New submission on your quote request form
Create an Estimate in QuickBooks with the customer, the work they asked about and the details they gave
One-directional. A submission triggers the action — nothing is written back into your form.
Renovation enquiries arrive with a rough budget and a description of the job, rarely with enough detail to price properly. The point of getting them into QuickBooks fast is not the number — it is having a numbered estimate against a named customer, instead of a note in someone's phone.
Trades who quote from site visits use this to keep the pipeline in one place. The estimate is opened the moment the request arrives, pricing happens after the visit, and the ones that get accepted convert into invoices without a second round of typing.
Setting it up
- 1
Publish the quote request form and check that Project Type offers a short, fixed list of options. Free text here makes the QuickBooks side harder to automate later.
- 2
Point the formformform "New Submission" trigger at that form and add QuickBooks Online with the Create Estimate action.
- 3
Add a Find Customer step on Full Name with create-if-missing enabled, so enquirers who have never bought from you still get a customer record to hang the estimate on.
- 4
Map Project Type to the Product/Service item on the first estimate line and Project Description to that line's description, so the estimate reads like the job the customer described.
- 5
Map Approximate Budget ($) to the customer memo, not to the line amount. It is what they hope to spend, and putting it in the amount column produces estimates that look priced when they are not.
- 6
Map Property Address to the shipping address on the estimate. That is the site, and it is often not where the bill should go.
- 7
Set the estimate status to Pending in the Zap and leave the email option off, so nothing reaches the customer before you have been round to look.
- 8
Use a Zapier date step to set the expiry date fourteen days out, submit a test request, check it under Sales then Estimates, and turn the Zap on.
What maps where
Using the Renovation Quote Request Form as the starting point. These are its real fields — swap in your own and the mapping works the same way.
| Form field | QuickBooks |
|---|---|
| Full Name | Customer on the estimate, found or created by display name |
| Email Address | Customer email on the estimate, used when you send it |
| Property Address | Shipping address on the estimate, recording the job site |
| Project Type | Product/Service item on the first estimate line |
| Project Description | Description on that estimate line |
| Approximate Budget ($) | Customer memo, visible while you price the job |
Variations worth knowing
Where a project type has a fixed survey fee or a standard starting package, add Zapier paths on Project Type that select the matching QuickBooks item. Those estimates land with a real figure on them and only the extras need adding by hand.
Add a Zapier filter on Approximate Budget ($) so requests below your minimum job size never create an estimate. They still arrive as responses in formformform, so you can reply, but they stop cluttering the sales pipeline in QuickBooks.
If something isn't arriving
That is the intended behaviour of this mapping — the budget goes in the memo, not the amount. If you would rather see a starting figure, map Approximate Budget ($) to the line amount as well, and keep the status as Pending so nobody mistakes it for a finished quote.
Property Address is mapped to the shipping address, and QuickBooks will carry it across when the estimate converts. Set the billing address separately on the customer record, either by hand or through the client intake recipe.
Frequently asked questions
Can the estimate be emailed to the customer automatically?
The QuickBooks action does offer a send option, but an estimate built from a description and a budget figure is not priced yet. Most trades leave it off, price the job after the site visit, and send from QuickBooks by hand.
What happens when the customer accepts the quote?
You mark the estimate as accepted in QuickBooks and convert it to an invoice there. None of that touches the form: the connection only runs from a submission into QuickBooks, never the other way round.
Do I need the customer to exist in QuickBooks first?
No, as long as the Zap includes a Find Customer step with create-if-missing switched on. Without it the estimate step fails, because QuickBooks will not raise an estimate against a name it does not recognise.
Related automations
- Add new clients to your QuickBooks customer list
Every new client who fills in your intake form arrives in QuickBooks as a customer record, ready to invoice.
- Log expense claims as QuickBooks expenses
Each expense claim submitted by staff is recorded in QuickBooks against the right category, payee and date.
- Onboard contractors and suppliers as QuickBooks vendors
New suppliers and contractors fill in their own details once, and the vendor record is created in QuickBooks.
- Raise a QuickBooks invoice from an order request
An order placed through your form becomes a draft invoice in QuickBooks, with terms and PO number already filled in.
- Record a paid order as a QuickBooks sales receipt
An order that has already been paid for is logged in QuickBooks as a sales receipt against the right income account.
- Add counter signups to your Customer Directory
A signup at the till or on your site becomes a Square customer profile straight away, spelled the way the customer typed it.
Build the form first
The automation needs somewhere to fire from. Publish a form, connect it once, and every submission from then on runs this flow.
Start free