• Home

  • Automation with Zapier

  • Zapier tutorials

Zapier tutorials

3 min read

How to automate a weekly Wordle competition for friends

Go head-to-head with your Wordle rivals

By Joshua Barnes · February 16, 2022
The Zapier logo on an orange background

Have you done your daily Wordle yet? At Zapier, the answer is a resounding yes. Some of us have already put our own spin on the game. We even have an entire Slack channel dedicated to posting your daily Wordle. 

I'm also in various text threads and Discord channels devoted to the game. But I wanted to find a way to better compete with friends and family, a way that would include all our best (and worst!) scores in one spot. Our daily "who's best" on social media just wasn't cutting it.

Because I know you love Wordle too, I've made sure to document the process for you, so you can set up your very own weekly Wordle competition in five minutes. 

How I used Zapier and Google Sheets to create a weekly Wordle competition 

My friends and I first went about creating a weekly scoring system in Google Sheets. The only problem? They didn't know how to get that data into Google Sheets without MANUALLY writing down everyone's scores each day.

I work at Zapier for a reason, so I decided to automate the entire process using one of Zapier's built-in tool—Email Parser—and Google Sheets. 

Now any time someone I know finishes their Wordle, they can email me the results and Zapier creates a new spreadsheet row with all the info in Google Sheets—automatically. 

Screenshot of the Wordle competition in Google Sheets

To do this, I created a 2-step Zap that does the following: 

  1. Trigger: New email is created in Email Parser by Zapier

  2. Action: Create spreadsheet row in Google Sheets

Here's the Zap that you can use to recreate this process, along with the Google Sheets template I created (just make a copy of the Google Sheet template for your own competition). I'll break down the process in more detail below, too. 

How to build the Zap

  1. Go to the shared Zap and click on the Try this Zap button. You'll be redirected to the Zapier Editor. 

2. Create an Email by Parser account for your trigger if you don't have one already. Once you've set up an account, click Create Mailbox. The letters that appear in the box below will be your email address.

Screenshot of a mailbox created in Email Parser by Zapier

3. Next, you need to train your parser to select the following text:

  • Wordle ID

  • Wordle score

  • Wordle hard mode

You can do this by copying your latest Wordle scores from Wordle and pasting them into the template box.

Screenshot of Wordle scores pasted into the Parser

4. Once you've done that, highlight each score/number and assign it the right name:

  • Wordle ID

  • Wordle score

  • Wordle hard mode

  • Wordle game

Screenshot of tagging Wordle scores in Email Parser

5. If you don't want to include the Wordle squares inside your Google sheets, you can also highlight the squares in the parser and tag it as "game".

Screenshot of tagging Wordle picture in Email Parser

6. Save your template and return to your Zap. Set up your trigger with the Mailbox address you created.

Screenshot of Wordle competition Zap

7. Now it's time to test your trigger. You may have to send a test email to your Email Parser address with your Wordle scores so the Zap can collect the data. Once you've done that, the parsed results that appear should look like this:

Screenshot of Wordle competition Zap: selecting fields

8. In the Google Sheets action, connect the spreadsheet you copied from this template (don't forget to share it with your fellow competitors!) and map the parsed data accordingly with your Wordle ID, Wordle score, and Wordle Hard Mode. You can do this by clicking within the field you want to map and selecting the data from your previous step in the dropdown that appears.

Screenshot of Zap review: the final step

9. Test out the action and if everything looks right, begin using your Zap.

You can also tweet your Wordle by adding one more step to the Zap above where you select Twitter for your action app and Create Tweet for your action event.

Get your friends to play ball

Once you've set up your Zap, it's game time. Every time you and your friends finish a Wordle, click the Share button, which will copy your scores to your clipboard.

Screenshot of shareable Wordle results

Get your friends, family, and frenemies to email the copied information to the mailbox address you set up with Email Parser by Zapier—and Zapier will send everybody's scores to your Google sheet, like this: 

Screenshot of the Wordle competition in Google Sheets

The spreadsheet shows off your competitors' best Wordles, number of plays, hard mode attempts, missed Wordles, and more.

So there you have it. By setting up this simple Zap, you can see who among your friends and family is the best wordsmith. 

Let's be honest. It's a lot more fun this way. 

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.


Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'