Google Analytics API team written a few in-depth articles meant as a "Deep Dive" into a specific topic, and is paired with open-source, sample reference code. The articles are as follows:
- Outputting Data from Data Export API to CSV Format shows how to automate all the manual work by printing data from DE API in CSV, the most ubiquitous file format for table data.
- Filling in Missing Values In Date Requests: If you want to request data displayed over a time series, you might find missing dates in your series requests. When requesting multiple dimensions, DE API only returns entries for dates that've collected data. This can lead to missing dates in a time series, this article describes how to fill in these missing dates.
Also See: Google Analytics Apps>[Source]