This article explains how to send text that has been retrieved in a comma-separated format (list format) and insert line breaks when sending it through Gmail or Yoom mail.

You can use this method when sending text or messages created in a spreadsheet,

as shown in the screenshot below ⬇️.

⬇️ Here is an overall image of the Flowbot.

We will walk you through each step below!

Go to your Flowbot edit screen.

Select the app (for this example, Google Sheets) and select the retrieved value under the "Integrate with apps" action, and retrieve the message data from the selected range of cells.

Run a test to confirm that the request has been successful.

You should see that the retrieved values are currently in comma-separated format (as shown by the red line).

Since this will be sent directly to Gmail or Yoom Mail in its current format, we will correct the data in the next step.

Next, under the data transformation action list, select Data Conversion.

Set it up as follows, then run a test and save the configuration:

Select Gmail (for this example) and select Send Email as the action.

Set the output you created in step 2 as the message content, and you're all set!

Here's an example of the configuration.

Please note that in the test-send screen, the line breaks won’t appear yet because the code hasn’t been applied.

However, the line breaks will be visible in the actual email.

Preview screen ⬇️

Sample received email ⬇️

That's it!

You've now learned how to insert line breaks and send an email with text that was retrieved in a comma-separated format. 🎉