Troubleshooting: I exported to Google Sheets but it doesn't show up on the last row on the sheet

Troubleshooting: I exported to Google Sheets but it doesn't show up on the last row on the sheet

The Google Sheets mechanism that AZInsight communicates with will automatically send the data directly to the last row on the Google sheet. But formulas or actions present on the sheet may manipulate the data. Check if there are my special sort or filters to any of the column's column actions applied causing the data export from showing up on the last row of the Google Sheet. 

Use the steps below to help troubleshoot this issue

  • Check to see if you have an added any new columns in the spreadsheet that contain special attributes such as a checkbox or function 
  • Check to see if you have an automatic sort applied to the column and the data causing google sheet to move the row of data either up or down on the sheet.
  • Check to make sure you logged into the Google Chrome browser.
  • Check to make sure that the Sheet tab name has not changed.

If you have filters applied, you can follow this article on how to clear them: https://blog.sheetgo.com/spreadsheets-tips/data-filters-and-sorting-in-google-sheets/ (3rd party website). If you are still experiencing issues, please contact us.