# OpenAI/Chat GPT Integration

Open AI integration is available as a separate npm package

{% tabs %}
{% tab title="Yarn" %}

```sh
yarn add @rowsncolumns/openai
```

{% endtab %}

{% tab title="NPM" %}

```sh
npm install @rowsncolumns/openai
```

{% endtab %}
{% endtabs %}

### Usage

```tsx
import { SpreadsheetProvider, CanvasGrid } from "@rowsncolumns/spreadsheet"
import {
  ASK_OPENAI,
  functionDescriptions as openAIFunctionDescriptions,
} from "@rowsncolumns/openai";
import { functionDescriptions, functions } from "@rowsncolumns/functions";
import { useSpreadsheetState } from "@rowsncolumns/spreadsheet-state"


const allFunctions = {
  ...functions,
  ASK_OPENAI
}

const allFunctionDescriptions = functionDescriptions.concat(
  openAIFunctionDescriptions
);

const MySpreadsheet = () => {
  const { ... } = useSpreadsheetState({
   functions: allFunctions
  })
  return (
    <CanvasGrid
      functionDescriptions={allFunctionDescriptions}
      {...}
    />
  )
}

export const App = () => (
  <SpreadsheetProvider>
    <MySpreadsheet />
  </SpreadsheetProvider>
)

```

<figure><img src="https://67932947-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FHWsslZpYESUXxPccoyig%2Fuploads%2Fgit-blob-531cc46a67252d4decba0891d6b001cf196f180c%2Fopenai.jpg?alt=media" alt=""><figcaption><p>Example of Open AI Integration</p></figcaption></figure>
