Webhook Automation for Data Sync

This workflow is ideal for:

• Business Owners: Looking to automate ticket time tracking with minimal manual intervention.
• Customer Support Teams: Who need to log call durations effectively for reporting and billing.
• Developers: Seeking to integrate webhook functionalities with external services like Google Sheets and Syncro.
• Data Analysts: Interested in analyzing ticketing data for insights and performance metrics.

This workflow addresses the challenge of manually tracking time spent on customer support calls. By automating the process, it ensures that:

• Accuracy: Reduces human error in time logging.
• Efficiency: Saves valuable time by automating data entry into Google Sheets and Syncro.
• Integration: Seamlessly connects multiple platforms to streamline operations.

1. Webhook Trigger: The workflow begins when a POST request is received at the specified webhook path (timersyncro). This request contains details about the call, including call_id, date_started, date_ended, and contact information.
2. Set Environment Variables: The workflow sets the base URL for the Syncro API, which is crucial for subsequent API requests.
3. Google Sheets Lookup: It queries Google Sheets to find if there is an existing ticket associated with the call_id. This step ensures that only valid tickets are processed.
4. Conditional Check: The workflow checks if the ticket exists. If the ticket is empty, it proceeds to a NoOp node (no operation), effectively ending the workflow for that instance.
5. Add Timer Entry: If a ticket is found, it makes a POST request to the Syncro API to log the call duration as a timer entry, including start and end times, notes, and user ID.
6. Completion: The workflow completes the process, ensuring that all relevant data has been logged accurately.