Connecting the Gemini Pro API to Google Sheets

🎉 Get the script from here: invertedstone.com/store/googl...
---
Google has recently released its most powerful AI model called Gemini Pro, and this video is a short and quick tutorial on how you can connect the API to Google Sheets and then generate content for 1000s of rows within minutes.
Apart from this, you can also get some more cool scripts here: invertedstone.com/store/

[@InvertedStone]

🎉 Get the script from here: invertedstone.com/store/google-sheets-to-gemini-api/

[@JamaisVulgaireCom]

Do your script works with vision api as well ?

[@InvertedStone]

@@JamaisVulgaireCom No, it doesn't.

[@user-ht3bi2lj8u]

Hi, do you have update for Gemini 1.5 ultra / gemini 1.5?

[@rahuldinesh2840]

Its cool. Really.

[@InvertedStone]

Glad you liked.

[@yusufeffendi2258]

it will better if you can call function some like =GEMINI("Prompt")

[@InvertedStone]

That's an easier solution, but it times out for even a few hundred rows. But the one I'm showing in the video can easily handle 1000s of rows.

[@damilo7404]

It times out, throws errors and re-runs the formula.
The method in the video is what I have been trying to achieve. I still need to tweak the script but I am sure that this is the foundation that I need.
Thanks for the video.

[@InvertedStone]

@@damilo7404 Yesterday, I have updated the Gemini script, and now there are no errors.