Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Automation

To start automating your email sending, first access Pabbly Connect by visiting its official website. Upon arrival, you will see options to sign in or sign up for a free account. If you are new, click on “sign up free” to create an account and receive 100 free tasks monthly. Existing users can simply log in to their account.

After signing in, you will land on the dashboard page of Pabbly Connect. Here, you can create a new workflow by clicking on the “Create Workflow” button. This will enable you to set up the integration process seamlessly.

2. Creating a Workflow in Pabbly Connect

In this section, you will create a workflow to automate email sending through Pabbly Connect. Use the quick builder feature to simplify the process. Start by typing a prompt like “integrate Google Sheets with Gmail.” This will guide the AI to set up your integration.

  • Select “New or Updated Spreadsheet Row” as the trigger for Google Sheets.
  • Choose “Send Email” as the action for Gmail.
  • Approve the workflow setup.

Now, you will see the workflow page where Google Sheets and Gmail are integrated. This setup will allow you to send emails automatically when new entries are added to your Google Sheets.

3. Setting Up Google Sheets with Pabbly Connect

Next, it’s time to set up Google Sheets for integration with Pabbly Connect. Copy the webhook URL provided in your workflow. Then, navigate to your Google Sheet where you want to capture new leads.

In Google Sheets, go to “Extensions” > “Add-ons” > “Get Add-ons” to find and install the Pabbly Connect Webhook app. Once installed, return to “Extensions” and select “Pabbly Connect Webhooks”. Choose “Initial Setup” and paste the copied webhook URL into the dialog box. Set the trigger column to the last data column of your sheet.

  • Enter the trigger column (for example, column E).
  • Click the “Submit” button to save your settings.

Now, send a test entry to ensure that Pabbly Connect is receiving data correctly. This will confirm that your integration is set up properly.

4. Sending Emails via Gmail with Pabbly Connect

Now that your Google Sheets are set up, it’s time to configure Gmail to send emails through Pabbly Connect. Select Gmail as your action app and click the connect button to establish a connection.

For a new connection, sign in with your Google account and allow access. You will then see fields to enter the sender’s name and email address. Here, you can map the recipient’s email address from the Google Sheets response, making it dynamic for each new entry.

  • Map the recipient’s email address from the Google Sheets response.
  • Enter the email subject and body content, including mapped fields for personalization.

Finally, click the “Save and Send Test Request” button to send a test email. Check your Gmail account to confirm that the email has been sent successfully, demonstrating that your automation works perfectly.

5. Conclusion: Automate Your Email Process with Pabbly Connect

In this tutorial, we explored how to automate email sending using Pabbly Connect with Google Sheets and Gmail. By following the steps outlined, you can set up a seamless integration that saves you time and effort.

With Pabbly Connect, you can easily send personalized emails to leads without manual input, enhancing your productivity. Start using Pabbly Connect today to revolutionize your email marketing efforts!