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
- Check that you have setup the Google token as explained in the Google API settings for import and export document.
- Create a VirtueMart Product export template
- On Source tab select Destination as Export to Google Sheets
- Now enter the Spreadsheet details. Consider an example spreadsheet like https://docs.google.com/spreadsheets/d/1g9isWCeljHGSpbLbDsdarF89OVvmy8AI4nUWHUZxXis/edit#gid=0
- 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.
-
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.
- Once the export is done, log details page shows the result of the export.
- You can now check your Google sheet for the exported data