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 (also known as bottom up) on the Google sheet. But formulas or actions present on the sheet may manipulate the data causing the data to be written to the top instead ( also known as top-bottom).
Verify the following cases to help fix this issue:
- Check that you don't have any blank rows in your spreadsheet, Google Sheets will automatically fill the first blank row that it finds, even if it is in the middle of various rows
- Check to see if you have 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
- Be sure you are logged into your Google account with the Google Chrome browser
- Check to make sure that the Sheet tab name has not been changed
- Verify that you do not have any special sort on any of the columns
- Verify that you do not have any column filters applied to any of the column actions
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.
Related Articles
I exported to Google Sheets but I don't see the data exported or can't find it
If the data isn't showing up on the spreadsheet, please verify the following ( video below for demostration) There are no rows on the sheet that are blank where the data is showing up on the bottom The spreadsheet is NOT in the saved under the ...Understanding the Google Sheet Integration
This tutorial is lengthy and covers the google sheet integration topic. If you do not have the patience to read the post you can watch this video here and come back to this tutorial for reference. For this tutorial, we will be using a new Google ...How to re-establish the connection to the Google Sheets Integration if it has been disconnected?
To re-establish the connection to the Google Sheets Integration, please follow the steps below: Go to the Export Configuration screen Then click the Sign in with Google to re-establish the connection to your Google account If you want to ...I click on the "Sign in with Google" button but nothing happens or the process does not complete correctly
Refer to the table below for help in troubleshooting Cause Solution Reference The Google authentication popup window has opened in the back of the current Chrome window Locate the Google authentication popup window in the background by resizing ...I click the sign in with Google button but the Gmail account I am looking for is not there
If the Google Sheets connection breaks, and you try to re-connect, but you do not see the correct Gmail account listed please follow the steps below: 1. Remove and reinstall the AZInsight extension 2. Go back to the Amazon Product page ...