Behind the Scenes: Using Google Spreadsheets to create a CSV data feed

Behind the Scenes: Using Google Spreadsheets to create a CSV data feed

So I have a few stores online stores and places to buy stuff on demand from various companies which create and our Jiggy Shop stuff.
From T-shirts, to bags and camera gear, there’s quite a bit in Our Jiggy Creationz Shop. So there are some systems like, our Instagram Shop which allow you to tag products and items from your shop, in the site.

So let’s look at the how to host your data feed on Google Docs. For this post, I will assume you already have a Google account. If not, you will be prompted to set one up once you go into Google Docs.

What is a CSV data feed?

CSV (Comma-Serperated Values / Variables) is a file format where you can make a list of things, which are separated by (guess what) commas. A CSV data feed uses a file save in this format to feed (send) information to another system. In this post, the system we will feed data to is Facebook Business, which then feeds to Instagram shop.

Why do I need one?

Well if you want to be able to manage, your shop links on the go, you should consider this option because once it’s set up, I can be a massive time saver. By using Google Spreadsheets to host your csv, you can update it anywhere (as long as you have internet access on your phone, laptop or desktop, and haven’t locked yourself out of your account!).

Great! Where do I go to get one?

Head of over to Google Spreadsheets and log in. That’s pretty much it. You can then create your csv file.

How do I create my own feed?

Different Systems have different needs when you create the CSV. For Instagram Shop / Facebook Business Catalogue you can download the template