Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I am trying to automatically add a row to a Google Sheet after a new order is created in Shopify. Most of the data I need is stored in a note which is passed on as one cohesive data point.

I used formatter to break into separate outputs that I can pull into individual fields in the spreadsheet, but I am not seeing all the output options created by the formatter when I try to match from formatter to spreadsheet.

Below are screenshots of my data in and my data out. I tried to block out any sensitive data. What am I doing wrong? I can’t seem to be able to pull most of the data I separated out through the formatter. See the third screenshot of my options. I can’t seem to, for example, pull 3 Output Item 1.

 

 

 

Hi ​@JonathanF 

Nested data points can be tricky to work with in Zaps.

Help us have more info by posting these screenshots:

  • How your Formatter Zap step is configured in EDIT mode with the field mappings visible
  • In Zap step 1, in the TEST section, how the Notes data point is returned from Shopify that you are trying to use in Zap step 2

Hi ​@Troy Tessalone ,

 

Here is what it looks like in Shopify:

 

Not sure what you mean by edit mode in the formatter step. When I click edit, it looks like my screenshot but the fields are editable.

​@JonathanF 

From Shopify, the Notes Attributes is an array of objects.

Array is indicated by the #s. (e.g. 1, 2, 3, etc.)

Objects are indicated by the keys/values within each array item. (e.g. Name, Value)

 

Follow this related guide to get your data points as their own custom variables to map.

  • Action: Formatter > Utilities > Line Items to Text
  • Action: Code > Run JavaScript

 

Thank you ​@Troy Tessalone - I was able to use Line Items to Text without code and it looks like it’s working.

Wow! Thank you for confirming that Troy’s resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.

Reply


Terms & Conditions