Grab Titles, URLs & Descriptions from Google SERPs (TSV)

Copy the snippet below into your console�it will extract each result�s title, URL, and description, build a tab-separated table, and pop up an overlay you can copy & paste directly into Google Sheets.

// == Grab titles, URLs & descriptions as TSV for Sheets ==
(function() {
  // 1. Collect title, URL & description from each result container
  const results = Array.from(document.querySelectorAll('div.tF2Cxc'))
    .map(el => {
      const titleEl = el.querySelector('h3');
      const linkEl  = el.querySelector('a');
      // description can live in different classes
      const descEl  = el.querySelector('div.VwiC3b, .IsZvec, .aCOpRe');
      return {
        title:       titleEl ? titleEl.innerText.trim().replace(/\t/g,' ') : '',
        url:         linkEl  ? linkEl.href : '',
        description: descEl  ? descEl.innerText.trim().replace(/\t/g,' ') : ''
      };
    })
    .filter(r => r.url);

  // 2. Build TSV string
  let tsv = 'Title\tURL\tDescription\n';
  results.forEach(({ title, url, description }) => {
    tsv += `${title}\t${url}\t${description}\n`;
  });

  // 3. Debug-log it
  console.log(tsv);

  // 4. Create fixed overlay
  const overlay = document.createElement('div');
  Object.assign(overlay.style, {
    position:   'fixed',
    top:        '10px',
    right:      '10px',
    width:      '550px',
    maxHeight:  '75vh',
    overflow:   'auto',
    background: '#fff',
    border:     '1px solid #ccc',
    padding:    '10px',
    zIndex:     9999,
    fontFamily: 'monospace',
    fontSize:   '12px'
  });

  const ta = document.createElement('textarea');
  ta.readOnly = true;
  ta.style.width  = '100%';
  ta.style.height = '400px';
  ta.value = tsv;
  overlay.appendChild(ta);

  const btn = document.createElement('button');
  btn.textContent = 'Copy for Sheets';
  btn.style.marginTop = '5px';
  btn.onclick = () => {
    navigator.clipboard.writeText(tsv)
      .then(() => btn.textContent = 'Copied!')
      .catch(() => btn.textContent = 'Copy failed');
  };
  overlay.appendChild(btn);

  document.body.appendChild(overlay);
})();

Preview Your TSV Results

After copying from the overlay, paste your TSV here and click �Preview Results� to see it as a table: