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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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.

  • Home
  • Get Help
  • How Do I
  • How do I split the Stripe fee test into two columns of Google Sheets in a specific order?
Question

How do I split the Stripe fee test into two columns of Google Sheets in a specific order?

  • 26 September 2023
  • 10 replies
  • 58 views
J

Hey all!

I have two different customers, Customer A and Customer B.

Customer A their Stripe Fee test data is being displayed as this:

 



Customer B their Stripe Fee test data is being displayed as this:



Both are in a different order as you can see. This is annoying as I'm adding this Data to a Google Spreadsheet.

 

This is what I want to do:

Put application_fee in column 1 and put stripe_fee in column 2 next to each other in a Google Spreadsheet.

 

I'm splitting these two currently using Two Format Actions, (One called Application Fee and only picks the first part of the list, and second one is called Stripe Fee and picks the last part of the list) but this does not work for all payments because the order is different.

 

How can I make this work so that the order always stays the same? application_fee first and than stripe_fee.


Thank you for your help!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

10 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @julienvandorland 

Good question.

This can be handled via these options:

  • Formatter > Line Items > options
  • Code
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J

Hey @Troy Tessalone 

Do you mean this with Line Items?

46abbee73d94c399db623de246aa8e85.png

Troy Tessalone
Userlevel 7
Badge +14

@julienvandorland 

You’ll likely have to use custom Code in order to sort the items in an array.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J

Hey @Troy Tessalone 

Will have a look into your post. Thanks!

J

Hey @Troy Tessalone 

I got the data, and than split it into the first part and second part. Then Line Itemizer to add a property value of A and B to the parts but it doesn't seem to work. What am I missing here?

Tried removing .reverse() as well, but without any luck to sort them.

2973e3e011a86e7c432054d797e734cf.png

 

Troy Tessalone
Userlevel 7
Badge +14

@julienvandorland 

1 Code step can be used to replace the 3 Formatter steps.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Troy Tessalone
Userlevel 7
Badge +14

@julienvandorland 

Try asking ChatGPT for help with the custom code.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J

Hey @Troy Tessalone 

I asked Chatgpt for a solution, had some code to sort it but figure it wouldn't work for this.

 

So what I did was adding a conditional path. I check if it starts with the letter S, from stripe_fee, than I proceed to input the Data in my spreadsheet with stripe_fee first, and the other way around too.

J

Hey @Troy Tessalone 

Ok well, this makes no sense.

Why would it pass?

eac1bbcc98a571b26ec20bc0f0956b6d.png
 

Troy Tessalone
Userlevel 7
Badge +14

@julienvandorland 

The value you are passing in on the left side is an array, not a string of text.

You can add a Formatter > Utilities > Line Items to Text step to flatten the array to be a string.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions