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!