The Scenario
The office manager at a real estate firm got a task last Monday: 60 property listings in the Excel workbook, each one needs a cover photo attached to its Knack record. The image URLs are in column D. The Knack record IDs are in column A.
She's been putting it off because she doesn't know how to do this without doing it sixty times by hand.
The bad version:
- Click on record 1001 in Knack, click the cover_photo field, click 'Upload', navigate to the file — except the files are URLs, not local files, so she'd have to download each image first, save it, then upload it to Knack.
- Download image from column D row 2, rename it something recognizable, upload to Knack record 1002, attach to cover_photo field. Repeat 58 more times.
- Finish row 43 and realize the image URL in column D was a redirect and the uploaded file is a 404 error page.
She manages listings, lease agreements, and client calls. Nobody hired her to spend a Tuesday afternoon downloading and uploading 60 images one by one, and nobody's going to be happy if the Knack app is missing photos when the sales team starts using it Thursday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the image URLs, uploads each one to Knack, and attaches the uploaded asset to the right record — in bulk, without requiring local file downloads or one-at-a-time clicking.
Open the SheetXAI sidebar and type:
For each row in the 'Properties' worksheet, upload the image at the URL in column D to Knack, then update the record in column A's Knack ID to attach the uploaded image to the 'cover_photo' field
What You Get
- Each image URL fetched and uploaded to Knack's file storage.
- The uploaded file attached to the cover_photo field on the corresponding Knack record.
- A status column written to column E — 'Attached', 'Upload Failed', or the specific error for any URL that returned a bad response.
What If the Data Is Not Quite Ready
Some image URLs in column D are blank or broken
For each row in the 'Properties' worksheet where column D contains a URL (not blank), upload the image to Knack and attach it to the cover_photo field on the record in column A — write 'NO URL' in column E for blank rows and 'UPLOAD FAILED' for any URL that doesn't return a valid image
The workbook has both cover photos and PDF brochures to upload
For each row in the 'Properties' worksheet, upload the image in column D to Knack and attach it to cover_photo on the record in column A. Also upload the PDF URL in column E to Knack and attach it to the brochure field on the same record.
Record IDs are missing for 10 rows and need to be looked up first
For each row in the 'Properties' worksheet where column A is blank, search the Knack 'Properties' object for a record where the listing_name field matches column B, write the found record ID into column A. Then for all rows, upload the image from column D and attach to cover_photo.
Validate image URLs, deduplicate by record ID, and attach in one shot
In the 'Properties' worksheet, flag any row where column D doesn't start with 'http' by writing 'INVALID URL' in column E. Remove any duplicate rows where column A (Knack ID) appears more than once, keeping the first. Then for all remaining unflagged rows, upload the image from column D to Knack and attach it to the cover_photo field on the record in column A.
That single prompt surfaces bad URLs, removes duplicates, and handles all the attachments that are actually ready.
Try It
Get the 7-day free trial of SheetXAI and open the workbook with your property listing data and image URLs, then ask it to upload and attach everything in one pass. Also see Bulk Import Records or the Knack overview.