[1662284677744] 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?

Create a template column to join all the columns together, and then use a joined list column to combine all rows. [image] How To: CSV Export and send as email Community Resources Below is a short tutorial that demonstrates how to generate a CSV export from Glide, and send…

The joined list can combine all data from many records. But it’s very difficult to separate data from rows back to its record.

[image] 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?

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.

Actually, I did it by copy data from Google Sheets to Excel. But it’s too many process.

The delimiter on your joined list column should probably be New Line character instead of a comma.

What is New Line character in Glide?

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.

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?

I saw it already. But it can’t line up as required.

How to send multi line data to Integromat?

Ask for Help

Darren_Murphy September 4, 2022, 10:03am 2

Create a template column to join all the columns together, and then use a joined list column to combine all rows.

Topic		Replies	Views
How To: CSV Export and send as email Community Resources tutorial	29	4797	August 2, 2023
Join List > Integromat > Create CSV Ask for Help	22	2294	August 12, 2021
How to export more than first row in table via Integromat to Google Docs Ask for Help	24	1155	May 30, 2023
Is it possible to add multiple rows with Joined list? Ask for Help	1	672	March 26, 2022
Export Glide Table/ Google Sheet Data to CSV using Joined List & Apps Script Project Showcase	12	4033	February 1, 2024

How to send multi line data to Integromat?

Related topics