# Extract text from Google Drive files to Google Sheets: n8n workflow > Started by an event in a connected app, and works across Google Docs, Google Drive, Google Sheets and Telegram. Source: https://millionrounds.com/workflow/extract-text-from-google-drive-files-to-google-sheets (Millionrounds; every figure on the page links to its filing or article) [Automation library](https://millionrounds.com/workflows) · [Documents and files](https://millionrounds.com/workflows?category=Documents+and+files#library) # Extract text from Google Drive files to Google Sheets Started by an event in a connected app, and works across Google Docs, Google Drive, Google Sheets and Telegram. 25 steps, 2 branches: large, and worth reading before you trust it with anything live. Large [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fextract-text-from-google-drive-files-to-google-sheets) **25 steps** Large: read it before trusting it with anything live **2** Branches: places the flow splits **0** Loops or waits **4** Services it connects to ## The flow Starts it 1 Logic 14 Service 10 The steps in the order they run, from what starts it. - 1 **Google Drive Trigger** Google Drive trigger *Starts it* - 2 **Normalize Raw Text** Code *Logic* - 3 **Normalize Input** Code *Logic* - 4 **Build Structuring Payload** Code *Logic* - 5 **Route Input** Switch *Logic* - 6 **Structure Output with NVIDIA** Http Request *Service* - 7 **Download Drive File** Google Drive *Service* - 8 **Get Google Doc** Google Docs *Service* - 9 **Send Unsupported Message** Telegram *Service* - 10 **Parse Structured Output** Code *Logic* - 11 **Route Downloaded File** Switch *Logic* - 12 **Normalize Google Doc** Code *Logic* - 13 **Append Row in Sheet** Google Sheets *Service* - 14 **Build Telegram Reply** Code *Logic* - 15 **Extract from PDF** Extract From File *Service* - 16 **Prepare Image Data URL** Code *Logic* - 17 **Extract from Text File** Extract From File *Service* - 18 **Extract from CSV** Extract From File *Service* - 19 **Send Reply** Telegram *Service* - 20 **Normalize PDF** Code *Logic* - 21 **Build Image Payload** Code *Logic* - 22 **Normalize Text File** Code *Logic* - 23 **Normalize CSV** Code *Logic* - 24 **Analyze Image with NVIDIA** Http Request *Service* - 25 **Normalize Image** Code *Logic* ## How it's built - **Starts on:** An event in a connected app - **Steps:** 25, with 2 branches - **Size:** Large: read it before trusting it with anything live - **Connects to:** Google Docs, Google Drive, Google Sheets, Telegram - **Model:** None. This is plumbing, not judgement ## Questions What does it need to run? An n8n account, plus your own Google Docs, Google Drive, Google Sheets and Telegram accounts. You connect your own accounts after importing it; none are included. What starts it? It starts on an event in a connected app. Does it use AI? No. Every step is fixed logic or a call to a service, so it does the same thing every time. How long does it take to set up? Take your time. At 25 steps it is large: read it before trusting it with anything live. How do I import it? Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts. **Before you run it** Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 25 steps before you point it at anything that matters. ## Run it in n8n - **Create your n8n account** Free to start. n8n is where the workflow runs. [Create an n8n account ↗](https://millionrounds.com/n8n) - **Download the workflow** Free with a Millionrounds account. [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fextract-text-from-google-drive-files-to-google-sheets) - **Paste it into n8n** Open a new workflow in n8n and paste. Then connect your own accounts. Stored with the author's traces removed: canvas notes, instance identifiers, saved credential names and any live document they had left behind. ## Connects to Each opens the other workflows that use it. [Google Docs](https://millionrounds.com/workflows?service=Google+Docs#library)[Google Drive](https://millionrounds.com/workflows?service=Google+Drive#library)[Google Sheets](https://millionrounds.com/workflows?service=Google+Sheets#library)[Telegram](https://millionrounds.com/workflows?service=Telegram#library) ## Workflows like it Also documents and files, with the same services where possible, closest in size first. - [**Nightly n8n backup to Google Drive** 25 steps · Google Drive](https://millionrounds.com/workflow/nightly-n8n-backup-to-google-drive) - [**Document RAG & chat agent: Google Drive to Qdrant with Mistral** 25 steps · calls a model · Google Drive, Qdrant](https://millionrounds.com/workflow/document-rag-and-chat-agent-google-drive-to-qdrant-with-mist) - [**Review contract risk and rewrite clauses with Groq** 25 steps · calls a model · Google Drive, Notion](https://millionrounds.com/workflow/review-contract-risk-and-rewrite-clauses-with-groq) - [**Archive HR and legal documents with UploadToURL** 26 steps · Airtable, Gmail](https://millionrounds.com/workflow/archive-hr-and-legal-documents-with-uploadtourl) - [**Automate document ingestion & RAG system with Google Drive** 24 steps · calls a model · Google Drive, Google Sheets](https://millionrounds.com/workflow/automate-document-ingestion-and-rag-system-with-google-drive) - [**Chat with Ollama and Supabase Vector DB** 26 steps · calls a model · Google Drive, Supabase](https://millionrounds.com/workflow/chat-with-ollama-and-supabase-vector-db)