📒 Automating market research with Google AI Studio Gemini Search grounding + JSON mode this evening: 1⃣ Use Gemini 1.5 Flash + Search grounding to pull recent data about a list of companies, their product offerings, valuations, more. 2⃣ Use JSON mode with Gemini 1.5 Flash-8B to extract out... specific details, for ~$0. 3⃣ Write data back to Google Sheets from Colaboratory:show more

Dropping a link to the Colab notebook here, in case anyone is interested:

@googleaistudio Can you share the jupyter notebook?

@googleaistudio What is the requirement to set this up in Colab notebook? Aside from getting Api key for Gemini 1.5 flash. Is getting Colab pro be the requirement too?

@googleaistudio Nope, just the Gemini API keys! :)

@googleaistudio I love the crabs and kittens in the video 🦀🐈

@googleaistudio Combining Gemini Search with JSON mode and Google Sheets streamlines the whole process. Great workflow

@googleaistudio I need this. Paige should share all the Colab links 😁

@googleaistudio Can you share the jupyter notebook 😁😁?

@googleaistudio Curious how fresh/accurate the search-grounded data is compared to Bloomberg Terminal. At this price point though, who's complaining?

@googleaistudio Grounding is expensive (1000 per 35$) it's a great feature nonetheless