Build an Event Registration System with Google Sheets

const API_URL = 'https://sheetapi.pro/api/v1/sheets/YOUR_SHEET_ID/data';
const API_KEY = 'YOUR_API_KEY';
const EVENT_NAME = 'Tech Conference 2024';

// Ticket selection
document.querySelectorAll('.ticket-option').forEach(option => {
    option.addEventListener('click', function() {
        document.querySelectorAll('.ticket-option').forEach(o => o.classList.remove('selected'));
        this.classList.add('selected');
        document.querySelector('input[name="ticket"]').value = this.dataset.ticket;
    });
});

// Form submission
document.getElementById('registrationForm').addEventListener('submit', async (e) => {
    e.preventDefault();
    
    const formData = new FormData(e.target);
    const data = {
        Name: formData.get('name'),
        Email: formData.get('email'),
        Event: EVENT_NAME,
        'Ticket Type': formData.get('ticket'),
        'Date Registered': new Date().toISOString(),
        Confirmed: 'No'
    };
    
    try {
        const response = await fetch(API_URL, {
            method: 'POST',
            headers: {
                'Content-Type': 'application/json',
                'Authorization': `Bearer ${API_KEY}`
            },
            body: JSON.stringify(data)
        });
        
        if (response.ok) {
            document.getElementById('status').innerHTML = 
                '<div class="success">✓ Registration successful! Check your email for confirmation.</div>';
            e.target.reset();
            document.querySelectorAll('.ticket-option').forEach(o => o.classList.remove('selected'));
        } else {
            throw new Error('Registration failed');
        }
    } catch (error) {
        document.getElementById('status').innerHTML = 
            '<div style="color:red; padding:15px; background:#f8d7da; border-radius:4px;">✗ Registration failed. Please try again.</div>';
    }
});

// Attendee list widget (read-only view)
const API_URL = 'https://sheetapi.pro/api/v1/sheets/YOUR_SHEET_ID/data';
const API_KEY = 'YOUR_API_KEY';

async function loadAttendees() {
    try {
        const response = await fetch(API_URL, {
            headers: { 'Authorization': `Bearer ${API_KEY}` }
        });
        
        const data = await response.json();
        const attendees = data.data || [];
        
        const confirmedCount = attendees.filter(a => a.Confirmed === 'Yes').length;
        
        document.getElementById('attendeeCount').textContent = confirmedCount;
        
        const listHtml = attendees
            .filter(a => a.Confirmed === 'Yes')
            .map(a => `
                <div class="attendee">
                    <strong>${a.Name}</strong>
                    <span class="ticket-badge">${a['Ticket Type']}</span>
                </div>
            `).join('');
        
        document.getElementById('attendeeList').innerHTML = listHtml;
        
    } catch (error) {
        console.error('Failed to load attendees:', error);
    }
}

loadAttendees();
// Refresh every 30 seconds
setInterval(loadAttendees, 30000);

from flask import Flask, request, jsonify
import requests
from datetime import datetime

app = Flask(__name__)

SHEET_ID = 'YOUR_SHEET_ID'
API_KEY = 'YOUR_API_KEY'
API_URL = f'https://sheetapi.pro/api/v1/sheets/{SHEET_ID}/data'

@app.route('/register', methods=['POST'])
def register():
    data = request.json
    
    payload = {
        'Name': data.get('name'),
        'Email': data.get('email'),
        'Event': data.get('event', 'My Event'),
        'Ticket Type': data.get('ticket_type'),
        'Date Registered': datetime.now().isoformat(),
        'Confirmed': 'No'
    }
    
    headers = {
        'Content-Type': 'application/json',
        'Authorization': f'Bearer {API_KEY}'
    }
    
    response = requests.post(API_URL, json=payload, headers=headers)
    
    if response.status_code == 200:
        # TODO: Send confirmation email
        return jsonify({
            'success': True, 
            'message': 'Registration successful'
        })
    else:
        return jsonify({
            'success': False, 
            'error': 'Registration failed'
        }), 500

@app.route('/attendees', methods=['GET'])
def get_attendees():
    headers = {'Authorization': f'Bearer {API_KEY}'}
    response = requests.get(API_URL, headers=headers)
    
    if response.status_code == 200:
        attendees = response.json().get('data', [])
        confirmed = [a for a in attendees if a.get('Confirmed') == 'Yes']
        
        return jsonify({
            'success': True,
            'total': len(attendees),
            'confirmed': len(confirmed),
            'attendees': confirmed
        })
    else:
        return jsonify({'success': False}), 500

if __name__ == '__main__':
    app.run(debug=True)

<?php
// event-registration.php
header('Content-Type: application/json');

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $data = json_decode(file_get_contents('php://input'), true);
    
    $payload = [
        'Name' => $data['name'],
        'Email' => $data['email'],
        'Event' => $data['event'] ?? 'My Event',
        'Ticket Type' => $data['ticket_type'],
        'Date Registered' => date('c'),
        'Confirmed' => 'No'
    ];
    
    $ch = curl_init('https://sheetapi.pro/api/v1/sheets/YOUR_SHEET_ID/data');
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($payload));
    curl_setopt($ch, CURLOPT_HTTPHEADER, [
        'Content-Type: application/json',
        'Authorization: Bearer YOUR_API_KEY'
    ]);
    
    $response = curl_exec($ch);
    $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
    curl_close($ch);
    
    if ($httpCode === 200) {
        // TODO: Send confirmation email
        echo json_encode(['success' => true, 'message' => 'Registered successfully']);
    } else {
        http_response_code(500);
        echo json_encode(['success' => false, 'error' => 'Registration failed']);
    }
}
?>

# Register a new attendee
curl -X POST https://sheetapi.pro/api/v1/sheets/YOUR_SHEET_ID/data \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -d '{
    "Name": "Jane Smith",
    "Email": "jane@example.com",
    "Event": "Tech Conference 2024",
    "Ticket Type": "Early Bird",
    "Date Registered": "2024-01-15T10:30:00Z",
    "Confirmed": "No"
  }'

# Get all attendees
curl -X GET https://sheetapi.pro/api/v1/sheets/YOUR_SHEET_ID/data \
  -H "Authorization: Bearer YOUR_API_KEY"

# Update confirmation status (requires row ID)
curl -X PATCH https://sheetapi.pro/api/v1/sheets/YOUR_SHEET_ID/data/5 \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -d '{"Confirmed": "Yes"}'