Setting up Google sheets export with RO CSVI

RO CSVI Supports import and export from Google sheets from 7.17.0 version.

Step by step instruction on setting up the template is explained. Before starting with the export it is needed to do settings in Google for generating needed keys which are then used in export template. 

1. Create a VirtueMart Product export template

2. On Source tab select Destination as Export to Google Sheets

setting up google sheet export with ro csvi

3. Enter Client ID and Client Secret keys; save the template.

google source export settings

4. Click on Generate Access token button. You will be redirected to Google page to select your google account and will be asked to allow access for the API for the account.

RO CSVI Google select account

In case you see the This app isn't verified page, there can be several reasons for that:

  • The way you configured the scopes in the app requires verification by Google and this hasn't been completed yet
  • The app is configured that it doesn't require verification by Google

Go to the Manage Consent Screen and edit your consent screen to allow for the Google verification process to verify your consent. On the edit page of the consent screen you will find a number of links and helpful information on how to deal with issues and the verification process. You can get more details on this verification process on the Unverified Apps page. You can click on Advanced and click on Go to CSVI (Unsafe) link to continue. In your case this will display the name of the app you have given in Google.

google app not verified



5. Allow access for the Service name CSVI to manage your spreadsheets.

google allow access to csvi

6. Confirm your choices with CSVI

google confirm choice settings

7. You will be redirected to RO CSVI Templates page with access token generated. Save the template.

export access token settings

8. Now enter the Spreadsheet details. Consider an example spreadsheet like

  • SpreadSheet id is 1g9isWCeljHGSpbLbDsdarF89OVvmy8AI4nUWHUZxXis
  • Sheet name is Sheet 1
  • From cell is A
  • To cell is G

Enter these details and save the template. We are all set for export. 

Spreadsheet details google

9. Go to RO CSVI Export page and do the export as usual, RO CSVI will read the data from database and write it to the Google sheet.

10. Once the export is done, log details page shows the result of the export.

11. You can now check your Google sheet for the exported data

Related Articles