Help to transform line of data to string but we can set number of set data perstring

Screenshot 2024-08-21 183927

hye guys, need your help

the data shown on the attachment

the data from google sheet ( sheet name : Semua data)

I want to email it based on this format

peremail will be 5 data

Email A

|1|z|a|
|2|y|b|
|3|x|c|
|4|w|d|
|5|v|a|

email B

|6|t|b|
|7|z|a|
|8|y|b|
|9|x|c|
|10|w|d|
|11|v|a|

and soo onn…
each email be comprised of 5 set of data.

need your help on this problem.

So what makes the first email only have 5 rows, and the second 6?

1 Like

I’m sorry. just 5 row only.

i want to add 5 rows in one string. (row 1 - 5)
email 2 row 6-10
email 3 row 11-15 and so on. i have around 4000 data. Do you have idea for this automotion?

Welcome to the Make community!

Yes, that is possible. You’ll need a minimum of three modules:

This is just an example. Your final solution may or may not look like this depending on your requirements.

Example Input

Example Output

Hope this helps! Let me know if there are any further questions or issues.
Note: I see hundreds of posts, notifications, and messages daily on this forum, so if I missed your reply, please message me to look at your reply.

@samliew


P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!

2 Likes

Thank you for your tips on this one SamLiew. Really appreciate it :pray: