Automate Audio Transcription from Google Drive to Google Sheets Using Pabbly Connect

Learn how to automate audio transcription from Google Drive to Google Sheets using Pabbly Connect with this detailed step-by-step tutorial. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To automate audio transcription from Google Drive to Google Sheets, you need to access Pabbly Connect. Start by visiting the Pabbly Connect website and either sign in or create a new account if you are a first-time user.

Once logged in, navigate to the Pabbly Connect dashboard. Here, you can begin creating your automation workflow. Click on the ‘Create Workflow’ button and name your workflow, such as ‘Google Drive to Happy Scribe to Google Sheets.’ This will set the foundation for your automation process.

2. Setting Up Google Drive Trigger in Pabbly Connect

In this section, we will set up the Google Drive trigger using Pabbly Connect. Select Google Drive as the app and choose the trigger event as ‘New File in Specific Folder.’ This allows Pabbly Connect to monitor a specific folder for new audio or video files.

• Choose your Google Drive account to connect.
• Select the folder where you will upload audio files for transcription.
• Click on ‘Save and Send Test Request’ to confirm the connection.

After saving, you will receive a response showing the details of the most recent file uploaded to your selected Google Drive folder. This confirms that the trigger is set up correctly and ready for the next steps in the automation process.

3. Changing File Permissions in Google Drive

Next, we need to change the share permissions of the uploaded audio or video files using Pabbly Connect. This ensures that the files can be accessed by Happy Scribe for transcription. In the action step, select Google Drive again and choose the action event ‘Share a File with Anyone.’

• Connect to your Google Drive account using the existing connection.
• Map the file ID from the previous step to dynamically change permissions for each new file.
• Click on ‘Save and Send Test Request’ to check if the permissions were successfully updated.

Once the permissions are updated, you will receive a link that allows anyone with the link to access the file. This is crucial for the transcription process in the next steps.

4. Sending File to Happy Scribe for Transcription

In this step, we will send the audio or video file to Happy Scribe for transcription using Pabbly Connect. Add an action step and select Happy Scribe as the app. Choose the action event ‘Create Transcription.’ You will need to connect your Happy Scribe account using the API key provided in your Happy Scribe settings.

After connecting, fill in the required fields such as the transcription name, language, and media URL. The media URL will be the link obtained from the previous step where you changed the file permissions. Click on ‘Save and Send Test Request’ to initiate the transcription process.

This step allows Happy Scribe to process the audio or video file and return a transcription once completed. You may want to add a delay action to give Happy Scribe enough time to finish the transcription.

5. Storing Transcription Details in Google Sheets

Finally, we will store the transcription details in Google Sheets using Pabbly Connect. Add another action step and select Google Sheets as the app. Choose the action event ‘Add New Row’ to insert the transcription data into your spreadsheet.

Connect your Google Sheets account and select the spreadsheet where you want to store the data. Map the file name, Google Drive URL, and transcription file URL to their respective columns in the spreadsheet. Click on ‘Save and Send Test Request’ to add the details to your Google Sheets.

After executing this step, you will see the new row added to your Google Sheets with all the relevant information. This completes the automation workflow, allowing for efficient transcription management.

Conclusion

This tutorial demonstrated how to automate audio transcription from Google Drive to Google Sheets using Pabbly Connect. By following the steps outlined, you can streamline your transcription process and enhance productivity.