How to analyze word frequency in Coda or specific Docs?

[Bill_French]

@Steve_Yang

I need to know " how many " How are you " in the texts.

I understand the requirements quite clearly. Since there is no apparent way to use native formulas to access Section texts, and there is also no API support for accessing text sections, you have to do pretty much what I said earlier:

@Bill_French

… set up a Coda action that exports a section via the Gmail pack every two hours. The Gmail account (using Google Apps Script) sees the exported section content, parses it as plain text, and then performs the text analysis in Javascript or with the help of AI tools such as Dialog Flow. With the text analytics in hand, the same process writes the data back into the Coda Doc as data in a table. It’s a quick, sustainable integration process that runs silently to maintain text analytics in the Coda document.

Note - while there is certainly a Pack for Google’s NLP service, there’s no [apparent] way to utilize this Pack with section [document] text; formulas are limited to accessing data tables and their fields as far as I know.