I've done some analysis in Google Sheets I don't want to re-do. Can I just import just a few numbers

I'm trying to hook up the Google Sheets connection, but my Google Sheet isn't rows and columns, it's just a column of variable names and a value next to each one, which is a live formula. Is it possible to just connect that much? I tried transposing it so each variable was a column with one number underneath because I thought that format would fit what Domo is expecting better. It's giving me an error every time though ("Failed to create DataSet. Please try again."). Is what I'm doing impossible or am I just doing it wrong?