So when it goes into the Google Sheet it counts that entry as two urls that were submitted by John Doe. The Google Sheet also checks that the url is active or removed usually giving out the 200, and if removed 404 error.
Is this something that can be replicated on Airtable?
I found the following conversation. I don’t know I you can solve the issue that they describe in the thread but you can use a third party platform like integromat to do this.