I’m looking to create an automation workflow in n8n that would help me generate daily reports of tasks completed on Monday.com by my team. The idea is to have all the completed tasks exported automatically into a spreadsheet (Google Sheets or similar) so I can easily review what was done each day.
I’m relatively new to n8n and would appreciate any guidance, example workflows, or tips on how to set this up efficiently.
If you want to have some suggestion about your workflow I suggest you to write into Help me Build my Workflow next time
Now I try to give you some hints, please tell me if they are useful or not:
n8n offers built-in integrations for both Monday.com and Google Sheets. Utilizing these can simplify the process of fetching data from Monday.com and writing it to a spreadsheet.
Use the Schedula node in n8n to set up a daily trigger for your workflow. This ensures that your report is generated automatically at a specified time each day.
When retrieving tasks from Monday.com, apply filters to select only those marked as “completed.” This focuses your report on the tasks that have been finalized.
Before exporting to Google Sheets, consider using nodes like Set or Function to organize and format your data. This makes the report more readable and useful.
It’s top-notch advice at the moment, let me know if you want to get more into the merits of anything.
