I'm trying to get the creation of a new invoice in QuickBooks to trigger the updating of a Google Sheet, so that every row in the sheet's "Product" column that matches a product name in a line of the invoice gets that line's quantity added to the next column over, the "Count" column. For instance, if I make an invoice for 2 of Widget A and 3 of Widget B, the zap finds the Widget A and Widget B columns I have set up in the sheet, and then in the next columns over, adds 2 and 3 respectively to the "Count" cells.
I've managed to set this up fine when there's only 1 product on the invoice, but when I go to use Line Items in my GS action - Find Many Spreadsheet Rows (With line item support) - there's no section for line items! I made sure I selected the QB trigger New Invoice (With line item support), even though weirdly enough the "line item" part of that title doesn't show up in the outline.
For what it's worth, I've also tried using Line Itemizer to separate out my values but they still show up in my Lookup Value as one comma-separated value, which of course doesn't match any cell of the spreadsheet. Any leads would be appreciated! Still relatively new so could be missing an obvious logical step or something.
Best answer by PaulKortman
View original