Migrating account problem with Google sheets
I am trying to migrate to a new Waves account and transfer as much as possible from the old one, but I am having problems transferring the products and customers through google sheets.
---STEPS SO FAR---
1. I have setup the new account, and given access to it within the old account
2. I have connected the old + new accounts through google sheets and wave connect
3. I have downloaded the products and customers from the old account
4. I try to upload the products from the old account -> new one but validation fails (see below)
---WHERE I AM STUCK---I am stuck when I try to upload the products to the new account, through google sheets.
When I try to validate the data in step 2, I get an error saying "Required Column Product Name not found".
I checked the new account (by downloading the empty "products" into a new sheet) and the title of the first column is "Name".
So I renamed the first column from the old account from "Product name" -> "Name" so it matches the new account.
I still get the same error of "Required Column Product Name not found".
Thanks in advance.