Microsoft Word Template Integromat (Make)

Yeah, Make.com has some of the worst help documentation that I’ve ever seen, and their support is slow.

I don’t know if anybody here will be able to answer your question since I haven’t heard of anybody in these forums using Make with Microsoft Word, so I would recommend opening up a support ticket with Make and reporting back here with whatever they say. That will help future people solve this same problem.

Alternatively:

1. Make.com also works with Google Docs, which might be easier to figure out.
2. On2Air: Actions works with Google Docs, and has great documentation and support.
3. If you only need to generate PDF files instead of Word files, you may want to explore DocuMint, which has a fantastic document template builder and also has great documentation and support.

Thank you Scott,

I will submit a support ticket as you suggested. It seems that Microsoft Word is rarely used in the automation workflows

Hi Trung,
I was too looking for more information on the Word module for Make just to see if I can achieve more than today.
When I started in July I found it very undocumented. I managed to find the right information from a Youtube tutorial. It is with Excel not Airtable, but it gives good stuff on the Word module.
I finally added a pdf.co module after the Word module to convert word in PDF.
https://youtu.be/AkV1MDUKrQA

I hope this helps although it’s been some time from your initial question.
Christophe

Thank you, Christophe!

The video is really helpful. I learned something new from it. I managed to solve the problem. It took a senior technician from Make to make it work

Please post a screenshot of how you solved this, so future people can learn how to do this.

Thank you, Christophe!

The video is really helpful. I learned something new from it. I managed to solve the problem. It took a senior technician from Make to make it work

This is similar to the example of Make’s documentation:

My scenario:

Word module setup:

And this is JSON string:

{
    "values": [{
            "key": "name",
            "value": "Trung Nguyen",
            "valueType": "value"
        },
        {
            "key": "contact",
            "value":[{
	            "entry": [
	            	{
	            		"key": "supplier_name",
	            		"value": "Test",
	            		"valueType": "value"
	            	},
	            	{
	            		"key": "email",
	            		"value": "test@gmail.com",
	            		"valueType": "value"            	
	        		},
	        		{
	            		"key": "phone",
	            		"value": "0123456789",
	            		"valueType": "value"        		
	        		}
	            ]},
	            {"entry": [
	            	{
	            		"key": "supplier_name",
	            		"value": "Another Test",
	            		"valueType": "value"
	            	},
	            	{
	            		"key": "email",
	            		"value": "another@gmail.com",
	            		"valueType": "value"            	
	        		},
	        		{
	            		"key": "phone",
	            		"value": "9876543210",
	            		"valueType": "value"        		
	        		}
	            ]}
	        ],
            "valueType": "loop-section"        
        }
    ]
}

Hello,

I wonder what you give to the “parse json” module as input?

Thanks for your feedback.

P.S.: I try to reproduce the same use case, and I get stuck. My scenario, does not give me a table but as many files as rows…

Hi Patrice,

The input of “Parse JSON” is the “JSON String” in my previous answer. This should be populated using Airtable formula.

Hope it helps!

Hi Trung,
Thanks for your answer, could you show me the airtable formula? Is it a concanetation?

Hi Trung,
how do you create the json fx of the CHI TIET DH table?

This is similar to the example of Make’s documentation:

My scenario:

Word module setup:

And this is JSON string:

{
    "values": [{
            "key": "name",
            "value": "Trung Nguyen",
            "valueType": "value"
        },
        {
            "key": "contact",
            "value":[{
	            "entry": [
	            	{
	            		"key": "supplier_name",
	            		"value": "Test",
	            		"valueType": "value"
	            	},
	            	{
	            		"key": "email",
	            		"value": "test@gmail.com",
	            		"valueType": "value"            	
	        		},
	        		{
	            		"key": "phone",
	            		"value": "0123456789",
	            		"valueType": "value"        		
	        		}
	            ]},
	            {"entry": [
	            	{
	            		"key": "supplier_name",
	            		"value": "Another Test",
	            		"valueType": "value"
	            	},
	            	{
	            		"key": "email",
	            		"value": "another@gmail.com",
	            		"valueType": "value"            	
	        		},
	        		{
	            		"key": "phone",
	            		"value": "9876543210",
	            		"valueType": "value"        		
	        		}
	            ]}
	        ],
            "valueType": "loop-section"        
        }
    ]
}

This is similar to the example of Make’s documentation:

My scenario:

Word module setup:

And this is JSON string:

{
    "values": [{
            "key": "name",
            "value": "Trung Nguyen",
            "valueType": "value"
        },
        {
            "key": "contact",
            "value":[{
	            "entry": [
	            	{
	            		"key": "supplier_name",
	            		"value": "Test",
	            		"valueType": "value"
	            	},
	            	{
	            		"key": "email",
	            		"value": "test@gmail.com",
	            		"valueType": "value"            	
	        		},
	        		{
	            		"key": "phone",
	            		"value": "0123456789",
	            		"valueType": "value"        		
	        		}
	            ]},
	            {"entry": [
	            	{
	            		"key": "supplier_name",
	            		"value": "Another Test",
	            		"valueType": "value"
	            	},
	            	{
	            		"key": "email",
	            		"value": "another@gmail.com",
	            		"valueType": "value"            	
	        		},
	        		{
	            		"key": "phone",
	            		"value": "9876543210",
	            		"valueType": "value"        		
	        		}
	            ]}
	        ],
            "valueType": "loop-section"        
        }
    ]
}

This is great information @Trung_Nguyen .  I am about to put my head through the wall on the Word Template module.  Have you figured out how to get the formatted document into an attachment field in Airtable when you are done?

You can use "Airtable - Update a record" to update the attachment field with the source file from "Onedrive - Download a file"

@Trung_Nguyen I am still running into a challenge.  I did what you suggested.  1) Connected to Airtable to get the date.  2) Downloaded the file from OneDrive.  3) Ran the file through the Word Template module and now I am trying to get the file into Airtable and I just feel like I am missing something.  I put in the FileName and it doesn't make it.  I tried WebUrl from OneDrive.  Any ideas?

Sorry, my previous reply was wrong. You have to use "Onedrive - get a sharable link" then use it as the file URL. Hope it helps!

@Trung_Nguyen Have you tested that?  I am pretty sure I tried that and it didn't work but I will attempt again.  

Also.  Do you know how to get the module to handle multiline fields?  Doesn't seem like the Word module is repeating my carriage returns.

Yes, I have tested it. The important part is that the scope attribute of the "Onedrive - Get a sharable link" module must be "the file is not accessible by anyone who has the link".

Or in my case, I do not need to use that module as the file generated is uploaded to a publically accessible folder on Ondrive already.

Ah.  Thanks for the info.  Any chance you know how to get the word module to accept multiple lines on a form?

This is similar to the example of Make’s documentation:

My scenario:

Word module setup:

And this is JSON string:

{
    "values": [{
            "key": "name",
            "value": "Trung Nguyen",
            "valueType": "value"
        },
        {
            "key": "contact",
            "value":[{
	            "entry": [
	            	{
	            		"key": "supplier_name",
	            		"value": "Test",
	            		"valueType": "value"
	            	},
	            	{
	            		"key": "email",
	            		"value": "test@gmail.com",
	            		"valueType": "value"            	
	        		},
	        		{
	            		"key": "phone",
	            		"value": "0123456789",
	            		"valueType": "value"        		
	        		}
	            ]},
	            {"entry": [
	            	{
	            		"key": "supplier_name",
	            		"value": "Another Test",
	            		"valueType": "value"
	            	},
	            	{
	            		"key": "email",
	            		"value": "another@gmail.com",
	            		"valueType": "value"            	
	        		},
	        		{
	            		"key": "phone",
	            		"value": "9876543210",
	            		"valueType": "value"        		
	        		}
	            ]}
	        ],
            "valueType": "loop-section"        
        }
    ]
}