How to Automate your Tables?

Let's imagine a company sending every month a recap of the hours worked by each of its employees.

All hours worked are located in a spreadsheet.

Step 1: Creating a Template

The first step will be to build our custom template in MinuteMerge.com

We will include a few words and a Table object.

Step 2: Creating an Integromat Scenario

Now let's build a scenario with Integromat, so that we can connect our google sheets to our MinuteMerge Template.

The first module will allow us to isolate all the hours worked by a specific employee thanks to a filter.

Step 3: JSON Agregate Module

The second module will agregate all the data gathered by the first module into a JSON object (which is the format we need to populate our Table in MinuteMerge).

Step 4: MinuteMerge Module

Now that we have our information in the right format, let's create a MinuteMerge module and input the freshly created JSON into the Table field.

Step 5: Upload to Google Drive

Once our document is generated, we can upload it automatically to Google Drive.

Step 6: Good to Go!

We can now generate a custom document to each of our employees with a recap of their hours worked for the month. Ready to automate!