I have a Google Sheet that pulls in the last 7 days of Adwords data. I am attempting to create a dataset that appends this data without creating duplicates. I would love it if someone can provide feedback on how to accomplish this. Thanks.
You'd probably want to look into using a recursive dataflow:
The dataflow feeds into itself and builds up over time. It's a really nice trick to have in your Domo quiver.