What are you trying to achieve?
I’m trying to automatically generate a complete SEO article using the Gemini API, based on a detailed outline stored in a Google Sheets file.
The goal is to run the Gemini module several times (once per topic/row in the outline), and then merge all the generated parts into a single final article.
Steps taken so far
I’ve set up the standard structure required to process a table, but the Gemini AI module [6] consistently fails with a data format error.
Structure Configuration (Modules)
The scenario is set up as follows — the standard Make method for processing lists:
- Module 7 (Google Sheets – Get Range Values): Reads range B2:C8 (7 rows of data) and sends the list to the next module. (Status:
Functional) - Module 9 (Flow Control – Iterator): Receives the full array (output of Module 7) and splits it into 7 “bundles” (individual rows) to send to the Gemini module. (Status: Functional)
- Module 6 (Google Gemini AI – Create a Completion): Receives each row and runs the request. (Status:
Fails)
Error Diagnosis (IMLError)
The Gemini module consistently fails with the following error:
IMLError: Function 'parseResponseSchema' finished with error!
Function 'removeTypeKeys' finished with error!
Cannot read properties of undefined (reading 'forEach')
This indicates a serialization issue with the Array or Collection format passed by the Iterator. The Gemini module can’t interpret the structure of the incoming data.
Unsuccessful Troubleshooting Attempts
I’ve tried all possible workarounds:
Verified that the Gemini API key is valid (it works in a simple, single-module scenario).
Cleared browser cache and reran the scenario to eliminate broken references.
Used the toString() function on the Iterator output in the prompt to force the data into plain text.
Checked that there are no empty rows in range B2:C8.
The issue seems isolated: the Google Gemini AI connector fails to read data coming from an Iterator, even when the scenario structure follows Make best practices.
Screenshots to include
Please attach the following images to support your report:
- Scenario Setup: To show modules 7, 9, and 6 connected.
- Final Error: Screenshot showing the log and persistent IMLError.
- Iterator Configuration: To confirm the Array setup.
- Prompt Configuration: To show the last attempt using
toString().
