RO CSVI

Setting up Google sheets export using RO CSVI

A step by step instruction on setting up Google Sheets export using RO CSVI with an import template is explained in this document.

Step by step setting up Google Sheets export using RO CSVI

    1. Check that you have setup the Google token as explained in the Google API settings for import and export document.
    2. Create a VirtueMart Product export template
    3. On Source tab select Destination as Export to Google Sheets

      Setting up Google sheets export using RO CSVI

    4. Now enter the Spreadsheet details. Consider an example spreadsheet like https://docs.google.com/spreadsheets/d/1g9isWCeljHGSpbLbDsdarF89OVvmy8AI4nUWHUZxXis/edit#gid=0
    5. Spreadsheet id is 1g9isWCeljHGSpbLbDsdarF89OVvmy8AI4nUWHUZxXis
    6. Sheet name is Sheet 1
    7. From cell is A
    8. To cell is G
    9. Enter these details and save the template. We are all set for export. 

      Spreadsheet details Google

    10. 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.

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

      Export result from exporting data into Google Sheets

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

Related Articles