In our system we have google spreadsheets which content editors use. I have some processes which pull these down and save them as local csv files, so the data can be read in by the system.
It would be very useful to know, when the system comes to use that data, whether it needs to be re-downloaded, and I thought that if I could somehow retrieve the “updated_at” timestamp for the google spreadsheet I could use that as the basis of a decision on whether to re-download the data.
Is there a way to get this, does anyone know? I’m using Ubuntu.