How to Merge Multiple PDFs and Send Them as One Email Attachment

Step 1: Add the Google Sheets Trigger

Create a Zap and select Google Sheets as the trigger app.

Choose New Spreadsheet Row, connect your Google account, and select the spreadsheet and worksheet containing the PDF links.

Test the trigger and select a sample row.

Step 2: Merge the PDF Files

Add another step and select PDF.co.

Choose Merge PDF, click Sign in, and authorize Zapier to access your PDF.co account.

Configure the action:

• Source Files URLs: Map the PDF URL columns from Google Sheets as a comma-separated list. Their order determines the page order in the merged PDF.
• Automatically Convert Non-PDF Files: Select false when every source file is already a PDF.
• Output File Name: Map the spreadsheet value or enter a name such as merged-documents.pdf.
• Custom Profiles: Leave blank unless additional merge settings are required.

For example, the source value may look like:

https://example.com/file1.pdf,https://example.com/file2.pdf,https://example.com/file3.pdf

Include only populated file URLs.

See the PDF.co Merge PDF documentation for the current fields and supported file types.

Step 3: Test the Merge

Test the PDF.co action. A successful result includes a temporary URL for the merged PDF.

Open the URL and confirm that:

• Every source PDF is included.
• The files appear in the correct order.
• The merged document opens successfully.

Step 4: Send the Merged PDF

Add Gmail — Send Email and connect your Gmail account.

Configure the email:

• To: Map the recipient’s email address.
• Subject: Map the subject from Google Sheets.
• Body: Map the message or enter a fixed email body.
• Attachments: Map the merged PDF URL returned by PDF.co.

Test the Gmail action and confirm that the message arrives with one merged PDF attachment.

Step 5: Activate the Zap

Publish the Zap after completing the test. Each new spreadsheet row will now cause Zapier to merge its listed PDFs and send them as a single email attachment.