> For the complete documentation index, see [llms.txt](https://docs.simplespa.net/simplespa-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.simplespa.net/simplespa-documentation/api/simplespa-enterprise-api/integrations/openai.md).

# OpenAI

Here is an easy integration flow to start using OpenAI with the SimpleSpa API

## Flow

```
SimpleSpa API (/clients.php)
        ↓
Filter Clients (birthday month = this month)
        ↓
For Each Client:
    ↓
    → Create custom prompt (Name + Birthday)
    → Send to OpenAI (ChatGPT API)
    → Receive Birthday Message
    → (Optional) Send email via Mailchimp/Gmail
```

## React

```
npm create vite@latest birthday-ai-app -- --template react
cd birthday-ai-app
npm install axios
npm run dev
```

Then replace src/App.jsx with this:

```jsx
import { useEffect, useState } from 'react';
import axios from 'axios';

function App() {
  const [clients, setClients] = useState([]);
  const [messages, setMessages] = useState([]);
  const [loading, setLoading] = useState(true);

  const simpleSpaApiKey = 'YOUR_SIMPLESPA_API_KEY';
  const openaiApiKey = 'YOUR_OPENAI_API_KEY';
  const simpleSpaApiUrl = 'https://my.simplespa.com/api/v1/clients.php';
  const todayMonth = new Date().getMonth() + 1; // JS months are 0-indexed
  const todayDay = new Date().getDate();

  useEffect(() => {
    async function fetchClientsAndMessages() {
      try {
        // Step 1: Fetch clients
        const response = await axios.post(
          simpleSpaApiUrl,
          {
            dob_month: todayMonth,
            dob_day: todayDay,
            page: 1,
            per_page: 100
          },
          {
            headers: {
              Authorization: `Bearer ${simpleSpaApiKey}`,
              'Content-Type': 'application/json'
            }
          }
        );

        const clients = response.data.clients || [];
        setClients(clients);

        // Step 2: Generate birthday messages
        const newMessages = [];

        for (const client of clients) {
          const name = client.firstname || 'Client';

          const aiResponse = await axios.post(
            'https://api.openai.com/v1/chat/completions',
            {
              model: 'gpt-4', // or 'gpt-3.5-turbo'
              messages: [
                { role: 'system', content: 'You are a creative assistant for a spa.' },
                { role: 'user', content: `Write a short, warm, friendly birthday message for a client named ${name}.` }
              ],
              temperature: 0.7
            },
            {
              headers: {
                Authorization: `Bearer ${openaiApiKey}`,
                'Content-Type': 'application/json'
              }
            }
          );

          const message = aiResponse.data.choices[0]?.message?.content || 'Happy Birthday!';
          newMessages.push({ name, email: client.email, message });
        }

        setMessages(newMessages);
      } catch (error) {
        console.error('Error fetching clients or generating messages:', error);
      } finally {
        setLoading(false);
      }
    }

    fetchClientsAndMessages();
  }, []);

  return (
    <div style={{ padding: '2rem', fontFamily: 'Arial, sans-serif' }}>
      <h1>🎉 Birthday Messages</h1>

      {loading ? (
        <p>Loading...</p>
      ) : messages.length === 0 ? (
        <p>No birthdays today!</p>
      ) : (
        <div>
          {messages.map((item, index) => (
            <div key={index} style={{ marginBottom: '2rem', padding: '1rem', background: '#f9f9f9', borderRadius: '8px' }}>
              <h3>{item.name} ({item.email})</h3>
              <p>{item.message}</p>
            </div>
          ))}
        </div>
      )}
    </div>
  );
}

export default App;
```

## What This React App Does:

| Step | Action                                                       |
| ---- | ------------------------------------------------------------ |
| 1    | Calls your SimpleSpa API to get today’s birthday clients     |
| 2    | For each client, calls OpenAI and generates a unique message |
| 3    | Displays the generated birthday messages on the screen       |

## PHP

To do this directly on your webserver you can also create a PHP file that generates this message

```php
<?php
// Configuration
$simpleSpaApiUrl = 'https://my.simplespa.com/api/v1/clients.php';
$simpleSpaApiKey = 'YOUR_SIMPLESPA_API_KEY_HERE';

$openaiApiKey = 'YOUR_OPENAI_API_KEY_HERE';
$openaiModel = 'gpt-4'; // or 'gpt-3.5-turbo' if you want cheaper
$todayMonth = date('n'); // 1-12
$todayDay = date('j');   // 1-31

// 1. Fetch clients with birthday today
$clients = fetchClientsWithBirthdayToday($simpleSpaApiUrl, $simpleSpaApiKey, $todayMonth, $todayDay);

if (empty($clients)) {
    echo "No clients found with birthday today.\n";
    exit;
}

foreach ($clients as $client) {
    $firstname = $client['firstname'];
    $email = $client['email'];

    // 2. Generate a birthday message with OpenAI
    $message = generateBirthdayMessage($firstname, $openaiApiKey, $openaiModel);

    // Output
    echo "🎉 Birthday Message for {$firstname} ({$email}):\n";
    echo $message . "\n\n";
}

// Functions

function fetchClientsWithBirthdayToday($apiUrl, $apiKey, $month, $day) {
    $postData = json_encode([
        'dob_month' => (int)$month,
        'dob_day' => (int)$day,
        'page' => 1,
        'per_page' => 100
    ]);

    $ch = curl_init($apiUrl);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_HTTPHEADER, [
        'Authorization: Bearer ' . $apiKey,
        'Content-Type: application/json'
    ]);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $postData);
    curl_setopt($ch, CURLOPT_POST, true);

    $response = curl_exec($ch);
    if (curl_errno($ch)) {
        echo 'SimpleSpa API error: ' . curl_error($ch) . "\n";
        return [];
    }
    curl_close($ch);

    $data = json_decode($response, true);
    if (isset($data['clients']) && is_array($data['clients'])) {
        return $data['clients'];
    }
    return [];
}

function generateBirthdayMessage($clientName, $openaiKey, $model) {
    $prompt = "Write a short, warm, friendly birthday message for a client named {$clientName}.";

    $payload = json_encode([
        'model' => $model,
        'messages' => [
            ['role' => 'system', 'content' => 'You are a creative assistant for a beauty spa.'],
            ['role' => 'user', 'content' => $prompt]
        ],
        'temperature' => 0.7
    ]);

    $ch = curl_init('https://api.openai.com/v1/chat/completions');
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_HTTPHEADER, [
        'Authorization: Bearer ' . $openaiKey,
        'Content-Type: application/json'
    ]);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $payload);
    curl_setopt($ch, CURLOPT_POST, true);

    $response = curl_exec($ch);
    if (curl_errno($ch)) {
        echo 'OpenAI API error: ' . curl_error($ch) . "\n";
        return 'Happy Birthday!';
    }
    curl_close($ch);

    $data = json_decode($response, true);
    if (isset($data['choices'][0]['message']['content'])) {
        return trim($data['choices'][0]['message']['content']);
    }
    return 'Happy Birthday!';
}
?>
```


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.simplespa.net/simplespa-documentation/api/simplespa-enterprise-api/integrations/openai.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.