Google Sheets can be integrated with custom ChatGPT. You can provide Sheets read and write functionality for ChatGPT. We will use Python notebook to c

Use Google Sheets in custom ChatGPT

submited by

Style Pass

2024-05-15 10:30:07

Google Sheets can be integrated with custom ChatGPT. You can provide Sheets read and write functionality for ChatGPT. We will use Python notebook to create custom code that will list all values from sheet and allow to update selected cell. The notebook will be served as REST API endpoint, which will be available as GPT Action. The OpenAPI schema for notebook and serving is handled by Mercury framework (opens in a new tab) . The notebooks is deployed online with Mercury Cloud.

Let's create a Python notebook for accessing Google Sheets. We need to install gspread (opens in a new tab) package to make Sheets integration simple and mercury for running notebook as web application:

I kept JSON with credentials in sheets-credentials.json file. Please read article on how to connect Python with Google Sheets service (opens in a new tab) .

The notebook code is ready. We need to put it online, the easiet way is to use Mercury Cloud. We get notebook running under custom domain address in few clicks.