how are folks extracting data (text from a Doc in this case but I'd want do the same with a table in Sheets) from a Google Drive "New Files" trigger? I tried the "Read File" action but it failed on me (see thread)
in this case, I just want the text from a doc file... one of my clients is using the transcriptions from Google Meet which auto-drop into a Drive folder... I want that to trigger custom analysis
I'm doing some product work for them and running user research calls to determine what they need to build/improve on next... I've figured out a less-than-ideal workaround trigger with some manual steps, but I figured there's gotta be a better way
also, while I'm here, that "Update Row" alert required me to reconnect an account I've had connected for eons... is that a known bug? expired auth tokens or something?
Rex H. https://chat.lindy.ai/home/?templateId=6879c2ecb1d2b3a69ef3ccf9 Here's the underlying logic and information flow: Workflow Logic & Information Flow Trigger: Google Drive - New Files (Instant)
Monitors a specific Google Drive folder for new files
Configured to watch "My Drive" in folder ID: 1JxwNy8d6d0Z7cgcGpD2pWuWp9PoiIkai
Decision Point: File Type Check
Uses a condition to determine if the new file is a Google Document
Two possible paths based on file type
Path 1: If Google Document
Set Conversation Title - Uses AI to generate a title based on the Google Document's name
Get Document Content - Retrieves the full document content/transcript from Google Docs
Generate Expectations Summary - Uses AI to analyze the document transcript and create a detailed summary of customer expectations
Path 2: If Not Google Document
Delete Current Task - Terminates the workflow since it only processes Google Documents
Information Flow
File Detection → Google Drive trigger captures new file metadata
Type Validation → Logic step filters for Google Documents only
Title Generation → Document name flows to conversation title setter
Content Extraction → Document ID flows to Google Docs API to retrieve full text
Analysis → Document transcript flows to AI writer for expectation analysis
This workflow is designed to automatically process customer requirement documents uploaded to a specific Google Drive folder, extracting and summarizing customer expectations from the document content.
thank you sire! also, thanks for the ChatGPT screenshot to text play-by-play!
