How to properly organize the synchronization of applications from the website?

Question

csv

There is a website with a catalog of components.
Applications come to email from Contacts (actively) + through web forms for ordering components (few).
For structuring, analysis and reporting, you need to write all this into CSV and import it into Google.Sheet.
Here a problem arises - what if we remove the email - the total number of applications per month will decrease, you can direct advertising to an online order, how to make such a transition correctly?

As an option, you can make a pivot table from 2 sources: auto - from web order forms, manually - from emails, such 2 csv import into a pivot table with date and time, where the ID is formed from the date and time (as a unique identifier).