I am using a webhook attached to an Airtable button to grab the record ID of an Airtable record, using a webhook. I then grab the fields I want and create a Google Doc (from a template) with those values mapped. This works fine for the fields in the table I’m attaching to.
In Airtable I have a separate ‘narratives’ table containing a number of fields, like:
Subject, Detail, Created by, Date modified.
These present to the make.com scenario as an array. This is a one to many relationship, so 1 record in the main table can have many records in the ‘narratives’ table. The Airtable module in the scenario shows this:
Narratives
I need to bring these in to the Google Doc as a something approaching a table - i.e. repeat each linked Narrative as a row.
How might I go about this?
1 Like
Tables, lists, and dynamic amounts of values are not supported when creating a document from a template.
You’ll have to use the “Make an API Call” module to add/modify tables of data.
Alternatively, you can build the table HTML using a Text Aggregator, but this means you cannot use the “Create a document from a template” module.
To do this, you can try using the Google Docs “Create a Document” module —
Creates a new Google document by adding the content of HTML format.
For more information, see https://www.make.com/en/integrations/google-docs, and https://www.make.com/en/help/app/google-docs in the help centre.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Hello
Thanks for the reply but I think I’m quite a long way from understanding and perhaps make.com is not best suited to this use case.
Are there any examples anywhere that could show me this in action?
1 Like