This article will help you configure a merge file using Google sheets. If you are not familiar with how to use merge files, then please see the articles from the Merge Files section.
To merge data from Google Sheets with your import, you will need to first publish the data to a .csv file. Then, you will copy & paste the URL from Google into your merge file HTTP settings in your GoDataFeed account.
- Open google sheet > Blank > File > Open
- Open file from "My Drive" or "Upload"
- Proceed if you are ready to publish your data
- File > Publish to the web
- In the "Publish to the web" modal, select "Entire document" and "Comma-separated values (.csv)"
- Optionally, you can check the "Automatically republish when changes are made" option under Published content & settings. This means any changes you make will be published and available to our system on import.
- Copy the URL. You should see "?output=csv" on the end of the URL.
- In GoDataFeed, go to Merge Files
- Create a new merge file using the plus button
- Select Method: HTTP
- Enter the name of the Merge field name in "SKU merge field name"; the example above shows the merge column name is "sku"
- Copy & paste the URL from Google Sheets into the
Be sure that your merge file meets all of the requirements below:
- All Unique ID values in both files must be unique.
- Every row in the desired file to be merged must have a value in the Unique ID field.
- All Unique ID values in the merge file should match the Unique ID values from the primary source file, otherwise product rows will be stacked/appended at the end of the catalog.
- Your GoDataFeed product catalog is limited to 200 header fields. This includes all headers from the primary source file and any merge files.
- Download and review your product catalog once the import is complete, Products > Catalog and select Download