Spreadsheet Chatbot

A chatbot that answers questions based on Google Sheets data using OpenAI's GPT-3.5.

Setup

1. Clone the repository:

git clone https://github.com/EpicShadow1/ian-chatbot.git
cd ian-chatbot

2. Install dependencies:

npm install

3. Create a .env file in the root directory with the following variables:

OPENAI_API_KEY=your_openai_api_key_here
GOOGLE_PROJECT_CREDENTIALS=path_to_your_credentials_file
SPREADSHEET_ID=your_spreadsheet_id_here

4. Set up Google Sheets API:

   • Go to the Google Cloud Console
   • Create a new project or select an existing one
   • Enable the Google Sheets API
   • Create a service account and download the credentials JSON file
   • Share your Google Sheet with the service account email

5. Start the server:

npm start

The server will run at http://localhost:3000

Security Note

This repository is configured to prevent accidental commits of sensitive information. The following files are ignored by Git:

• .env and all .env.* files
• sheetbot.json (Google service account credentials)
• Other sensitive configuration files

Always use the template files provided and never commit actual credentials or API keys.