A self-healing integration where Make.com listens for Webgility error webhooks, automatically verifies and creates the missing Account or Item in QuickBooks Online, and notifies the team via Slack/Email, ensuring seamless e-commerce accounting flow.
The Problem
When Webgility fails to sync an order due to a missing SKU or Account in QuickBooks, the automation chain breaks, leading to delayed financial reporting and manual troubleshooting. This scenario often requires an accountant to manually create the missing ledger entry or item before the sync can proceed.
The Outcome
A self-healing integration where Make.com listens for Webgility error webhooks, automatically verifies and creates the missing Account or Item in QuickBooks Online, and notifies the team via Slack/Email, ensuring seamless e-commerce accounting flow.
Step-by-Step Guide
1. **Create Webhook in Make.com**: Add a 'Webhooks' module with a 'Custom Webhook' trigger. Copy the provided URL.
2. **Configure Webgility**: In Webgility (Online or Desktop via Gateway), go to Settings > Notifications and paste the Make.com Webhook URL, selecting 'Sync Error' as the trigger event.
3. **Parse JSON**: Send a test error from Webgility to Make.com. Use the 'JSON' module 'Parse JSON' if the payload arrives as a string to map fields like `SKU`, `AccountName`, and `ErrorType`.
4. **Search QuickBooks**: Add a 'QuickBooks Online' module: 'Search for Objects' (Item or Account). Use the data from the webhook (e.g., `SKU` or `Name`) to find a match.
5. **Apply a Router**: Add a 'Router' module. Create one path for 'New Creation' (where the search result is empty) and one for 'Notification' (where the object exists but another error occurred).
6. **Create Missing Object**: On the 'New Creation' path, add a 'QuickBooks Online' module: 'Create an Account' or 'Create an Item'. Map the `Name` and `Account Type` (e.g., Sales of Product Income).
7. **Format Currency/Dates**: Use Make.com functions like `formatDate()` or `parseNumber()` to ensure the data matches QuickBooks’ strict schema requirements.
8. **Implement Error Handling**: On the QuickBooks modules, right-click and select 'Add error handler'. Use 'Break' or 'Resume' to handle API rate limits or transient network issues.
9. **Slack Notification**: Add a 'Slack' module 'Create a Message' to notify the finance team that a new account/item was created automatically to bridge the Webgility sync gap.
10. **Finalize & Activate**: Name the scenario, save it, and toggle the 'Scheduling' switch to ON.