This add a custom function =Gemini("Hello World")
to google sheets
⚠️ Scripts do not protect secret API keys, do not share documents with this script installed
- Go to Google AI Studio and create an API key Here
- Open a new document in Google Sheets, click Extensions / Apps Script
- In the Code.gs, clear the file and paste the code
- Replace the GEMINI_API_KEY with gemini api key
- Save the file
- Then back in your google sheet, test the functionality by typing
=Gemini
, the autocomplete functionality will guide to the rest
For support and enquiries, contact us at [email protected]