# How To: CSV Export and send as email **URL:** \ **Category:** Community Resources\ **Tags:** tutorial\ **Created:** [September 10, 2021, 3:39pm UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618 "2021-09-10T15:39:51Z")\ **Posts on this page:** 20\ **Page:** 1
**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 10, 2021, 3:39pm UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/1 "2021-09-10T15:39:51Z")
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 🙂 https://www.loom.com/embed/099399914bd849c4b3769100aaf9490b * * * _If the above video won't play, paste the below link into a browser._ ```auto https://www.loom.com/share/099399914bd849c4b3769100aaf9490b ``` ---
**Author:** ![Purvang\_Joshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/purvang_joshi/32/12645_2.png) [@Purvang\_Joshi](https://community.glideapps.com/u/Purvang_Joshi)\ **Post date:** [September 10, 2021, 4:15pm UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/2 "2021-09-10T16:15:41Z")
Awesome… 👍 ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [September 10, 2021, 9:10pm UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/3 "2021-09-10T21:10:11Z")
Great one!!! ---
**Author:** ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)\ **Post date:** [September 10, 2021, 11:16pm UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/4 "2021-09-10T23:16:28Z")
That is super handy! Thanks ---
**Author:** ![Luther](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luther/32/17929_2.png) [@Luther](https://community.glideapps.com/u/Luther)\ **Post date:** [September 11, 2021, 11:34am UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/5 "2021-09-11T11:34:15Z")
This is Super @Darren_Murphy. Thank you for sharing 🤗. Its gonna come in handy for one of my projects. ---
**Author:** ![Luiz\_Rai](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luiz_rai/32/7093_2.png) [@Luiz\_Rai](https://community.glideapps.com/u/Luiz_Rai)\ **Post date:** [June 16, 2022, 2:08am UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/6 "2022-06-16T02:08:42Z")
I couldn’t replicate the column name part, could you help me? ---
**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:** [June 16, 2022, 2:24am UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/7 "2022-06-16T02:24:50Z")
Can you elaborate a little, please? Which column, which name? Do you have a screen shot? ---
**Author:** ![Luiz\_Rai](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luiz_rai/32/7093_2.png) [@Luiz\_Rai](https://community.glideapps.com/u/Luiz_Rai)\ **Post date:** [June 16, 2022, 2:42am UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/8 "2022-06-16T02:42:05Z")
As you can see the columns are not named, example “name” “date” ![Screenshot 2022-06-15 at 23-39-56 JULHO - lzraybrazil@gmail.com - Gmail](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/701ae142b741332841d2705c8e982f9bf2face33.png) ---
**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:** [June 16, 2022, 2:45am UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/9 "2022-06-16T02:45:58Z")
Is that screenshot from your Google Sheet? The first row in your spreadsheet must contain the column headers. Just insert a row at the top and add them in. ---
**Author:** ![Luiz\_Rai](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luiz_rai/32/7093_2.png) [@Luiz\_Rai](https://community.glideapps.com/u/Luiz_Rai)\ **Post date:** [June 16, 2022, 2:47am UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/10 "2022-06-16T02:47:56Z")
No, this is the generated CSV file, I would like the column titles to be included in it ---
**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:** [June 16, 2022, 2:54am UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/11 "2022-06-16T02:54:54Z")
oh! hahah… Okay, so it looks like you are missing the header row in your template, or it might not be defined properly. So that’s what you should check. If you can’t identify where it’s wrong, please show me how you have it configured. ---
**Author:** ![Luiz\_Rai](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luiz_rai/32/7093_2.png) [@Luiz\_Rai](https://community.glideapps.com/u/Luiz_Rai)\ **Post date:** [June 16, 2022, 3:18am UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/12 "2022-06-16T03:18:42Z")
**1st I created a template to gather the information.** ![01](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/5/35d9d066f4c76d679a67f01378738fcb59c880c9.jpeg) **2nd I created a joined list to be able to use the webhook** ![02](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/5/a5e5d53cb722654d76af586d973aac166d4fa9ed.jpeg) **3rd I configured the webhook to pull the data from the joined list.** ![03](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/3/139cffbe5ebae7900dd6ccb1caecda05f9daf5fa.jpeg) ---
**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:** [June 16, 2022, 3:24am UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/13 "2022-06-16T03:24:50Z")
Yes, you are missing a template column for the header row. If you go back and look at my video, I talk about this at 6:08 ---
**Author:** ![sschafbuch](https://avatars.discourse-cdn.com/v4/letter/s/a88e57/32.png) [@sschafbuch](https://community.glideapps.com/u/sschafbuch)\ **Post date:** [January 30, 2023, 9:00pm UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/14 "2023-01-30T21:00:07Z")
@Darren_Murphy, this is really helpful. I created a separate table in glide with my subject, body, and data. When setting up my webhook action, I don’t know how to pull from the separate glide table I created. It automatically pulls from the table with all the user data. Should I just create extra columns in that single table? I think I’m missing something. ![Screenshot 2023-01-30 at 2.52.21 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/9/193c8ae203eeb5a19318056f88695d773bcd9fa9.png) ---
**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:** [January 31, 2023, 12:21am UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/15 "2023-01-31T00:21:17Z")
> [@sschafbuch](#): > > I created a separate table in glide with my subject, body, and data. Is there a reason you want to create a separate table for this? Can you show us the data structure you currently have? ---
**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:** [January 31, 2023, 1:51am UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/16 "2023-01-31T01:51:22Z")
> [@sschafbuch](#): > > It automatically pulls from the table with all the user data. Sounds like the source of your screen is your Users Table? You would either need to change the source of your screen to use the Helper Table, or alternatively use Single Value columns to “copy” those columns from your Helper Table to your Users table. ---
**Author:** ![sschafbuch](https://avatars.discourse-cdn.com/v4/letter/s/a88e57/32.png) [@sschafbuch](https://community.glideapps.com/u/sschafbuch)\ **Post date:** [February 1, 2023, 3:32pm UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/17 "2023-02-01T15:32:49Z")
Thank you for the response, ThinhDinh. I am new to glide and was following Darren’s video step by step and saw he used a separate table. I went ahead and just added extra columns. Thanks. ---
**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:** [February 1, 2023, 3:35pm UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/18 "2023-02-01T15:35:12Z")
Yes, strictly speaking the Helper Table isn’t actually required. Personally, I tend to use them quite a bit as they create a natural separation of concerns and keep my data tables cleaner. But at the end of the day, it mostly comes down to personal preference. ---
**Author:** ![gendelmanliudmila](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gendelmanliudmila/32/51068_2.png) [@gendelmanliudmila](https://community.glideapps.com/u/gendelmanliudmila)\ **Post date:** [February 18, 2023, 2:20pm UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/19 "2023-02-18T14:20:09Z")
Thank you very much for the tutorial! That was really verey very helpful. I have only one question left and can’t understand what you are saying there. Which separater do you use (in tutorial 6’03’') to put each row on a separate line? Thanks a lot beforehand! ---
**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:** [February 18, 2023, 2:22pm UTC](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/20 "2023-02-18T14:22:01Z")
Carriage Return Line Feed (CRLF), which is just the “Enter” key on your keyboard. [Next page](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618.md?page=2)