How I Made the n8n Workflow Simple with the 1 Code: Here's How

A client reached out to me to automate a horse schedule sheet for 40+ horses. Every morning at 8 AM, they needed to track which services each horse would receive that day (e.g., Thursday services), update the sheet with the service details, and note the date.

The real kicker? At the end of the month, the client has to generate invoices, so they need to know exactly which horse received which service and how many times that month. This was becoming a huge manual task—checking the schedule, updating records, and creating invoices.

Initially, I used the Google Sheets part, with minor adjustments, and reused it repeatedly, which made the workflow more complex and harder for the client to understand.

So, I asked myself: 'How can I make this more efficient and simpler for the client, who might get stuck when making changes to such a complex workflow?

My Solution,

I created custom code that takes information from the previous node, which changes every time (like the day names). Because the data changes, I used a switch condition. The same Google Sheets part, with minor adjustments, was being reused repeatedly, making the workflow more complex and larger. So, I wrote the code to fetch the name and pass the required information, allowing me to use the Google Sheets part just once. This simplifies the process, making it easier for the client to understand and make changes.

💬 Your Thoughts?

If anyone has a different approach to solving this type of challenge or any tips for optimizing workflows with n8n and Google Sheets, feel free to share in the comments! Let’s collaborate and help each other out. 🙌

Also, let’s see if this project leads to another exciting opportunity to work on an invoicing workflow for the client. Fingers crossed! 🤞

#Automation #n8n #GoogleSheets #WorkflowAutomation #Fiverr #TechSolutions #HorseSchedule #Invoicing #Productivity #SoftwareDevelopment

3 comments