Can't send value from Google Sheets cell to Gemini

[Manu2]

What are you trying to achieve?

Hi, I’m trying to configure an scenario where a long text in a Sheets cell must be shared as a value with a Gemini module.

The reason I want to do it in a sheet document is I can run 1 row every certain time automatically.

Steps taken so far

Tried to send value straight forward from sheets to Gemini, also tried to set variable in order to send just text in another format, but even with another modules, output show always a long string that Gemini understands as empty.

Screenshots: scenario setup, module configuration, errors

[Stoyan_Vatov]

Hey Manu,

In your screenshot you ran only the Gemini module. Can you show the result when you run the full scenario?

[Manu2]

This is my full scenario. Doesn’t really matter because I’m stuck at first steps.

My goal is to create a sheet manually that provides info to gemini to give certain structure and automate posting on my site.

I tried many ways to make Gemini gets a cell with long text as actual text and not as a string, which causes error due to it seems to be empty.

[Manu2]

This is what I get as output with the Search Row module. A long text (longer than it appears on screenshot) that proves cell is formatted correctly. But somehow, can’t make Gemini gets this text correctly. Any way to make it work?

[Stoyan_Vatov]

Ok but in the first screenshot it shows you only ran the Gemini module. What happens when you run the scenario and not just the modules?

[Manu2]

I share the result when running full scenario. Get an error when it tries to run Gemini module.