Send Personalized Emails with SMTP and Mail Merge in Google Sheets

The Mail merge add-on lets you send personalized emails to multiple recipients in one go. The emails are always sent via your Gmail account or your Google Workspace email address. Google also imposes a limit on the number of emails you can send per day.

Mail Merge with SMTP

Mail merge is convenient because you can put your contacts in a Google Sheet and the add-on will individually send the emails for you. However, if you aren’t using Gmail or have a large mailing list, an SMTP service like SendGrid or AWS may be more a suitable option for sending out personalized emails.

Wouldn’t it be nice if you could enjoy the ease of the Mail Merge add-on while still utilizing an SMTP service to send personalized emails? That’s where the Document Studio add-on can help.

Generate SMTP Credentials

Google for SMTP settings for [your email provider] and you’ll find the SMTP server address, port number, and the authentication details like the username and password (or API key) for your email service.

For instance, if you plan to use Zoho Mail for mail merge, the SMTP settings would be as follows:

  • SMTP Server: smtp.zoho.com
  • Port: 465
  • Username: Your Zoho account email address
  • Password: Your zoho.com password

Send Email with SMTP

Prepare Mail Merge Data

Open the Google Sheet with your mail merge data and launch the Document Studio add-on. Create a new workflow and choose the Send Email task.

From the list of Email Service providers, choose SMTP Server and enter the SMTP server address, port number, and the authentication details that you found in the previous step.

SMTP for Mail Merge

Next, move to the Email Message section and configure your email template. You can use placeholders like {{First Name}} and {{Title}} in the message body and subject line to personalize the emails.

If you would like to attach files to the email, you can do that as well. You may attach the same file to all emails or use placeholders to attach different files to each email.

Click the Preview button and you should see a sample email sent to your own email address through the SMTP server. You can now click the Save and Run button to send personalized emails to all recipients in your Google Sheet.

How to Add a Simple User Ranking System for WordPress Comments

Do you want to add a simple user ranking system for WordPress comments on your website?

A ranking system can gamify your comments section and motivate more users to leave their thoughts and questions on your website. This can boost engagement and build a sense of community around your brand.

In this article, we will show you how to easily add a simple user ranking system for WordPress comments.

Add a Simple User Ranking System for WordPress Comments

Why Add a Ranking System for WordPress Comments?

Comments help improve user engagement on your WordPress website. By adding a ranking system for these comments, you can motivate users to leave informative and well-written discussion points on your blog.

For example, you can feature the comments you like at the top of the comment section or award badges to the comments of your choice.

Similarly, you can add an upvote/downvote system for users to control comment popularity or bury spam comments at the bottom of the discussion. This can create a sense of community around your WordPress blog and also help you moderate comments.

Having said that, let’s see how to easily add a ranking system for WordPress comments. In this tutorial, we will look at two methods, and you can use the links below to jump to the method of your choice:

Method 1: Add a User Ranking System in WordPress Comments

If you want to add a simple user ranking system to your comments section, then you can easily do this with Thrive Comments.

It is the best WordPress comments plugin on the market that helps you create an interactive comments section by featuring/burying comments, adding thumbs up/thumbs down, awarding badges, and more.

For more information, see our complete Thrive Themes review.

First, you must visit the Thrive Themes website and sign up for an account. Once you do that, head over to your member dashboard.

From here, click on the ‘Download and install the Thrive Product Manager plugin’ link.

Install Thrive Product Manager

Next, open up your WordPress dashboard to install and activate Thrive Product Manager. For detailed instructions, see our step-by-step guide on how to install a WordPress plugin.

Upon activation, you must visit the Product Manager tab from the WordPress admin sidebar and click on the ‘Log into my account’ button.

Log into Thrive Themes account

Once you have provided your login credentials, you will see your Product Manager dashboard.

From here, select the Thrive Comments plugin and click the ‘Install selected products’ button.

Install Thrive Comments

Next, you can visit the Comments » Thrive Comments Moderation page in the WordPress dashboard, where you will see a list of all the comments on your blog.

From here, you can approve, unapprove, edit, or flag the comments as spam. You can also feature a comment by opening the ‘More’ dropdown menu and selecting that option.

Feature, edit, delete, or approve a comment from the Thrive moderation dashboard

Once you do that, all the featured comments will be displayed at the top of the discussion section. These comments will also have a badge in the top left corner, which will signify their importance.

For more detailed instructions, you can see our tutorial on how to feature or bury comments in WordPress.

Featured comments preview

Afterward, you can visit the Thrive Dashboard » Thrive Comments page from the WordPress admin area and scroll down to the ‘Voting and Badges’ section.

From here, you can add like/dislike functionality to your comments to boost engagement. You can select the ‘Up and down’ option to add thumbs up/thumbs down icons with the comments.

You can also choose the ‘Up only’ option if you don’t want users to be able to dislike any comments on your website.

After that, you can toggle the ‘Users must be registered and logged in to vote’ switch to ‘On’ if you only want to provide this functionality to logged-in users.

Choose Up and down option to allow users to like or dislike comments in WordPress

For detailed instructions, you can see our tutorial on how to allow users to like/dislike comments in WordPress.

Next, you can scroll down and toggle the ‘Award Badges’ switch to ‘On.’ Once you do that, just click the ‘Add New Badge’ Button.

Toggle the award badges option to On

This will open a prompt on the screen, where you can start by adding a name for the badge. After that, you can choose when to award it from the dropdown menu.

For example, if you want to award a badge to a user when they have at least 5 featured comments on your website, then you can select the ‘Featured’ option from the dropdown menu.

Then, add 5 as the value next to the ‘reaches’ option.

Configure award rules for badges

After that, you can choose a badge image or upload one from your computer.

Once you are done, simply click the ‘Save Badge’ button to store your settings.

Choose an image for your badge and click Save Changes

You can then click the ‘Add New Badge’ button again to create a badge awarding system for your comments.

Your settings will be saved automatically.

Click Add New badge button to add more badges

Now, simply visit your WordPress site to view the badges in action.

In our example, you can see that the comment at the top is featured because it has an icon at the top left corner. You can also see the badge awarded to the users next to their names.

Comment ranking system preview

Method 2: Add a User Ranking System in WordPress Forums

If you want to create a ranking system for the discussion forums on your website, then this method is for you.

First, you will need to install and activate the bbPress plugin. For detailed instructions, see our beginner’s guide on how to install a WordPress plugin.

Upon activation, visit the Forums » Add New page from the WordPress admin sidebar. Here, you can add the name, description, visibility, status, and moderators for the forum you will create.

Once you are done, don’t forget to click the ‘Publish’ button to store your settings. For detailed instructions, see our tutorial on how to add a forum in WordPress with bbPress.

Create a forum

After that, you have to install and activate the bbp user ranking plugin. For details, see our step-by-step guide on how to install a WordPress plugin.

This plugin will show each forum member’s total rankings, the number of topics they started, and replies.

Upon activation, visit the Settings » bbp user ranking page from the WordPress dashboard and scroll down to the ‘Ranking Calculations’ section.

Here, you will see that the plugin uses the number of topics and replies a user has created to calculate rankings. You can simply check these options to add them as ranking factors.

Now, by default, the plugin offers two ranking levels for comments. However, if you want to add another ranking level, then simply enter the number of levels you want into the ‘Number of levels’ field and click the ‘Save Changes’ button to refresh the page.

Configure ranking level calculations

Once you have done that, it’s time to configure settings for different levels.

To do this, scroll down to the ‘Level 1’ section and type a name for it into the ‘Rank Name’ field. This will be the name that will appear on the user’s profile.

After that, you must add the number of posts that members must make to graduate from this level and move to the next level under the ‘Up to number’ option.

Add rank name and upto number

For instance, you may create a New Member level with an ‘Up to number’ value of 5. This means that anyone who posts 1-5 comments will be a New Member.

You can then also add the URL for the image that will displayed next to the name of all level 1 users. You can get the image’s URL from your media library.

Adding a user badge to the simple rating system

After that, you can also configure the image size, font color, and font size from different settings.

You can then repeat the process to set up other levels on your website. Once you are done, don’t forget to click the ‘Save Changes’ button to store your settings.

After that, switch to the ‘Badges’ tab from the top. Here, you can select if you want to show multiple badges earned by the users in a row or column.

Select how to display badges

Next, scroll down to add the number of badges you want to create for your forum next to the ‘Number of Badges’ option. After that, click the ‘Save Changes’ button to refresh your page.

Then, you can add a badge name, paste the URL for the badge image, and choose a font color.

You can then also configure the image size according to your liking. If you don’t want to display an image with your badge, then you can select the ‘Click to display name’ option from the top.

However, you must select the ‘Click to display name on top of image’ option to show both the name and image for your badge.

Configure badge settings

You can now repeat this process to create as many badges as you want. Once you are done, don’t forget to click the ‘Save Changes’ button to store your settings.

Next, switch to the ‘Display’ tab from the top. Here, you can configure how the user ranking information will look on your forum.

You can now choose if you want to display the topic count, reply count, level symbols, or rank names. Simply check the box next to the information that you want to showcase.

After that, you can add an optional label to help people understand what the different numbers mean.

Adding the reply count to the user profile

Next, you can also check the boxes to display level images and badges next to the user’s names.

After that, don’t forget to click the ‘Save Changes’ button to store your settings.

Choose to display images and badges and click the 'Save Changes' button to store your settings

You have now successfully added a user ranking system. You can visit your website to view the users’ profiles in your forum.

Here, you will be able to see their ranking levels and calculations.

Rewarding forum users with star symbols

You can also award different badges that you created to users on your website. However, keep in mind that you will have to do this manually by visiting the Users menu tab.

Once you are there, click the ‘Edit’ link under any user profile of your liking.

Edit a user profile to award badges

This will take you to a new screen where you must scroll down to the ‘Badges’ section.

Here, check the ‘Click to add this badge’ option for any badge that you want to award the user. Once you are done, don’t forget to click the ‘Update User’ button to store your settings.

You can now repeat the process for other users as well.

Check the click to add this badge option to award a badge to a user

Bonus: Add a Points System in WordPress

Other than adding a ranking system for comments, you can also add a points system on your WordPress site to boost engagement.

For instance, you might reward your customers with points upon user registration, purchasing a product, or as part of a loyalty program. You can then award prizes or exclusive content to visitors with the most points.

If you have a membership site, then you can also offer a level upgrade to users with a certain number of points.

You can easily add a points system in WordPress with myCred. Upon activation, simply visit the Points » Settings page from the WordPress dashboard to start choosing a label and image for your points.

For example, you can call the points earned by the audience coins, brownies, jewels, tokens, or anything else that works.

Choose a points label

After that, you will have to create user levels, set hooks for the points system, and integrate the plugin with different tools like MemberPress or LearnDash according to your liking.

Once you are done, you can use the different blocks provided by myCred to add a points system leaderboard on your website.

MemberPress hooks

For detailed instructions, see our tutorial on how to add a points system in WordPress to ignite user engagement.

We hope this article helped you learn how to add a simple user ranking system for WordPress comments. You may also want to see our beginner’s guide on how to allow users to report inappropriate comments in WordPress and our expert tips and tools to combat comment spam in WordPress.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

The post How to Add a Simple User Ranking System for WordPress Comments first appeared on WPBeginner.

Longing For May (2024 Wallpapers Edition)

Inspiration lies everywhere, and as a matter of fact, we discovered one of the best ways to spark new ideas: desktop wallpapers. Since more than 13 years already, we challenge you, our dear readers, to put your creative skills to the test and create wallpaper calendars for our monthly wallpapers posts. No matter if you’re into illustration, lettering, or photography, the wallpapers series is the perfect opportunity to get your ideas flowing and create a small artwork to share with people all around the world. Of course, it wasn’t any different this month.

In this post, you’ll find desktop wallpapers created by artists and designers who took on the creativity challenge. They come in versions with and without a calendar for May 2024 and can be downloaded for free. As a little bonus goodie, we also compiled a selection of favorites from our wallpapers archives at the end of the post. Maybe you’ll spot one of your almost-forgotten favorites from the past in here, too? A big thank-you to everyone who shared their designs with us this month! Happy May!

  • You can click on every image to see a larger preview,
  • We respect and carefully consider the ideas and motivation behind each and every artist’s work. This is why we give all artists the full freedom to explore their creativity and express emotions and experience through their works. This is also why the themes of the wallpapers weren’t anyhow influenced by us but rather designed from scratch by the artists themselves.
  • Submit a wallpaper!
    Did you know that you could get featured in our next wallpapers post, too? We are always looking for creative talent.

A Symphony Of Dedication On Labour Day

“On Labour Day, we celebrate the hard-working individuals who contribute to the growth of our communities. Whether in busy urban areas or peaceful rural settings, this day recognizes the unsung heroes driving our advancement. Let us pay tribute to the workers, craftsmen, and visionaries shaping our shared tomorrow.” — Designed by PopArt Studio from Serbia.

Navigating The Amazon

“We are in May, the spring month par excellence, and we celebrate it in the Amazon jungle.” — Designed by Veronica Valenzuela Jimenez from Spain.

Popping Into Spring

“Spring has sprung, and what better metaphor than toast popping up and out of a fun-colored toaster!” — Designed by Stephanie Klemick from Emmaus Pennsylvania, USA.

Duck

Designed by Madeline Scott from the United States.

Cruising Into Spring

“When I think of spring, I think of finally being able to drive with the windows down and enjoying the fresh air!” — Designed by Vanessa Mancuso from the United States.

Lava Is In The Air

Designed by Ricardo Gimenes from Sweden.

Love Myself

Designed by Design-Studio from India.

Bat Traffic

Designed by Ricardo Gimenes from Sweden.

Springtime Sips

“May is a month where the weather starts to warm and reminds us summer is approaching, so I created a bright cocktail-themed wallpaper since sipping cocktails in the sun is a popular warm weather activity!” — Designed by Hannah Coates from Baltimore, MD.

Hello May

“The longing for warmth, flowers in bloom, and new beginnings is finally over as we welcome the month of May. From celebrating nature on the days of turtles and birds to marking the days of our favorite wine and macarons, the historical celebrations of the International Workers’ Day, Cinco de Mayo, and Victory Day, to the unforgettable ‘May the Fourth be with you’. May is a time of celebration — so make every May day count!” — Designed by PopArt Studio from Serbia.

ARRR2-D2

Designed by Ricardo Gimenes from Sweden.

May Your May Be Magnificent

“May should be as bright and colorful as this calendar! That’s why our designers chose these juicy colors.” — Designed by MasterBundles from Ukraine.

The Monolith

Designed by Ricardo Gimenes from Sweden.

Blooming May

“In spring, especially in May, we all want bright colors and lightness, which was not there in winter.” — Designed by MasterBundles from Ukraine.

The Mushroom Band

“My daughter asked me to draw a band of mushrooms. Here it is!” — Designed by Vlad Gerasimov from Georgia.

Poppies Paradise

Designed by Nathalie Ouederni from France.

Lake Deck

“I wanted to make a big painterly vista with some mountains and a deck and such.” — Designed by Mike Healy from Australia.

Make A Wish

Designed by Julia Versinina from Chicago, USA.

Enjoy May!

“Springtime, especially Maytime, is my favorite time of the year. And I like popsicles — so it’s obvious isn’t it?” — Designed by Steffen Weiß from Germany.

Celestial Longitude Of 45°

“Lixia is the 7th solar term according to the traditional East Asian calendars, which divide a year into 24 solar terms. It signifies the beginning of summer in East Asian cultures. Usually begins around May 5 and ends around May 21.” — Designed by Hong, Zi-Cing from Taiwan.

Stone Dahlias

Designed by Rachel Hines from the United States.

Understand Yourself

“Sunsets in May are the best way to understand who you are and where you are heading. Let’s think more!” — Designed by Igor Izhik from Canada.

Sweet Lily Of The Valley

“The ‘lily of the valley’ came earlier this year. In France, we celebrate the month of May with this plant.” — Designed by Philippe Brouard from France.

Today, Yesterday, Or Tomorrow

Designed by Alma Hoffmann from the United States.

Add Color To Your Life!

“This month is dedicated to flowers, to join us and brighten our days giving a little more color to our daily life.” — Designed by Verónica Valenzuela from Spain.

The Green Bear

Designed by Pedro Rolo from Portugal.

Lookout At Sea

“I wanted to create something fun and happy for the month of May. It’s a simple concept, but May is typically the time to adventure out into the world and enjoy the best of Spring.” — Designed by Alexander Jubinski from the United States.

Tentacles

Designed by Julie Lapointe from Canada.

Spring Gracefulness

“We don’t usually count the breaths we take, but observing nature in May, we can’t count our breaths being taken away.” — Designed by Ana Masnikosa from Belgrade, Serbia.

Geo

Designed by Amanda Focht from the United States.

Blast Off!

“Calling all space cadets, it’s time to celebrate National Astronaut Day! Today we honor the fearless explorers who venture beyond our planet and boldly go where no one has gone before.” — Designed by PopArt Studio from Serbia.

Colorful

Designed by <a href=https://www.lotum.de>Lotum from Germany.

<a href=https://archive.smashing.media/assets/344dbf88-fdf9-42bb-adb4-46f01eedd629/e8daeb22-0fff-4b2a-b51a-2a6202c6e26e/may-12-colorful-31-full.png>

Who Is Your Mother?

“Someone who wakes up early in the morning, cooks you healthy and tasty meals, does your dishes, washes your clothes, sends you off to school, sits by your side and cuddles you when you are down with fever and cold, and hugs you when you have lost all hopes to cheer you up. Have you ever asked your mother to promise you never to leave you? No. We never did that because we are never insecure and our relationship with our mothers is never uncertain. We have sketched out this beautiful design to cherish the awesomeness of motherhood. Wishing all a happy Mothers Day!” — Designed by Acodez IT Solutions from India.

Asparagus Say Hi!

“In my part of the world, May marks the start of seasonal produce, starting with asparagus. I know spring is finally here and summer is around the corner when locally-grown asparagus shows up at the grocery store.” — Designed by Elaine Chen from Toronto, Canada.

May The Force Be With You

“Yoda is my favorite Star Wars character and ‘may’ has funny double meaning.” — Designed by Antun Hirsman from Croatia.

Birds Of May

“Inspired by a little-known ‘holiday’ on May 4th known as ‘Bird Day’. It is the first holiday in the United States celebrating birds. Hurray for birds!” — Designed by Clarity Creative Group from Orlando, FL.