Automate Granola Call Transcripts to Google Drive with n8n

Automate Granola Call Transcripts to Google Drive with n8n

Effortlessly manage your Granola call transcripts by integrating them with Google Drive using n8n's powerful automation! This robust workflow runs nightly to seamlessly transfer updated Granola notes into personalized Google Doc transcripts stored in your "Transcrições" folder. Say goodbye to manual transcription processes and ensure your notes are always organized and easily accessible.

What this workflow does

• Triggers every night at 23:30 (America/Sao_Paulo) to check for any recently updated notes in Granola.
• Utilizes the Granola API to retrieve and disassemble notes updated in the last 24 hours.
• Fetches comprehensive note details and compares note titles to a customer list from Supabase to find the best match.
• Searches in Google Drive for the appropriate customer folder, within which it locates the "Documentos" and "Transcrições" subfolders.
• Generates a new Google Doc in the "Transcrições" folder, transforming Granola's markdown summaries into styled Google Doc text using batchUpdate requests.

Use cases

• Customer Service Automation: Automatically sync transcripts for immediate retrieval and analysis, enhancing customer service operations.
• Record Keeping and Archiving: Maintain a well-organized repository of call transcripts categorized by customer, simplifying future access and compliance adherence.
• Data Analysis: Export and format data for analysis without manual intervention, facilitating better decision-making and reporting.

Technical details

• Integrates with Granola API to fetch note data.
• Utilizes Supabase for customer data comparison and matching.
• Employs Google Drive API for document generation and storage.
• Core nodes used: if, code, limit, merge, split out, no op, alongside custom API calls.

Perfect for n8n users, automation engineers, and SaaS operators seeking an efficient method to automate their transcription workflow. Embrace seamless integration and streamlined document management with this meticulous n8n workflow.