Convert Meeting Recordings to Notes & Action Items with AssemblyAI, GPT-4 & Google Sheets

This n8n workflow automates the process of transcribing meeting recordings, extracting key information like notes and action items using AI, and then storing this structured data in Google Sheets. It streamlines post-meeting follow-up and ensures important details are captured and organized.

What it does

1. Receives Recording URL: The workflow starts by listening for a webhook trigger, expecting a POST request containing a URL to a meeting recording.
2. Transcribes Audio (AssemblyAI - Implied): Although not explicitly present in the provided JSON, the workflow's name suggests an integration with AssemblyAI for transcription. It's likely an HTTP Request node (like "HTTP Request" in the JSON) would be configured to send the recording URL to AssemblyAI for transcription.
3. Extracts Notes & Action Items (GPT-4): The transcribed text is then processed by an "AI Agent" node, which likely uses an "OpenAI Chat Model" (GPT-4) in conjunction with a "Structured Output Parser" to extract meeting notes and action items in a structured format.
4. Formats Data: An "Edit Fields (Set)" node prepares the extracted data for storage, ensuring it matches the expected schema for Google Sheets.
5. Stores in Google Sheets: The processed notes and action items are appended as a new row to a specified Google Sheet.
6. Conditional Logic: An "If" node is present, suggesting conditional logic might be applied based on the output of a previous step (e.g., if AI extraction was successful, or if certain keywords are present).

Prerequisites/Requirements

• n8n Instance: A running n8n instance to host the workflow.
• Webhook Source: An application or service capable of sending POST requests with meeting recording URLs to the n8n webhook.
• AssemblyAI Account & API Key: (Implied) For transcribing audio recordings.
• OpenAI Account & API Key: For GPT-4 access via the "OpenAI Chat Model".
• Google Account: With access to Google Sheets for storing the extracted data.
• Google Sheets Credential: Configured in n8n to allow writing to your spreadsheet.
• OpenAI Credential: Configured in n8n for API access.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Webhook:
   • Activate the "Webhook" node.
   • Copy the generated webhook URL. This URL will be used by your external system to trigger the workflow with a recording link.
3. Configure Credentials:
   • Set up a Google Sheets credential in n8n.
   • Set up an OpenAI credential in n8n.
   • (Implied) If using AssemblyAI via an HTTP Request node, configure the necessary API key or authentication.
4. Configure Google Sheets Node:
   • Specify the Spreadsheet ID and Sheet Name where the meeting notes and action items should be stored.
   • Ensure the column headers in your Google Sheet match the fields being output by the "Edit Fields (Set)" node (e.g., "Meeting Notes", "Action Items", "Recording URL").
5. Configure AI Agent and OpenAI Chat Model:
   • Ensure the "OpenAI Chat Model" is correctly configured with your OpenAI credential and the desired model (e.g., gpt-4).
   • Review and adjust the prompt within the "AI Agent" node to guide the AI in extracting the desired notes and action items from the transcription.
   • Verify the "Structured Output Parser" matches the expected JSON schema for the AI's output.
6. Configure HTTP Request (AssemblyAI - Implied):
   • If an HTTP Request node is used for AssemblyAI, ensure it's configured to send the recording URL and receive the transcription.
7. Activate the Workflow: Once all configurations are complete, activate the workflow.
8. Trigger the Workflow: Send a POST request to the webhook URL (obtained in step 2) with the meeting recording URL in the request body. The workflow will then process the recording and update your Google Sheet.