Looks like others have similar problems see
Main problem I guess parsing the response from Gemini. In this example I was trying to get JSON format result. But Gemini returns with extra symbols and text. Check the topic for more detail. If you place JS code that parse the gemini response like this example, I can record every json data to google sheets with mapping.
If my reply solves your problem, please remember to mark it as a solution.