How to sort text from an Upsales order to Gmail message?

I want to generate an email (Gmail) with order details every time a new Upsales order has been registered. I’ve managed to trigger the email, but I can’t figure out how to sort the text in the email correctly. I want to pair each product with its correct location and time period, which is where I got stuck. Right now the email looks like this:

Upsales-ID: 1234
Key Account Manager: Jane Doe
Client: Client ABC
Products: Product 1,Product 2,Product 3
Location: Location 1,Location 2,Location1
Time period: 2023-10-04,2023-12-04,2023-10-04,2023-12-04,Week 42,44,46 and 50,2023-10-04,2023-12-04

I want to group Product 1 with Location 1 and the first time period (2023-10-04 → 2023-12-04), and so on, in the email. How do I sort and pair the text correctly?

Page 1 / 1

Hi @LenaMRo

Good question.

To help us have more context please post detailed screenshots with how your Zap steps are configured.

You’ll likely need to look into using the Formatter > Utilities > options for line items.

I’ve set up these steps in the Zap

Step 2 looks like this:

Step 3 looks like this

@LenaMRo

Try using this Zap action: Formatter > Utilities > Line Items to Text

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded