Learn how to automatically convert text to speech using Eden AI and Google Sheets with Pabbly Connect. Follow this step-by-step tutorial for seamless integration. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.
Watch Step By Step Video Tutorial Below
1. Setting Up Pabbly Connect for Text to Speech Automation
To automatically convert text to speech using Pabbly Connect, you first need to access the Pabbly Connect dashboard. This integration allows you to convert text entered in Google Sheets into speech using Eden AI. Start by signing up for a free account on Pabbly Connect.
Once you are logged in, click on ‘Create Workflow’. Name your workflow, such as ‘Automatically Convert Text to Speech’. Choose a folder for your workflow, then click on ‘Create’ to proceed. This sets up the foundation for your automation.
2. Integrating Google Sheets with Pabbly Connect
The next step involves integrating Google Sheets with Pabbly Connect to start the automation process. In the trigger window, select Google Sheets as your app and choose the trigger event as ‘New or Updated Spreadsheet Row’. This will allow the workflow to trigger whenever a new row is added.
- Select Google Sheets as the app.
- Choose ‘New or Updated Spreadsheet Row’ as the trigger event.
- Copy the generated webhook URL.
- Install the Pabbly Connect Webhooks add-on in Google Sheets.
After installing the add-on, refresh Google Sheets, go to Extensions, and select Pabbly Connect Webhooks. Click on ‘Initial Setup’ and fill in the required fields, including the selected sheet, webhook URL, and trigger column. This setup is crucial for the automation to work correctly.
3. Configuring Eden AI in Pabbly Connect
After setting up Google Sheets, the next step is to configure Eden AI in Pabbly Connect. In the action window, search for Eden AI and select it. Choose the action event ‘Convert Text to Speech’ and connect your Eden AI account by entering the API token.
Map the text input from your Google Sheets to the text field in Eden AI. You can also set the voice type (male or female) and the provider from the dropdown options available in your Google Sheets. Make sure to select English as the language for conversion.
- Select ‘Convert Text to Speech’ as the action event.
- Enter your Eden AI API token to connect.
- Map the text and voice fields from Google Sheets.
Once the mapping is done, save the settings and send a test request to ensure the automation is functioning correctly. You should receive a success response with the audio URL for the converted speech.
4. Updating Google Sheets with Audio URL
The final step is to update Google Sheets with the audio URL generated by Eden AI through Pabbly Connect. Add another action step in your workflow and select Google Sheets again. This time, choose the action event ‘Update Cell’ to update the specific cell with the audio URL.
Connect your Google Sheets account again and select the spreadsheet and sheet where you want to update the audio URL. In the range field, specify the column (e.g., D) and use the row index received from the trigger step to ensure the URL is placed in the correct row.
Select ‘Update Cell’ as the action event. Specify the range for updating the audio URL. Map the audio URL from the Eden AI response.
After mapping the fields, save the settings and send a test request. If successful, the audio URL will be updated in Google Sheets, completing the automation process.
5. Testing the Automation Workflow
Now that the automation is set up, it’s time to test it. Enter a new text in your Google Sheets, select the platform and voice, and watch as Pabbly Connect triggers the automation. Within seconds, the text will be converted into speech, and the audio URL will be populated in the same row.
To verify the process, check the Google Sheets for the audio URL. You can click on the URL to download the MP3 file and listen to the converted speech. This confirms that the entire workflow is functioning as intended.
Whenever you add new text in the specified column, the automation will automatically convert it to speech and update the Google Sheets with the corresponding audio URL. This seamless integration showcases the power of Pabbly Connect in automating tasks between various applications.
Conclusion
This tutorial demonstrates how to use Pabbly Connect to automatically convert text to speech using Eden AI and Google Sheets. By following these steps, you can streamline your workflow and enhance productivity.
Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.
- Check out Pabbly Connect – Automate your business workflows effortlessly!
- Sign Up Free – Start your journey with ease!
- 10,000+ Video Tutorials – Learn step by step!
- Join Pabbly Facebook Group – Connect with 21,000+ like minded people!