Hey, in google sheets, I’m attempting to set up an automated spreadsheet to use a few segment URLs as an input, and provide an output of the segment’s name and also the most recent date ANYONE has completed it.

I’ve successfully grabbed the segment’s name, but not sure how to go about getting the most recent completed date. I don’t care at all about the person’s name or time or any personal information - literally just what was the date it was most recently completed.

Can anyone offer a good way of doing this via Strava’s API?

I have already created an API app as a DataImporter and am using google’s AppsScript editor to aid in this.

Thanks for your help and time.