After validating the license key, Authenticate with Google on Integration Tab.
Authorizing with Google
When an application requests private data, the request must be authorized by an authenticated user who has access to that data. This means it allows to fetch the google sheets automatically from the given google account.
Click “Get code” to retrieve your code from Google Drive to allow us to access your spreadsheets. And paste the code in the below textbox.
Make sure while authentication requires to Enable Google Drive and Google Sheets Permissions!
Its 100% Secure, Refer to the Google Sheets OAuth API
Click on Get Code Button
It will show the login page, to login into the Google account or select the Google account to configure
By clicking on the Allow button you will get your access code.
Click to Copy the Auth-Code, and Paste it to the Integration Tab, and Hit Save & Authenticate
After saving the code you will see a message in green that the Access code is saved. But do check debug log for invalid access code!
If it is not authenticated then check the debug log, if debug log is empty without any errors, then it means it’s authenticated without any errors.
Once it’s Authenticated, Click on fetch the sheets.
It will fetch the sheets on click. If it takes time to fetch sheets, just make sure that don’t have too many sheets in your account.
If there are too many sheets in the account, then it will take time to fetch the list.