how to setup a google sheets that syncs your aliases & domains to improvMX

This is a blog explaining how to sync ImprovMX domains and aliases directly from Google Sheets. Each row edit triggers a Google Apps Script that creates or updates the domain, alias, and wildcard alias using the ImprovMX API.

Sheet layout

Create a Google Sheet with these columns:

What the script does

On every row edit:

• Creates the domain if it doesn’t exist
• Creates or updates the alias
• Creates or updates the wildcard (*) alias
• Writes the result to the Status column

Setup

1. Open the sheet
2. Go to Extensions → Apps Script
3. Paste the script below
4. Replace YOUR_API_KEY_HERE with the ImprovMX API key:

Now you just save and exit.

Google Apps Script

const BASE_URL = "https://api.improvmx.com/v3";

const API_KEY = "YOUR_API_KEY_HERE";

const SHEET_NAME = "Sheet1";

const START_ROW = 4;

function onEdit(e) {

 if (!e) return;

 const sheet = e.source.getActiveSheet();

 if (sheet.getName() !== SHEET_NAME) return;

 processRow(sheet, e.range.getRow());

}

function processRow(sheet, row) {

 if (row < START_ROW) return;

 const [domain, alias, forwardTo, status] =

   sheet.getRange(row, 1, 1, 4).getValues()[0];

 if (!domain || !alias || !forwardTo) {

   sheet.getRange(row, 4).setValue("Missing data");

   return;

 }

 const done = `Synced: ${domain} | ${alias} → ${forwardTo}`;

 if (status === done) return;

 try {

   ensureDomain(domain);

   upsertAlias(domain, alias, forwardTo);

   upsertAlias(domain, "*", forwardTo);

   sheet.getRange(row, 4).setValue(done);

 } catch (err) {

   sheet.getRange(row, 4).setValue(`Error: ${err.message}`);

 }

}

function ensureDomain(domain) {

 const res = api("post", "/domains", { domain: domain.trim() });

 if (

   res.code === 200 ||

   res.code === 201 ||

   res.body.includes("already registered")

 ) return;

 throw new Error(res.body);

}

function upsertAlias(domain, alias, forwardTo) {

 const clean = alias.includes("@") ? alias.split("@")[0].trim() : alias.trim();

 const path = `/domains/${encodeURIComponent(domain)}/aliases/${encodeURIComponent(clean)}`;

 const res = api("put", path, { forward: forwardTo });

 if (res.code === 200 || res.code === 201) return;

 throw new Error(res.body);

}

function api(method, path, payload) {

 const r = UrlFetchApp.fetch(BASE_URL + path, {

   method,

   contentType: "application/json",

   payload: JSON.stringify(payload),

   headers: { Authorization: "Basic api:" + API_KEY },

   muteHttpExceptions: true

 });

 return { code: r.getResponseCode(), body: r.getContentText() };

}

Enable the trigger

In Apps Script, open Triggers

Add a trigger:

1. Function: onEdit
2. Event type: On edit

- Then save and authorize the script.

Result

Editing a row keeps ImprovMX domains and aliases in sync with the spreadsheet.
The sheet becomes the source of truth.

‍

‍