About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Extracting metafield data from Shopify to Google Sheets

  • 2 September 2020
  • 3 replies
  • 429 views
Z
Userlevel 1

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

 

icon

Best answer by Liz_Roberts 5 November 2020, 14:53

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.

3 replies

Z
Userlevel 1

Anybody?

Liz_Roberts
Userlevel 7
Badge +8

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!

Wemakefuture
Userlevel 6
Badge +7

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

https://www.wemakefuture.com/
Terms & Conditions