Feed the product library from a Google Sheets price list
Keep prices in the sheet you already maintain. Add a row or change a price, and a Zap creates or updates the matching product in QuoteCloud, ready for the next quote.
- 5/5 on G2
- 4.2 on Capterra
- Building QuoteCloud since 2013
Build a Zap with QuoteCloud's Zapier app, on Essentials and up. Google Sheets' New or Updated Spreadsheet Row, watching the Price column, starts it. QuoteCloud's Find Product looks the SKU up, and Create Product updates that product, or creates a new one, with the row's name, folder, SKU and price. Documents already sent keep their prices.
Last reviewed by the QuoteCloud team
Two overlapping panels with sample data. Behind, Tanbark Trade Supply's product library in QuoteCloud: six products with SKU, category, unit, price and status; the 12 oz double-wall hot cup now at $71.00. In front, an illustration of Tanbark's 2027 price list in Google Sheets, the Products tab, where the hot cup's price was just changed from $68.00 to $71.00.
Why keep the price list in a sheet?
Tanbark Trade Supply's e-commerce manager, Dev Malhotra, already keeps the trade price list in Google Sheets: it feeds the website, the buyers check it, and the costs sit on a tab only the directors see. Keeping a second copy of every price in QuoteCloud by hand meant the two drifted apart.
Now the sheet is the one place prices change. When Dev adds a product or changes a price, a Zap creates or updates the product in QuoteCloud's product library, so the next quote Owen builds uses the new price.
- The SKU is the key: the Zap finds the product by it before updating.
- Costs stay in the sheet. The product library gets the sell price, name, folder and SKU.
- Documents already sent keep the prices they were created with.
How does a price change reach QuoteCloud?
Three steps: watch the Price column, find the product by SKU, then update it or create it.
ZapPrice list row changed: update the product
-
When
Google SheetsTriggerNew or Updated Spreadsheet RowOn the Products worksheet, with Price as the trigger column. New rows always trigger.Passes on
- SKU
- Line item name
- Folder
- Unit
- Price
- Published
-
Then
QuoteCloudSearchFind ProductSearch By SKU. Set Zapier to carry on if nothing is found, so new products are created.Searches on
- Search By: SKU
- SKU or Product ID
-
Then
QuoteCloudActionCreate ProductWith the product ID from Find Product it updates that product; without one it creates a new product.Mapped in
- QuoteCloud Product Id
- Product Short Name (Unique)
- Folder Name
- Pricing Table Line Item Name
- Product SKU
- Price
- Published Product
Create Product's yes/no settings, such as Recipients Can Edit Quantity and Lock Pricing Value, are required: set them once in the Zap. Use the SKU as the Product Short Name (Unique) so every product's short name stays unique.
Dev changes the 12 oz hot cup from $68.00 to $71.00 on Thursday afternoon. Find Product finds TT-CUP12; Create Product updates it. When Owen adds hot cups to a quote on Friday, the library gives $71.00.
Result
QuoteCloud's product library follows the price list, product by product, without a second round of typing.
Essentials and up (API & Zapier, Product Library) · products aren't documents: no per-document fee
How wholesalers manage trade pricesThe price list and the product library, side by side
Dev's Products tab, beside the QuoteCloud library the Zap keeps up to date.
| Product | Price | Unit | Cost | Margin | Status |
|---|---|---|---|---|---|
| 12 oz double-wall hot cup, kraftTT-CUP12 · Cups & lids | $71 | Carton (500) | — | — | Active |
| 90 mm sip lid, blackTT-LID90 · Cups & lids | $42 | Carton (1000) | — | — | Active |
| Kraft takeaway box, mediumTT-BOXM · Takeaway | $54 | Carton (200) | — | — | Active |
| Kraft SOS bag, size 12TT-BAG12 · Takeaway | $39 | Carton (500) | — | — | Active |
| 2-ply dinner napkin, whiteTT-NAP2P · Takeaway | $46 | Carton (2,000) | — | — | Active |
| Nitrile gloves, mediumTT-GLVM · Cleaning | $59 | Carton (1,000) | — | — | Draft |
Cost and margin are for your team only: they never appear in the client's document
Zap
- New or Updated Spreadsheet Row
- Find Product
- Create Product
| SKU | Line item name | Folder | Unit | Price | Published |
|---|---|---|---|---|---|
| TT-CUP12 | 12 oz double-wall hot cup, kraft | Cups & lids | Carton (500) | $71.00 (updated by a Zap) | Yes |
| TT-LID90 | 90 mm sip lid, black | Cups & lids | Carton (1000) | $42.00 | Yes |
| TT-BOXM | Kraft takeaway box, medium | Takeaway | Carton (200) | $54.00 | Yes |
| TT-BAG12 | Kraft SOS bag, size 12 | Takeaway | Carton (500) | $39.00 | Yes |
| TT-NAP2P | 2-ply dinner napkin, white | Takeaway | Carton (2,000) | $46.00 | Yes |
| TT-GLVM | Nitrile gloves, medium | Cleaning | Carton (1,000) | $59.00 | No |
- Products
- Costs
- Changes
Cell updated by a Zap
The sheet is our illustration of a generic spreadsheet with sample data, not Google's screen. Every business here is fictional.
Which column fills which product field?
The Create Product fields, with the values from the hot cup's row.
| Google Sheets: Google Sheets column | Direction | QuoteCloud: QuoteCloud product field | Goes into | Example (sample data) | Note |
|---|---|---|---|---|---|
| Finding the product (Find Product) | |||||
| SKU | Google Sheets to QuoteCloud | SKU or Product ID | Search value | TT-CUP12 |
Search By: SKU. Must match exactly. |
| The product (Create Product) | |||||
| (from Find Product) | Google Sheets to QuoteCloud | QuoteCloud Product Id | Product field | the found product's ID |
Blank for a new SKU, so a new product is created. |
| SKU | Google Sheets to QuoteCloud | Product Short Name (Unique) | Product field | TT-CUP12 |
Required. Keep it unique. |
| SKU | Google Sheets to QuoteCloud | Product SKU | Product field | TT-CUP12 |
|
| Line item name | Google Sheets to QuoteCloud | Pricing Table Line Item Name | Product field | 12 oz double-wall hot cup, kraft |
What the client sees in the price table. |
| Folder | Google Sheets to QuoteCloud | Folder Name | Product field | Cups & lids |
Required. |
| Price | Google Sheets to QuoteCloud | Price | Product field | 71.00 |
Required. A plain number. |
| Unit | Google Sheets to QuoteCloud | Description | Product field | Carton (500) |
Shown under the line item. |
| Published | Google Sheets to QuoteCloud | Published Product | Product field | Yes |
No = the product stays in draft. |
| Image URL (optional column) | Google Sheets to QuoteCloud | Product Image 1 | Product field | a public JPG or PNG link |
QuoteCloud downloads and stores it, up to 15 MB. |
Costs and margins stay in your sheet. All values are sample data.
Variations for the price list
A changes log, sub folders, images, or the Make route.
Log library changes
A second Zap on QuoteCloud's Product Changed trigger can add a row to a Changes tab. Point it at a different tab from the one the first Zap watches.
Sub folders
Map Sub Folder and Sub Folder 2 from columns when your range has more than one level, such as Cups & lids, then Hot cups.
Product images
Add an image URL column and map it to Product Image 1. QuoteCloud downloads the image into the product library.
Build it in Make instead
Bring your own: watch the sheet with Make's own Google Sheets modules and call QuoteCloud's API or Zapier endpoints through Make's built-in OAuth connection.
Point a copy of your price list at QuoteCloud
QuoteCloud's Zapier app and product library are on the Essentials plan and up. Start a free 14-day trial and test with three rows.
Build the price-list Zap in five steps
Tidy the sheet
One row per product, a header row, a unique SKU in every row, and prices as plain numbers.
Watch the Price column
In Zapier choose Google Sheets' New or Updated Spreadsheet Row on the Products worksheet, with Price as the trigger column.
Find the product
Add QuoteCloud's Find Product, Search By SKU, and let the Zap carry on when nothing is found.
Create or update it
Add Create Product with the product ID from Find Product and map the name, folder, SKU, price and published flag. Set the yes/no options once.
Test, then turn it on
Change one test product's price, check it in QuoteCloud's product library, add a new test row, then switch the Zap on.
Questions about the price list
Will changing a price in the sheet change quotes already sent?
No. The Zap updates the product in QuoteCloud's product library, so new quotes use the new price. Documents already created keep the prices they were built with; revise a document in QuoteCloud if a client needs the new price.
How does the Zap know which product to update?
By the SKU. QuoteCloud's Find Product searches by SKU, and Create Product updates the product whose ID it found. Create Product's own help text also says to keep each Product Short Name (Unique) unique so products update; using the SKU as the short name does that.
Can I import my whole price list at once?
The Zap handles products one row at a time as they're added or changed. For a first load of hundreds of products, QuoteCloud's product library imports a CSV with column mapping; export the sheet as CSV, import it, then let the Zap keep it current.
Do product updates carry the per-document fee?
No. The fee applies only to documents created through Zapier or the API. Creating and updating products doesn't create documents, though each run uses a task on your Zapier plan. QuoteCloud's Zapier app and product library are on Essentials and up.
More on QuoteCloud and Google Sheets
Six use cases with the exact Zapier steps, then how to connect, test and what it costs.
- Log every quote event in Google SheetsSent, viewed, signed, paid and expired: each QuoteCloud event adds a row, and sheet formulas turn the log into a report.
- Keep a quote pipeline tracker in Google SheetsOne row per quote: a Zap adds it when the document is created and updates its status as it changes.
- Create quotes from Google Sheets rowsA new row creates the document from your template, with the row's details in data items and price-table rows.
- Fill a price table from Google Sheets linesOne sheet row per product line: a Zap looks the lines up and adds them to the new quote's price table.
- Google Sheets or QuoteCloud's Spreadsheet block?Two different spreadsheets: your Google Sheet outside, the Spreadsheet block inside the quote, and how a Zap reaches each.
- Connect Google Sheets to QuoteCloud, step by stepCheck the plan, set up the sheet's header row, connect both apps in Zapier and test your first Zap.
- Google Sheets column mapWhich column each Zap on this site writes or reads, which way it travels and a sample value.
- Test and troubleshoot the Google Sheets ZapsTest with a copy of the sheet, then fix the usual problems: no row found, blank columns, duplicate documents.
- What QuoteCloud with Google Sheets can and can't doWhat the Zaps do, where they stop, Zapier or Make, and what we haven't confirmed yet.
- What the Google Sheets connection costsEssentials and up for Zapier, plus a fee only for documents a Zap or the API creates. Logging rows is free.
- FAQAnswers to the questions teams ask before connecting QuoteCloud and Google Sheets.
Change the price once.
Start a free 14-day trial, point the Zap at a copy of your price list and test with a few products.