Hi Alon,
By "Feedback Loop," I mean a conditional data repair cycle inside a For Each Row loop. The goal is to check if a row is incomplete, fetch the missing info externally, update the source sheet in real-time, and then continue processing.
Here is the generic logic I am trying to build:
Scenario: Processing a list of Vendor Profiles.
1. Iterate through rows in my Google Sheet.
2. Condition Check: For the current row, check if the Status or Description columns are empty.
3. Branch A (Data Missing):
Fetch External Data: Run a scraper/API call using the Vendor Link from the current row.
Process: Use an AI node to extract the missing details.
Update Source: Write these new values back to the same row in the Google Sheet immediately.
Proceed: Pass these new values to the next step.
4. Branch B (Data Exists):
Skip the fetch step.
Proceed: Use the existing sheet values for the next step.
5. Final Step: Generate a final report for that row using the complete data.
