4 ms·
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
by zhendlin 3y 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 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-cloud/#:~:text=Right%20now%2C%20developers%20have%20free,for%20most%20app%20development%20needs https://blog.google/technology/ai/gemini-api-developers-clou....