# Make Text Aggregator Examples: Many Rows, One Email > How the Make Text aggregator joins many bundles into one block of text: source module, separators, HTML line breaks and a daily summary email you can copy. Source: https://learn.ynteractive.com/content/blog/make-text-aggregator-examples · Updated 2026-10-20 · Free from Stepthrough (https://learn.ynteractive.com) Quick answer The Make [Text aggregator](https://learn.ynteractive.com/content/glossary/make-aggregator) collects every bundle from a source module and joins them into one piece of text, so ten sheet rows become one email instead of ten. You set **Source Module** to the module that returns the rows and write the text for one row in **Text**, for example `Name: Reason
`. The free [daily summary lesson](https://learn.ynteractive.com/content/make-com-daily-summary-email-google-sheets-schedule) builds this between Google Sheets and Gmail. Last updated October 20, 2026 [Take the free module →](https://learn.ynteractive.com/courses/ai-for-operations/11)Module 11 of the free [AI for Operations Teams](https://learn.ynteractive.com/courses/ai-for-operations) course, about 12 minutes. No account needed. By [Robert Breen](https://learn.ynteractive.com/content/about) · Published October 20, 2026 · Updated October 20, 2026 · 3 min read Make · Aggregators · Gmail ## Why do you need an aggregator? Without one, every module after a search runs once per bundle. A Search Rows module that finds six requests would send six separate emails. The Text aggregator stops that. It waits for all bundles from the source module, writes one line per bundle and outputs a single bundle with one field called **text**. The Gmail module after it runs once. ## How do you set up the Text aggregator? Add it from **Tools**, under **Aggregators**, then set the source module and the text for one row. The lesson's setup, step by step: 1. Click the **+** on the right of **Google Sheets**, click **Tools**, and under **Aggregators** click **Text aggregator**. 2. Open **Source Module** and click **Google Sheets - Search Rows [1]**. 3. Click the **Text** field. In the mapping panel, click **Name (A)**. 4. Type a colon and a space, click **Reason (D)**, then type `
` at the end. 5. Click **Save**. In Gmail's **Send an email**, set **Body type** to **Raw HTML**, click **Content** and pick **text** under **2. Tools - Text aggregator**. The manager gets one email that lists each patient and reason on its own line. ## Try it free, step by step **On a Schedule: A Daily Summary Email from a Google Sheet in Make.com**. Build a Make scenario that runs every day at 5 PM, finds today's rows in Google Sheets, combines them with a Text aggregator and emails one summary with Gmail. You do every step yourself in a practice copy of Make, it checks your work as you go, and “Do it for me” finishes any step you get stuck on. Free, and nothing touches your real accounts. [Start the free lesson](https://learn.ynteractive.com/modules/make-daily-summary) [Or read the full step-by-step guide](https://learn.ynteractive.com/content/make-com-daily-summary-email-google-sheets-schedule) ## Text aggregator examples for office work Each example is what you put in **Text** for one bundle. The aggregator repeats it for every row. | Use | Text for one row | | --- | --- | | Daily request list (HTML email) | `{{1.Name}}: {{1.Reason}}
` | | Bulleted list (HTML email) | `
  • {{1.Client}}: {{1.Status}}
    • ` then wrap the Content in `` | | [Plain-text email](https://learn.ynteractive.com/content/glossary/plain-text-email) | `- {{1.Name}} ({{1.Phone}})` with a newline as the row separator | | Overdue [invoices](https://learn.ynteractive.com/content/glossary/invoice) | `{{1.Invoice}} from {{1.Vendor}}, due {{1.Due}}, ${{1.Total}}
    ` | | A CSV line for a file | `{{1.Name}},{{1.Email}},{{1.Topic}}` with a newline separator | | Slack message | `• {{1.Task}} (owner: {{1.Owner}})` with a newline separator | The `{{1.Name}}` pills here stand for fields you click in the mapping panel; the number is the source module's position. ## Should I use a row separator or `
    `? Use `
    ` (or list tags) when the email body is HTML, and the row separator's **New row** option when the destination is plain text. HTML email ignores ordinary line breaks, so a list joined with new lines shows up as one long paragraph. That is why the lesson types `
    ` and checks that **Body type** is **Raw HTML**. ## What about the Array aggregator? The Array aggregator outputs a list of bundles instead of text. Use it when the next module needs structured items, such as a module that takes an array of attachments or line items. For a readable email or message, the Text aggregator is simpler. ## What if Search Rows finds nothing? The aggregator outputs nothing and Gmail does not run, so no empty email is sent on a quiet day. If you want a "nothing new today" email anyway, add a router before the aggregator or use `ifempty()` in the email body. ## Key takeaways - The Text aggregator turns many bundles into one, so the next module runs once. - Source Module must be the module that produced the bundles, here Search Rows. - Use `
    ` with Raw HTML email bodies; use New row separators for plain text. - Choose the Array aggregator when the next module needs a list, not text. ## Frequently asked questions **What is an aggregator in Make?** An aggregator is a module that combines several bundles into one. Make has Text, Array, Numeric and Table aggregators, among others, under Tools and in some apps. **Where is the Text aggregator in Make?** Add a module, click Tools, and look under Aggregators. Text aggregator is listed there. **Why does my Make scenario send one email per row?** There is no aggregator between the search and the email. Add a Text aggregator with the search as its Source Module and map its text into the email. **Which free course covers this?** The [Make & Zapier Jump Start](https://learn.ynteractive.com/courses/make-zapier-jump-start) course. It is also part of [AI for Operations Teams](https://learn.ynteractive.com/courses/ai-for-operations). ## Free lessons in this post - [On a Schedule: A Daily Summary Email from a Google Sheet in Make.com](https://learn.ynteractive.com/content/make-com-daily-summary-email-google-sheets-schedule): Build a Make scenario that runs every day at 5 PM, finds today's rows in Google Sheets, combines them with a Text aggregator and emails one summary with Gmail. ## Related terms Plain-English definitions, each with an example from a free lesson. [Aggregator (Make)](https://learn.ynteractive.com/content/glossary/make-aggregator) · [Plain-text email](https://learn.ynteractive.com/content/glossary/plain-text-email) · [Invoice](https://learn.ynteractive.com/content/glossary/invoice) · [Iterator (Make)](https://learn.ynteractive.com/content/glossary/make-iterator) · [Bundle (Make)](https://learn.ynteractive.com/content/glossary/make-bundle) · [Operation (Make)](https://learn.ynteractive.com/content/glossary/make-operation) [The full AI glossary](https://learn.ynteractive.com/content/glossary) ## Related prompts - [End of day report prompt](https://learn.ynteractive.com/content/prompts/end-of-day-report-prompt): A ChatGPT prompt for an end of day report: paste your rough notes and get a short EOD report with what got done, what is still… [All free prompt templates](https://learn.ynteractive.com/content/prompts) ## Keep reading - [Make Filter Operators Cheat Sheet: Text, Number, Date](https://learn.ynteractive.com/content/blog/make-filter-operators-cheat-sheet): Every Make filter operator group on one page: text, numeric, date, basic and array, with an office example for each and the mistakes that block bundles. - [Make formatDate Examples: Dates in Filters and Emails](https://learn.ynteractive.com/content/blog/make-formatdate-examples): Copy-ready Make date functions: formatDate(now; "YYYY-MM-DD"), addDays, parseDate and time zones, with the daily summary filter that finds today's rows. - [Make Google Sheets Modules: Add a Row vs Search Rows](https://learn.ynteractive.com/content/blog/make-google-sheets-modules): Which Make Google Sheets module to use: Add a Row, Search Rows, Update a Row or Watch New Rows, how to pick the sheet and how headers map. [All blog posts](https://learn.ynteractive.com/content/blog) · [All free tutorials](https://learn.ynteractive.com/content)