I am probably missing something very obvious here but any help would be greatly appreciated, as I have been trying for hours. I have a billing statement that uploads to Google Sheets, from there I have it create a 2nd worksheet and under that is where it sums up certain line items to use in QuickBooks invoices.

For example, 2nd Worksheet would have headers such as “Shipping” “Services” “Returns” and under those would be the sum of the total charges of all the rows that had those columns (for type of charge) in Worksheet 1. 

Now when I try to create an invoice in QuickBooks Online it says Line Item support and shows line items but it only lets me select 1 line item. Am I missing something?

I have tried using formatter to create line items, I tried using Get Many Rows in the Google Sheets actions to output line items, etc. But I can’t figure out how to properly use them in the QuickBooks Zap to make it actually break the line items out properly on the Invoice. It either breaks them out incorrectly or just uses “Amend” instead of the charge type, etc.

Any help would be greatly appreciated.