Hello Makers,
I need some assistance in creating a dynamic table in Google Docs that can automatically add new rows when there are multiple entries in a purchase order.
Here’s a summary of the requirements:
- The table’s columns are fixed and remain the same for every order.
- The values in the rows are variable, depending on the data from the purchase order.
- The solution should ideally avoid heavy coding, as my coding knowledge is limited.
So far, I’ve mapped Airtable fields with a Google Docs template and successfully output a single row in the table. However, I need the table to handle up to 15 entries/rows dynamically.
Template looks like this
I would greatly appreciate any guidance or solutions to achieve this. Thank you in advance for your support!
Patrick
Hi Patrick,
I’ve had the same problem before. This is how I handled it:
Instead of creating a table, format the Google Doc Template as simple text with tabstops and put a single variable in there like {{line items}}.
Now, get the information for your line items from Airtable and use a text aggregator to combine them into a single text line with a tab-variable in between each.
Next, combine all those text lines from your line items into a single block of text with a table aggregator that delimits them by a new line.
Input this text block into the {{line items}} variable in your google doc template.
I’ve created this blog post for more details: Automatically Create Invoices and Offers with Unlimited Line Items Using GDocs, Notion, and Make.com for Streamlined Business Automation
Let me know if you have any questions or if that worked for you.
Stephan 
