Last Updated: February 25, 2016
· christaggart

Quickly lookup potential domains/startup ideas with google spreadsheets and domainr

Create a Google spreadsheet and create a new custom script that includes the following:

function domainLookup(domain) {
  var result = "";
  if (domain == "") {

  // Function to lookup available domains on domainr
  httpResult = UrlFetchApp.fetch(""+domain);
  res = Utilities.jsonParse(httpResult);
  for (i in res.results) {
   var domain = res.results[i];
    if (domain.availability == 'available' || domain.availability == 'maybe') {
      result = result + "\n" + domain.domain + ": " + domain.availability;

  return result;


In your spreadsheet create two columns, one with your name ideas, and one with:
where A1 is the cell that contains your domain name.

Copy this formula down whatever number of cells you need to.

1 Response
Add your response

This is giving me an error in my cell:

Request failed for returned code 401. Truncated server response: {"message":"unauthorized: invalid API client ID"} (use muteHttpExceptions option to examine full response) (line 11).

Any ideas for a fix?

over 1 year ago ·