We Build Shopify Apps

Montreal-based Shopify experts cooking some Shopify apps.

CSV import to Shopify Google Spreadsheet links

Requires Moose Sync

Problem

Struggling importing products in a Shopify store from a Google Spreadsheet link.

Solution (from Megalytics)

Using Moose Sync, the google spreadsheet URL is automatically transformed into a URL that downloads a CSV file. You won't need to manually edit the URL following the instructions below, this is just to inform you of the logic behind this URL transformation.

Google Sheets can be downloaded automatically as CSV files using a URL that you can construct from the sheet’s key. Take this sheet, for example:

https://docs.google.com/spreadsheets/d/1qrtaGu5dwljVbHJeR4RIMWtdZKOauJfJ6nODlPwMRno/edit?usp=sharing

You can create a CSV download link for that sheet, but plugging the “key” into this URL structure: https://docs.google.com/spreadsheets/d/{key}/gviz/tq?tqx=out:csv

The “key” is the long string appearing after /d/:
1qrtaGu5dwljVbHJeR4RIMWtdZKOauJfJ6nODlPwMRno

So, in this case, using our example key, you get the following link:
https://docs.google.com/spreadsheets/d/1qrtaGu5dwljVbHJeR4RIMWtdZKOauJfJ6nODlPwMRno/gviz/tq?tqx=out:csv

Get In Touch

Tabarnapp's mission is to help you get the most of each visit on your Shopify store.

E: support@tabarnapp.com