Hi,
Please be aware that using category names in place of product names will be a very resource-intensive procedure for the server and is not advised for bigger sets of products. However, you can use the following filter in the functions.php file of your present theme:
add_filter('wcgs_products_data_categories', function($value, $row){
if( ! $value ) return $value;
$value = array_map(function ($v) {
$cat = get_term_by( 'name', trim($v['id']), 'product_cat' );
$item['id'] = $cat->term_id;
return $item;
}, $value);
return $value;
}, 999, 2);
Now inside your Google Sheet you can add names in the categories columns like Cate gory A|Category B