Google Sheet Data is a platform that allows you to export data from Google Sheets into a single XML or JSON file. This way, you can perform the task automatically, something that is not possible without the tool. The extension also gives you a preview of the data before exporting it (view or listen).
Once you have downloaded the program from its official page, you will see that a Google Sheet page automatically opens and asks for permission to install as an add-on (you need to be logged in to Google).
Now you have the extension in the top menu under Add-ons. Once you have all the data inserted in your spreadsheet, just go to Add-ons, choose Export Sheet Data, and the platform interface will open on the right side.
From the interface, you can select the format between XML or JSON and also choose whether you want to convert all the spreadsheets, the active ones, or customize the conversion. All that remains is to preview the export and export it.
The environment truly offers a simple and fast way to convert Google Sheets data to XML or JSON, whether from some cells or in batch. Google Sheet Data is a free extension for the Google Chrome browser; to install it you need to log in to Google.