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.

Hi,

 

I’ve been stuck for days on this and am not sure how to do this. 

What I’m trying to do:

  1. Each time a new order from Shopify comes in, create a new row in a sheet in a specific Google Sheets file
  2. From Shopify order, pull metafield data that is delimited (not properly formatted because I am utilsing an app to customise fields)
  3. Then insert each of the formatted metafield data point (after proper formatting) into each of the specific cells in Google Sheets

Issue

I am able to get point 1 up easily.

For 2, I use Formatter and got screenshot 1 below which seems to looks OK. It looks strange though, that after “0:”, it continues with “0:” again.

For 3, I have issues with it. With reference to screenshot 2 below, I can’t seem to see the nicely broken down line items I see in screenshot 1, for utilisation in the “Type or Insert” fields. All I see is the jumbled up unformatted full line item. 

How am I able to do this correctly, such that I can correctly utilise the outputs from the Formatter?

 

Thanks!

 

 

Screenshot 1

 

 

Screenshot 2

 

Anybody?

Hi @zhhan ,

Checking in here as I see you were working with Support on this Zap. It looks like you were able to use the using the Split Text function within Formatter to solve this issue! Let our team know if you have any additional questions- always happy to help!

@zhhan do you still need help on it? We could help you out with some custom code.

Terms & Conditions