Importing from a "New" Google Spreadsheet creates duplicate records
We have several Google spreadsheets that are automatically imported into our Zoho Reports tables. We use the criteria "Add records and replace if already exists". We always use the record ID as the unique identifier.
Since setting up some imports from the "New" Google Spreadsheets, duplicate records are created in our Zoho Reports tables on subsequent import runs, but the duplicates have blank record ID's (the field we're using as the unique identifier)
Attached are s
creenshots of the:
- Duplicates in our Zoho Reports tables
- Google Spreadsheet records are being imported from
- The Scheduled import setup showing the settings