Hi guys!
I have a different each time number of rows in google sheet and I need to push them to a mail content as a table.
How would you go about it?
An easy way to autocreate table in a markdown?
Welcome to the Make community!
Yes, that is possible. You’ll need a minimum of three modules:
1. You’ll have to create HTML table rows using a Text Aggregator.
<tr><td>cell 1</td><td>cell 2</td></tr>
2. Then insert into the email with the rest of the table’s HTML code.
<table>
<tr><th>header 1</th><th>header 2</th></tr>
{{2.aggregator_text_variable}}
</table>
Give it a go and let us know if you have any issues!
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
2 Likes
Hi! Thanks for the answer.
Would it work for a variable numer of rows?
I don’t know how mamy rows I will have each time.
An aggregator will take in an unlimited number of bundles to form a single variable.
For more information see the Make Academy.
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
General
- Help Center | Tutorials
- Make Academy – learn Make and get your certificate
- Discord Server – join us in live chat for fans of Make!
Help Center Basics
- Mapping – What is mapping? What can I map?
- Mapping with arrays – How to map items in an array
- Aggregate an array for mapping complex fields
- Tokens for
parseDate| Tokens forformatDate - HTTP modules – Make a request, Get (download) a file
- Webhooks – Error Handling, Responding to webhooks
Articles & Videos
- Router Magic Formula - YouTube
- Error Handlers in Make - YouTube playlist
- Getting started with OpenAI
- How to use Regex in Make
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
2 Likes