At Zapier, the author created a weekly Wordle competition by automating the process of collecting scores using Email Parser and Google Sheets. The author set up a 2-step Zap that triggers when a new email is received with Wordle scores, which then creates a new spreadsheet row in Google Sheets. To recreate this process, users can follow the steps outlined in the shared Zap, including creating an Email by Parser account, training the parser to select specific text, and mapping the parsed data to the desired fields in Google Sheets. Once set up, users can share their Wordle scores with friends and family, who can email them to the designated mailbox address, which will then send the scores to the Google sheet, displaying a leaderboard of competitors' best Wordles and other statistics.