使用Google Apps Script检测Google Docs中超链接点击事件的方法

Great question! Let's cut to the chase: Google Docs doesn't offer a native, direct event listener for hyperlink clicks in Google Apps Script. But depending on your specific needs, there are workarounds that can get you close to the functionality you want.

Workaround 1: Track "Indirect" Clicks via Custom Menus/Sidebars #

If you don't need fully automatic tracking and can ask users to take a small extra step, this is a simple approach:

• Add a custom menu to your Docs (e.g., "Track Link Clicks")
• When a user selects a hyperlinked piece of text and clicks the menu option, your script can extract the link URL and log the "click" (to a Google Sheet, for example)

Here's a quick code snippet to set this up:

function onOpen() {
  DocumentApp.getUi()
    .createMenu('Link Tracker')
    .addItem('Log This Link Click', 'logLinkClick')
    .addToUi();
}

function logLinkClick() {
  const doc = DocumentApp.getActiveDocument();
  const selection = doc.getSelection();
  
  if (!selection) {
    DocumentApp.getUi().alert('Please select a hyperlinked text first!');
    return;
  }
  
  const element = selection.getRangeElements()[0].getElement();
  let linkUrl = null;
  
  // Check if the selected element is text with a link
  if (element.asText().getLinkUrl() !== null) {
    linkUrl = element.asText().getLinkUrl();
  }
  
  if (linkUrl) {
    // Log to a Google Sheet (replace with your sheet ID)
    const sheet = SpreadsheetApp.openById('YOUR_SHEET_ID').getActiveSheet();
    sheet.appendRow([new Date(), Session.getActiveUser().getEmail(), linkUrl]);
    DocumentApp.getUi().alert(`Clicked link logged: ${linkUrl}`);
  } else {
    DocumentApp.getUi().alert('No link found in selected text!');
  }
}

Workaround 2: Use a Middleman Web App to Track External Link Clicks #

If you need to track when users actually open external links from your Doc, this is the most reliable method. Here's how it works:

1. Create a Google Apps Script Web App that acts as a redirector
2. Replace all external links in your Doc with links pointing to this Web App (passing the original target URL as a parameter)
3. When a user clicks the modified link, the Web App logs the click, then redirects them to the original URL

Step 1: Build the Web App #

function doGet(e) {
  const targetUrl = e.parameter.target;
  if (!targetUrl) {
    return HtmlService.createHtmlOutput('Invalid link!');
  }
  
  // Log the click details to a Sheet
  const sheet = SpreadsheetApp.openById('YOUR_SHEET_ID').getActiveSheet();
  sheet.appendRow([
    new Date(),
    Session.getActiveUser().getEmail(),
    targetUrl
  ]);
  
  // Redirect to the original URL
  return HtmlService.createHtmlOutput(`
    <script>
      window.location.href = "${targetUrl}";
    </script>
  `);
}

Deploy this as a Web App (adjust access settings based on your user base—if you allow anonymous access, you won't be able to capture user emails).

Step 2: Update Links in Your Doc #

Replace your original links (e.g., https://example.com) with the Web App URL plus the target parameter:
https://script.google.com/macros/s/YOUR_WEB_APP_ID/exec?target=https://example.com

Important Limitations to Note #

• You can't capture native, unmodified link clicks (i.e., when a user clicks a standard link without any intermediary) via Apps Script—Google Docs doesn't expose this event to the API.
• The Web App method only works for links you control (you have to update them to point to your redirector).
• For internal links (within the same Doc), tracking clicks isn't possible with current Apps Script capabilities—there's no way to detect when a user jumps to a bookmark or internal anchor.

内容的提问来源于stack exchange，提问作者charles bell