Import Feed via Google Sheets

How to import your feed when using Google Sheets to access the feed tool

Updated over a week ago

To get started, select URL as your feed type and click on the +Add button to reveal the options. 

You'll see a field to paste a URL into, dropdowns for setting a fetch schedule, and fields for username and password.

Note: It is highly suggested that if you're hosting your feed file on Google Sheets that you password protect access to the file. When you set a username and password for access, you'll need to input this information to our app so that it can access your feed for scheduled fetches.

Additionally, you must publish your Google Sheet for sharing as one of the following file formats:

  • CSV

  • TXT

  • XLS

How you set your Fetch Schedule is entirely dependent on how often changes are made to your feed. 

URL feeds are simpler than uploading a feed file in the sense that when updates are made they will automatically get pulled into the app at your desired fetch time. 

There are 3 different options for fetch frequency:

  1. Daily

  2. Weekly

  3. Monthly

If your feed changes often or you add/remove products from your site on a regular basis, your best option is to fetch daily.

If changes are rarely made, set the fetch frequency to weekly or monthly. 

We suggest setting the fetch time at a time very early in the morning between 3-5 AM. This ensures your feed file is imported and will cause little to no interference in your experience using the apps other features.

Click save to save your feed settings.

Once your file has uploaded to the app, you will be redirected to the Feed Mappings section, where you will need to map the data fields from your file to the data fields that our app will be pushing to Google Merchant Center. 

The column on the left titled "Field" contains the fields found in your uploaded file and the column on the right titled "Attribute" is what the fields will need to be named for our feed to be built and sent to Merchant Center.

Note: When you upload a file and complete the mapping, you will not need to map again UNLESS you upload a new file with different names for the data fields. If you keep the same fields your mapping will remain saved in the software.

You'll notice in the above example there are several Attributes set as [Ignore Field]. This instruct our app to not import data from these fields from your uploaded file.

Once mapping is completed, click on the Save & Fetch button to instruct the app to build your new data feed and export it out to Merchant Center.

Pro Tips:

When upload your feed via URL, you are able to add multiple URLs into the system. This is best for larger product catalogs of over 50,000 SKUs. For best results, we suggest keeping each feed URL to a maximum of 50,000 SKUs and breaking it up into multiple files if you have more than that.

Keep in mind, additional feed files DO NOT act as supplemental feeds. If you upload 2 files with one having 15 fields and one have 2 fields, the more recently fetched feed will override the other. 

Did this answer your question?