Starting in Looker 7.4, you can export data directly to Google Sheets using the Google Sheets action from the Looker Action Hub. See the Looker Actions — Google Sheets Help Center article for more information.

Looker supports exporting a Look directly to Google Sheets. In this article, we present some extra Google Sheets functions that make the process smoother.

Basic Setup

You can find the basic setup for exporting a Look to Google Sheets on the Public Sharing, Importing, and Embedding documentation page. The process is:

1. Click the gear menu on the Look page, and select Edit Settings.
2. Turn on Public Access.
3. Save the change.
4. Copy the URL under Google Spreadsheet.
5. Paste the URL into the cell of the Google spreadsheet where you would like the upper-left cell of your data to appear, and then press Enter.

Custom Import Function

The URL above includes the Google Sheets built-in ImportXML function. After receiving some reports of unreliability and long loading times, we developed a custom lookerFetchData function, which addresses some of these problems.

function lookerFetchData(url) {
  url = url.replace(/(\/\w+\.)txt|html|csv|gsxml(\?.*)?/, "$1csv$2");
  var csvString = UrlFetchApp.fetch(url).getContentText();
  var dataIn = Utilities.parseCsv(csvString);
  var dataOut = dataIn.map(function(row) {
  return row.map(function(val) {
  if (val == '') return '';
  var dateMatch = /(\d{4})\-(\d{2})-*(\d{0,})/.exec(val);
  while (dateMatch != null) {
  // first index is full match
  return new Date(dateMatch[1], dateMatch[2] - 1, dateMatch[3] || 1);
  };
  if (val.match(/[-a-zA-Z]/)) {
  return String(val)
  };

  val = val.replace(/[^\d.]/g, '');

  if (val.match(/[0-9.]+/))
  return Number(val);

  return Number(parseInt(val));
  });
  });
  return dataOut;
}

If you have a field with a more granular timestamp format, such as yyyy-MM-dd HH:mm:ss, use the script below to export the full timestamp:

function lookerFetchData(url) {
  url = url.replace(/(\/\w+\.)txt|html|csv|gsxml(\?.*)?/, "$1csv$2");
  var csvString = UrlFetchApp.fetch(url).getContentText();
  var dataIn = Utilities.parseCsv(csvString);
  var dataOut = dataIn.map(function(row) {
  return row.map(function(val) {
  if (val == '') return '';
  var dateMatch = /(\d{4})\-(\d{2})-*(\d{2})_(\d{2})\:(\d{2})\:(\d{2})/.exec(val);
  while (dateMatch != null) {
  // first index is full match
  //return new Date(dateMatch[1], dateMatch[2] - 1, dateMatch[3] || 1);
  return Utilities.formatDate(new Date(dateMatch[1], dateMatch[2] - 1, dateMatch[3], dateMatch[4], dateMatch[5], dateMatch[6]|| 1), "GMT", "MM-dd-yyyy HH:mm:ss");
  };
  if (val.match(/[-a-zA-Z]/)) {
  return String(val)
  };
  val = val.replace(/[^\d.]/g, '');
  if (val.match(/[0-9.]+/))
  return Number(val);
  return Number(parseInt(val));
  });
  });
  return dataOut;
  }

To use this script inside Google Sheets:

1. Navigate to Tools > Script Editor from the top section of the sheet.
2. Create a new blank project.
3. Paste the code above into the script editor and save — you may give it any name. Close the script editor and refresh the Google Sheet.
4. Replace ImportXML from the vanilla setup with lookerFetchData.