I export data to the Google Spreadsheet but it isn't showing up on the last row of the Spreadsheet

The Google Sheets API that AZInsight communicates with will automatically send the data directly to the last row on the Google sheet but sometimes there are formulas or actions that are atomically applied to the sheet to manipulate the data. 

Please check if there are my special sort or filters to any of the columns column actions applied that is moving the data export from showing up on the last row of the Google Sheet. 

If you have filters applied you can follow this article by this 3rd website on how to clear them: https://blog.sheetgo.com/spreadsheets-tips/data-filters-and-sorting-in-google-sheets/