URL Encoding in No-Code Tools: Zapier, Power Automate, Sheets, and n8n

No-code automation platforms are powerful for building workflows that call APIs and construct URLs — but they don't always make encoding obvious. If your Zapier zap or Power Automate flow passes user data directly into a URL without encoding, you'll hit errors the moment a value contains a space, ampersand, or equals sign.

Each major platform has an encoding function. Here's how to use it in Zapier, Power Automate, Google Sheets, and n8n.

URL Encoding in Google Sheets with ENCODEURL

Google Sheets has a built-in ENCODEURL() function that percent-encodes a string:

=ENCODEURL("hello world & more")
// Result: hello%20world%20%26%20more

=ENCODEURL(A2)
// Encodes whatever value is in cell A2

This is useful for building dynamic URLs in a spreadsheet, such as a column of search queries that need to be URL-encoded before being assembled into API request URLs. Combine it with CONCATENATE() or the & operator:

="https://api.example.com/search?q="&ENCODEURL(A2)&"&limit=10"

Note: ENCODEURL() encodes spaces as %20, not as +.

URL Encoding in Zapier

Zapier doesn't have a dedicated URL encode step, but you can run JavaScript in a Code step to encode a value:

1. Add a Code by Zapier step with JavaScript.
2. Map your input data to a variable, then return the encoded value:

const value = inputData.myValue;
output = [{ encoded: encodeURIComponent(value) }];

In later steps, use the encoded field anywhere you need the URL-safe version. This works for query parameter values, path segments, or any data that needs to pass safely through a URL.

For Webhooks in Zapier: when you configure a POST or GET request, Zapier's built-in URL field will sometimes encode values automatically. Test with a request bin to verify the actual URL being sent.

Sell Custom Apparel — We Handle Printing & Free Shipping

URL Encoding in Power Automate

Power Automate has a built-in expression function: encodeUriComponent().

Use it in any expression field:

encodeUriComponent(triggerBody()?['searchQuery'])
// Encodes the searchQuery field from the trigger

encodeUriComponent('hello world & more')
// Returns: hello%20world%20%26%20more

To build a full URL with an encoded parameter in an HTTP action:

concat('https://api.example.com/search?q=', encodeUriComponent(variables('searchTerm')))

Use this in the URI field of an HTTP action or any dynamic content field that accepts expressions. Note the function name is encodeUriComponent (camelCase, not encodeURIComponent).

URL Encoding in n8n

In n8n, you can URL encode in expressions using JavaScript's built-in encodeURIComponent():

{{ encodeURIComponent($json["searchQuery"]) }}

Use this in any field that accepts expressions (indicated by the expression toggle). For example, in an HTTP Request node's URL field:

https://api.example.com/search?q={{ encodeURIComponent($json["query"]) }}&limit=10

n8n also has a URL Encode operation in the String node (available since v1.x). Add a String node, select URL Encode as the operation, and map your input field — no code required.

Frequently Asked Questions

Does Zapier automatically encode URL parameters in webhook steps?

Sometimes, but inconsistently. Zapier may encode values when you use the Query String Params section of a Webhook step. However, when building URLs via string concatenation in code steps, encoding is manual. Always verify the actual sent URL using a request logging tool.

Google Sheets ENCODEURL doesn't encode commas. Is that a problem?

Commas are technically allowed in URL query strings (RFC 3986), so ENCODEURL() leaves them unencoded. For most APIs this is fine. If you need commas encoded, use a workaround: =SUBSTITUTE(ENCODEURL(A2),",","%2C").

Can I URL encode in Make (formerly Integromat)?

Yes. Make has a built-in encodeURL() function available in the formula editor. It works the same way as Google Sheets' ENCODEURL — paste your value and it returns the percent-encoded result.

What about Airtable formulas?

Airtable doesn't have a native ENCODEURL function. You can use a URL encode tool to pre-encode values and store them as static text, or use a JavaScript code step in an Airtable automation to encode dynamically.