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:
https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/How-can-I-add-only-unique-values-from-one-dataset-to-another/td-p/16549
The dataflow feeds into itself and builds up over time. It's a really nice trick to have in your Domo quiver.
I was not able to recreate a recursive data flow using this technique. Not sure what I did wrong, but I will get support at Domopalooza.