Google Sheets Integration

Pull image URLs from a Google Sheet, process them in batch, and get results written back to the same sheet.

Why use Google Sheets?

If you manage product catalogs in spreadsheets (and most e-commerce teams do), Google Sheets integration saves you from copy-pasting URLs. Paste your sheet link, pick the column that contains image URLs, and start the batch. When processing finishes, result URLs and status updates appear directly in your sheet.

Connecting your sheet

On any batch tool page, switch to the URL Import tab and select Google Sheets. Paste the full URL of your Google Sheet. It needs to be publicly accessible (anyone with the link can view) or shared with Sirv AI Studio via Google OAuth.

We read the first sheet in the workbook by default. If your URLs are on a different sheet, append the sheet name to the URL with #gid=SHEET_ID or rename the tab you want us to read to be the first one.

Required column format

Your sheet needs at minimum one column with image URLs. The first row should be a header. Here is a typical layout:

Column	Required	Description
image_url	Yes	Full URL to the source image (https://...)
sku	No	Product SKU or identifier. Passed through to results.
filename	No	Custom output filename. If omitted, the original filename is used.

After pasting the sheet URL, you pick which column contains image URLs from a dropdown. We auto-detect columns that look like URLs, but you can select any column manually.

Starting the batch

Once your URLs are loaded and validated (green checkmarks for reachable URLs, red X marks for broken ones), configure the tool settings and hit Start Batch. Processing works the same as any other batch job.

Results in your sheet

When processing finishes, two new columns are added to your sheet:

result_url with the processed image URL
statusshowing "success" or the error message

Each row matches back to the original image. You can share the updated sheet with your team or use it as a record of what was processed.

Error handling

Rows with invalid URLs (404s, unreachable hosts, non-image files) are flagged during the validation step before processing even starts. You can fix those URLs in the sheet and re-import, or skip them and process only the valid ones.

If an image fails during processing (timeout, unsupported format), the status column shows the specific error. You can retry just the failed rows without re-running the entire batch.

CSV and XLSX files

Prefer working offline? You can upload a .csv or .xlsx file instead of connecting a Google Sheet. Same column format applies. The only difference is that results are not written back to the file automatically. You can export results as a new CSV from the batch results page instead.