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!
Best answer by briansballoonsView original