Teamwork Fencing is a project designed to streamline job management using ServiceM8 and enhance data integration with Google Sheets through automation. Initially, Zapier was used as the middleware for updating records in Google Sheets when jobs were moved between queues in ServiceM8. However, due to limitations in Zapier, such as the inability to delete rows by ID and remove duplicate records, the project transitioned to using Make.com for a more robust solution.
Teamwork Fencing is a project designed to streamline job management using ServiceM8 and enhance data integration with Google Sheets through automation. Initially, Zapier was used as the middleware for updating records in Google Sheets when jobs were moved between queues in ServiceM8. However, due to limitations in Zapier, such as the inability to delete rows by ID and remove duplicate records, the project transitioned to using Make.com for a more robust solution.
The use of Zapier as a middleware presented significant challenges:
• Lack of functionality to delete rows by ID in Google Sheets.
• Inability to remove duplicate records.
• Inefficiencies in managing job data across multiple sheets
corresponding to specific queues.
To automate and streamline the process of job management by integrating ServiceM8 with Google Sheets through Make.com, ensuring accurate and efficient data handling, including the creation, updating, and deletion of records.
Here’s how we helped Teamwork Fencing
The implementation of Make.com for workflow automation and data integration resulted in significant improvements: