This is the legacy documentation for Google Ads scripts. Go to the current docs.


Retrieve a list of fixtures for the English Premier League

 * @fileoverview Example of using Sportsradar API to get English Premier League
 * soccer schedules, to use in adjusting campaigns.
 * The principles of this example could easily be reused against any of the
 * sports feeds available from Sportradar.
 * Example: Get fixtures on 1st Oct 2016
 * var schedule = getSoccerSchedule(2016, 10, 1);
 * See
 * See

// Replace with the API Key found on your Sportradar API Application page.

// Insert your email address here for notification of API request failures.

var VERSION = 2;
var LEAGUE = 'eu';

// Set to false when no longer in trial mode.
var TRIAL_MODE = true;

 * Retrieves a list of fixtures from the Soccer Schedule API.
 * @param {number} year The year for which to get matches, in the form yyyy.
 * @param {number} month The month for which to get matches, in range 1-12.
 * @param {number} day The day for which to get matches, in range 1-31.
 * @return {!Array.<!Object>} An array of object containing fixture info or
 *     null if the request was unsuccessful.
function getSoccerSchedule(year, month, day) {
  var urlTemplate =
  var accessLevel = TRIAL_MODE ? 't' : 'p';
  var url = Utilities.formatString(
      urlTemplate, accessLevel, VERSION, LEAGUE, year, month, day, API_KEY);
  var response = UrlFetchApp.fetch(url);
  return parseScheduleXml(response.getContentText());

 * Converts the date format returned from the XML feed into a Date object.
 * @param {string} scheduleDate A date from the feed e.g. 2016-07-11T17:00:00Z
 * @return {!Date} The resulting Date object.
function parseScheduleDate(scheduleDate) {
  return new Date(
      scheduleDate.replace(/-/g, '/').replace('T', ' ').replace('Z', ' GMT'));

 * Parses the schedule XML, identifying only English Premier League Soccer
 * matches, as an example of selecting events on which to make Google Ads
 * changes.
 * @param {string} xmlText XML response body from a call to the soccer schedule
 *    API.
 * @return {!Array.<!Object>} An array of object containing fixture info.
function parseScheduleXml(xmlText) {
  var fixtures = [];
  var scheduleElement = XmlService.parse(xmlText).getRootElement();
  // The namespace is required for accessing child elements in the schema.
  var namespace = scheduleElement.getNamespace();
  var matchesElement = scheduleElement.getChild('matches', namespace);

  var matchElements = matchesElement.getChildren();
  for (var i = 0, matchElement; matchElement = matchElements[i]; i++) {
    var status = matchElement.getAttribute('status').getValue();

    var scheduled = matchElement.getAttribute('scheduled').getValue();
    var scheduledDate = parseScheduleDate(scheduled);
    var categoryElement = matchElement.getChild('category', namespace);
    var country = categoryElement.getAttribute('country').getValue();
    var tournamentElement = matchElement.getChild('tournament', namespace);
    var tournamentName = tournamentElement.getAttribute('name').getValue();
    if (tournamentName === 'Premier League' && country === 'England') {
      var homeElement = matchElement.getChild('home', namespace);
      var awayElement = matchElement.getChild('away', namespace);

      var homeTeamName = homeElement.getAttribute('name').getValue();
      var awayTeamName = awayElement.getAttribute('name').getValue();

        date: scheduledDate,
        homeTeam: homeTeamName,
        awayTeam: awayTeamName
  return fixtures;