Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Automation

To begin automating reminder emails, you need to access Pabbly Connect. Open your browser and go to pabbli.com/connect. If you’re new, sign up for free to explore the features available.

Once signed in, you can utilize 100 free tasks each month, allowing you to send up to 100 emails. This is a great way to test the capabilities of Pabbly Connect before committing to a subscription plan.

2. Setting Up Google Sheets with Pabbly Connect

Next, you need to set up your Google Sheets to work with Pabbly Connect. Open your Google Sheets and ensure you have all the necessary recipient details in place. These details will be used for sending reminder emails.

  • Open your Google Sheets and navigate to Extensions.
  • Select Add-ons and search for Pabbly Connect Webhooks.
  • Install the Pabbly Connect Webhooks extension.

After installation, refresh your Google Sheets to enable the new extension. This will allow you to set up the integration between Google Sheets and Pabbly Connect.

3. Creating the Integration Workflow in Pabbly Connect

Now that you have your Google Sheets ready, return to Pabbly Connect to create your workflow. Click on the “Create Workflow” button and select Google Sheets as your trigger application.

For the event, choose “New or Updated Spreadsheet Row”. Click on Connect and paste the webhook URL provided by Pabbly Connect into your Google Sheets under the Pabbly Connect Webhooks settings.

  • Set the trigger column to the final data column (e.g., Column D).
  • Click Submit to configure the setup.
  • Test the webhook by sending a test data response.

Once the test is successful, you can proceed to the next step of sending reminder emails through Gmail.

4. Sending Emails with Gmail via Pabbly Connect

After capturing the webhook response, it’s time to set up the action step for sending emails. In Pabbly Connect, add a new action step and select Gmail as the application.

Choose the event as “Send Email” and connect your Gmail account. If you have previously connected it, select the existing connection; otherwise, create a new one by signing in and granting the necessary permissions.

  • Enter the sender’s name and email address.
  • Map the recipient email address from the previous step to make it dynamic.
  • Customize the email subject and content as needed.

Once all fields are filled, click on “Save and Send Test Request” to verify that the email is sent successfully.

5. Automating the Email Reminder Process

To automate the process of sending emails to all recipients, return to your Google Sheets. Navigate to Extensions, select Pabbly Connect Webhooks, and click on “Send All Data”. This action will trigger the workflow in Pabbly Connect to send reminder emails to all entries in your spreadsheet.

Make sure to toggle the “Send on Event” option to ensure that every new entry automatically triggers an email reminder. This makes the entire process seamless and efficient.

By using Pabbly Connect, you can easily manage and automate your email reminders without any manual intervention, saving you time and effort.

Conclusion

In this tutorial, we explored how to automate reminder emails using Pabbly Connect with Google Sheets and Gmail. By following the steps outlined, you can efficiently manage your email reminders without manual effort. Start using Pabbly Connect today for seamless automation.