问尝试创建一个脚本，自动填充来自谷歌工作表的屏蔽超链接的谷歌文档

EN

// get the lookup data from the spreadsheet
var lookupData = SpreadsheetApp.openById("...").getSheetByName("...").getDataRange().getDisplayValues();

// first row is header row
var lookupDataHeaderRow = lookupData.shift();

// get document body from the doc
var documentBody = DocumentApp.openById("...").getBody();

// we will continously search the document until there are no more found results
var searchResult = null;
while(searchResult = documentBody.findText("&.*?&", searchResult))
{
  // get the found element
  var foundElement = searchResult.getElement();

  // make sure it is a text type
  if(foundElement.getType() !== DocumentApp.ElementType.TEXT) continue;

  // get the text object of the found element
  var foundText = foundElement.asText();

  // extract the search string
  var documentText = foundText.getText().match("&(.*?)&")[1];

  // look for the documentText in the lookup data
  var foundLookupRows = lookupData.filter(function(row){
    return row[lookupDataHeaderRow.indexOf("DOCUMENT TEXT")] == documentText;
  });

  // make sure we found it in the lookup data
  if(foundLookupRows.length == 0) continue;

  // first replace the found text with the masking text of the first found row
  foundText.setText(foundLookupRows[0][lookupDataHeaderRow.indexOf("MASKING TEXT")]);

  // make it a hyperlink
  foundText.setLink(foundLookupRows[0][lookupDataHeaderRow.indexOf("HYPERLINK")]);
}