Derek R.

Gabe E. yes that’s correct. I explained above what the use case is, here it is again: I’m using API to pull in email out reach campaign names and data. Then I’m exporting from Clay to a Google Excel spreadsheet. This process runs daily, and the most recent information is at the bottom of the sheet, while the previous information is out of date.

Bo both of these options only work on the first instance of data and not applicable to my use case. I’m wanting to update new duplicate data that’s added and remove the initial duplicate(s).

I’m using API to pull in email out reach campaign names and data. Then I’m exporting from Clay to a Google Excel spreadsheet. This process runs daily, and the most recent information is at the bottom of the sheet. The process runs fine since the excel sheet only received data from NEW cells, but I would prefer to have a cleaner Clay sheet and not have many duplicates being entered daily.

Is there any work around, like adjusting table settings so new data is added to the top of the sheet?