Appends values to a specified range in a Google Sheet.

This function appends provided data to a specified range in a Google Sheet. It allows customization of how the input data should be interpreted and inserted. The function returns a promise that resolves to an object containing information about the append operation.