Page template to insert Google Sheets JSON feed into WordPress

page-insert-from-google-sheets.php

<?php
//Template Name: Insert Json from Google Sheets

//Testing Mode First
$test = true;

//Google Sheet JSON Feed Url
$url = 'https://spreadsheets.google.com/feeds/list/{{UNIQUE-ID}}/od6/public/values?alt=json';

//Convert our JSON into a PHP Array
$array = json_decode(file_get_contents($url),true);

if($array) { 
  if($test){  //Testing mode simply outputs the data onto the screen to verify
    foreach ($array[feed][entry] as $row){ //Loop through the feed and output each row
      echo 'Post Title:' . $row['gsx$title']['$t'] . '<br>';  
      echo 'Post Content:' . $row['gsx$content']['$t'] . '<br><br>';
    }
  }else{ //Live mode actually inserts the post into our database
    foreach ($array[feed][entry] as $row) { //Loop through the feed so we can insert each post
      $post_arr = array(
        'post_title' => $row['gsx$title']['$t'], //Title of post
        'post_type' =>'post', //could be any custom post type
        'post_content' => $row['gsx$content']['$t']
      );
      wp_insert_post($post_arr, true);
    }    
  }
} 

?>