How to Transcribe Audio/Video from Google Drive and Save in Google Sheets Using Pabbly Connect

Learn how to transcribe audio and video files from Google Drive and save them in Google Sheets using Pabbly Connect. Step-by-step tutorial included. Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Audio/Video Transcription

To begin transcribing audio or video files from Google Drive, you need to set up Pabbly Connect. This integration platform allows you to automate the process efficiently. Start by visiting the Pabbly Connect landing page and either sign up for a new account or log in to your existing account.

Once logged in, navigate to the dashboard and click on the ‘Create Workflow’ button. Here, you can name your workflow—for example, ‘Google Drive to Happy Scribe to Google Sheets’—and select the folder where you want to create this automation.

2. Triggering Google Drive with Pabbly Connect

The next step involves setting up the trigger for your workflow in Pabbly Connect. You will need to connect your Google Drive account to Pabbly Connect. Start by selecting Google Drive as your app, and then choose the trigger event ‘New File in Specific Folder’ from the dropdown menu.

• Select your Google Drive account and click on ‘Connect’.
• Choose the specific folder you want to monitor for new files.
• Click on ‘Save and Send Test Request’ to confirm the connection.

Upon successful connection, you will receive a response indicating the details of the most recent file uploaded. This confirms that your trigger setup is working correctly through Pabbly Connect.

3. Changing File Share Permissions with Pabbly Connect

After setting up the trigger, the next step is to change the share permissions of the uploaded files in Google Drive. This is crucial because the files need to be accessible for transcription by Happy Scribe. In Pabbly Connect, add an action step and select Google Drive again, this time choosing the action event ‘Share a File with Anyone’.

• Connect your Google Drive account again if prompted.
• Map the file ID from the previous trigger response to set the share permissions dynamically.
• Click on ‘Save and Send Test Request’ to apply the new sharing settings.

This step ensures that the files are now shareable, allowing Happy Scribe to access them for transcription through Pabbly Connect.

4. Transcribing Files Using Happy Scribe via Pabbly Connect

Now that your files are shareable, it’s time to send them to Happy Scribe for transcription. In Pabbly Connect, add another action step and select Happy Scribe as your app. Choose the action event ‘Create Transcription’ and connect your Happy Scribe account by entering your API key and organization ID.

Next, you will need to map the following fields:

Transcription Name: Use the file name from the trigger response. Media URL: Enter the publicly accessible link obtained from the previous step. Workspace Name: Give a name for your workspace in Happy Scribe.

After configuring these settings, click on ‘Save and Send Test Request’ to initiate the transcription process. This step confirms that the audio or video file is now being processed by Happy Scribe through Pabbly Connect.

5. Saving Transcription Details in Google Sheets Using Pabbly Connect

Finally, after the transcription is complete, you need to save the details in Google Sheets. In Pabbly Connect, add another action step and select Google Sheets. Choose the action event ‘Add New Row’ and connect your Google Sheets account.

Map the following fields in your Google Sheets:

File Name: Use the file name from the Google Drive trigger response. Google Drive File URL: Map the Pabbly link from the share action. Transcription File URL: Map the link you received from Happy Scribe.

Once all fields are mapped, click on ‘Save and Send Test Request’. This will add a new row in your Google Sheets with all the transcription details, completing the workflow setup via Pabbly Connect.

Conclusion

Using Pabbly Connect, you can seamlessly transcribe audio and video files stored in Google Drive and save the results in Google Sheets. This automation not only saves time but also streamlines your content creation process effectively.