How to Send WordPress Blog Notification Every Month Using Pabbly Connect

Learn how to send monthly WordPress blog notifications using Pabbly Connect. This detailed tutorial covers every step of the integration process with Google Sheets and Gmail.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Monthly Notifications

To send WordPress blog notifications every month, you need to set up Pabbly Connect. Start by logging into your Pabbly Connect account or create a free account if you don’t have one. Once logged in, navigate to the dashboard where you can create a new workflow.

Click on the blue button labeled ‘Create Workflow’ and name your workflow something like ‘Send WordPress Blog Notification Every Month’. Choose the folder where you want to save this workflow and click on ‘Create’. This sets the foundation for your automated notifications.

2. Configuring Trigger and Action in Pabbly Connect

In Pabbly Connect, the next step is to configure the trigger and action. For this integration, you will use the ‘Schedule’ feature as the trigger app. This means that your workflow will be triggered on a specific date every month. using Pabbly Connect

• Select ‘Schedule’ as the trigger application.
• Choose the option for ‘Dates of Month’ and specify the date (for example, the 2nd of the month).
• Set the time you want the workflow to run (e.g., 9:27 AM).

After saving this trigger configuration, the next step is to add an action where you will fetch the latest articles from your WordPress site. This action will be set to retrieve the latest posts automatically whenever the trigger occurs.

3. Fetching Latest Articles from WordPress

Once you have set up the trigger, it’s time to fetch the latest articles from your WordPress blog using Pabbly Connect. Click on the plus icon to add a new action and select ‘WordPress’ as the application.

Choose the action event labeled ‘Get Latest Blogs’. You will need to connect to your WordPress account by providing your username, password, and base URL. Ensure that the WordPress REST Authentication plugin is installed and configured on your site for this connection to work.

• Set the status to ‘Published’ to fetch only the published articles.
• Specify the number of posts to retrieve (e.g., 5 posts).

After setting these options, save and send a test request to confirm that the connection is working correctly. You should receive a response containing the details of the latest articles.

4. Transforming Data Format in Pabbly Connect

After fetching the articles, the next step involves transforming the data format using Pabbly Connect. Since the blog details are captured in an array format, you need to convert this into a simpler format for sending emails.

Select ‘Data Transformer’ as the next action step and choose ‘Line Itemizer’ as the action event. This allows you to map the array data you received from the previous step. Ensure that the data is correctly mapped to facilitate the next steps in your workflow.

Map the response data from the previous step to the input fields. Ensure to replace commas with a new line character for better readability.

Once this transformation is complete, you will have a neatly formatted list of articles ready to be included in your email notifications.

5. Sending Email Notifications via Gmail

The final step is to send the email notifications to your subscribers using Gmail through Pabbly Connect. Add another action step and select ‘Gmail’ as the application. Choose ‘Send Email’ as the action event.

Connect your Gmail account and set up the email fields. You can map the email addresses of your subscribers that you fetched from Google Sheets into the ‘To’ field. Customize the subject line and email content to include the latest articles.

Use a subject like ‘New Blog Articles for You!’ In the email body, greet the subscriber and include the list of articles.

After configuring these settings, save and test the email action to ensure everything is working as expected. You should receive an email notification with the latest blog articles.

Conclusion

In this tutorial, we demonstrated how to send WordPress blog notifications every month using Pabbly Connect. By integrating WordPress, Google Sheets, and Gmail, you can automate the notification process efficiently. This setup ensures your subscribers receive timely updates without any manual effort.