Automatically Generate Text-to-Speech with Pabbly Connect: Google Sheets to Growthens

Learn how to automate text-to-speech conversion using Pabbly Connect, Google Sheets, and Growthens API in this detailed tutorial. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Text-to-Speech Automation

To begin automating text-to-speech conversion, we will use Pabbly Connect. Start by signing up for a free account on the Pabbly Connect dashboard. Once logged in, click on ‘Create Workflow’ and name your workflow, for example, ‘Text to Speech Automation.’ This is the first step towards integrating Google Sheets with the Growthens API.

After naming your workflow, you will see two main windows: the trigger and action windows. The trigger window is where you will set up the event that initiates the automation. Here, you will select Google Sheets as your trigger app and choose the event as ‘New or Updated Spreadsheet Row.’ This setup allows Pabbly Connect to monitor your Google Sheets for new entries.

2. Connecting Google Sheets with Pabbly Connect

Now that you have configured Pabbly Connect, it’s time to connect your Google Sheets. In the trigger window, after selecting the Google Sheets app, you will receive a webhook URL. This URL is crucial for connecting your Google Sheets with Pabbly Connect. Copy this URL and head over to your Google Sheets.

Within Google Sheets, navigate to Extensions > Add-ons > Get Add-ons. Search for ‘Pabbly Connect Webhooks’ and install it. After installation, refresh your Google Sheet. Then, go back to Extensions > Pabbly Connect Webhooks > Initial Setup. You will need to fill in the selected sheet, paste the webhook URL, and define the trigger column (e.g., Column B). Click ‘Send Test’ to verify the connection. If successful, Pabbly Connect will confirm that the data has been sent successfully.

• Install the Pabbly Connect Webhooks add-on.
• Set up the Initial Setup with your selected sheet and webhook URL.
• Define the trigger column where new data will be entered.

Once you have completed the setup, the Google Sheets and Pabbly Connect integration will be ready to trigger whenever new text is added.

3. Generating Speech from Text Using Growthens API

With your Google Sheets connected to Pabbly Connect, the next step is to generate speech from the text. In the action window of your workflow, search for and select the Growthens API app. Choose the action event as ‘Make TTS Request.’ This will allow Pabbly Connect to send the text to the Growthens API for conversion into speech.

To establish this connection, you will need to enter your Growthens API token. If you haven’t created an account yet, follow the provided instructions to obtain your API token. After entering the token, you will also need to provide the 11 Labs API key and select the voice ID for the speech. This setup enables Pabbly Connect to effectively communicate with the Growthens API to generate the speech audio.

• Select ‘Make TTS Request’ as the action event.
• Enter your Growthens API token and 11 Labs API key.
• Select the voice ID for the speech output.

After completing these steps, you will be able to generate speech from any text entered in your Google Sheet using Pabbly Connect and the Growthens API.

4. Retrieving the Audio URL of the Generated Speech

Once the text has been converted into speech, the next step in your Pabbly Connect workflow is to retrieve the audio URL. After making the TTS request, you will need to wait for a brief delay to allow the Growthens API to process the request. In this case, you can add a delay of 1 hour using the ‘Delay by Pabbly’ action.

After the delay, use the ‘Get TTS Request’ action from the Growthens API to fetch the audio URL. You will need to map the request ID from the previous step to ensure you retrieve the correct audio file. Once you have done this, Pabbly Connect will provide you with the audio URL for the generated speech.

Add a delay of 1 hour to allow for processing. Use the ‘Get TTS Request’ action to retrieve the audio URL. Map the request ID from the previous step for accurate retrieval.

By following these steps, you will successfully retrieve the audio URL of the generated speech using Pabbly Connect.

5. Updating Google Sheets with the Audio URL

The final step in this automation is to update your Google Sheets with the audio URL. In the action window of your Pabbly Connect workflow, select Google Sheets again and choose the action event ‘Update Cell Value.’ This allows you to place the audio URL in the same row as the text that was converted into speech.

When setting this up, you will need to specify the spreadsheet and the sheet where the audio URL should be placed. Map the range to the appropriate cell (e.g., Column C) and set the value to the audio URL retrieved from the previous step. This ensures that every time text is added, the corresponding audio URL is updated in your Google Sheet, completing the automation process.

Select ‘Update Cell Value’ as the action event. Map the audio URL to the appropriate cell in Google Sheets. Confirm your settings to ensure the audio URL updates correctly.

With these steps, your Google Sheets will now automatically reflect the audio URL for each text entry, showcasing the power of Pabbly Connect in automating text-to-speech conversions.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the process of converting text to speech using Google Sheets and the Growthens API. By following the steps outlined, you can efficiently generate audio from text entries in your Google Sheets and retrieve the audio URL seamlessly. This automation not only saves time but also enhances productivity in managing text-to-speech tasks.