# How to send multi line data to Integromat? **URL:** \ **Category:** Ask for Help\ **Created:** [September 4, 2022, 9:50am UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545 "2022-09-04T09:50:10Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [September 4, 2022, 9:50am UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545/1 "2022-09-04T09:50:10Z")
![1662284677744](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/6/36211d823d66475b8ca29ea299ec55a0686a7666.jpeg) I have query data as in attached file and display by using DataGrid on Glide page. I tried to export these data to Google Sheet by using Integromat but it sent only first single line. Is it possible to export all these data by Integromat? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 4, 2022, 10:03am UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545/2 "2022-09-04T10:03:18Z")
Create a template column to join all the columns together, and then use a joined list column to combine all rows. > [@How To: CSV Export and send as email](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618): > > Below is a short tutorial that demonstrates how to generate a CSV export from Glide, and send it as an email attachment using Integromat. This uses the joined list technique that was originally described by @Purvang_Joshi [here](https://community.glideapps.com/t/export-glide-table-google-sheet-data-to-csv-using-joined-list-apps-script/27467). I hope others find it useful slight_smile ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [September 5, 2022, 3:05pm UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545/3 "2022-09-05T15:05:33Z")
The joined list can combine all data from many records. But it’s very difficult to separate data from rows back to its record. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 6, 2022, 12:48am UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545/4 "2022-09-06T00:48:43Z")
> [@paiboolk](#): > > But it’s very difficult to separate data from rows back to its record. Can you go into more details what’s the specific challenge here? ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [September 6, 2022, 1:55am UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545/5 "2022-09-06T01:55:15Z")
I have joined data look like this. item0001, pen, 10.00, item0002, pencil, 15.00, item0003, desk, 13.00 I would like Google Sheets to separate any item to be different row not just in a single cell. Thank you. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [September 6, 2022, 1:57am UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545/6 "2022-09-06T01:57:37Z")
Actually, I did it by copy data from Google Sheets to Excel. But it’s too many process. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 6, 2022, 2:05am UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545/7 "2022-09-06T02:05:38Z")
The delimiter on your joined list column should probably be New Line character instead of a comma. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [September 6, 2022, 2:08am UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545/8 "2022-09-06T02:08:12Z")
What is New Line character in Glide? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 6, 2022, 2:25am UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545/9 "2022-09-06T02:25:23Z")
Delete the comma in the Joined List configuration, and press the Enter key to create a new line…unless other people have a better suggestion or a different character sequence that they would suggest. I’m just guessing on this, since I’ve never done this myself. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 6, 2022, 2:39am UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545/10 "2022-09-06T02:39:27Z")
Yes, that’s the way to do it. And that’s covered in the tutorial that I linked to earlier in the thread. @paiboolk did you look at that? ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [September 6, 2022, 3:03am UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545/11 "2022-09-06T03:03:22Z")
I saw it already. But it can’t line up as required. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 6, 2022, 3:08am UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545/12 "2022-09-06T03:08:58Z")
You need to explain what “required” is in this context. A screen shot of what you get, and what you would expect to get, would be incredibly useful. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [September 6, 2022, 3:26am UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545/13 "2022-09-06T03:26:16Z")
I explained up there as… I have joined data look like this. item0001, pen, 10.00, item0002, pencil, 15.00, item0003, desk, 13.00 I would like Google Sheets to separate any item to be different row not just in a single cell. Thank you. My required display on Excel / Google Sheets is item0001, pen, 10.00 item0002, pencil, 15.00 item0003, desk, 13.00 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 6, 2022, 3:31am UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545/14 "2022-09-06T03:31:27Z")
Well, by following the instructions in the tutorial, the end result should have been a CSV file, which could then be opened directly in Google Sheets and converted to Google Sheet format. If you’ve pasted the data into an existing sheet and it’s all wound up in a single column, then you can probably fix that using Data → Split Text to Columns ![Screen Shot 2022-09-06 at 11.28.49 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/94d9c908216d79142ea0acc923e82022f185fad0.png) ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [September 6, 2022, 3:33am UTC](https://community.glideapps.com/t/how-to-send-multi-line-data-to-integromat/48545/15 "2022-09-06T03:33:22Z")
If you tried to split the data like that. All data will split to the column. Not to the row as I told. Thank you all. I solved it out already.