So weird that this is happening till now, after 2 years. Any way, I was able to solve the issue, by sheer luck! You'll have to create a new zip from Google as per the instructions but select everything instead of limited timeline. When importing in to mileage record, do not filter any results and try and import everything. I've repeated this few times until one time it just imported everything.
