How to auto export MySQL data to Google Sheets, Excel Online and CSV
MySQL database to CSV, XLSX and GSheets | Full data objects | Flatly
Select MySQL Database as your Data Source.
Select your Data Destination from the following:
Google Drive (includes Google Sheets)
Microsoft OneDrive (includes Excel Online)
Microsoft OneDrive for Business (includes Excel Online)
Set the remaining preferences for your Job, including frequency: (every 10 minutes, every 1 hour, every 1 day, etc.)
Click Run Once Now to test.
Click Run Per Schedule.
Done. You can safely log out of Flatly. It is advisable to return periodically to check your logs.