Dazentaki
Jan 30th, 2023
568
4
Never
This is comment for paste Internal link script
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function addLinksFromSheet() {
  2. var sheet = SpreadsheetApp.openById("YOUR_SPREADSHEET_ID").getSheetByName("Sheet1");
  3. var data = sheet.getDataRange().getValues();
  4.  
  5. var document = DocumentApp.getActiveDocument();
  6. var body = document.getBody();
  7.  
  8. for (var i = 0; i < data.length; i++) {
  9. var searchPhrase = data[i][0];
  10. var hyperlink = data[i][1];
  11.  
  12. var search = null;
  13. var count = 0;
  14. while (count < 1 && (search = body.findText(searchPhrase, search))) {
  15. var searchElement = search.getElement();
  16. var startIndex = search.getStartOffset();
  17. var endIndex = search.getEndOffsetInclusive();
  18. searchElement.asText().setLinkUrl(startIndex, endIndex, hyperlink);
  19. count++;
  20. }
  21. }
  22.  
  23. document.saveAndClose();
  24. }
  25.  
Advertisement
Add Comment
Please, Sign In to add comment