Hacker News new | ask | show | jobs
by zhendlin 872 days ago
Call Google Gemini / BARD from Google Sheets directly and for free.

Here's a quick app script I put together so you can simply use =BARD() from within a gsheet

get your api key from google https://makersuite.google.com/app/apikey

in a gsheet, click "extensions" then "app script"

copy + paste the code here into code . gs

hit 'run' and give permissions

viola! you can now use =BARD(prompt) in gsheets!

Per Google: "Right now, developers have free access to Gemini Pro and Gemini Pro Vision through Google AI Studio, with up to 60 requests per minute, making it suitable for most app development needs." Source: https://blog.google/technology/ai/gemini-api-developers-clou....