CSV Getter Docs
CSV GetterLoginSign Up
  • Welcome
  • What is CSV Getter?
  • The Export URL
  • Data Sources
    • Connect Airtable
    • Connect Notion
    • Connect Google Sheets
    • Upload Data
  • Destinations
    • Connect to Dropbox
    • Connect to Google Drive
  • Exporting
    • Export Airtable
    • Export Airtable (With Airtable URL)
    • Export Airtable (via API)
    • Export Notion
    • Export Google Sheets
    • Export Uploaded Data
  • Automations
    • Export to Excel (Windows)
    • Export to Google Sheets (Drive)
    • Export to Google Sheets (Direct)
    • Export to Dropbox
    • Export to JSON
    • Export to XML
  • Airtable
    • Linked Records and Lookup Fields
    • Export Shared Airtable View
  • Platform Features
    • URL Parameters
    • The "Type" Parameter
    • The "SQL" Parameter
    • Email Notifications
    • Extract JSON Property
    • Embeddable Wordpress HTML
  • Misc
    • Zapier Code Example
    • Google App Script Snippet
  • Custom Chat GPT Code
Powered by GitBook
On this page

Was this helpful?

Custom Chat GPT Code

Create a custom ChatGPT for your terminal. Keep it knowledgable with your data using CSV Getter

import requests
from dotenv import load_dotenv
import os
import openai

data = requests.get('your csv getter URL')
load_dotenv()
my_rates = data.text

OPENAI_API_KEY = os.environ.get("OPENAI_API_KEY")

openai.api_key = OPENAI_API_KEY

context = "My service rates are " + my_rates

messages = [
    {"role": "system", "content": context}
]

while True:
    user_input = input("You: ")

    if user_input.lower() == "exit":
        print("Ending the conversation. Goodbye!")
        break

    messages.append({"role": "user", "content": user_input})

    try:
        response = openai.chat.completions.create(
            model="gpt-4o-mini",
            messages=messages
        )

        assistant_reply = response.choices[0].message.content
        print(f"Servicebot: {assistant_reply}")

        messages.append({"role": "assistant", "content": assistant_reply})

    except Exception as e:
        print(f"An error occurred: {e}")
        break

Video Context:

PreviousGoogle App Script Snippet

Last updated 2 months ago

Was this helpful?