The Scenario
You are an events manager running a peer-to-peer marathon fundraising campaign. 300 individual fundraisers have registered. The campaign closes Sunday.
Your program director wants a ranked leaderboard in a Google Sheet by Friday afternoon so the team can send personalized encouragement messages to anyone who has raised less than 20% of their goal. That outreach has to go out Friday evening — the campaign closes in two days and every dollar counts.
The slow version of Thursday:
- Open the Raisely admin dashboard, navigate to the fundraiser profiles section
- Page through 300 profiles, 20 at a time
- Copy each fundraiser's name, goal, and total raised into the sheet by hand
- Realize you also need donor counts and Raisely does not show all three fields on the same page
- Navigate to a separate API view to get donor counts
- Cross-reference the two data sets manually
- It is 5 PM. You have 80 profiles entered. The outreach goes out half-covered.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Raisely campaign via the API and writes the full leaderboard for you, so you never have to page through the admin panel or cross-reference two exports.
Open the SheetXAI sidebar and type:
Fetch all fundraiser profiles from my Raisely campaign 'marathon-2025', rank them by amount raised descending, and populate this sheet with fundraiser name, goal, amount raised, donor count, and percentage of goal reached. Add a 'Status' column that flags anyone below 20% of goal as 'Needs Outreach'.
SheetXAI pulls all 300 profiles, calculates the percentage column, adds the status flag, and writes the ranked list into the sheet. The outreach team has their list in minutes, not hours.
What You Get
A complete ranked leaderboard:
- Fundraiser name — one row per profile
- Goal and amount raised — exact values from Raisely
- Donor count — how many people backed each fundraiser
- Percentage of goal reached — calculated inline
- Status flag — "Needs Outreach" for anyone below 20%, so the outreach team knows exactly who to contact
All 300 profiles, ranked from top to bottom. SheetXAI handles Raisely's pagination automatically, so no profile gets skipped.
Want a second view showing only team profiles instead of individual fundraisers? Ask for it in the same prompt.
What If the Data Is Not Quite Ready
Peer-to-peer campaign data comes with complications. Fundraisers with no donations yet, team profiles alongside individual ones, and names that are duplicated across different teams.
When some fundraisers have not made their page public yet
Raisely sometimes includes draft or unpublished profiles in the API response. You only want live fundraisers in the leaderboard.
Fetch all fundraiser profiles from 'marathon-2025'. Filter to profiles with status 'active' or 'published' only. Rank by amount raised descending and write name, goal, raised, and donor count to this sheet.
When you need to break out team fundraisers separately
The campaign has both individual and team fundraiser profiles. You want a separate tab for each.
Fetch all fundraiser profiles from 'marathon-2025'. Write individual profiles to the 'Individuals' tab ranked by amount raised. Write team profiles to the 'Teams' tab ranked by total raised. In each tab, add a percentage-of-goal column.
When the program director wants top-3 called out separately
Leadership wants the top three fundraisers highlighted in a summary row before the main leaderboard.
Fetch all fundraiser profiles from 'marathon-2025'. Write the top 3 by amount raised into rows 2 through 4 with a 'TOP FUNDRAISER' label in column A. Then write the full ranked list starting at row 6, without the top 3 repeated.
When you need to enrich the list with contact details for outreach
The outreach team needs email addresses alongside the leaderboard data. Raisely stores email on the user record, not the profile.
Fetch all fundraiser profiles from 'marathon-2025'. For each profile, look up the associated user's email address. Add an 'Email' column to the leaderboard sheet. Flag anyone below 20% of goal as 'Needs Outreach' so the team can filter and contact them directly.
The pattern: the leaderboard is not just a data pull, it is the input to the next action. Pull, enrich, and flag in one prompt so the outreach team can move immediately.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull your peer-to-peer campaign's fundraiser profiles into a ranked sheet. The Raisely integration is included in every plan. See also how to import donations for board reporting or the Raisely in Google Sheets overview.