We are looking to hire a developer experienced with Make.com (formerly Integromat) to finalize an automated workflow. The objective is to select the most relevant information from a source system (e.g., Google Sheets), gather related external data, and utilize an AI service (e.g., OpenAI) to synthesize the information into a structured output.
Core Workflow Requirements:
The scenario involves several key phases:
-
Inputs and Data Retrieval: The scenario must accept input parameters (date ranges, keywords, volume limits) and retrieve matching records from the primary data source.
-
Scoring and Filtering Logic: The workflow needs to iterate through the records, parse metadata (stored as JSON within the records), and calculate a “Priority Score.” This score is based on matching the metadata against the input keywords and their associated confidence levels.
-
Sorting and Selection: The aggregated results need to be sorted using multi-level criteria: first by the calculated Priority Score (highest first), and second by date (newest first). The workflow then selects the “Top N” records (e.g., the top 15).
-
External Data Fetching: The scenario needs to fetch external information for the top records (e.g., via HTTP requests to URLs listed in the records). This step requires standard error handling (e.g., using the
Resumedirective) to manage potential timeouts or failed requests. -
AI Integration and Output: The collected data is combined, formatted into a prompt, and sent to an LLM API for synthesis. The final generated content is saved to a cloud document (e.g., Google Docs).
-
Tracking/Counter: The workflow utilizes a Make.com Data Store to manage a persistent counter, ensuring every output has a unique identifier.
Current Status and Challenges:
We have an architectural outline and a prototype of this workflow already built. However, we have encountered implementation challenges. Specific areas needing attention include the correct application of array manipulation functions (map, filter, sort, slice), implementing the multi-level sorting logic, and configuring the error handling properly.
Opportunity:
We need a developer to take our existing outline, resolve the implementation issues, and deliver a stable, working solution. We are interested in establishing a working relationship for future automation projects if this initial engagement is successful.
