I'm using the following method to encode URLs in Google Sheets:
It works. The only problem is – when I apply it to a sheet with 6000 entries – it gives ERRORs. As far as I understand this is due to too many requests. One of the help messages suggested trying to set in delays.
How can I do this?