Get unsampled data.
Sometimes Google Analytics will sample your data. Avoiding sampling is easy with Big Analytics Data add-on. Simply set 'max days per query' to a lower number.

Get more than 10K results (rows of data).
To get more than 10 000 results, set max-results to a higher number. The add-on will run multiple queries until the number in max-results is reached (maximum 1 million).

Combine multiple reports in one data set.
If you want to combine data from multiple reports in one sheet, simply give them identical report names. The data will be printed to the same sheet.