The Scenario
It's Monday morning and your weekly growth review starts in two hours. You run six active LinkedIn campaigns in HeyReach and your manager wants a single table: campaign name, connection requests sent, acceptance rate, messages sent, reply rate — sorted by reply rate so the team can see what's working.
The last time this report was due, you opened HeyReach, clicked into each campaign one at a time, copied the stats into a scratch tab, calculated the rates in two more columns, and pasted everything into the reporting sheet before the call. It took 45 minutes.
The bad version:
- Open each of six campaigns in HeyReach, navigate to the stats panel, and manually read or copy the metrics one campaign at a time.
- Paste each campaign's numbers into a scratch tab in your Google Sheet, then write a formula to calculate acceptance rate and reply rate per row.
- Sort the table, format it, and paste it into the reporting sheet before the meeting starts — only to discover that one campaign's stats didn't refresh yet.
You have two hours and this is one of four things on your prep list. The report shouldn't be what consumes them.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, understands what you need, and through its built-in HeyReach integration it can pull campaign stats, calculate rates, and write everything to your sheet in a single ask.
Fetch overall HeyReach stats for all campaigns over the last 30 days and write campaign name, connection requests sent, accepted, messages sent, and replies into my sheet — one row per campaign
What You Get
- One row per campaign lands in your active sheet with all five metrics populated.
- The data is current as of the moment you run the prompt — no cached or stale numbers.
- You can follow up immediately: "Add a column for acceptance rate (accepted ÷ sent) and a column for reply rate (replies ÷ messages sent)" or include both asks in a single prompt.
- The sheet is ready for the meeting without manual reformatting.
What If the Data Is Not Quite Ready
You need calculated rate columns added automatically
The raw numbers are useful but what you actually need for the review is acceptance rate and reply rate already computed.
Fetch HeyReach campaign stats for the last 30 days — write campaign name, connection requests sent, accepted, messages sent, replies, acceptance rate, and reply rate into my 'Campaign Performance' sheet — acceptance rate is accepted ÷ sent, reply rate is replies ÷ messages sent
You only want campaigns that are currently active
You have some paused and completed campaigns in HeyReach and don't want them cluttering the report.
Pull HeyReach stats for all active campaigns from the last 30 days — skip any campaign with status paused or completed — write the metrics into my sheet one row per campaign
The report needs to cover multiple time windows side by side
Leadership wants to compare last 30 days versus last 7 days to see if performance is trending up or down.
Pull HeyReach campaign stats for the last 30 days and for the last 7 days — write both sets of metrics into my 'Weekly Review' sheet — 30-day columns first, then 7-day columns, one row per campaign
Pull stats, calculate rates, rank by reply rate, and flag top performers — in one shot
Fetch HeyReach stats for all campaigns over the last 30 days — add calculated acceptance rate and reply rate columns — sort by reply rate descending — mark the top 2 campaigns in column H as "Top Performer" — write everything into my 'Campaign Performance' sheet
Combining the analysis and the output into one prompt is faster than running them as two separate asks, and the result is review-ready without additional cleanup.
Try It
Get the 7-day free trial of SheetXAI and open whatever Google Sheet you use for campaign reporting. Ask it to pull your HeyReach stats and build the table you'd normally assemble by hand. See also how to bulk import leads into HeyReach or view the full HeyReach integration overview.