Back to TimelinesAI in Google Sheets
SheetXAI logo
TimelinesAI logo
TimelinesAI · Google Sheets Guide

List All Active WhatsApp Chats from TimelinesAI Into a Google Sheet

2026-05-14
5 min read

The Scenario

It's the third week of the quarter. Your sales manager has 200 open WhatsApp conversations spread across the team in TimelinesAI, and nobody can remember which ones are still unassigned. The pipeline review is in two hours and someone needs to triage.

The spreadsheet is open. It's empty. The data is sitting inside TimelinesAI, paginated across multiple screens, and the only way to get to it right now is to click through each conversation manually.

The bad version:

  • Log into TimelinesAI, filter by "unassigned," screenshot the first page of results, open the sheet, type out the chat IDs by hand.
  • Get to page 3 of results and realize the filter wasn't set correctly — some of the "unassigned" chats already have owners. Start over.
  • Run out of time before the meeting. Walk in with a partial list and an apology.

The data exists. The problem is extraction, not analysis.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Google Sheet. It reads your sheet and talks to TimelinesAI on your behalf — including listing and filtering your open conversations.

List all unread WhatsApp chats from TimelinesAI and paste them into this sheet with columns for chat ID, contact, last message, and assigned agent

What You Get

  • One row per conversation, written directly into your sheet.
  • Columns: chat ID, contact name or phone number, last message text (truncated), last message timestamp, and assigned agent (blank if unassigned).
  • All unread conversations are returned — not just the first page visible in the TimelinesAI UI.
  • Rows are ready to filter, sort, and share with the team without any manual formatting.

What If the Data Is Not Quite Ready

You only want unassigned conversations

List all unread WhatsApp chats from TimelinesAI that have no assigned agent and paste them into this sheet with chat ID, contact number, and last message date — sorted by last message date descending.

You want to join the chat list against a CRM contact sheet

List all unread chats from TimelinesAI with chat ID and contact number. For each number, look it up in the 'CRM' tab column B and write the matching account name from column C into this sheet's column E.

You want to flag high-priority contacts based on a separate list

Fetch all unread TimelinesAI chats and write them into this sheet. Then check column A phone numbers against the 'Priority Accounts' tab — if there's a match, write 'HIGH' in column F, otherwise write 'STANDARD'.

Full triage prep in one prompt

Fetch all unread and unassigned WhatsApp chats from TimelinesAI. Write to this sheet: chat ID, contact number, last message text, last message timestamp, and days since last message. Sort by days since last message descending. Flag any conversation over 3 days old with 'OVERDUE' in column F.

The pattern: fetch, filter, and prioritize in a single prompt rather than pulling first and cleaning second.

Try It

Get the 7-day free trial of SheetXAI and open a blank sheet — then ask it to pull every unread TimelinesAI conversation and organize them for triage. Add your priority-flagging logic to the same prompt. See also: exporting chat message history and the full TimelinesAI overview.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more