Scheduled exports from Shopify to Google Sheets

Google Sheets

Here we will take a look at how to make scheduled exports to Google Sheets from Shopify. You can use this to have always the newest exported information for better and automated report constructing

Steps exporting to Google Sheets

1. Setup export.

In the Excelify app select checkboxes with information that you wish to export to Google Sheets. Here we will use product information, but you can also apply this tutorial for any other export combintion.Export Products Shopify

2. Configure scheduled export options.

Here we will need to do two things – configure our export to run on specific times and set the custom file name for the export. We will need this to ensure that our exported file link is always the same. To do this we click on ‘Options’.

  • Select option Repeat every: 1 hour until cancelled. But you can choose any other time interval for your scheduled export.
  • And we will set Custom File name to – ‘ExcelifyProductsExport’
  • Unckeck – Zip CSV files.
  • Chose an export format – ‘Excelify: CSV
  • Press ‘Export’Shopify scheduled export

3. Copy exported file link.

You can do this by right clicking ‘Download Exported File’ button and selecting the option ‘Copy link address’.3 - Copy link address

4. Create a new Google Sheets sheet.

Head over to https://docs.google.com/spreadsheets/ and select ‘Blank’ sheet4 - Create new sheet

5. Use a formula to automatically get data from the exported file.

In cell A1 use following formula =IMPORTDATA(“”). In this formula, you need to paste the link you copied from ‘Download Export File’ button, so it looks something like this –

=IMPORTDATA("https://shopify-excel-export-import.s3.amazonaws.com/excelify-renars-5c851cb4/export/ExcelifyProductsExport.csv")

Import data into Google Sheets from Shopify

Success!

Now you have the newest data always at hand and always in the same place. It’s worth noting that Google Sheets will only automatically export IMPORTDATA function every hour so, there is no reason to set your scheduled exports too often.Export from Shopify to Google Sheets

Good to know!

Schedule import to Shopify from Google Sheets

Google Sheets to Shopify

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.

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.

Steps to import file from Google Sheets to Shopify

  1. Prepare your Google Sheet on your Google Docs account.
  2. Make that Google Sheet viewable from a public link.
  3. Paste your Google Sheet link in the app.
  4. Schedule the regular import from that Google Sheet URL.

1. Prepare your Google Sheet on your Google Docs account

Your Google Sheets document needs to be prepared in the same manner as the “Excelify: Excel” file – with the sheet names, and columns that are understandable by “Bulk Import Export Update with Excel” app.

Basically, it will look like this:

Google Sheet to Shopify import - prepare Google Sheet

2. Make that Google Sheet viewable from a public link

Press the “SHARE” button and make the publicly shareable link to this Sheet.

You just need to give it permission “Anyone with the link can view” – no need for a write permission.

Copy that link.

Google Sheet to Shopify import - share the sheet as view only

3. Paste your Google Sheet link in the app

Open the “Bulk Import Export Update with Excel” app in your Shopify store, install it if you haven’t already.

Scroll down to the “Import” section, and paste the URL there.

Google Sheet to Shopify import - paste the URL in the app

Then press the blue “Upload from URL” button – so that the app can upload the file and analyze it.

Don’t worry – it will not import that just yet, you will need to set additional options first.

4. Schedule the regular import from that Google Sheet URL

After the app has finished uploading and analyzing the file, you will see the “Options” button there.

Press that button and set up the import options – the scheduled time for your next import in your Shopify store time zone.

And repeating time interval.

Your eventual options will look like this:

Google Sheet to Shopify import - setup options to schedule and repeat import

Notice the “Take import file from URL” – that is pointing to your Google Sheet. The app will download the fresh file each time it repeats the import.

Now, press the “Schedule Import” button.

It will schedule the import and if the date and time for the first import have already passed, then the app will start the first import shortly after you schedule it.

Good to know

  • You can see the progress of all your scheduled imports and exports in the “History & Schedule”. You can also cancel any of those jobs from there. You can download the import results file from there, too.
  • The scheduled time is in your Shopify store time zone.
  • You can also schedule import files to Shopify store from FTPDropbox or Google Drive the same way.
  • You can also import files from Google Sheet manually – by just pasting that Google Sheet link.
  • Import, not just Products data – import and update any of supported by Excelify.io formats.