Turn new client rows into merged PDF packets
Keep client paperwork together. Add a row with the PDFs to combine, and Notis can merge them into one document.
Trigger
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Action
Merge PDFs
Tool to merge multiple pdf documents into a single pdf. use when you need to concatenate several pdfs on the server-side.
Why this helps
Client documents arrive in separate files, leaving you to track down each PDF and combine them by hand.
- Combine the PDFs referenced in a new client row.
- Reduce manual document assembly and context switching.
- Receive a run report through your chosen channel.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Api2pdf once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a name.
- 3Describe in one instruction how to merge the PDFs listed in each new client row.
- 4Pick the New Rows in Google Sheet trigger and choose where run reports go.
- 5Test with one real row that contains the PDFs to merge.
Questions about this workflow
What should a new row contain?
Include information that lets the automation identify the PDF documents to merge. The workflow can only use documents available to Api2pdf.
Does this create a PDF from the other spreadsheet data?
No. The selected action merges existing PDFs. It does not create a PDF from spreadsheet cells.
Where do run updates go?
Choose a report channel when you create the automation.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Api2pdf. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Api2pdf actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Header Footer
Tool to add headers and footers to a pdf document. use when you need consistent page numbering, titles, or custom branding on every page.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Delete PDF
Tool to delete a previously generated pdf. use when you need to immediately remove a pdf by its response id.
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Extract PDF Pages
Tool to extract specific pages from a pdf document. use when you need only certain pages from a larger pdf file.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
LibreOffice PDF to HTML
Tool to convert a pdf document to html using libreoffice. use when you need html output of a pdf file (experimental; images may be excluded).
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
LibreOffice Thumbnail
Tool to generate a thumbnail image of a document using libreoffice. use when you need a quick visual preview of a pdf or office file's first page.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Merge PDFs
Tool to merge multiple pdf documents into a single pdf. use when you need to concatenate several pdfs on the server-side.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Optimize PDF
Tool to optimize a pdf document to reduce file size while maintaining quality. use when you need to minimize storage or bandwidth for an existing pdf.
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Reorder PDF Pages
Tool to reorder pages of a pdf document. use when you need to rearrange pages into a new order by specifying page indices.
Connect any two apps with Notis in the middle.
Google Sheets and Api2pdf, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Api2pdf.