play watch

Free Google Shopping Course

  • 41 tutorials
  • 5 hr 31 min 26 sec
Section 3.5: How to Create Your Product Feed

Set up your product feed with Google Sheets

In this video, you're going to learn how to set up your product feed using the Google Sheets method. This is the best method to use if you have a lot of products because it allows you to download them directly from Shopify.

Resources

💁 Helpful links

📘 Complete Guide to Google Shopping Product Title Optimization ➤ Read here

📘 Product Feed Field Guide ➤ Read here

📄 Google Product Category ➤ Click here

📄 Supported languages and currencies ➤ Click here

🔗 HTML Cleaner ➤ Click here

Recommended lessons

🎥 What is Google Merchant Center and how does it work? ➤ Watch here

🎥 How to Claim & Verify Your Website on Google Merchant Center ➤ Watch here

🎥 How to set up your Shipping and Returns Settings on Google Merchant Center ➤ Watch here

🎥 How to Write Product Descriptions that Sell for your Ecommerce Store ➤ Watch here

🎥 What is a Product Feed and What Are Product Fields? ➤ Watch here

🎥 How to fix Product Disapprovals in Google Merchant Center ➤ Watch here

Add Your Comments & Questions Below

Subscribe
Notify of
guest
6 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Emad
Emad
1 year ago

Hi Sam, Amazing video. 
It's about uploading feeds through Google Sheets on GMC, as you say. Even though I do the same procedure through CTX feed WordPress, it still shows me a GTIN error and shopping ads do not run because of this error. 

GTIN Error.png
Sam
Admin
Sam
1 year ago
Reply to  Emad

Hi Emad,

Thanks!
The screenshot you shared seems like the missing GTINs are just a warning, but that doesn't stop the ads from being served. Warnings aren't ideal, and you'd like to fix them, but the ads are still being served. I would look more in-depth to determine why the ads aren't running.

Todd Entenman
1 year ago

Thank you Sam for your amazing videos. I have been Googling my questions as I try to build my website, and your videos come up at the top of the searches. All the information you present answers my questions succinctly, like I'm asking you questions face-to-face. Your videos have been an answer to prayer, as navigating all this can be VERY confusing. Thank you again for giving me a great jumping off point.

Arthur Baptistella
Arthur Baptistella
1 year ago

Hello Sam! I'd like to know if there is an way to put more than just one image link using google sheet. Thanks

Ela Bruce
Admin
1 year ago

Hi Arthur,

You can add more images with the [additional_image_link] attribute.

AR Legacy Properties
AR Legacy Properties
11 months ago

For those who have a large spreadsheet of products, you can also use the excel function to remove the hyperlinks for your descriptions.

1. Select the cells you will convert all html to texts, and press the Ctrl + F keys to open the Find and Replace dialog box.
2. In the Find and Replace dialog box, go to the Replace tab, enter <*> into the Find what box, keep the Replace with box empty, and click the Replace All button.

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
page
post

Subscribe to Our Newsletter and Don't Miss Anything Important!

Thank you for your interest in our newsletters. We will send you only the most important news and updates. No spam, we promise.

We are committed to protecting your privacy, as described in our Privacy policy.

What’s your goal today?

1. Hire us to grow your ecommerce store

We’ve generated millions for our clients, using the methods we’ve developed over years with a singular focus on Google Ads for ecommerce. To discover how we can help grow your business:

Claim your FREE website strategy session with one of our renowned experts.

2. Learn & develop your ecommerce skills

Watch our highly regarded YouTube channel, followed by over 23,000 store owners and ecommerce learners from around the world.

You can also subscribe to our weekly email newsletter to get real-world tested growth and optimization strategies, as well as notifications on anything you may need to know as an ecommerce store owner.

Browse our blog, written and structured to be the best resource in the world for anyone starting and growing their online store. It includes strategy guides, setup instructions, checklists, and tools.

Explore our KeyCompendium, which is a comprehensive wiki of digital marketing terms. Many readers have commented on the usefulness of this content.

3. Join our team

If you want to join our team—or discover why our team members love working with KeyCommerce—then see our “Careers” page.

4. Contact us

We help ecommerce store owners around the world, so get in touch!