Nevado Pitita 5000m

Mountains | No comments

<?php

function sheet_value_shortcode($atts) {
    $API = 'AIzaSyDoTr4Y6-w6Tulx-PTS2ylE8WP3-d00a5w';
    $google_spreadsheet_ID = '1RJtpFysDP8Zwwj4z_UEJ6_1Z_k25nw8ILxjJ5R7HcVo';
    $api_key = esc_attr( $API);

    $location = $atts['location'];

    $get_cell = new WP_Http();
    $cell_url = "https://sheets.googleapis.com/v4/spreadsheets/$google_spreadsheet_ID/values/$location?&key=$api_key";	
    $cell_response = $get_cell -> get( $cell_url);
    $json_body = json_decode($cell_response['body'],true);	
    $cell_value = $json_body['values'][0][0];
    return $cell_value;
}
add_shortcode('get_sheet_value', 'sheet_value_shortcode');