Best answer

How do I send Xero invoices to Airtable without using Google Sheets as an intermediary for line items?

  • 12 April 2022
  • 5 replies
  • 38 views

Userlevel 1

Hey guys,

 

I currently zap new invoices to google sheets in a line item format and then from google sheets to airtable. 

 

I tried using the Utilities action to do it, but it is only sending the first line item on the invoice to airtable. Does anyone know a way I can just send it straight to Airtable or do I need to continue using google sheets as intermediary?

icon

Best answer by Troy Tessalone 12 April 2022, 16:43

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Userlevel 7
Badge +14

Hi @mari 

Good question.

The Looping app can be used to handle line items: https://zapier.com/apps/looping/help

Help article about using line items in Zaps: https://zapier.com/help/create/basics/use-line-items-in-zaps

Userlevel 1

Hey @Troy Tessalone 

I have tried that, but it’s not working properly. It’s only creating the record for the first loop (first line item)

Userlevel 7
Badge +14

@mari 

Per the Looping help article: https://zapier.com/help/create/other-functions/loop-your-zap-actions

 

Userlevel 1

Yup! haha It is working perfectly now :) thank you very much!!! 

Userlevel 7
Badge +9

Thanks for looping ( 😉 ) back around to keep us updated on what worked for ya, @mari