# 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**

| Name | Type | Required | Description |
| --- | --- | --- | --- |
| `url` | string | Yes | The sheet's share URL (docs.google.com/spreadsheets/…). A #gid selects a tab. |
| `segment_name` | string | No | Name for the created segment. Defaults to a dated “Sheet import”. |

**Node.js**

```js
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 });
```

**Ruby**

```ruby
require "mailblastr"

Mailblastr.api_key = "mb_xxxxxxxxx"

Mailblastr::Audiences.import_sheet("AUDIENCE_ID", {
  "url": "https://docs.google.com/spreadsheets/d/SHEET_ID",
  "segment_name": "Webinar signups"
})
```

**PHP**

```php
$mailblastr = Mailblastr::client('mb_xxxxxxxxx');

$mailblastr->audiences->importSheet('AUDIENCE_ID', [
  'url' => "https://docs.google.com/spreadsheets/d/SHEET_ID",
  'segment_name' => "Webinar signups"
]);
```

**Python**

```python
import mailblastr

mailblastr.api_key = "mb_xxxxxxxxx"

mailblastr.Audiences.import_sheet("AUDIENCE_ID", {
  "url": "https://docs.google.com/spreadsheets/d/SHEET_ID",
  "segment_name": "Webinar signups"
})
```

**Go**

```go
package main

import (
    "fmt"
    "io"
    "net/http"
    "strings"
)

func main() {
    req, _ := http.NewRequest("POST", "https://api.mailblastr.com/audiences/AUDIENCE_ID/contacts/import-sheet", strings.NewReader(`{
  "url": "https://docs.google.com/spreadsheets/d/SHEET_ID",
  "segment_name": "Webinar signups"
}`))
    req.Header.Set("Authorization", "Bearer mb_xxxxxxxxx")
    req.Header.Set("Content-Type", "application/json")
    res, _ := http.DefaultClient.Do(req)
    defer res.Body.Close()
    out, _ := io.ReadAll(res.Body)
    fmt.Println(string(out))
}
```

**Rust**

```rust
use reqwest::Client;

#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
    let res = Client::new()
        .post("https://api.mailblastr.com/audiences/AUDIENCE_ID/contacts/import-sheet")
        .header("Authorization", "Bearer mb_xxxxxxxxx")
        .header("Content-Type", "application/json")
        .body(r#"{
  "url": "https://docs.google.com/spreadsheets/d/SHEET_ID",
  "segment_name": "Webinar signups"
}"#)
        .send()
        .await?;
    println!("{}", res.text().await?);
    Ok(())
}
```

**Java**

```java
import java.net.URI;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;

var client = HttpClient.newHttpClient();
var request = HttpRequest.newBuilder()
    .uri(URI.create("https://api.mailblastr.com/audiences/AUDIENCE_ID/contacts/import-sheet"))
    .header("Authorization", "Bearer mb_xxxxxxxxx")
    .header("Content-Type", "application/json")
    .method("POST", HttpRequest.BodyPublishers.ofString("""
{
  "url": "https://docs.google.com/spreadsheets/d/SHEET_ID",
  "segment_name": "Webinar signups"
}
"""))
    .build();
var response = client.send(request, HttpResponse.BodyHandlers.ofString());
System.out.println(response.body());
```

**.NET**

```csharp
using System.Net.Http;
using System.Text;

var client = new HttpClient();
var request = new HttpRequestMessage(HttpMethod.Post, "https://api.mailblastr.com/audiences/AUDIENCE_ID/contacts/import-sheet");
request.Headers.Add("Authorization", "Bearer mb_xxxxxxxxx");
request.Content = new StringContent(@"{
  ""url"": ""https://docs.google.com/spreadsheets/d/SHEET_ID"",
  ""segment_name"": ""Webinar signups""
}", Encoding.UTF8, "application/json");
var response = await client.SendAsync(request);
Console.WriteLine(await response.Content.ReadAsStringAsync());
```

**cURL**

```bash
curl -X POST 'https://api.mailblastr.com/audiences/AUDIENCE_ID/contacts/import-sheet' \
  -H 'Authorization: Bearer mb_xxxxxxxxx' \
  -H 'Content-Type: application/json' \
  -d '{
  "url": "https://docs.google.com/spreadsheets/d/SHEET_ID",
  "segment_name": "Webinar signups"
}'
```

**CLI**

```bash
mailblastr audiences import-sheet AUDIENCE_ID \
  --url 'https://docs.google.com/spreadsheets/d/SHEET_ID' \
  --segment-name 'Webinar signups'
```

### Response

```json
{
  "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"]
}
```