Watch Step By Step Video Tutorial Below





1. Setting Up Pabbly Connect for Email Automation

To automate email sending using Pabbly Connect, the first step is to access the platform. Start by opening a new tab and searching for ‘pabbly.com/connect’. This will direct you to the Pabbly Connect landing page.

Once on the landing page, click on the ‘Sign Up Free’ button in the top right corner. After creating your account, you will receive 100 free tasks every month to build workflows. To fully utilize Pabbly Connect, consider upgrading to the premium version for more tasks.

2. Creating Your Email Automation Workflow

After logging into your Pabbly Connect account, navigate to the dashboard and click on ‘Create Workflow’. This is where you will build your email automation workflow.

To initiate the workflow, select Google Sheets as the trigger application. Click the plus button and choose ‘New or Updated Spreadsheet Row’. This setup allows the workflow to trigger whenever a new row is added to your Google Sheet.

  • Select the Google Sheets application as your trigger.
  • Choose ‘New or Updated Spreadsheet Row’ as the trigger event.
  • Connect your Google Sheets account to Pabbly Connect.

After setting up the trigger, you will receive a webhook URL. Copy this URL and proceed to your Google Sheet to install the Pabbly Connect webhook add-on.

3. Integrating Google Sheets with Pabbly Connect

To integrate Google Sheets with Pabbly Connect, click on the ‘Extensions’ menu in your Google Sheet. Navigate to ‘Add-ons’ and then ‘Get add-ons’. Search for the Pabbly Connect webhook and install it.

Once installed, return to the ‘Extensions’ menu, select Pabbly Connect, and click ‘Initial Setup’. Paste the webhook URL you copied earlier into the designated field. Ensure you specify the trigger column, which is the last column of your Google Sheet.

  • Paste the copied webhook URL in the setup.
  • Specify the trigger column (e.g., column D).
  • Send a test to Pabbly Connect to confirm integration.

After submitting the configuration, your Google Sheets will now automatically send data to Pabbly Connect whenever a new row is added.

4. Setting Up Gmail to Send Emails

Next, you need to set up Gmail as the action application in your Pabbly Connect workflow. Click the plus button and select Gmail. Choose ‘Send Email’ as the action event.

To create a connection between Gmail and Pabbly Connect, click the connect button. You will have the option to add a new connection. Select ‘Add New Connection’ and sign in with your Google account.

  • Select Gmail as your action application.
  • Choose ‘Send Email’ as the action event.
  • Sign in to your Google account to create a connection.

Once connected, you can start framing your email by adding the sender name, email address, recipient’s email, subject, and email content. Use mapping to dynamically insert data from your Google Sheet.

5. Testing Your Automated Email Workflow

After setting up your email parameters in Pabbly Connect, it’s time to test the workflow. Click on ‘Save and Send Test Request’. This will trigger an email to the recipient specified in your Google Sheet.

Check your Gmail account to confirm that the email was sent successfully. The email will contain personalized information based on the data from your Google Sheet, allowing for automated communication without manual effort.

This entire process showcases how Pabbly Connect facilitates seamless integration between Google Sheets and Gmail, enabling efficient email automation.

Conclusion

In this tutorial, we explored how to automate email sending from Google Sheets using Pabbly Connect. By following these steps, you can streamline your communication and save time on manual tasks.