call google sheet API with columsn ID API_KEY AND STATUS to return the first API key with status "Unused" and update the status of the cell to "Used"

					<?php
/**
 * Function to find and update API status
 */
function maadpro_update_api_status() {
    // Include the Google Sheets API library
    require_once 'path/to/google-api-php-client/vendor/autoload.php';

    // Load the API credentials and create a client
    $client = new Google_Client();
    $client->setAuthConfig('path/to/client_secret.json');
    $client->addScope(Google_Service_Sheets::SPREADSHEETS);

    // Create a Sheets service object
    $service = new Google_Service_Sheets($client);

    // Spreadsheet ID and range
    $spreadsheetId = 'YOUR_SPREADSHEET_ID';
    $range = 'Sheet1!A2:C';

    // Get the API keys and statuses from the spreadsheet
    $response = $service->spreadsheets_values->get($spreadsheetId, $range);
    $values = $response->getValues();

    // Find the first API key with status "Unused"
    foreach ($values as $row) {
        $apiKey = $row[1];
        $status = $row[2];

        if ($status === "Unused") {
            // Update the status to "Used"
            $row[2] = "Used";
            $values = [$row];
            $body = new Google_Service_Sheets_ValueRange([
                'values' => $values
            ]);

            // Update the cell value
            $service->spreadsheets_values->update($spreadsheetId, $range, $body, [
                'valueInputOption' => 'RAW'
            ]);

            // Break out of the loop after updating the status
            break;
        }
    }
}

// Hook the function to a WordPress action
add_action('wp_loaded', 'maadpro_update_api_status');