Your eventual options will look like this: Press that button and set up the import options – the scheduled time for your next import in your Shopify store time zone. 4. Schedule the regular import from that Google Sheet URLĪfter the app has finished uploading and analyzing the file, you will see the “Options” button there. Then press the blue “Upload from URL” button – so that the app can upload the file and analyze it.ĭon’t worry – it will not import that just yet, you will need to set additional options first. Scroll down to the “Import” section, and paste the URL there. Open the “ Bulk Import Export Update with Excel” app in your Shopify store, install it if you haven’t already. It should be enabled by default but if it is not then the app will not be able to download the file and Google Sheets will return 400 Bad Request error. If using view permissions then in the file Share pop-up, click on the cogwheel icon for Settings and make sure that you have enabled the setting – Viewers and commenters can see the option to download, print, and copy. You just need to give it permission “Anyone with the link can view” – no need for a write permission. Press the “SHARE” button and make the publicly shareable link to this Sheet. Make that Google Sheet viewable from a public link Your Google Sheets document needs to be prepared in the same manner as the “ Matrixify: Excel” file – with the sheet names, and columns that are understandable by “ Bulk Import Export Update with Excel” app.Ģ. Prepare your Google Sheet on your Google Docs account

Schedule the regular import from that Google Sheet URL.ġ.

Paste your Google Sheet link in the app.

Make that Google Sheet viewable from a public link.

Prepare your Google Sheet on your Google Docs account.

Steps to import file from Google Sheets to Shopify If you want to import Excel or CSV files that are stored on Google Drive, read this tutorial: Schedule import to Shopify from Google Drive. Importing from Google Sheets is a bit different than importing from a file that is saved on Google Drive, that’s why we will look at it as a separate tutorial.

Upload excel to google docs