RO CSVI Supports import from Google sheets starting with 7.17.0 version. Step by step procedure for setting up google account API is explained in the document.
Before doing any import or export settings we need to do few Google account settings so the generated keys can be used in RO CSVI import and export templates.
You need to create import template first before setting up Google. The template URL is used as redirect URL in the Google settings.
Install Google library
RO CSVI does not include Google API Library with core files as the library is too big to ship with core package. The Google library is shipped by Google via Composer, this means that you will need the following:
- shell access to your server
- composer needs to be installed to install the library
The Google library needs to be installed before setting up the import and export templates, without the library RO CSVI cannot do import or export using Google sheet option.
To install Google library, take the following steps:
- Login to the server via SSH (Shell)
- Go to path administrator/components/com_csvi/assets/google
- Run the command composer install. This will download around 30 MB package into the Google folder.
- The installation is finished
If you are having difficulty in installing the Google library with composer please consult with your hosting provider on how to do it for your hosting.
Setting up a Google Account
- Go to https://console.developers.google.com/
Click on API & Services and then Dashboard
Enable Google sheet API by clicking on Enable APIs and Services button on top
In the top menu bar click on the Search products and resources field
In the search field enter Google sheets, select the API and enable it.
Go to Credentials page to create OAuth Client ID and a client secret key.
Click on Create Credentials button on top and select OAuth Client ID
Select Application type as Web application and give a name for OAuth client ID. Here we have set it as CSVI.
In the Authorized redirect URIs field set the import template URL or export template URL you are going to use Google sheets with. Click on Create button. An example template URL for import would be
This DOMAIN must be a top-level domain, for example .com or .org or another valid top-level-domain.
You can find the ID of the template on the Details page of the template.
You will see Client ID and Client Secret Key generated. Note them down and keep them safe.
Click on Done and now you have OAuth Client id and Client secret ready.
Now they can be used in RO CSVI Import/Export templates.