**Workflow to Extract Email Address from a Gmail and Include It in an URL Query String** [home](..) _posted 2015-10-28_ My astrology website has a paid membership tier, and the membership software is unreliable. Most of the time, a reader subscribes and pays via PayPal, and her WordPress account is automatically assigned the correct role and privileges. But sometimes it just doesn't work, and I am neurotic about fixing issues before I get the complaints, which means that every time I get an email from PayPal, I checked the user's email in my user database to make sure she is truly an All-Access member. Previously, I'd copy the email address to my clipboard, and go to the Users page in my WordPress dashboard and enter it into search. Later, I created a [Launch Center Pro][1] action that would append the clipboard to an URL: `http://sasstrology.com/wp-admin/users.php?s=[clipboard]` After I poked around in the subreddit for [Workflow][2], I realized I could automate this process even more. I have an IFTTT recipe to save all PayPal notification emails in Dropbox, and then I use a Workflow to extract the user's email and append it to the above string. In my [shared IFTTT recipe](https://ifttt.com/recipes/337491-save-an-email-to-dropbox) you can see that I use the Gmail trigger to search for `subject:(Notification of Payment Received from)` and then save the body of the email in Dropbox. Once I get an email or IFTTT notification, I visit the Dropbox iOS app. The email is the most recently added or updated item, so I just tap on it and then on the Share icon. I then tap on Run Workflow and choose "PayPal Member." I'm not going to upload the "PayPal Member" workflow, but here are the actions: 1. When the workflow is run, the default input is the shared Dropbox URL. I use the **Replace Text** action to replace `www.dropbox` with `dl.dropboxusercontent` so that the content of the URL can be accessed. 2. **Get Contents of URL** 3. **Get Email Addresses from Input** 4. **Get Item from List**. I choose "First Item" because in the body of the notification email, the user's email is the first instance of "email address." 5. I use the **URL** action and replace the above LCP action with the `Input` variable instead of `clipboard`. 6. **Open URLs** This way, all I have to do is go to Dropbox, tap on the most recent item, and run the workflow, and I can immediately view the user's profile in WordPress. [1]: http://contrast.co/launch-center-pro/ [2]: http://workflow.is