Throw ALL Your CRM Notes into the Table
Now that your code is finished, you can delete all rows from your Analytics table—start with a clean slate—and then execute your scheduled function. To do so, you can change your “lastModifiedSince” variable to a date months or years ago to ensure you’re capturing all Notes in the CRM.
Alternatively, if you have thousands of Notes, you should probably just export those from the CRM (try a data backup) and then import them directly to your Analytics table.
Just DON’T FORGET to change your lastModifiedVariable back to “2 hours ago” when you’re finished.