Looking for help with filling Word template document

Community Archive
1

My goal is to fill the MS Word template with data from Google Forms and Excel file. Excel rows needs to be filtered by matching values from multiple choice answer from Google Form. These rows also contains other necessary data in other columns. Several columns from previously filtered Excel records must be entered into the Word file as one table. There is also one column in Excel filtered records from which all values must be summed and inserted into the Word document as one value. Also few other fields from Google forms needs to land in the Word document

process
process875×814 89.3 KB

I managed to do almost everything except putting the sum of values into Word document (orange arrows).

I’m a total beginner in this tool, so there is a chance that everything I prepared till now is wrong :stuck_out_tongue: I need further help

1 Like
3

Hello @3dbesta, welcome to the make Hire a pro section , I would love to work with you on this, you can book a call here : Calendly to discuss the project requirements and you can checkout my Upwork profile

4

Hi @3dbesta ,

If paid help works for you, I offer an $80 for 50min screen share technical help package, you can book it here.

We can resolve it together, and probably we’ll also have time left to go through some more tips or optimizations with your workflow :slight_smile:

Best,
Milan, smoothwork.ai
My youtube (including some Make tutorials): youtube.com/@vasarmilan

5

Hi @3dbesta!

I would love to help you with this, it is a rather simple automation, should not take long to solve.

We are a small team of make.com experts and have developed plenty of complex integrations. This project should not be a challenge to us.

If you are interested we would love to help you, you can schedule a call in here: 30 Min Meeting | Felipe Saucedo | Cal.com or check our website www.aspirity.com

6

Hi @3dbesta,

If you’re looking for someone with over 2 years of experience and certified expertise to tackle this challenge, I’d be happy to help. With my background in automating workflows and integrating Google Docs and Excel, I believe I can streamline the process and ensure seamless integration.

Feel free to explore my services further, and I’d be glad to connect with you on LinkedIn to stay in touch.

Looking forward to connecting soon!

7

Make.com Hero - NewPath Consulting I look forward to talking to you and your team should they join us.

I am an experienced Maker from legacy Integromat days and have developed a full SaaS on it https://accountbridge.app.

I can safely say I have a lot of experience. Let me help you.

8

Automating document generation from mixed inputs like Google Forms + Excel + Word templates is exactly the type of workflow where n8n (or Make/Power Automate) shines.

The key piece you’re missing is summing values and injecting that into Word, usually requires adding an aggregation step before passing data to the document template. In practice, that means:

  • Filtering Excel rows based on the Google Form response.

  • Running an aggregator (sum operation) on the numeric column of the filtered dataset.

  • Mapping both the table data and the sum value into placeholders inside the Word template.

We’ve solved similar problems by combining Spreadsheet File → Aggregator → MS Word Template nodes, sometimes even layering in Google Apps Script for edge cases. This way, the workflow is modular, repeatable, and flexible if the template or filters change later.

If you’re still stuck, happy to share some approaches from how we handle sums, tables, and dynamic content injection into Word templates. :rocket:

here’s a quick link to book a call with us:
:date: Book 30min Calendy Slot Now!

9

This topic was automatically closed after 30 days. New replies are no longer allowed.