Built a complex
Make.com workflow triggered by a webhook that parses incoming JSON data, runs it through OpenAI to extract and structure the relevant financial details, then splits into two paths. The main track pulls pricing data from Google Sheets, processes it through multiple variable-setting steps, and routes transactions into Tripletex — creating and updating records across four price categories with full logging via the Tripletex log module. A secondary path handles anomalies or unmatched entries, routing a summary email through Gmail and logging the result to Google Sheets for manual review.