Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start using Pabbly Connect, first visit pabbly.com/connect. This platform allows you to create powerful integrations between various applications, including Google Sheets and Google AI Studio.

If you are new to Pabbly Connect, sign up for a free account to receive 100 free tasks each month. This is a great way to test the features of Pabbly Connect before deciding on a paid plan.

2. Creating a Workflow in Pabbly Connect

Once logged into Pabbly Connect, you can create a new workflow. This workflow will automate the process of converting text from Google Sheets into audio using Google AI Studio. Start by selecting the trigger as “New or Updated Spreadsheet Row” in Google Sheets.

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

After setting up the trigger, you will connect Google Sheets to Pabbly Connect by using the webhook URL. This allows automatic data transfer whenever a new row is added or updated.

3. Configuring Google Sheets with Pabbly Connect

To configure Google Sheets with Pabbly Connect, open your spreadsheet and go to Extensions > Add-ons > Get Add-ons. Search for “Pabbly Connect Webhooks” and install it.

Once installed, refresh your Google Sheets. You’ll now see the option for Pabbly Connect Webhooks. Click on it and select “Initial Setup”. Paste the webhook URL you copied earlier and set the trigger column (e.g., Column A).

  • Enter the webhook URL in the setup dialog.
  • Specify the trigger column (Column A).
  • Click on Submit to complete the setup.

Activate the “Send on Event” option in the same menu to ensure that data is sent to Pabbly Connect whenever a new text is entered.

4. Connecting Google AI Studio to Pabbly Connect

After setting up Google Sheets, the next step is to connect Google AI Studio to Pabbly Connect. Choose Google AI Studio in your workflow and select the “Connect” option. You will need to provide an API key for this connection.

To obtain the API key, go to the Gemini playground section and create a new key. Copy this key and paste it into Pabbly Connect. Choose the model for audio generation, such as “Gemini 2.5 Pro Preview TTS”.

  • Add a new connection in Google AI Studio.
  • Paste the API key from the Gemini playground.
  • Select the voice option for audio output.

Map the text data from Google Sheets to the corresponding field in Google AI Studio. This ensures that the text you enter will be converted into audio automatically.

5. Saving and Testing the Workflow

Once everything is configured, click on “Save and Send Test Request” in Pabbly Connect. This will initiate the text-to-speech conversion process. Within seconds, you will receive an audio URL that corresponds to the text you entered in Google Sheets.

To verify the setup, open the audio URL in a new tab and listen to the audio output. You should hear the exact text you entered in your spreadsheet, confirming that the integration is successful.

  • Click “Save and Send Test Request” to generate audio.
  • Open the received URL to listen to the audio.
  • Ensure the audio matches the text input.

Finally, you can set up an action step in Pabbly Connect to automatically update the audio URL back into your Google Sheets, enhancing your workflow efficiency.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to integrate Google Sheets with Google AI Studio for seamless text-to-speech conversion. By following these steps, you can automate your workflows effectively.