Hello!
Previously, I’ve used Make (formerly Integromat) to generate .docx documents from templates, using functions like {#section}{/section}. These functions allow me to create dynamic sections that adapt based on the fields that need to be filled. My question is: is it possible to do something similar with spreadsheets?
Use case:
I have a spreadsheet template, and in one section of this template, I need to add information from Airbnb reservations. The number of rows required will depend on the number of reservations. For example, if there are 3 reservations, I would need the template to automatically adapt and add 3 rows, each containing the relevant information for each reservation in the appropriate columns.
Example:
| Name | Date | |
|---|---|---|
| John Doe | 2025 | john@doe.com |
| Jane Smith | 2024 | jane@smith.com |
| Alex Brown | 2023 | alex@brown.com |
Is there any tool or method that allows for this kind of dynamic row adaptation in a spreadsheet?
My database would be monday.com boards.
Thanks in advance for your help!