# How to export more than first row in table via Integromat to Google Docs

**URL:** <https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804>\
**Category:** Ask for Help\
**Created:** [October 15, 2022, 4:45pm UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804 "2022-10-15T16:45:22Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Daniel\_Lof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_lof/32/48029_2.png) [@Daniel\_Lof](https://community.glideapps.com/u/Daniel_Lof)\
**Post date:** [October 15, 2022, 4:45pm UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/1 "2022-10-15T16:45:22Z")

</div>

Feels like I’m missing something quite apparent here in my efforts to create a simple export of a table (page) content.

I have a restaurant menu grouped by category. Looks ace on glide pages. Customer needs to create pdf of this from time to time and send it to his clients.

So I created a button, created a webhook. Connected it to Make and created a flow so that it via [[params]] writes data to a google docs template. As I would like to construct a template for this food menu using the data coming from the glide page, I am having issues, as only the first row is shown in the document itself (so the connection works kind of)…

 ![Skärmavbild 2022-10-15 kl. 19.39.33](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/9/69d5973c70e55b14df4be05093aa7be8d7234ddf.jpeg)  
 ![Skärmavbild 2022-10-15 kl. 19.40.25](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/57c7162a9884f8ffbf10a55c98de265e8c72029b.png)  
 ![Skärmavbild 2022-10-15 kl. 19.40.01](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/d/5d694a126821e609189ff72ca5461a76585630ad.jpeg)  
 ![Skärmavbild 2022-10-15 kl. 19.39.46](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/5166225624a8030d7d8720a54bdfab70d08d57a2.jpeg)

Attaching some screeshots of the setup. I must be getting something wrong. Any guidance, pointers are appreciated. Have a nice weekend everyone!

 ![Skärmavbild 2022-10-15 kl. 19.47.57](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/4/a48d6ced37b069415877b101c7c5af958ccfbb81.png)  
Output after action

 ![Skärmavbild 2022-10-15 kl. 19.48.03](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/4/c4305bab2b7e79adfc3c96361f0b353ad13f5626.png)  
Template in docs

---

<div class="post-metadata">

**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:** [October 15, 2022, 4:52pm UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/2 "2022-10-15T16:52:12Z")

</div>

Sounds like you need a joined list 😉

Have a watch of the below - I suspect it will get you on the right track…

> [@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

---

<div class="post-metadata">

**Author:** ![Daniel\_Lof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_lof/32/48029_2.png) [@Daniel\_Lof](https://community.glideapps.com/u/Daniel_Lof)\
**Post date:** [October 15, 2022, 5:14pm UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/3 "2022-10-15T17:14:24Z")

</div>

Thanks! 😃

---

<div class="post-metadata">

**Author:** ![Daniel\_Lof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_lof/32/48029_2.png) [@Daniel\_Lof](https://community.glideapps.com/u/Daniel_Lof)\
**Post date:** [October 15, 2022, 7:29pm UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/4 "2022-10-15T19:29:30Z")

</div>

Definately needed a joint list and feels like I’m getting closer now.

 ![Skärmavbild 2022-10-15 kl. 22.25.22](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/2/e27e47cd20da686b044a252b64b3b3f91b587214.png)  
Managed with a joint list to list all items in a google doc. Final thing to figure out now is to group them by category so that I can add headers for the different categories in the export, and data from the price column next to each item and I’m all set. Hopefully wont be an all nighter 😁

 ![Skärmavbild 2022-10-15 kl. 22.25.54](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/f/0f11fc2e5f82ea21b143bf5f6e32ceac03130a84.jpeg)

---

<div class="post-metadata">

**Author:** ![Daniel\_Lof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_lof/32/48029_2.png) [@Daniel\_Lof](https://community.glideapps.com/u/Daniel_Lof)\
**Post date:** [October 16, 2022, 4:08am UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/5 "2022-10-16T04:08:09Z")

</div>

Still haven’t figured the final steps of this one out. As I need to list items per category as separate sections in docs I suspect I am missing some parameters in glide tables. I think I might need to export the per category from three different locations, perhaps. And I also need to display the data from a different column (price) next to each item. The prices are individual for each item. Any pointers regarding solving this would be much appreciated 😌

---

<div class="post-metadata">

**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:** [October 16, 2022, 4:23am UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/6 "2022-10-16T04:23:37Z")

</div>

I think I’d be tempted at this point to create a JSON object and send that as a single parameter. Something along the following lines:

```auto
{
  "menu": {
    "appetisers": [
      "item1",
      "item2",
      "item3"
    ],
    "mains": [
      "item4",
      "item5",
      "item6"
    ],
    "desserts": [
      "item7",
      "item8",
      "item9"
    ]
  }
}

```

To construct that in Glide, you’d have a separate joined list for each category, and then you’d combine the lot in a single template, that would look something like this:

```auto
{
  "menu": {
    "appetisers": [{jl-appetisers}],
    "mains": [{jl-mains}],
    "desserts": [{jl-desserts}]
  }
}

```

You would use replacement values for each of `{jl-appetisers}`, `{jl-mains}` and `{jl-desserts}`, substituting each of your 3 joined lists.

---

<div class="post-metadata">

**Author:** ![Daniel\_Lof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_lof/32/48029_2.png) [@Daniel\_Lof](https://community.glideapps.com/u/Daniel_Lof)\
**Post date:** [October 16, 2022, 5:09am UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/7 "2022-10-16T05:09:03Z")

</div>

Thanks man, trying this out right now. 🤝 The JSON part I assume is done over at Integromat right?

---

<div class="post-metadata">

**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:** [October 16, 2022, 5:11am UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/8 "2022-10-16T05:11:36Z")

</div>

You construct the JSON in Glide, and then it can be unpacked it in Make. Make has JSON modules to deal with that.

---

<div class="post-metadata">

**Author:** ![Daniel\_Lof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_lof/32/48029_2.png) [@Daniel\_Lof](https://community.glideapps.com/u/Daniel_Lof)\
**Post date:** [October 16, 2022, 6:37am UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/9 "2022-10-16T06:37:46Z")

</div>

Now I’m getting the data as separate entities into a google doc template using Make. Thanks very much!

I’m not sure I’ve set it up 100% correctly but at least it works.

![Skärmavbild 2022-10-16 kl. 09.34.09](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/d/7d8b9de01b66701d803cc5bc54c77da1bb603f2e.png)  
Google doc template with tags

 ![Skärmavbild 2022-10-16 kl. 09.34.47](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d5f8d8763bffc0968aef44a3629a03d8bb8e3625.jpeg)  
Template column in Glide

 ![Skärmavbild 2022-10-16 kl. 09.34.30](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ece00e5020102a6ac9f105f074a7f97a5954397e.png)  
Button with webhook action

 ![Skärmavbild 2022-10-16 kl. 09.34.15](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/d/cd7bbdf01483ae361020adfff211c147918ca4ae.png)  
Output in generated document in Make

---

<div class="post-metadata">

**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:** [October 16, 2022, 7:27am UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/10 "2022-10-16T07:27:19Z")

</div>

Looks like you’re sending each category list as a separate value, so your Menu template isn’t actually used?

But whatever, that should work equally well.

---

<div class="post-metadata">

**Author:** ![Daniel\_Lof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_lof/32/48029_2.png) [@Daniel\_Lof](https://community.glideapps.com/u/Daniel_Lof)\
**Post date:** [October 16, 2022, 7:31am UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/11 "2022-10-16T07:31:33Z")

</div>

That is true. At first try I tried to send the menu to the template to Make but couldn’t figure out the config on make end. So did a quick switch and sent the categories separately and works for this purpose. I now need to reflect for a couple of hours and go through the steps and verify what I have done and how all things are connected. Appreciate all the help, it really helped a lot!

Oh one thing I haven’t figured out yet is how I can get value from a price column to be displayed next to the product names with a blank space in between.

---

<div class="post-metadata">

**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:** [October 16, 2022, 7:43am UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/12 "2022-10-16T07:43:03Z")

</div>

> [@Daniel\_Lof](#):
>
> Oh one thing I haven’t figured out yet is how I can get value from a price column to be displayed next to the product names with a blank space in between.

You should be able to use a template column for that.

---

<div class="post-metadata">

**Author:** ![Daniel\_Lof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_lof/32/48029_2.png) [@Daniel\_Lof](https://community.glideapps.com/u/Daniel_Lof)\
**Post date:** [May 29, 2023, 7:40pm UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/13 "2023-05-29T19:40:56Z")

</div>

Reviving this one. I added a switch to each table to mark the row as active or inactive. It should only take into account where status is set to true, and this should be sent to webflow cms collection, google docs template etc. But it isn’t. Not when using the joined list solution. That worked well when all things could be sent but not when there are conditions. Trying to figure this out. Any help appreciated.

---

<div class="post-metadata">

**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:** [May 29, 2023, 11:00pm UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/14 "2023-05-29T23:00:43Z")

</div>

Are you accounting for your true status when building a relation or query, and then building your joined list off of that relation or query?

---

<div class="post-metadata">

**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:** [May 30, 2023, 1:09am UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/15 "2023-05-30T01:09:22Z")

</div>

> [@Daniel\_Lof](#):
>
> Reviving this one. I added a switch to each table to mark the row as active or inactive. It should only take into account where status is set to true, and this should be sent to webflow cms collection, google docs template etc. But it isn’t. Not when using the joined list solution.

The way I deal with this is to create an if-then-else column that returns the template column only for rows that meet the filter criteria, and then create my joined lists using the if-then-else column.

---

<div class="post-metadata">

**Author:** ![Daniel\_Lof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_lof/32/48029_2.png) [@Daniel\_Lof](https://community.glideapps.com/u/Daniel_Lof)\
**Post date:** [May 30, 2023, 4:30am UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/16 "2023-05-30T04:30:15Z")

</div>

Actually no. I am creating the joined list straight of the product name column.

---

<div class="post-metadata">

**Author:** ![Daniel\_Lof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_lof/32/48029_2.png) [@Daniel\_Lof](https://community.glideapps.com/u/Daniel_Lof)\
**Post date:** [May 30, 2023, 4:30am UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/17 "2023-05-30T04:30:59Z")

</div>

Ah I see, thanks guys for the help, I’ll try this solution.

---

<div class="post-metadata">

**Author:** ![Daniel\_Lof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_lof/32/48029_2.png) [@Daniel\_Lof](https://community.glideapps.com/u/Daniel_Lof)\
**Post date:** [May 30, 2023, 5:20am UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/18 "2023-05-30T05:20:08Z")

</div>

Think I got it working. I will use the Starters Joined List to send to webflow cms collection, google docs template etc.

 ![Skärmavbild 2023-05-30 kl. 08.18.19](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/9/5997a2e9c0530f95e85e38a72d9ff0f58bd2c8fe.png)  
 ![Skärmavbild 2023-05-30 kl. 08.18.45](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ec440d33bfde498cda6e1f310d34938620f0fe12.png)  
 ![Skärmavbild 2023-05-30 kl. 08.18.34](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/c/2c7d3893ab8da26a011ea280ef2e916971a59dec.jpeg)  
 ![Skärmavbild 2023-05-30 kl. 08.18.27](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f0e8da8ac7cdec2a7f622486bbc99c39b8d12679.png)

---

<div class="post-metadata">

**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:** [May 30, 2023, 5:21am UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/19 "2023-05-30T05:21:09Z")

</div>

Yep, that’s exactly what I meant 👍

---

<div class="post-metadata">

**Author:** ![Daniel\_Lof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_lof/32/48029_2.png) [@Daniel\_Lof](https://community.glideapps.com/u/Daniel_Lof)\
**Post date:** [May 30, 2023, 3:56pm UTC](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804/20 "2023-05-30T15:56:30Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/ad56d30e43897d17f01c68a187e7d2a09c559b2d.jpeg)

Ah of course it now also passes the status true along into the food menu. Need to figure out how to only pass the food item name and keep the conditional logic.

[Next page](https://community.glideapps.com/t/how-to-export-more-than-first-row-in-table-via-integromat-to-google-docs/51804.md?page=2)