Netmend · Tools · Netmend Sheets AI
Type =NETMEND_AI("Write a product title for", A2) and drag it down. Netmend Sheets AI adds AI formulas to any Google Sheet with a short Apps Script you install yourself, using your own free Gemini key.
Ask anything, optionally about a cell or range: write, summarise, rewrite, answer. Free.
Translate a cell into any language, keeping tone. Free.
Pull an email, a company, a price or a date out of messy text. Pro.
Sort feedback, leads or tickets into your own categories. Pro.
Positive, Neutral or Negative for reviews and replies. Pro.
A list that spills down the column: ideas, keywords, names. Pro.
Paste a column of values, pick a function and see what you would get in your sheet. Free: 3 runs a day, 20 rows each.
Code.gs and paste the Netmend code (button below). Click Save.=NETMEND_AI("Write a haiku about", A1).The code is open: read it before you paste it. Identical prompts are cached for 6 hours so recalculation does not burn your quota. Google shows an "unverified app" screen because the script is yours, not a published add-on: click Advanced → Go to project.
Similar add-ons charge $8 to $30 a month on top of your AI bill. Pro is one payment, and you keep using your own free key.
In the sheet, activate Pro with Netmend → Activate Pro licence and the same key.
No. The script runs in your Google account and sends only the text in your formula to Google's Gemini API with your key. Netmend has no server.
Because then there is no monthly fee. Google's free Gemini tier is generous for normal sheet work. Limits are set by Google and can change.
No daily cap, the EXTRACT, CLASSIFY, SENTIMENT and LIST functions, and "Fill selected cells", which writes plain values so the sheet never recalculates the AI again.
Each person who installs the script uses their own key. The licence is per person.