How to Convert Text-to-Speech from Google Sheets and Upload File in Google Drive Using Pabbly Connect

Learn how to automate text-to-speech conversion from Google Sheets and upload audio files to Google Drive using Pabbly Connect. Step-by-step tutorial included. Eliminate manual repetitive tasks from your workflow. Discover proven automation methods with intuitive steps designed for efficiency-minded professionals.

Watch Step By Step Video Tutorial Below

Accessing Pabbly Connect for Text-to-Speech Automation

To begin converting text to speech using Pabbly Connect, first access the platform through your web browser. Search for Pabbly Connect and log in to your account. If you don’t have an account, you can sign up for free in just a few minutes.

Once logged in, navigate to the dashboard where you can create a new workflow. Click on the ‘Create Workflow’ button and name your automation. For this example, you might name it ‘Google Sheets to Voice Maker to Google Drive’. This sets the stage for integrating Google Sheets, Voice Maker, and Google Drive through Pabbly Connect.

Setting Up Google Sheets Integration with Pabbly Connect

In this step, we will connect Google Sheets to Pabbly Connect to monitor changes. Choose Google Sheets as the app in the trigger step and select the event as ‘New or Updated Spreadsheet Row’. This allows Pabbly Connect to receive data whenever a new row is added or updated.

To complete this integration, follow these steps:

• Select your Google Sheets account and allow access.
• Copy the webhook URL provided by Pabbly Connect.
• In Google Sheets, install the Pabbly Connect Webhooks add-on.
• Paste the copied webhook URL into the add-on settings.

After completing these steps, every time you add a new entry in Google Sheets, Pabbly Connect will receive the data, allowing for seamless automation.

Filtering Data for Voice Maker Integration

Next, we need to filter the data to ensure that only entries marked for audio generation are processed. In Pabbly Connect, add a filter step to check the status of the entry. This is crucial as we only want to generate audio for rows marked as ‘Generate Audio’.

To set up the filter:

• Select the status label from the data received from Google Sheets.
• Set the filter condition to ‘Equals’ and enter ‘Generate Audio’.

Once the filter is set up, Pabbly Connect will only continue the automation for entries that meet this condition, ensuring efficient processing.

Generating Audio with Voice Maker via Pabbly Connect

Now that we have our data filtered, we can proceed to generate audio using Voice Maker. In this step, select Voice Maker as the action app and choose the action event as ‘Generate Audio’. This allows Pabbly Connect to send the text to Voice Maker for conversion to speech.

During this process, you will need to provide the following details:

Select the voice ID from the options provided in your Google Sheet. Map the language code and the text to be converted.

After configuring these settings, click on ‘Save and Send Test Request’. If successful, Pabbly Connect will return a link to the generated audio file, ready for the next step.

Uploading Audio File to Google Drive Using Pabbly Connect

The final step involves uploading the generated audio file to Google Drive. In this step, select Google Drive as the action app and choose the action event as ‘Upload a File’. This allows Pabbly Connect to manage file uploads directly from your automation.

To complete this action, you will need to specify:

The URL of the audio file generated by Voice Maker. The folder ID in Google Drive where the file will be stored. The name of the audio file along with its extension.

After mapping these fields, click on ‘Save and Send Test Request’. If successful, the audio file will be uploaded to your specified Google Drive folder, completing the automation process.

Conclusion

In this tutorial, we explored how to automate text-to-speech conversion from Google Sheets and upload audio files to Google Drive using Pabbly Connect. This integration streamlines the process, making it efficient and easy to manage.