How to Convert Text to Speech Using Pabbly Connect with Google Sheets and Voice Maker

Learn how to automate text-to-speech conversion using Pabbly Connect, Google Sheets, and Voice Maker for seamless audio file generation. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start using Pabbly Connect, open your browser and search for Pabbly Connect. You will find options to either sign in or sign up for a free account. If you are a new user, click on the ‘Sign Up Free’ button to create your account quickly.

After signing in, you will land on the Pabbly Connect dashboard. Here, click on the ‘Create Workflow’ button to begin setting up your automation. Name your workflow, for example, ‘Google Sheets to Voice Maker to Google Drive’. This naming helps in identifying the purpose of the workflow easily.

2. Setting Up Google Sheets for Text Entry

In this section, we will prepare our Google Sheets where we will input the text that needs to be converted into speech. You need to create columns for the text, audio file name, language, voice ID, and status. The status column will have options like ‘Draft’ and ‘Generate Audio’. Whenever you change the status to ‘Generate Audio’, it will trigger the automation.

• Create a new Google Sheets document.
• Add columns for Text, File Name, Language, Voice ID, and Status.
• Ensure to add the necessary voice IDs and languages based on the API documentation from Voice Maker.

With the Google Sheet prepared, we can now connect it to Pabbly Connect to automate the process of converting text to speech and uploading the audio file to Google Drive.

3. Connecting Google Sheets to Pabbly Connect

To connect Google Sheets with Pabbly Connect, select Google Sheets as the app in the trigger section. Choose the trigger event as ‘New or Updated Spreadsheet Row’. This allows Pabbly Connect to monitor your Google Sheets for any new entries or updates.

Copy the webhook URL provided by Pabbly Connect and go to your Google Sheet. Navigate to Extensions > Add-ons > Get Add-ons, and install the Pabbly Connect Webhooks add-on. After installation, refresh your Google Sheet and set up the webhook by selecting the sheet and pasting the URL in the setup window.

4. Generating Audio with Voice Maker

Once your Google Sheets is connected to Pabbly Connect, the next step is to send the text to Voice Maker for audio generation. In the action step, select Voice Maker and choose ‘Generate Audio’ as the action event. Here, you will need to input your Voice Maker API key.

Map the fields from the Google Sheets response to the Voice Maker action, including the text, language code, and voice ID. Ensure the voice ID matches the format specified in the Voice Maker API documentation. After mapping the required fields, click on ‘Save and Send Test Request’ to generate the audio file.

5. Uploading Audio to Google Drive

After generating the audio file, the final step involves uploading the file to Google Drive. In the next action step, select Google Drive and choose ‘Upload a File’ as the action event. Connect your Google Drive account if you haven’t already.

Map the file URL received from Voice Maker into the Google Drive upload action. Specify the folder ID where you want to store the audio file and give it a name. Once done, click on ‘Save and Send Test Request’ to upload the file to your specified Google Drive folder.

Finally, to update your Google Sheets with the link to the uploaded audio file, add another action step to update the cell in your Google Sheets with the Google Drive file link. This completes the automation process using Pabbly Connect.

Conclusion

This tutorial demonstrated how to automate the process of converting text to speech using Pabbly Connect, Google Sheets, and Voice Maker. By following these steps, you can efficiently generate audio files and manage them in Google Drive.