Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Email Automation

To start automating email generation, you first need to access Pabbly Connect. Begin by visiting the Pabbly Connect URL in your browser. You will be presented with options to sign in or sign up for a free trial.

If you are a new user, click on the sign-up button to create your account. Existing users can simply log in. Once logged in, you will be taken to the workflow page where you can create your automation.

2. Setting Up Google Sheets Trigger in Pabbly Connect

In this section, you’ll set up Google Sheets as the trigger application in Pabbly Connect. Select Google Sheets from the list of applications and choose the event as “New or Updated Spreadsheet Row”. This will allow the automation to trigger whenever a new entry is made in your Google Sheet.

  • Select Google Sheets as the trigger application.
  • Choose the event “New or Updated Spreadsheet Row”.
  • Click on the connect button to establish a connection.

After clicking the connect button, a webhook URL will be generated. This URL is crucial for linking your Google Sheets with Pabbly Connect. Copy this URL as you will need it in the next steps.

3. Configuring Google Sheets to Send Data to Pabbly Connect

Next, you will configure your Google Sheets to send data to Pabbly Connect. Open your Google Sheet and go to Extensions > Add-ons > Get Add-ons. Search for “Pabbly Connect Webhooks” and install it if you haven’t already.

  • Navigate to Extensions > Add-ons > Get Add-ons.
  • Search for “Pabbly Connect Webhooks” and install it.
  • Go back to Extensions > Pabbly Connect Webhooks > Initial Setup.

In the initial setup dialogue, paste the webhook URL you copied earlier. For the trigger column, enter the last data column of your Google Sheet. Finally, click on submit to save your settings.

4. Generating Automated Emails Using OpenAI

Now that your Google Sheets is configured, it’s time to generate automated emails. In Pabbly Connect, select OpenAI as the next application and set the event to generate email content. You will need to connect to OpenAI by entering your API token.

  • Choose OpenAI as the application.
  • Enter your OpenAI API token to establish the connection.
  • Set the prompt for the email content using dynamic mapping.

By using mapping in Pabbly Connect, you can insert the customer’s name and product dynamically from the Google Sheets data. This allows each email to be personalized based on the lead’s interest.

5. Sending Emails Through Gmail Using Pabbly Connect

Finally, you will set up Gmail to send the generated emails. In Pabbly Connect, select Gmail as the last application. Choose the event to send an email and connect your Gmail account.

Fill in the necessary fields such as sender’s name, recipient’s email (mapped from Google Sheets), subject, and email content (mapped from OpenAI). Once all fields are filled, click on “Save and Send Test Request” to send a test email.

You will receive a positive response indicating that the email has been sent successfully. Check your Gmail account to confirm that the email has arrived, demonstrating that the integration works flawlessly through Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to automate email generation using Pabbly Connect along with Google Sheets and OpenAI. By following the steps outlined, you can streamline your email communications and personalize messages based on customer data.