How to Convert a File in CloudConvert & Upload to Google Drive Using Pabbly Connect

Learn how to convert files in CloudConvert and upload them to Google Drive using Pabbly Connect. Follow this step-by-step guide for seamless integration. 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. Accessing Pabbly Connect for File Conversion

To begin using Pabbly Connect, navigate to the Pabbly Connect website by typing ‘Pabbly.com/connect’ in your browser. This platform acts as the central hub for integrating various applications, including Google Sheets, CloudConvert, and Google Drive.

Once on the landing page, you will see options for signing in or signing up. If you are new, click on ‘Sign Up for Free’ to create an account, which is a quick process that grants you 100 free tasks. If you already have an account, simply sign in to access your dashboard.

2. Creating a Workflow in Pabbly Connect

After signing in, click on ‘Create Workflow’ on the dashboard. You will be prompted to name your workflow. For this tutorial, name it something descriptive like ‘Convert File in CloudConvert and Upload to Google Drive’. This workflow will integrate Google Sheets, CloudConvert, and Google Drive using Pabbly Connect.

Upon creating the workflow, you will see options for setting a trigger and actions. Start by selecting Google Sheets as your trigger application. The trigger event you need is ‘New or Updated Spreadsheet Row’. This event will initiate the workflow whenever a new row is added or updated in your Google Sheets.

• Select Google Sheets as the trigger application.
• Choose ‘New or Updated Spreadsheet Row’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

Next, head over to your Google Sheets where you have the URLs of the files stored. Use the copied webhook URL in the Pabbly Connect Webhooks add-on to connect your Google Sheet with Pabbly Connect.

3. Setting Up Google Sheets for Integration

In your Google Sheets, go to Extensions, then Add-ons, and select Get Add-ons to find the Pabbly Connect Webhooks add-on. Install it if you haven’t done so. Once installed, return to Extensions, navigate to Pabbly Connect Webhooks, and select ‘Initial Setup’. Here, paste the webhook URL you copied earlier.

Set the trigger column to the final data column, typically the column where the file links are stored. For example, if your file links are in column C, specify ‘C’ as the trigger column. After setting this up, click on ‘Send Test’ to send a test request to Pabbly Connect, confirming that your Google Sheets is correctly integrated.

• Go to Extensions > Pabbly Connect Webhooks > Initial Setup.
• Paste the webhook URL in the setup.
• Set the trigger column to the appropriate column (e.g., C).

After sending the test request, you should see a confirmation in your Pabbly Connect dashboard indicating that the data has been received successfully.

4. Integrating CloudConvert for File Conversion

Now that your Google Sheets is set up, the next step is to integrate CloudConvert using Pabbly Connect. Select CloudConvert as your action application and choose the action event ‘Convert a File’. You will need to connect your CloudConvert account to Pabbly Connect by clicking on ‘Add New Connection’.

Once connected, map the required fields: the file URL from Google Sheets, the input format (e.g., MP4), and the output format (e.g., MP3). For the file name, provide a name including the desired extension, such as ‘new_video.mp3’. After mapping these fields, click ‘Save and Send Test Request’ to initiate the conversion process.

Select CloudConvert as the action application. Choose ‘Convert a File’ as the action event. Map the file URL, input format, output format, and file name.

After sending the test request, you will receive a response from CloudConvert confirming that the conversion was successful, including the job ID for the converted file.

5. Uploading Converted Files to Google Drive

With the file successfully converted, the final step is to upload it to Google Drive using Pabbly Connect. Select Google Drive as your next action application and choose ‘Upload a File’ as the action event. Connect your Google Drive account by clicking ‘Add New Connection’ and authorizing the connection.

Next, map the URL of the converted file received from CloudConvert, and specify the folder ID in Google Drive where you want to upload the file. To find the folder ID, navigate to your Google Drive, open the desired folder, and copy the ID from the URL. Finally, provide the file name for the uploaded file and click ‘Save and Send Test Request’ to complete the process.

Select Google Drive as the action application. Choose ‘Upload a File’ as the action event. Map the converted file URL and specify the folder ID.

After completing these steps, refresh your Google Drive to see the newly uploaded file, confirming that the integration process using Pabbly Connect was successful.

Conclusion

This tutorial has shown you how to use Pabbly Connect to convert files in CloudConvert and upload them to Google Drive seamlessly. By following the steps outlined, you can automate this process and enhance your workflow efficiency.