Due to a data migration between two domains, the IDs of the files have changed.
Is it possible with GScript to search in a GMail that I forward or reply to and replace a URL to a Google file. In a separate table I have an overview "oldID" <> "newID".
One example:
This URL:
https://docs.google.com/document/d/10IXFzXXXpEPW6X2W6nXWVJX_hXdrgc0IivDnTF-I1_c
becomes this URL:
https://docs.google.com/document/d/1ByuyeidXxXN3WxXRK-NFoaYubVAXXAQU4_vtBzgFK99
My primary question is whether this is possible and if so, which approach should I take?
Greetings
I am still looking for a starting point.