URL Optimiser [Google Sheets]
This script will first filter the rows to keep only those that have non-empty values in columns A, B, and C after trimming. Then, for each row that is kept, it will check column B for URLs starting with “http://” or “https://”, and remove the protocol from the URL. Finally, it will clear the contents of the sheet and write back the filtered and updated rows.
