Importing markers from Google sheet – deleting data from sheet

[timwelby]

Hi,

I’m aware my question is probably going beyond the scope of your plugin! But I wondered if you might have any suggestions.

We collect markers (sightings for a sightings board) from a phone app, which then sends the data to a Google sheet. We then have this sheet set up to import into the plugin, which it does successfully, and also when we schedule it. Ideally we will have it import data every 5 minutes.

However the problem we have is that we don’t know how to delete the data after the marker import. I don’t believe the plugin can delete data itself? So we need to be able to clear all but the header rows from the file after import. Is there an obvious way to do that? We could try to time another script deleted data shortly after the scheduled import time, but we risk someone uploading a marker in that short time, which then gets deleted before it could be imported.

Without being able to do this we import the same data over and over.

Please let me know if you have any ideas! If necessary we could find a different method than using a Google sheet.

Thanks.

[Author]

Posts