The reason why you're encountering the "detail": "Connection columns are not unique…" error is because the columns in your google spreadsheet isn't distinct. To correct this, each column should be given a unique name.
Example Unique Headers:
Not Unique:
Can't find what you're looking for?