This project is a Google Sheets add-on developed using Google Apps Script and TypeScript. It provides access to LLMs providers conveniently inside of google sheets. Currently, it supports the following providers:
- OpenAI
-
Clone the Repository:
git clone https://github.com/allen-n/sheets-ai cd sheets-ai -
Install Dependencies: Ensure you have Node.js and npm installed, then run:
npm i pnpm -g pnpm install
-
Authenticate Clasp: Run the following command and follow the instructions to authenticate:
pnpm clasp login
-
Create your .clasp.json: Create a
.clasp.jsonat the top level of the directory that mirrors example.clasp.json. -
Replace the script ID with the ID of your Google Apps Script project
- Navigate to
https://docs.google.com/spreadsheets/and open the sheet you want to develop the add-on in. - Click on
Extensions->Apps Script - Navigate to
Project Settings(the gear icon.) - Copy the Script id listed on the settings page.
- Navigate to
-
Push to Google Apps Script: Use
claspto push your code to Google Apps Script:pnpm clasp:push # single push pnpm clasp:watch # watch for changes and push
-
Create a New Version: Create a new version of your script:
clasp version "Your version description" -
Deploy as an Add-on: Follow the Google Workspace Marketplace documentation to deploy your add-on.
- [TBD: Instructions on how to use the add-on once installed in Google Sheets.]
- [TBD: Instructions on how to run tests, if applicable.]
- Fork the repository.
- Create a new branch (
git checkout -b yourUsername/YourFeature). - Commit your changes (
git commit -am 'Add some feature'). - Push to the branch (
git push origin yourUsername/YourFeature). - Open a pull request.
- Once approved, squash and merge your branch.
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
SheetsAI uses PostHog to collect anonymous usage data to improve the add-on. The analytics implementation follows these key principles:
- No sheet content, prompts, or raw user emails are collected
- Users can opt out at any time via the Settings UI
- Events are batched to respect Google Apps Script quotas
- All data is tied to a randomly generated UUID and, when available, a hashed email