I tried to do this through a macro but I'm unable to have it actually record. I'm not a coder so I've been recording macros and using the code from there to create an add on. I need a script that can find "null" and replace it with nothing. Not null as in no value, I mean the sheets are literally showing null as a value. I'd use Ctrl+H to find and replace but I need to do this for 50 or so reports on a regular basis.
I don't think that using the macro recorder to copy code automatically generated will be enough to create a G Suite Document Editor add-on, but you have to start somewhere.
I didn't used Class TextFinder yet but it looks promising.