The Scenario
Your content team shares production assets through public Yandex Disk links. Someone started a tracking sheet six months ago — 60 rows, one Disk URL per row, columns for file name and download link that were filled in manually when the files were first shared.
The creative director just asked whether all those assets are still accessible and whether the download links are current. Some files may have been moved or deleted. Some links may have been updated with newer versions.
You have the URL column. You do not have a quick way to check 60 links without clicking through each one.
The bad version:
- Open row 2, click the Yandex Disk link, wait for the page to load, read the file name, copy the download URL, come back to the sheet, paste both into columns B and C
- Three links in, hit one that returns "File not found" — note it, move on
- Finish the check an hour and a half later, realize the creative director also wants file sizes and you did not capture those
An hour and a half of link-clicking is not what you were supposed to be doing today.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. Through the Yandex Disk integration, it can call the public resource metadata API for each link in your sheet and write file name, size, modification date, and download URL back into the sheet — all at once.
For each Yandex Disk public URL in column A of this sheet, fetch the resource metadata and write file name, size, modified date, and download URL into columns B through E. Start at row 2 and process all non-empty rows.
What You Get
- Column B: file name as Yandex Disk returns it
- Column C: file size (bytes or human-readable depending on the API response)
- Column D: last modified date
- Column E: current direct download URL
- Rows where the link is no longer valid get "Not found" in column B, making broken links immediately visible in the sheet
What If the Data Is Not Quite Ready
Some entries are folder links, not individual file links
Shared folders return a different metadata structure than individual files. You want the sheet to handle both without failing.
For each URL in column A, fetch Yandex Disk metadata. If the resource is a file, write name, size, and modified date into columns B through D and the download URL into column E. If the resource is a folder, write the folder name into column B, item count into column C, and leave columns D and E with "Folder — no direct download". Flag invalid or expired links with "Dead link" in column B.
Flag files that have not been modified in over 90 days
Some of these assets are evergreen. Others were supposed to be updated for the current campaign and apparently were not.
For each Yandex Disk URL in column A, fetch resource metadata and write file name, size, and modified date into columns B through D. In column E, write "Stale — check if current" for any file whose modified date is more than 90 days ago, and "Recent" for all others.
Cross-reference the file names against an approved asset list
The creative team maintains an Approved Assets sheet. Any file in the Disk tracking sheet that is not on the approved list may have been added informally and should be reviewed.
For each URL in column A, fetch the Yandex Disk resource name and write it into column B. Then check whether the file name in column B appears anywhere in column A of the Approved Assets sheet. Write "Approved" in column C if it matches, and "Not on approved list — review" if it does not.
Fetch metadata, validate download URL freshness, flag broken links, and sort broken entries to the top in one pass
Download URLs from Yandex Disk expire. A URL that was valid when it was pasted into the sheet may return a 403 now. You want to know before anyone tries to use them.
For each Yandex Disk URL in column A, fetch current resource metadata. Write file name into column B, size into column C, modified date into column D, and a fresh download URL into column E. Check whether the download URL in column E returns a valid status. Write "Valid" or "Expired" in column F. Then sort the sheet so that "Expired" rows appear first. Start at row 2.
You bring the expired-links-first version to the creative director, not the unsorted raw output.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your Yandex Disk asset tracker, then ask it to verify all 60 links, pull fresh metadata, and sort broken links to the top for immediate review. See also: enriching company lists and inventorying Object Storage buckets.