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/GmailReact
npm create vite@latest birthday-ai-app -- --template react
cd birthday-ai-app
npm install axios
npm run devThen replace src/App.jsx with this:
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/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
// Configuration
$simpleSpaApiUrl = 'https://my.simplespa.com/api/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!';
}
?>Last updated