--- title: Automate Quote Line Item Retrieval in HubSpot with Zapier description: Learn how to retrieve line items from quotes in HubSpot, automate the process using Zapier, and keep records up-to-date effortlessly. Find out more in this detailed guide. image: https://www.whimpact.co/hubfs/automating%20line%20item%20retrieval%20from%20quotes%20hubspot%20using%20zapier.png --- [Skip to content](https://www.whimpact.co/wh1nsights/automate-quote-line-item-retrieval-in-hubspot-with-zapier#main-content) [![whimpact logo](https://www.whimpact.co/hs-fs/hubfs/whimpact%20logo.png?width=333&height=250&name=whimpact%20logo.png)](https://www.whimpact.co) - [About WHI](https://www.whimpact.co/about) - [Learn - WHInsights](https://www.whimpact.co/wh1nsights) Open main navigation Close main navigation - [About WHI](https://www.whimpact.co/about) - [Learn - WHInsights](https://www.whimpact.co/wh1nsights) - [Start Your Assessment](https://www.whimpact.co/whintensive) [Start Your Assessment](https://www.whimpact.co/whintensive) May 1, 2024 11:48:29 AM # Automate Quote Line Item Retrieval in HubSpot with Zapier ![Picture of Ryan Schweighart](https://www.whimpact.co/hs-fs/hubfs/Chat_photo-1.jpg?width=50&name=Chat_photo-1.jpg) [Ryan Schweighart](https://www.whimpact.co/wh1nsights/author/ryan-schweighart) Be a hero and share this WHInsight: [Share this page via Email](mailto:?body=https://www.whimpact.co/wh1nsights/automate-quote-line-item-retrieval-in-hubspot-with-zapier) [facebook-f icon](http://www.facebook.com/share.php?u=https://www.whimpact.co/wh1nsights/automate-quote-line-item-retrieval-in-hubspot-with-zapier) [Share this page on LinkedIn](http://www.linkedin.com/shareArticle?mini=true&url=https://www.whimpact.co/wh1nsights/automate-quote-line-item-retrieval-in-hubspot-with-zapier) [Share this page on Twitter](https://twitter.com/intent/tweet?url=https://www.whimpact.co/wh1nsights/automate-quote-line-item-retrieval-in-hubspot-with-zapier) In a [recent question on the HubSpot community forum](https://community.hubspot.com/t5/Tickets-Conversations/import-quotes/td-p/950638), Mr. Leo asked whether it's possible to retrieve line items associated with quotes in HubSpot. The good news is that it's possible. In this post, I'll guide you through the process of how to do it.   Here's how I retrieved line items from a quote, added them to a Google Sheet, and sent myself an email notification: 1. **Setting Up the Trigger in HubSpot**: First, you need a deal with associated line items and a quote. Once the quote is signed, the deal moves to a "Closed Won" stage, triggering an automation sequence. In HubSpot, create a quote-based workflow that activates when a quote is signed. You can set criteria for e-signature dates or manual signatures to initiate the workflow. 2. **Integrating with Zapier**: Once the quote is signed and the deal stage changes, this triggers a Zap in Zapier, which then executes the following tasks: - Retrieves the signed quote. - Fetches line items related to the deal. - Adds these line items to a Google Sheet. - Sends an email notification via Zapier, providing a link to the updated Google Sheet. 3. **Configuring the Automation**: - In Zapier, set the workflow to start when a deal reaches the "Closed Won" stage. - Use a "Find Association" step to link the deal ID with its associated quote. - Retrieve line items related to the quote using another "Find Association" step. 4. **Looping through Line Items**: Zapier's looping feature allows you to process multiple line items individually. For each line item, the following occurs: - The line item is retrieved and added to the Google Sheet. - Each line item's details are updated in the sheet, allowing for calculations like discounts. 5. **Final Steps and Notifications**: After processing all line items, if it's the last loop iteration, an email notification is sent. This email can be customized and sent through various platforms supported by Zapier. This automation not only streamlines the process of updating records after a deal closes but also ensures that all related documentation is kept up-to-date automatically. For those interested in deeper customization or using the HubSpot API directly, you can find more details in [the original community post](https://community.hubspot.com/t5/Tickets-Conversations/import-quotes/td-p/950638). This setup can be especially useful for integrating HubSpot with accounting platforms like Xero or QuickBooks to keep all business processes in sync. If you have any questions or need further assistance, feel free to reach out or comment below. Happy automating! [Systemize Your Busyness](https://www.whimpact.co/wh1nsights/tag/systemize-your-busyness) ## Related posts [![](https://www.whimpact.co/hs-fs/hubfs/2024.08.06_whinsight%20thumbnail.png?height=200&name=2024.08.06_whinsight%20thumbnail.png)](https://www.whimpact.co/wh1nsights/using-a-calculated-property-to-create-a-rollup-in-hubspot) [Systemize Your Busyness](https://www.whimpact.co/wh1nsights/tag/systemize-your-busyness) ## [Using a Calculated Property to Create a Rollup in HubSpot](https://www.whimpact.co/wh1nsights/using-a-calculated-property-to-create-a-rollup-in-hubspot) ![Picture of Ryan Schweighart](https://www.whimpact.co/hs-fs/hubfs/Chat_photo-1.jpg?width=50&name=Chat_photo-1.jpg) [Ryan Schweighart](https://www.whimpact.co/wh1nsights/author/ryan-schweighart) Aug 7, 2024 8:28:00 AM In this guide, we will walk through the steps to create a custom property in HubSpot that... [Read more](https://www.whimpact.co/wh1nsights/using-a-calculated-property-to-create-a-rollup-in-hubspot) [![](https://www.whimpact.co/hs-fs/hubfs/2024.07.10%20whinsight%20thumbnail.png?height=200&name=2024.07.10%20whinsight%20thumbnail.png)](https://www.whimpact.co/wh1nsights/how-i-created-a-deal-in-hubspot-with-line-items-automatically-associated-after-customer-purchase) [Systemize Your Busyness](https://www.whimpact.co/wh1nsights/tag/systemize-your-busyness) ## [How I Created a Deal in HubSpot with Line Items Automatically Associated after Customer Purchase](https://www.whimpact.co/wh1nsights/how-i-created-a-deal-in-hubspot-with-line-items-automatically-associated-after-customer-purchase) ![Picture of Ryan Schweighart](https://www.whimpact.co/hs-fs/hubfs/Chat_photo-1.jpg?width=50&name=Chat_photo-1.jpg) [Ryan Schweighart](https://www.whimpact.co/wh1nsights/author/ryan-schweighart) Jul 10, 2024 12:43:53 PM Hello, I’m Ryan Schweighart, founder of Whole Hart Impact, where I help organizations grow without... [Read more](https://www.whimpact.co/wh1nsights/how-i-created-a-deal-in-hubspot-with-line-items-automatically-associated-after-customer-purchase) [![](https://www.whimpact.co/hs-fs/hubfs/2024.05.22%20thumbnail.png?height=200&name=2024.05.22%20thumbnail.png)](https://www.whimpact.co/wh1nsights/customize-hubspots-help-desk-sidebar-to-conditionally-show-certain-properties) [Systemize Your Busyness](https://www.whimpact.co/wh1nsights/tag/systemize-your-busyness) ## [Customize HubSpot’s Help Desk Sidebar to Conditionally Show Certain Properties](https://www.whimpact.co/wh1nsights/customize-hubspots-help-desk-sidebar-to-conditionally-show-certain-properties) ![Picture of Ryan Schweighart](https://www.whimpact.co/hs-fs/hubfs/Chat_photo-1.jpg?width=50&name=Chat_photo-1.jpg) [Ryan Schweighart](https://www.whimpact.co/wh1nsights/author/ryan-schweighart) May 22, 2024 2:49:59 PM [Read more](https://www.whimpact.co/wh1nsights/customize-hubspots-help-desk-sidebar-to-conditionally-show-certain-properties) --- [![Whole Hart Impact Logo 43-2](https://www.whimpact.co/hs-fs/hubfs/Whole%20Hart%20Impact%20Logo%2043-2.png?width=266&height=200&name=Whole%20Hart%20Impact%20Logo%2043-2.png "Whole Hart Impact Logo 43-2")](https://www.whimpact.co) [![SolutionPartnerTierBadges_FINAL_PARTNER_ORANGE](https://www.whimpact.co/hs-fs/hubfs/SolutionPartnerTierBadges_FINAL_PARTNER_ORANGE.png?width=200&height=200&name=SolutionPartnerTierBadges_FINAL_PARTNER_ORANGE.png "SolutionPartnerTierBadges_FINAL_PARTNER_ORANGE")](https://app.hubspot.com/marketplace/20619232/solutions/whole-hart-impact) [![hubspot community champions logo](https://www.whimpact.co/hs-fs/hubfs/logos/hubspot%20community%20champions%20logo.png?width=170&height=170&name=hubspot%20community%20champions%20logo.png "hubspot community champions logo")](https://community.hubspot.com/u/rschweighart/summary) - [About WHI](https://www.whimpact.co/about) - [Get $500, Give $1,000 - WHIntroductions](https://www.whimpact.co/whintroductions) - [Pricing - WHImplementation](https://www.whimpact.co/whimplementation) - [Grow - WHIntensive](https://www.whimpact.co/whintensive) - [Learn - WHInsights](https://www.whimpact.co/wh1nsights) - [Careers - WHImpacters](https://www.whimpact.co/careers) ### I want to hear from you! [ryan@whimpact.co](mailto:ryan@whimpact.co) +1 (405) 972-6809 Located in Carlsbad, CA -- Available worldwide --- Copyright © 2026, Whole Hart Impact ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Ryan Schweighart", "url" : "https://www.whimpact.co/wh1nsights/author/ryan-schweighart" }, "dateModified" : "2025-08-04T22:15:03.370Z", "datePublished" : "2024-05-01T16:48:29.000Z", "headline" : "Automate Quote Line Item Retrieval in HubSpot with Zapier", "image" : [ "https://www.whimpact.co/hubfs/automating%20line%20item%20retrieval%20from%20quotes%20hubspot%20using%20zapier.png" ], "mainEntityOfPage" : { "@id" : "https://www.whimpact.co/wh1nsights/automate-quote-line-item-retrieval-in-hubspot-with-zapier", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.whimpact.co/hubfs/Whole%20Hart%20Impact%20Logo%2043-1.png" }, "name" : "Whole Hart Impact, LLC" } } ```