An example of a Google Apps Scripts that calls the Youtube API and writes results to BigQuery.

bigQueryYouTube.gs

function youTubeAnalytics() {
  projectId = "xxx";
  datasetId = "xxx";
  tableId = 'xxx';
  myChannels = YouTube.Channels.list('id', {mine: true});
  channel = myChannels.items[0];
  channelId = channel.id;
  yesterday = new Date();
  yesterday.setDate(yesterday.getDate() - 2); // I'm setting it back two days because that's the most recent date for the API.
  yesterday = Utilities.formatDate(yesterday, 'UTC', 'yyyy-MM-dd');
  bigQueryDate = Utilities.formatDate(yesterday, "UTC", "yyyy-MM-dd'T'HH:mm:ss'Z'");
  data = [];
  analyticsResponse = YouTubeAnalytics.Reports.query(
    'channel==' + channelId,
    yesterday,
    yesterday,
    'estimatedMinutesWatched,views,likes,subscribersGained',
    {dimensions: 'video','max-results': '200',sort: '-views'});
  for (i=0; i < analyticsResponse.rows.length; i++){
    vid = analyticsResponse.rows[i][0];
    estimatedMinutesWatched = analyticsResponse.rows[i][1];
    views = analyticsResponse.rows[i][2];
    likes = analyticsResponse.rows[i][3];
    subscribersGained = analyticsResponse.rows[i][4];
    if(vid){
      videoResponse = YouTube.Videos.list('snippet',{id: vid});
      title = videoResponse.items[0].snippet.title;
      data.push(JSON.stringify({
        'title':title,
        'estimatedMinutesWatched':estimatedMinutesWatched,
        'views':views,
        'likes':likes,
        'subscribersGained':subscribersGained,
        'date': bigQueryDate}));
    }
  }
  data = data.join('\n');
  blobData = Utilities.newBlob(data, "application/octet-stream");
  job = {
    configuration: {
      load: {
        destinationTable: {
          projectId: projectId,
          datasetId: datasetId,
          tableId: tableId
        },
        sourceFormat: "NEWLINE_DELIMITED_JSON"
      }
    }
  }
  job = BigQuery.Jobs.insert(job, projectId, blobData);
}