Add a product feed with Google Sheets

Adding your own product feed allows you to use your own products from your own product database. This means that you don't have to add all products manually, and you can just use your own products that are already available. 

With Google Sheets, you can easily convert, manage, and play around with your product feed and keep your products synced with Spott. In this article, we'll show you how to set up the connection! 

 

In short: Copy our Google Sheets template file or create your own one with at least the mandatory fields. Then add your products and get share your file as a CSV. Add the CSV to Spott and let us do the importing work. That's it! 

 

Step by Step guide

Step 1: Create your Google Sheets file

To get started, you need to set up your Google Sheets file where you will be syncing the products from. 

The mandatory fields that Spott requires are the following columns:

  • ID: a unique ID that products or items from your database have (suggested name: product_id)
  • Name: the name of the product or item (suggested name: product_title)
  • URL: the link to your product page or item page (suggested name: product_url)
  • Image URL (Optional): when your products or items have an associative image, you can select it under Image(s) as well. This should be a URL to your image. (suggested name: product_image)

We've created a Google Sheets file with the mandatory fields and some examples that you can use. Copy the file to your own Google Drive and edit it to your own columns

mceclip0.png

 

Step 2: Populate the sheet

The next step is to import your data, this can be done with an external tool or collect the product information manually.

The big advantage of using Google Sheet for Spott Product Feeds is that you can easily import and use your already existing products coming from an XML or Excel file.

 

Step 3: Get your CSV file link

When you've done the setup and/or added your products, it's time to share it as a CSV file.

Click "File" and then click "Publish to the web".

shareGSpread1.png

The following modal will pop up. Under the Link tab, change the sheet to the sheet you want to share, change the type to "Comma-separated values (.csv)". Then click the "Publish" button.

(You can only share one sheet at a time)

mceclip1.png

Now copy the URL when you're done.

mceclip2.png

 

Step 4: Add your URL to Spott

When you've done step 3, head on over to Spott on the "Products" tab or click here for a shortcut! Then click "Create Product" and "Connect a Feed".

connectFeed.jpg

The setup modal will now open where you can set the following things:

  • Feed Name: Give your feed a name so you can reference it later.
  • Feed URL: Paste the link you've copied from step 3.
  • Update frequency: If you have a feed that updates frequently you can set this to daily, weekly, or monthly. If you're doing a one-time import, leave it as Disabled (default).

Click "Next" to continue.

 

mceclip3.png

 

If you see the following Validation screen, you're on your way to success! 😉 Click "Next" to go.

 

csvValidate.jpg

 

On the latest screen, you can map your fields. Map the required columns such as ID, name, and URL to the imported column name.

mceclip6.png

Note that every extra field in your spreadsheet file will be imported as well as custom fields. 

 

Now click "Connect feed" and let Spott do its thing! 🥳

 

Troubleshooting

My items don't update when I edit them

Spott doesn't know when edits happen to your Google Spreadsheet file. So you need to wait for the refresh to happen (see Update Frequency in step 4) or refresh it manually.

You can manually refresh a feed by going to the product feed list and clicking "Update Now". Spott will now go through your file and sync the products.

mceclip7.png

 

Was this article helpful?
2 out of 2 found this helpful

Comments

0 comments

Article is closed for comments.