Automate Text Extraction, Translation, and Entity Analysis from Google Drive Files

This workflow begins by monitoring a specified folder in Google Drive for new files. Once a file is detected, it retrieves the file and performs OCR to extract text. The extracted text is then translated from Chinese to English. Following translation, the text undergoes keyword extraction and named entity recognition to identify key information and entities. Finally, the results are logged into a Google Sheets document for easy access and analysis.