Setup Google Sheets
Format
Your Google Sheet must be in a specific format for us to be able to read it. The first row should be the header row with the column names. The column names should use Google's Product Feed Specification.
Examples of supported columns:
- id
- item_group_id
- title
- description
- price
- sale_price
- sale_price_effective_date
- image_link
- additional_image_link (should be a comma separated list)
- availability
- size
- sku
- brand
- category
- color
- condition
- cost
- custom_label_0
- custom_label_1
- custom_label_2
- custom_label_3
- custom_label_4
- gender
- google_product_category
- gtin
- link
- product_type
- sell_on_google_quantity
- shipping_weight
Finding the Google Sheet URL
Firstly, make the Google Sheet accessible to anyone with the link. Otherwise, we can't read the data in the sheet. To do that, click the Share button in the top right corner of the Google Sheet and change the general access to Anyone with the link like shown in the image below.
Now, we need to get the Google Sheet ID and GID. To do that, open the Google Sheet and copy the Google Sheet ID from the URL. The URL should look something like this:
https://docs.google.com/spreadsheets/d/19NIOMFcWW5y0boWh8MbD-VAHNMgjvWDXl3y5sMBABKg/edit#gid=0
For this example, the Google Sheet ID is 19NIOMFcWW5y0boWh8MbD-VAHNMgjvWDXl3y5sMBABKg and the GID is 0. If your sheet has multiple sheets, the GID will be different.
When you have the two values, you can make the url. It will look something like this:
https://docs.google.com/spreadsheet/ccc?key=[SHEET_ID]&output=csv&gid=[GID]
For this example, the url is https://docs.google.com/spreadsheet/ccc?key=19NIOMFcWW5y0boWh8MbD-VAHNMgjvWDXl3y5sMBABKg&output=csv&gid=0
Creating the shop in Feedr
- Log in to your Feedr account
- Navigate to your shops
- Click the add button in the right corner
- Select the CSV integration option
- Fill out the form
