Skip to main content
Best answer

Troubleshooting data transfer from Shopify to Google Sheets using Text Formatter

  • December 12, 2024
  • 5 replies
  • 22 views

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.

 

 

 

Best answer by Troy TessaloneBest answer by Troy Tessalone

@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

 

View original
Did this topic help you find an answer to your question?

5 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31068 replies
  • December 12, 2024

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

  • Author
  • New
  • 2 replies
  • December 12, 2024

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.


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31068 replies
  • Answer
  • December 12, 2024

@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

 


  • Author
  • New
  • 2 replies
  • December 12, 2024

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


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2394 replies
  • December 13, 2024

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.