Adding a changing text to the end of a URL from a spreadsheet

I'm trying to modify or reuse a Macro that was created with the help of Gabe a while back.
The original version was to choose from a drop-down menu to then run several steps and open two additional pages.

What I'm trying to do here is copy a name from a spreadsheet (IE 8121) and then add it to the end of to open
I'm getting the error message "Open URL failed with invalid URL" in macro...
I'm sure it is something simple that I'm not seeing, but I can't figure out what it wrong.

Thank you for any help you can give me.


Keyboard Maestro 8.2.4 Actions

Keyboard Maestro Actions.kmactions (8.7 KB)

Hi again, Steve,

You need to ensure that the URL being opened in the 5th action is valid, which means that the SavedClipboard variable needs to be percent encoded before being added to the tumblr URL. Fortunately, KM includes an action that makes it easy to do that:


Try adding this "Filter" action just as its shown here to your macro after the "Set Variable" action and before the "Open URL" action, like so:


Thanks, Gabe;

That seems to be working.

Thanks again;


So the only issue that I am running into with this is that it adds a %0A to the end of everything.
For more of the names that I'm adding on it works fine anyway, but there are a few that come back and say "Could Not Load Conversation"





%0A is URL for a line break. You can fix that by adding a "Trim Whitespace" filter action before the "Percent Encode" filter action:


1 Like