function main() {
var sheet = SpreadsheetApp.getActiveSheet();
var replaceRules = [
['対象語', '置換後'],
['hoge', 'fuga'],
['bar', 'baz']
];
for ( var i = 0; i < replaceRules.length; i++ ) {
replaceInSheet(sheet, replaceRules[i][0], replaceRules[i][1]);
}
}
function replaceInSheet(sheet, to_replace, replace_with) {
var values = sheet.getDataRange().getValues();
for ( var row in values ) {
var replaced_values = values[row].map(function(original_value) {
return original_value.toString().replace(to_replace, replace_with);
});
values[row] = replaced_values;
}
sheet.getDataRange().setValues(values);
}