If you’re facing an issue with creating downloads using Google Sync in WooCommerce, follow the steps below to add downloads to each product:
Create a column with the heading “downloads” before the sync column in your Google Sheets.
Against the downloadable product, set its downloads value in the following format:
[{"name":"YOUR_FILE_NAME_1","file":"YOUR_FILE_URL_1"},{"name":"YOUR_FILE_NAME_2","file":"YOUR_FILE_URL_2"}]
Note that this is a JSON format, and you need to provide values against the “name” and “file” keys.
Ensure that the URLs you provide are approved in WooCommerce downloads. You can learn more about WooCommerce approved directories here: https://woocommerce.com/document/approved-download-directories/.