Oookay, that was a bad idea. I tried removing the entries in the column id_str before running the script again. It did indeed grab all tweets from the last 7 days. However, the overlap between the searches was significantly higher than expected. Since the “delete duplicates script” asks for confirmation before it deletes anything, and the sheet feels the need to recalculate everything after each deletion, this has become impossible to clean up.
Number of Tweets: 33,578
Unique tweets: 28,540