API Reference

Import from Google Sheet

POST /audiences/:id/contacts/import-sheet — import a link-shared sheet; headers become merge tags.

POST/audiences/:id/contacts/import-sheet

Imports contacts from a Google Sheet shared as “Anyone with the link can view”. The sheet needs an email column; every other header (e.g. name, phone_no, marks, country) is auto-registered as a contact property, so each column is usable as a merge tag — Hi {{name}}, we tried reaching you at {{phone_no}} resolves per row. Rows land in a fresh segment you can target from a campaign.

Body parameters

urlstringrequired

The sheet's share URL (docs.google.com/spreadsheets/…). A #gid selects a tab.

segment_namestringoptional

Name for the created segment. Defaults to a dated “Sheet import”.

Request

import { MailBlastr } from 'mailblastr';

const mb = new MailBlastr('mb_xxxxxxxxx');

const { data, error } = await mb.audiences.importSheet('AUDIENCE_ID', {
  "url": "https://docs.google.com/spreadsheets/d/SHEET_ID",
  "segment_name": "Webinar signups"
});
console.log({ data, error });

Response

{
  "object": "sheet_import", "imported": 42, "updated": 3, "skipped": 0, "total": 45,
  "segment_id": "seg_9", "segment_name": "Sheet import 2026-07-04", "segment_added": 45,
  "variables": ["name", "phone_no", "marks", "country"]
}