Best answer

Writing multiple records to an Airtable Base

  • 9 September 2020
  • 4 replies
  • 317 views

Userlevel 1
Badge

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.

icon

Best answer by andywingrave 13 December 2020, 23:19

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.

4 replies

Userlevel 7
Badge +9

@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.

Userlevel 7
Badge +8

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

Userlevel 7
Badge +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.

Userlevel 7
Badge +14

ADVANCED

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