The Scenario
The finance director just sent a message at 4:45 PM. The auditors want a complete year-end package for one of your largest clients — all twelve monthly statements, in order, merged into a single PDF — by 9 AM tomorrow. You have a Google Sheet with all twelve PDF URLs already in column A, in the right order. What you don't have is a way to merge them without doing it by hand.
The bad version:
- Download all twelve PDFs from their respective URLs, saving them to a local folder and renaming them 01 through 12 so you don't lose track of the order
- Use a desktop PDF tool to merge them — realize it reordered two files because you named 9 before 10, so you rename, re-run, check the page count, and verify the cover page of each statement landed in the right sequence
- Upload the merged file somewhere, generate a shareable link, and paste it into the sheet — then wonder if the auditors will want a revised version and whether you'll have to do this again
The year-end package has to be right. Auditors notice page-order errors. You don't have time to reconcile twelve PDFs manually at this hour — and you shouldn't have to.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads what's in your sheet and through its built-in CustomJS integration it can merge your list of PDF URLs in row order and write the resulting download link back to your sheet — no file downloads, no manual reordering.
Open the SheetXAI sidebar and paste this prompt:
Merge all PDF URLs listed in column A of my Google Sheet — in row order — into a single PDF using CustomJS and write the combined file's download URL into cell B1
What You Get
- Cell B1 receives the CustomJS download URL for the merged document
- The merge respects row order exactly — the statement from A2 becomes page 1, A3 page 2, and so on through A13
- If any URL in the list is unreachable, SheetXAI surfaces which row caused the failure rather than silently producing an incomplete document
- The original URLs in column A are untouched
What If the Data Is Not Quite Ready
Some URLs in column A are expired or return 403 errors
Check each URL in column A to confirm it's reachable before merging — list any that return errors in column C with the status code, then merge only the valid URLs in row order and write the result to B1
The PDF list spans two separate tabs and needs to be combined in a specific order
Take the PDF URLs from column A of the "H1 Statements" tab and column A of the "H2 Statements" tab — H1 first, H2 second — merge all of them into one PDF using CustomJS, and write the download URL to cell B1 on the "Summary" tab
Each PDF in the list needs a cover page inserted before it stating the month name from column B
For each row in my sheet, use CustomJS to prepend a text cover page with the month name from column B to the PDF at the URL in column A, then merge all the resulting PDFs in row order into one document and write the final download URL to cell C1
Validate URLs, convert any HTML fallbacks, merge everything, and flag the final page count
In column A, some rows have PDF URLs and some have HTML strings as fallback — convert any HTML strings to PDF using CustomJS first, then merge all resulting PDFs in row order into a single document, write the download URL to B1, and write the total page count to C1; flag any rows that failed conversion in column D
One prompt handles the cleanup and the merge together — you don't need to run two separate operations to get to a clean result.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet where column A holds a list of PDF URLs, then ask it to merge them in order and drop the result link into a single cell. Also see: bulk converting HTML strings to PDFs and the CustomJS overview.