HubSpotResend

Email a weekly HubSpot campaign performance recap

A HubSpot + Resend agent flow

Every Monday a marketer logs into HubSpot, clicks into a campaign, reads off the numbers, and pastes them into an email to the team. It takes twenty minutes and it's the same twenty minutes every week. The agent can do the reading and the writing. It calls get_campaign_analytics for the campaigns you track, pulls the performance figures, and sends a recap with send-email: sends, opens, clicks, and the week-over-week move. HubSpot returns the analytics when the agent asks, so the agent runs on your weekly cadence, composes the recap from the numbers it read, and delivers it before the standup instead of during it.

The flow

HubSpotget_campaign_analytics

Retrieves performance analytics for a marketing campaign.

Resendsend-email

Sends a single transactional email immediately or scheduled, with HTML/text, attachments, CC/BCC, and tags.

Step by step

  1. Pull the analytics

    The agent calls get_campaign_analytics for each campaign on your list and reads the performance metrics it returns for the reporting period.

  2. Compose the recap

    It lays the figures into a short email, one block per campaign, and where it kept last week's numbers it shows the delta. A headline line carries the totals across campaigns.

  3. Send the email

    send-email delivers the recap to the marketing list from your verified domain, scheduled for Monday morning, tagged so it files into the weekly-reports thread.

Tell your agent

Every Monday at 8am, call get_campaign_analytics for each campaign in my list, and email the marketing team a recap with sends, opens, clicks, and the change versus last week for each. Put combined totals at the top.

Setup

This flow needs both servers connected to your agent. Follow each install guide:

Worth knowing

  • get_campaign_analytics is per campaign, so the agent loops your list and makes one call each. The metrics returned are HubSpot's campaign performance fields; it doesn't return the contact-level detail, so don't promise per-recipient breakdowns the tool can't provide.
  • Week-over-week deltas require last week's numbers from somewhere. The agent has to retain the prior run's figures, or read a stored copy, since a single analytics call only gives the current period.
  • send-email needs a verified sending domain with SPF and DKIM in Resend. Set that up first, or the recap may not reach inboxes outside your own org.

Questions

Can it cover all campaigns automatically?
get_campaign_analytics takes a campaign, so the agent needs the set of campaigns to report on. Maintain that list, or have the agent first discover active campaigns through HubSpot's campaign tools and then pull analytics for each.
Does a campaign with no activity break the recap?
No. The metrics come back at or near zero. Have the agent note it as quiet rather than dropping it, or filter it out of the recap entirely, depending on whether the team wants the full roster or only movers.