Using Data Shuttle with Google Drive as the target exports the file in XLSX format

Jenishiya

"When using Data Shuttle with the Target Location set to Google Drive, we have the option to select the exported file in either XLSX or CSV format. Is there a way to automatically convert the file to a Google Sheet directly within Smartsheet?"

Gia Thinh

Hi Jenishiya

Smartsheet does not have currently built in option to automatically export a sheet to Google sheets directly. However, you can use Google Apps Script as a workaround to convert exported Excel or CSV files into Google sheets.

Google Apps Script can monitor a specific Google Drive folder and automatically converts newly uploaded files into Google Sheets.

If you need step-by-step guidance on developing the script, ChatGPT can help!