Skip to main content
Best answer

Writing multiple records to an Airtable Base

  • September 9, 2020
  • 4 replies
  • 350 views

sardamit
Forum|alt.badge.img

How can I write all line items in an order to an Airtable base?

 

Imagine a Shopify Order that contains multiple line items.

I want to write all these line items to an Airtable base with each line item on its own line.

 

Any insights are highly appreciated.

Best answer by andywingrave

@sardamit I don’t think a code step will do this :sweat_smile:

The best workaround I’ve used for this is to send to a Google Sheet and send those to Airtable.

So...Send as line items to Google sheets, and then create a new zap with the trigger being new line in Google sheets, which you can send to Airtable.

Good news is that I know there’s something in the works from Zapier to handle this with a native app.

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31067 replies
  • September 10, 2020

ADVANCED

Create a looping Zap with Code, Filter, Webhook steps to cycle thru each line item.


Liz_Roberts
Forum|alt.badge.img+8
  • Zapier Staff
  • 1366 replies
  • December 7, 2020

@Troy Tessalone can you provide an example of the code @sardamit would need to use here?


Troy Tessalone
Forum|alt.badge.img+14

@Liz_Roberts I don’t have the exact code to provide as I have not solved for this exact scenario, but I’ve done many implementations of a Zap that uses the mentioned apps to create a looping Zap.


andywingrave
Forum|alt.badge.img+9
  • Zapier Expert
  • 854 replies
  • Answer
  • December 13, 2020

@sardamit I don’t think a code step will do this :sweat_smile:

The best workaround I’ve used for this is to send to a Google Sheet and send those to Airtable.

So...Send as line items to Google sheets, and then create a new zap with the trigger being new line in Google sheets, which you can send to Airtable.

Good news is that I know there’s something in the works from Zapier to handle this with a native app.