function fetch_google_sheet_data() {
$script_url = 'https://script.google.com/macros/s/AKfycbxlNOdAEiUmfQjwl93nh3W71vBwMQH4nP9NDwLDHok1J8SubHC9jPXpoi20bUPE9e-Rlw/exec';
$response = wp_remote_get($script_url);
if (is_wp_error($response)) {
return 'Error fetching data: ' . $response->get_error_message();
}
$body = wp_remote_retrieve_body($response);
$data = json_decode($body, true);
if (json_last_error() !== JSON_ERROR_NONE) {
return 'Error decoding JSON: ' . json_last_error_msg();
}
if (empty($data)) {
return 'No data found.';
}
$output = '';
$output .= '
';
return $output;
}
add_shortcode('show_google_sheet', 'fetch_google_sheet_data');
| ' . esc_html($header) . ' | '; } $output .= '
|---|
| ' . esc_html($cell) . ' | '; } $output .= '