Removing characters up to a specific combination in a Google Sheets/Excel spreadsheet cell?

Question

Macros

There is a table It is

necessary to leave in the cell only the characters that come after gclid=
There can be a lot of cells, so it's not an option to do it manually
Ideally, do it in Google spreadsheets. I tried to write a script, but it all ended there

function main() {
  var ss = SpreadsheetApp.getActiveSheet();
  var data = ss.getDataRange().getValues();
  for (var i = 7; i < data.length; i++) {
    var link = data[i][0];
  }
}

I wanted macros in Excel, but they are not written correctly
Which way to dig? How can it be implemented?

Answer 1

for cell R2 containing the entire text of the link, you need to write something like this:

Answer 2

It does not work with scripts, try formulas first. For example,
=ARRAYFORMULA(REGEXEXTRACT(A2:A;".*?gclid=(.*)$"))

https://docs.google.com/spreadsheets/d/1Nll6tQ-I9a...