How can I get Quickbook Line Items into Google Calendar?

Question

I want to create a Google Calendar Detailed Event description field containing some of the line item fields from a Quickbooks online invoice.

Quickbooks is sending me a line item variable for each field:

Since Google Calendar doesn’t support line items, how can I combine these fields and add them all to my calendar description field? I managed to have Zapier output selected fields to a Google sheet like thus:

But when I try to use this in the calendar step it only has input data options for the first row created:

There can be a variable amount of line items in each invoice (won’t always be 3). Google sheets isn’t necessarily required if there is another way of getting this done.

Help is much appreciated!

icon

Best answer by briansballoons 10 September 2020, 22:45

View original

briansballoons · Accepted Answer

The Line Itemizer still isn’t quite what I needed as it still just creates separate line item lists for each field. Perhaps I’m not using in correctly.

I did stumble upon a solution that works, though. Apparently you can add multiple line items to the Line-item to text function, and then separate them. I can’t quite wrap my head around WHY it works... but it does what I need!

That gives me this output:

Then I use a Formatter Text Replace function to strip out the remaining commas and I’m good to go.

Thanks!

Troy Tessalone · Answer

Try this App: Formatter - Utilities - Line ItemizerArticle: https://zapier.com/help/create/format/create-line-items-in-zaps#line-itemizer

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded