Use Google Apps Script to Create A BigQuery Table with nested JSON fields.

createBigQueryTable.gs

function createBigQueryTable() {
  projectId = "xxx";
  datasetId = "xxx";
  var tableId = 'xxx';
  var table = {
    tableReference: {
      projectId: projectId,
      datasetId: datasetId,
      tableId: tableId
    },
    schema: {
      fields: [
        // This example is for the Google Maps API. You can change the fields as needed, but this is used to demostrated nested fields.
        {name: 'location', type: 'RECORD', "fields": [{name: 'lat', type: 'FLOAT'},{name: 'lng', type: 'FLOAT'}]},
        {name: 'id', type: 'STRING'},
        {name: 'place_id', type: 'STRING'},
        {name: 'reference', type: 'STRING'}
      ]
    }
  };
  table = BigQuery.Tables.insert(table, projectId, datasetId);
  Logger.log('Table created: %s', table.id);
}