【技术分享】ChatGPT 工作空间分析页不给你邮箱？不能导出？写个脚本把它补回来

// ==UserScript==
// @name         ChatGPT Business 分析邮箱增强 + 导出
// @namespace    https://github.com/gpt-email-enhancer
// @version      2.0.0
// @description  在 chatgpt.com/admin/usage 工作空间分析页面为成员表格增加邮箱列，支持 CSV 导出
// @author       yantao
// @match        https://chatgpt.com/*
// @match        https://chat.openai.com/*
// @grant        none
// @run-at       document-start
// ==/UserScript==

(function () {
  'use strict';

  const state = {
    emailMap: {},
    emailByUserId: {},
    nameByUserId: {},
    allMembers: [],
    fetched: false,
    fetching: false,
    uiInjected: false,
    tableProcessed: false,
    accessToken: null,
    userListSeed: null,
    paginating: false,
  };

  const DEBUG = true;
  const log = (...a) => DEBUG && console.log('%c[GPT-Email]', 'color:#10a37f;font-weight:bold', ...a);

  // ---- 1. 拦截网络请求 ----
  const _fetch = window.fetch;
  window.fetch = function (input, init) {
    const url = typeof input === 'string' ? input : (input?.url || '');
    const promise = _fetch.apply(this, arguments);

    if (url.includes('/api/auth/session')) {
      promise.then(r => r.clone().json()).then(d => {
        if (d?.accessToken) state.accessToken = d.accessToken;
      }).catch(() => {});
    }

    if (url.includes('/analytics/user_list')) {
      if (!state.userListSeed) {
        state.userListSeed = { input, init };
        log('已捕获 user_list 请求种子');
      }
      promise.then(r => r.clone().json()).then(d => {
        extractEmailsFromJSON(d, url);
      }).catch(() => {});
      return promise;
    }

    if (
      url.includes('/members') || url.includes('/people') ||
      url.includes('/users') || url.includes('/workspace-user') ||
      url.includes('/admin') || url.includes('/analytics')
    ) {
      promise.then(r => r.clone().json()).then(d => {
        extractEmailsFromJSON(d, url);
      }).catch(() => {});
    }

    return promise;
  };

  async function paginateUserList(originalInput, originalInit, firstCursor, firstQueryId) {
    if (state.paginating) return;
    state.paginating = true;

    const baseUrl = typeof originalInput === 'string'
      ? originalInput : (originalInput?.url || '');

    let cursor = firstCursor;
    let queryId = firstQueryId || null;
    let pageCount = 1;
    const MAX_PAGES = 200;

    try {
      while (cursor && pageCount < MAX_PAGES) {
        pageCount++;
        const u = new URL(baseUrl, location.origin);
        u.searchParams.set('cursor', cursor);
        if (queryId) u.searchParams.set('query_id', queryId);

        const req = (originalInput instanceof Request)
          ? new Request(u.toString(), originalInput)
          : new Request(u.toString(), originalInit);

        const r = await _fetch(req);
        if (!r.ok) { log(`翻页第 ${pageCount} 页失败：${r.status}`); break; }
        const d = await r.json();
        extractEmailsFromJSON(d, u.toString());
        cursor = d?.next_cursor || null;
        if (d?.query_id) queryId = d.query_id;
      }
      log(`翻页完成，共 ${pageCount} 页`);
      showStatus(`已获取全部 ${Object.keys(state.emailMap).length} 个邮箱`, 'success');
    } catch (e) {
      showStatus(`翻页中断：${e.message}`, 'error');
    } finally {
      state.paginating = false;
    }
  }

  // ---- XHR 兜底 ----
  const _xhrOpen = XMLHttpRequest.prototype.open;
  const _xhrSend = XMLHttpRequest.prototype.send;
  XMLHttpRequest.prototype.open = function (m, url) {
    this.__url = url;
    return _xhrOpen.apply(this, arguments);
  };
  XMLHttpRequest.prototype.send = function () {
    this.addEventListener('load', function () {
      const url = this.__url || '';
      if (url.includes('/members') || url.includes('/users') || url.includes('/admin')) {
        try { extractEmailsFromJSON(JSON.parse(this.responseText), url); } catch (_) {}
      }
    });
    return _xhrSend.apply(this, arguments);
  };

  function extractEmailsFromJSON(data, source) {
    if (!data || typeof data !== 'object') return;
    const lists = [];
    for (const key of ['members', 'users', 'items', 'data', 'results', 'people', 'rows']) {
      if (Array.isArray(data[key])) lists.push(data[key]);
    }
    if (Array.isArray(data)) lists.push(data);

    let count = 0;
    for (const list of lists) {
      for (const item of list) {
        const email = item.email || item.email_address || item.user?.email || '';
        const name  = item.name || item.display_name || item.user?.name || '';
        const uid   = item.user_id || item.id || item.user?.id || '';

        if (email && email.includes('@')) {
          if (name) state.emailMap[name.toLowerCase().trim()] = email;
          if (uid)  state.emailByUserId[uid] = email;
          if (uid && name) state.nameByUserId[uid] = name;
          if (!state.allMembers.some(m => m.email === email)) {
            state.allMembers.push({ ...item });
          }
          count++;
        } else if (name && uid) {
          state.nameByUserId[uid] = name;
        }
      }
    }
    if (count > 0) {
      state.fetched = true;
      tryEnhanceTable();
    }
  }

  async function fetchMemberEmails() {
    if (state.fetching || state.paginating) return;
    if (!state.userListSeed) {
      showStatus('请先打开 /admin/usage 让页面发起一次数据请求', 'warn');
      return;
    }
    state.fetching = true;
    showStatus('正在从第一页重新拉取全部成员…');

    state.emailMap = {}; state.emailByUserId = {};
    state.nameByUserId = {}; state.allMembers = [];
    state.fetched = false; state.tableProcessed = false;
    document.querySelectorAll('[data-email-processed]').forEach(el => {
      el.removeAttribute('data-email-processed');
      el.querySelectorAll('.gpt-email-td').forEach(td => td.remove());
    });

    const { input, init } = state.userListSeed;
    const baseUrl = typeof input === 'string' ? input : (input?.url || '');
    const u = new URL(baseUrl, location.origin);
    u.searchParams.delete('cursor');
    u.searchParams.delete('query_id');

    try {
      const req = (input instanceof Request)
        ? new Request(u.toString(), input)
        : new Request(u.toString(), init);
      const r = await _fetch(req);
      if (!r.ok) { showStatus(`首页请求失败：${r.status}`, 'error'); return; }
      const d = await r.json();
      extractEmailsFromJSON(d, u.toString());
      if (d?.next_cursor) {
        await paginateUserList(input, init, d.next_cursor, d.query_id);
      } else {
        showStatus(`已获取全部 ${Object.keys(state.emailMap).length} 个邮箱`, 'success');
      }
    } finally {
      state.fetching = false;
    }
  }

  // ---- 表格增强、UI 注入、CSV 导出、手动导入弹窗 ----
  // 完整逻辑见原文件，限于篇幅这里省略，
  // 接下来的章节是 findUsageTable / tryEnhanceTable /
  // injectToolbar / exportTableCSV / openManualInput 等函数，
  // 行为和文中描述完全一致。

  function init() {
    /* 启动入口：injectStyles + setInterval(tick) + MutationObserver */
  }
  if (document.readyState === 'loading') {
    document.addEventListener('DOMContentLoaded', init);
  } else { init(); }
})();

上面是节选版骨架，完整可用源码请从原始文件 Untitled-1.js 拷贝，或在评论区找我要。