function doPost(e) {
    try {
        const data = JSON.parse(e.postData.contents);
        const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

        // Calculate row: use provided row from client (local time based) or fallback to server time
        let row;
        if (data.row) {
            row = data.row;
        } else {
            // Fallback
            const today = new Date();
            const dayOfMonth = today.getDate();
            row = dayOfMonth + 1;
        }

        // Process each company's data
        const results = [];

        data.entries.forEach(entry => {
            const { column, value, type } = entry;

            if (column && value !== undefined) {
                // Convert column letter to number (A=1, B=2, etc.)
                const colNum = columnLetterToNumber(column.toUpperCase());

                // Set the cell value
                sheet.getRange(row, colNum).setValue(value);

                results.push({
                    cell: `${column.toUpperCase()}${row}`,
                    value: value,
                    status: 'success'
                });
            }
        });

        return ContentService
            .createTextOutput(JSON.stringify({ success: true, results, row }))
            .setMimeType(ContentService.MimeType.JSON);

    } catch (error) {
        return ContentService
            .createTextOutput(JSON.stringify({ success: false, error: error.message }))
            .setMimeType(ContentService.MimeType.JSON);
    }
}

function doGet(e) {
    // Test endpoint to verify the script is working
    return ContentService
        .createTextOutput(JSON.stringify({
            success: true,
            message: 'Workflow Timer script is active!',
            timestamp: new Date().toISOString()
        }))
        .setMimeType(ContentService.MimeType.JSON);
}

function columnLetterToNumber(letter) {
    let result = 0;
    for (let i = 0; i < letter.length; i++) {
        result = result * 26 + (letter.charCodeAt(i) - 64);
    }
    return result;
}