Support is offline. We are back Monday 23 November, 09:00.

Export SQL to Google Sheets #86882

Resolved fotonio opened this topic Tuesday, 20 October 2026 · 5 replies
Author

Hi, i am trying to setup an export with SQL to Google Sheets.

I have followed the tutorial here and i have checked at the component 's option Google Api tab, the token is there.

Publishing status of the application is set to "Testing" and i added the Google drive account owner to test users.

When i run the template the notice says the export was completed but the sheet remains empty.

I am not sure if i selected the appropriated scopes in Google developper console. Can you check the attached screenshot and tell me if the unchecked scopes are required for the export to work?

I also tried to backup the template to send it to you but i get error message: Unable to save the template backup file to path /var/www/vhosts/my-domain/httpdocs/tmp/com_csvi/csvi_templates_my-domain_20261020.xml

tmp folder is writtable 755 permissions.

I have joomla 6.2.0, php 8.4.26 and ROCSVI 9.13.0

  • selected scopes.png
Support

Hi,

When i run the template the notice says the export was completed but the sheet remains empty.

Please post export debug log to check. To get the debug log read How to collect debug information? document.

I also tried to backup the template to send it to you but i get error message: Unable to save the template backup file to path /var/www/vhosts/my-domain/httpdocs/tmp/com_csvi/csvi_templates_my-domain_20261020.xml

tmp folder is writtable 755 permissions.

Template backup XML is saved inside tmp/com_csvi folder before download and that com_csvi folder must be missing so you get error message. Go to RO CSVI About page and click on Fix folders in there. You can then do template backup after that. Please post that as well to check.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Thank you for the tip, i fixed the folders.

I notice in the template file line 45 sheet name is set to Sheet 1 from the file tab which i can't edit because after selecting export type XLSX in the file tab and save, i notice a strange behavior, Advanced and Help buttons stop working (see attached video).

In destination, options and fields tab the sheet name is set correctly to sheet1.

I also tried to change everywhere the sheet name to Sheet 1 but still the Google sheet remains empty.

Support

Hello,
Thank you for posting requested files.

file tab which i can't edit because after selecting export type XLSX in the file tab and save, i notice a strange behavior, Advanced and Help buttons stop working (see attached video).

Yes I see that issue and there is a JavaScipt error. I will look into this.

In destination, options and fields tab the sheet name is set correctly to sheet1.

I also tried to change everywhere the sheet name to Sheet 1 but still the Google sheet remains empty.

On File tab set Export type to CSV instead of XLSX and save the template. RO CSVI writes CSV data into Google sheets. Setting export type to CSV should solve your issue of google sheet empty on export. Try and let me know.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Yes, it works after selecting export as CSV.

Last question: If the export is a repeatable cron job is it possible not to overwrite everytime the Sheet data from row 1 but instead write in the next empty row?

Or if this is not possible it would be useful to have the functionalities of "Save on server folder" option. So we could select a Google drive folder and create a different file every time the cron runs with customizable filename.

Support

Hi,

Last question: If the export is a repeatable cron job is it possible not to overwrite everytime the Sheet data from row 1 but instead write in the next empty row?

With every export current sheet data is overwritten and it is not possible to write data from next empty row. You can change the spreadsheet ID to new Google sheet or change the Sheet name so the data is saved in new Sheet.

Or if this is not possible it would be useful to have the functionalities of "Save on server folder" option. So we could select a Google drive folder and create a different file every time the cron runs with customizable filename.

We have save on server folder option for normal CSV export but not with Google sheets. You can either export to a new spreadsheet ID or a new sheet in same spreadsheet ID.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Log in to reply to this topic.