DESCRIPTION
If you have a Google Drive integration enabled on your site (eg. to drive product images or supplementary product data via a .csv file) and find your data isn't updating or auto syncing from Google Drive (it might look something like this on the sync status page for hours at a time):
And it only works once you reconnect your google drive via the website CMS in the sync menu:
Then there may be an issue with the refresh token that was originally generated at Google's end at the time you first connected your Google Drive to the site.
EXTRA INFO
In order for a third party (such as Web Ninja) to connect to Google Drive's data via Google's API connection, and remain authenticated to continue to access data in your Google Drive account with requiring you to log into your Google Drive every time; a "refresh token" has to be generated that authorises that third party to be able to continually request an access token.
This is primarily for the security of your data so some other system you haven't authorised can't just come along and try to access data on your Google Drive by connecting to it via an API connection.
Sometimes when we first send the request to google on your behalf when you first connected your google account to the site - this refresh key can be corrupted (wasn't generated correctly).
HOW TO FIX
The fix is quite simple - you just need to remove Web Ninja from the list of permitted applications on your Google account - which will delete the corrupted refresh token; then log back into Google via the Webninja CMS on your site and that will create a brand new refresh token:
While logged into your Google account - go to this link on Google's site:
https://myaccount.google.com/u/0/permissions
It'll show you which online applications you've given permissions to - eg:
Clicking on the Web Ninja application will take you to a screen that looks like this:
Click on the section "Delete all connections you have with Web Ninja".
Then go back to the CMS of your site and reconnect your google account (you might have to click on the disconnect button first):
Then reconnect your Google Drive:
It'll take you to a page requesting you to verify which Google Account you want to connect to the site:
Once connected back to your Google drive, just let the auto sync run and it shouldn't have anymore issues.
If you have trouble following any of these steps - please contact Web Ninja Support!