See llms.txt for all machine-readable content.

Back to Templates

Log and analyze call recordings in Google Sheets with Palatine Speech

Created by

Created by: Palatine Speech || palatine-speech
Palatine Speech

Last update

Last update a day ago

Categories

Quick overview

This workflow watches a Google Drive folder for new call recordings, downloads each audio/video file, transcribes and analyzes sentiment with Palatine Speech, summarizes the transcript, and appends the date, filename, summary, sentiment, and transcript to a Google Sheets call log.

How it works

  1. Triggers when a new file is created in a specific Google Drive folder.
  2. Filters the event to only continue for audio or video files based on MIME type or file extension.
  3. Downloads the call recording from Google Drive.
  4. Sends the recording to Palatine Speech to generate a transcription and a sentiment analysis in parallel.
  5. Combines the transcription and sentiment results and asks Palatine Speech to summarize the transcript as a meeting summary.
  6. Formats the date, original filename, summary, sentiment JSON, and full transcript into a single record and appends it as a new row in Google Sheets.

Setup

  1. Install n8n-nodes-palatine-speech on self-hosted n8n, or select the verified package if it is available in your n8n Cloud workspace.
  2. Add Google Drive credentials, select the folder to watch, and ensure the trigger has permission to read new files.
  3. Add Palatine Speech credentials for the transcription, sentiment, and summarization steps.
  4. Connect Google Sheets credentials and select the target spreadsheet and sheet. Create these exact headers: Date, File, Summary, Sentiment, Transcript. Test a short recording, verify all five cells and the output format, then publish the workflow. Test with a non-media file to confirm it is ignored.

Requirements

  • Google Drive read access to the recordings folder, Google Sheets write access to the call log, and a Palatine Speech API account with transcription, sentiment and text summarization available. Install the Palatine Speech community node and select credentials in each relevant node.

Customization

  • Adapt the summary prompt for sales or support calls, add a review queue or notification based on the returned sentiment data, or store long transcripts separately and add a link to the sheet. Check AI-generated analysis against the recording.

Additional info

The Summary and Sentiment columns preserve structured results as JSON text when the service returns objects. The workflow appends a row per processed recording; it does not deduplicate repeat runs.

Need help with Palatine Speech?

Check info here: speech.palatine.ru

Documentation: docs.speech.palatine.ru