Access Mandrill in Excel

List Senders

Return the senders that have tried to use this account, both verified and unverified

Fields

  • Address
  • Created
  • Sent
  • Hard Bounces
  • Soft Bounces
  • Rejects
  • Complaints
  • Unsubs
  • Opens
  • Clicks
  • Unique Opens
  • Unique Clicks

List Subaccounts

Get the list of subaccounts defined for the account

Parameters

  • Prefix - An optional prefix to filter the subaccounts' ids and names

Fields

  • Id
  • Name
  • Custom Quota
  • Status
  • Reputation
  • Created
  • First Sent
  • Sent Weekly
  • Sent Monthly
  • Sent Total

Search Messages

Search recently sent messages

Parameters

  • Query
  • Sent After
  • Sent Before
  • Max Results

Fields

  • Ts
  • _id
  • Sender
  • Template
  • Subject
  • Email
  • Tags
  • Opens
  • Opens_detail
  • Clicks
  • Clicks_detail
  • Metadata

Message Info

Get the information for a single recently sent message

Parameters

  • Message ID

Fields

  • Ts
  • _id
  • Sender
  • Template
  • Subject
  • Email
  • Tags
  • Opens
  • Opens_detail
  • Clicks
  • Clicks_detail
  • State
  • Metadata
  • Smtp_events

Tag Info

Return more detailed information about a single tag

Parameters

  • Tag

Fields

  • Tag
  • Sent
  • Hard Bounces
  • Soft Bounces
  • Rejects
  • Complaints
  • Unsubs
  • Opens
  • Clicks

Tag Time Series

Return the recent history (hourly stats for the last 30 days) for a tag

Parameters

  • Tag

Fields

  • Ts
  • Sent
  • Hard Bounces
  • Soft Bounces
  • Rejects
  • Complaints
  • Unsubs
  • Opens
  • Unique Opens
  • Unique Clicks

List Rejects Calls

Retrieves your email rejection blacklist.

Parameters

  • Email - Receiving email
  • Include Expired - Whether to include rejections that have already expired.
  • Filter Subaccount

Fields

  • Email
  • Reason
  • Detail
  • Created
  • Last Event
  • Expires
  • Expired
  • Subaccount

List Whitelist Entries

Retrieves your email rejection whitelist.

Parameters

  • Email - Receiving email
  • Filter Subaccount

Fields

  • Email
  • Detail
  • Created

List URLs

Get the 100 most clicked URLs

Fields

  • Url
  • Send
  • Clicks
  • Unique Clicks

Search URLs

Return the 100 most clicked URLs that match the search query given

Parameters

  • Url - Beginning of URL to search for

Fields

  • Url
  • Send
  • Clicks
  • Unique Clicks

URL Time Series

Return the recent history (hourly stats for the last 30 days) for a url

Parameters

  • Url - Exact URL to show time series for

Fields

  • Time
  • Send
  • Clicks
  • Unique Clicks

List Templates

Return a list of all the templates available to this user

Fields

  • Slug
  • Name
  • Labels
  • Code
  • Subject
  • From Email
  • From Name
  • Text
  • Publish Name
  • Publish Code
  • Publish Subject
  • Publish From Email
  • Publish From Name
  • Publish
  • Published
  • Created
  • Updated

List Webhooks

Get the list of all webhooks defined on the account

Fields

  • Id
  • Url
  • Description
  • Auth_key
  • Created_at
  • Lastsentat
  • Batches_sent
  • Events_sent
  • Last_error

List Inbound Domains

List the domains that have been configured for inbound delivery

Fields

  • Domain
  • Created
  • Valid MX

Access

Follow these steps to create an API key

Add from Manager

The Mandrill Connector is available in the Connectors Manager in the top ribbon:

Head over to the Email and install Mandrill:


Contribute

This connector suite is open-sourced on GitHub.


See

Official Documentation

Mandrill API


Get help with this function in the community →