The Scenario
You're a content manager. Someone handed you a Google Sheet with 120 image URLs — assets pulled from a legacy DAM that's being retired at the end of the month. Your job is to get all of them into NocoDB's attachment storage so they appear as linked assets in the 'Media Library' table before the old system goes offline.
The bad version:
- Open NocoDB, navigate to the 'Media Library' table, click the attachment field on the first row, use the URL import option to paste the first URL, wait for the upload to complete.
- Go back to the sheet, copy the next URL, return to NocoDB, repeat.
- Do that 120 times — while the import UI occasionally times out and resets your scroll position.
The old system's deadline is not flexible. And nothing about this task requires a content manager. It requires a script or a tool. You have neither.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet and through its built-in NocoDB integration it can upload each URL to NocoDB storage and write the resulting attachment paths back to your spreadsheet — all in one instruction.
Upload each URL from column A of this sheet to NocoDB storage and write the resulting attachment URL back into column B
What You Get
- Each URL in column A is submitted to NocoDB's attachment storage endpoint.
- The resulting stored file path or CDN URL is written back into column B on the same row.
- Any URL that fails to upload (404, unsupported format, size limit) is flagged in column B with an error note rather than left blank.
- The sheet becomes a record of what uploaded successfully and what needs follow-up.
What If the Data Is Not Quite Ready
Some URLs in the column are dead links from the legacy system
Upload each URL from column A to NocoDB storage — for URLs that return an error, write 'UPLOAD FAILED: [error]' into column B instead of an attachment path
The sheet has a mix of image URLs and document URLs that belong in different NocoDB tables
Upload URLs from column A to NocoDB storage — if the URL ends in .pdf or .docx, write the result into column C; for all other file types, write the result into column B
You need to upload and also tag each asset with metadata from column C
Upload each URL from column A to NocoDB storage, write the stored path into column B, then update the 'Media Library' table row with the attachment and the tag value from column C in the 'Tags' field
Full kill-chain: validate URLs, upload, write back, flag failures, and summarize
Check each URL in column A — skip any that are blank or malformed and write 'SKIPPED' in column B — upload the valid ones to NocoDB storage, write the returned path into column B — at the bottom of column B, write a count of successful uploads and a count of failures
One prompt covers the validation, the upload, the writeback, and the summary. No second pass needed.
Try It
Get the 7-day free trial of SheetXAI and open the sheet with your media URL list, then ask it to push every URL into NocoDB storage and report back what landed. Also useful: Audit All NocoDB Integrations and Write Results Into a Google Sheet and the NocoDB integration overview.