Table in Google Docs/Sheets that provides a count of specified words/phrases

Question

I am writing a play on Google Docs and I am looking to have a table either in Google Docs or a separate Google Sheet where I can see how many times a word/name is mentioned in real time. I understand I can do this simply by using the native ctrl+F feature but unfortunately, that's hard to remember to do after writing each scene and it would be great to see how many lines I have different characters delivering as I write.

Answer 1

kinda vague question so here is example of counting phrase lorem ipsum:

=INDEX(SUM(LEN(REGEXREPLACE(REGEXREPLACE(LOWER(A1:A), 
 "lorem ipsum", "♥"), "[^♥]+", ))))

Answer 2

You should accept Player()'s answer.

However in answer to the subsequent question about getting paragraphs into a spreadsheet, the below app script function will get it done by putting each paragraph in a cell (Starting in cell A1) and moving down through the document.

Be cautious of the permission warning signs that appear, these are not to be completely dismissed without reviewing. Given that you can see the actual code, you can process without too much worry (even if you don't understand it, you can rest assured that there's a community of smart folks on here who would ban me if I gave you code that was harmful).

function putParagraphsInCells(){
  var macBethPartII =  DocumentApp.openById('??????????????'); //change to match yours
  var allParagraphs = macBethPartII.getBody().getParagraphs();
  var theResult = [];
  for(var i=0;i<allParagraphs.length;i++){
    theResult.push([allParagraphs[i].getText()])
  }

  const ss = SpreadsheetApp.openById('?????????');//or whatever
  const ws = ss.getSheetByName("Sheet1");

  ws.getRange(1,1,allParagraphs.length,1).setValues(theResult);
}