The Scenario
You're the product manager running the re-engagement campaign. Someone on the growth team asked which Sendbird users haven't been active in 60 days — they want to target that segment with push notifications. The data they need is in Sendbird: user_id, nickname, last-seen timestamp, and whether the account is still active. Getting it out is your problem.
You have never exported a user list from Sendbird before.
The bad version:
- Ask the backend team if there's a Sendbird user export endpoint — get back "yes but it's paginated, you'd need to handle pagination, also there are 500 users so you'd need multiple calls"
- Spend an afternoon learning how to make paginated API calls, writing results to a CSV, importing into a Google Sheet
- Finish the export, discover the "last_seen_at" field is in epoch milliseconds and now you have to convert 500 values before the sheet is usable
The growth team needs this segmented list before their campaign brief is due. The brief is due tomorrow.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Sendbird through its built-in integration, handles pagination automatically, and writes the full user list into your sheet — no API scripting, no CSV importing, no epoch conversion.
List all users in Sendbird and write each user's user_id, nickname, and last seen timestamp into columns A, B, and C of this Google Sheet
What You Get
- All 500 users written into the sheet in one operation — pagination handled automatically
- Columns A, B, and C populated exactly as specified: user_id, nickname, last_seen_at
- The sheet is ready to filter immediately — sort by column C to find the oldest last-seen dates
- No API scripting, no CSV imports, no intermediate steps
What If the Data Is Not Quite Ready
You also need the is_active flag for each user
List all users in Sendbird and write each user's user_id, nickname, last seen timestamp, and is_active status into columns A through D of this Google Sheet
You only want users who haven't been seen in more than 60 days
List all Sendbird users, and for each user where the last seen timestamp is more than 60 days ago from today, write their user_id, nickname, and last seen timestamp into columns A, B, and C — skip any users whose last seen is within the last 60 days
You want to join the Sendbird data with a separate CRM tab that has email addresses
List all Sendbird users and write user_id, nickname, and last seen timestamp into columns A through C of the SendbirdUsers tab — then look up the email address for each user_id from the CRM tab (user_id in column A, email in column B) and write the matched email into column D of SendbirdUsers, leaving it blank where no match is found
Full re-engagement prep in one shot: export, filter dormant users, flag for campaign
List all Sendbird users and write user_id, nickname, last seen timestamp, and is_active into columns A through D — then in column E, write "DORMANT" for any user where the last seen timestamp is more than 60 days ago, and "ACTIVE" for all others
One prompt, your re-engagement segment built and flagged.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to pull your full Sendbird user list with last-seen timestamps into the sheet ready for segmentation. Also see: Export Sendbird Message History Into a Google Sheet for Compliance and the Sendbird integration overview.