Arne S.

My problems basically stem from the need to handle, compare, and filter large amounts of records/rows, and limitations in the number of sources you can have in one table

Yes but it does require setting it up if you do it after the fact. Working with duplicates is not a long-term strategy; whenever you want to make changes you would need to manually do that for an X number of tables. Btw, I appreciate your checking-in but rephrasing requests is not very helpful

Yess I have indeed tried to write them to other tables. In principle this is a solution, problems I am experiencing:

So my use case is that I am collecting a bunch of company leads from the google maps api. In 4 tables, I am reaching the 20 sources limit. I would like to add more tables with the same source limit. My problem is checking for duplicates, exporting without having to merge (often slightly incongruent) data, and getting a general overview of all leads based on advanced filters. So let’s say I have 1.000 leads in each individual table, drawing on one particular region. Practice shows me that about 50% of those are relevant leads for me. If I want to get all relevant leads from 2+ regions (=tables) in one place, I would have to go through a (error-prone) process of getting them in google sheets or clay. This is a hassle. Next to that, the 500 relevant leads per region, are a bundle of several smaller niches. I can separate the niches based on some advanced filtering. The specific niches I am then using in very targeted marketing campaigns, with promising results. These are all part of a general effort to experiment with who and how we best reach with our product. I am a Go-To-Market Engineer.

Solid tip, but not solving my problem

Hey Daniel, thanks for the update! Main point is data analysis, so google sheets is kind of perfect. Anyway, great you will be working on the gsheet integration