# How to Send One Weekly Email Containing All Rows

**URL:** <https://community.glideapps.com/t/how-to-send-one-weekly-email-containing-all-rows/85273>\
**Category:** Ask for Help\
**Created:** [November 7, 2025, 9:23am UTC](https://community.glideapps.com/t/how-to-send-one-weekly-email-containing-all-rows/85273 "2025-11-07T09:23:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Prashanth\_Gurusamy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prashanth_gurusamy/32/84653_2.png) [@Prashanth\_Gurusamy](https://community.glideapps.com/u/Prashanth_Gurusamy)\
**Post date:** [November 7, 2025, 9:23am UTC](https://community.glideapps.com/t/how-to-send-one-weekly-email-containing-all-rows/85273/1 "2025-11-07T09:23:20Z")

</div>

Hi everyone, I need help with a weekly summary email workflow.

I have a table called **Competition Results** , and each row has a **Date** and some other details.

**Goal:**  
Send **one single email per week** that lists **all rows** that happened in the **last 7 days**.

**Current Issue:**  
Right now, my workflow is sending **one email per row** , because the **Send Email** action is inside the loop. I want to **combine all the rows into one message** and send **one email only.**

What I need guidance on:

1. How to **collect all rows from the last 7 days**.
2. How to **join all of those rows into one text block**.
3. How to **send one single email** after joining the text.

---

<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:** [November 7, 2025, 9:50am UTC](https://community.glideapps.com/t/how-to-send-one-weekly-email-containing-all-rows/85273/2 "2025-11-07T09:50:57Z")

</div>

You can use the Generate CSV action.

- In your Competition Results table, create a Math column that returns the Date 7 days ago. (`Now-7`)
- Create a Query column that targets the Competition Results, and filter where Date is after 7 days ago.
- Use that Query as the source of a Generate CSV action, and include that in an email.

As long as your Competition Results table is not a Big Table, that should work.

---

<div class="post-metadata">

**Author:** ![Prashanth\_Gurusamy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prashanth_gurusamy/32/84653_2.png) [@Prashanth\_Gurusamy](https://community.glideapps.com/u/Prashanth_Gurusamy)\
**Post date:** [November 7, 2025, 10:09am UTC](https://community.glideapps.com/t/how-to-send-one-weekly-email-containing-all-rows/85273/3 "2025-11-07T10:09:05Z")

</div>

Thanks for the response!

I’ll break down my requirement a bit more:

I **don’t want to send it as a CSV attachment**.  
The number of rows per week is small (around 10–15), so I want the details to be shown **directly in the email body** , as a readable list — not as a file to open.

So basically:

- Filter rows where **Date is within the last 7 days**
- Take those rows
- **Join them together using Joined list**
- And send **one single email** containing that text

Right now, my workflow is sending **one email per row** , because of the loop.  
I’m trying to figure out the right way to **combine all matched rows into a single text block** and then send **only one email**.

---

<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:** [November 7, 2025, 11:10am UTC](https://community.glideapps.com/t/how-to-send-one-weekly-email-containing-all-rows/85273/4 "2025-11-07T11:10:06Z")

</div>

Okay, so use the Query column as I described, create a Template column that concatenates the columns in each row that you need, then use a Joined List through the Query to gather all rows. In the workflow, just send the result of the Joined List in a single step - don’t use a loop.