Speed up course creation using Make.com content automation

Process Overview

Step 1: Setup Google Sheet

1. Create a Google Sheet: This sheet will store all necessary information about your video files.

2. Columns to Include:

   - Project Name: Name of the end process document.

   - Video Link: Copy the viewable link from Google Drive.

   - Video ID Extraction: Use a formula to extract the video ID from the video link.

   - Notes Column: Make notes on file size (e.g., over 25MB, under 25MB).

Step 2: Monitor New Rows in Make.com

1. Module Setup: Configure the "Watch new Rows" module.

2. Parameter Details:

   - Select the path to the Google Sheet.

   - Indicate headers and their positions.

   - Specify the number of files to process simultaneously.

Step 3: Download Video File

1. Retrieve Video ID: Automatically from your sheet in Make.com.

2. Download File: Use the Google Drive module to download the file using the video ID.

Step 4: Transcription with ChatGPT Whisper

1. Create ChatGPT Module: Choose transcription with Whisper.

2. Model Selection: Use the Mistmodel1 for transcription and export the response as JSON.

Step 5: Handle Files Below 25MB

1. Direct Process: For files below 25MB, directly pass them through ChatGPT for transcription.

2. System Instructions: Define prompt for converting video transcripts to process documents.

3. Format: Return result in GitHub-flavored markdown without sign-offs.

Step 6: Handle Files Above 25MB

1. Error Handling: Detect and manage errors for files exceeding 25MB.

2. Compression: Use CloudConvert to convert video files to MP3.

3. Resume Workflow: Continue the transcription process with converted files.

Step 7: Automate Content Process Doc

1. Create ChatGPT Module: Pass whisper output to GPT4o chat completion model with instructions at a system level on how to handle the users input. This prompt should include all the key elements you expect in your final document to ensure it is converted as you desire.

2. Test Output and Formating: Run the module with test data multiple time to ensure content automation matches expectations. Tweak the prompt as needed.

Step 8: Convert Markdown to HTML

1. Markdown Module: Use tools to convert markdown to HTML.

2. Integration: Create a Google document with the formatted HTML content.

Step 9: Final Steps and Document Storage

1. Save Location: Define the document’s storage location.

2. Project Name Integration: Ensure the document name reflects the project name.

Note:

Documents can be stored and managed using different project management tools like ClickUp, Notion, or simple Google Docs, depending on personal or organizational preferences.

Frequently Asked Questions (FAQs)

1. What tools are necessary for this process?

   - You will need Make.com, ChatGPT, Whisper, CloudConvert, Google Drive, and Google Sheets.

2. How do you handle larger files over 25MB?

   - Files larger than 25MB are converted to a smaller format using CloudConvert before transcription.

3. Can I store the final process documents outside Google Docs?

   - Yes, you can use different platforms such as ClickUp, Notion, etc., based on your preference.

4. What is the purpose of Google Sheets in this process?

   - Google Sheets help organize video file information efficiently, streamlining the workflow.

5. How is the final document formatted?

   - The document is formatted using GitHub-flavored markdown, which is then converted to HTML for final presentation.

6. Is there a file size limit for Whisper transcription?

   - Yes, Whisper can process files up to about 25MB, which is why larger files need pre-conversion.

7. What happens if the video exceeds the supported transcript size?

   - Larger videos may need to be segmented as CloudConvert struggles with files over an hour long. 

light house digital may be paid a commision in the event you purchase from the above sites, these affilate links help us provide value to our audience free of charge. We will only ever promote tools we are using ourselves at the time of filming.