Merge approved PDF files from a Google Sheets request
Keep approved document packets together without opening and combining each file by hand.
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
Join PDFs
This tool allows users to merge multiple pdf files into a single pdf document by accepting an array of pdf urls, sending a post request to the bannerbear api, and returning the unique identifier, status, and url of the merged pdf.
Why this helps
PDF links collected in a sheet still need to be copied into a separate tool and merged manually.
- Combine a request's PDF files into one document when its row arrives.
- Review the merge status and resulting URL in the Notis run report.
- Reduce repetitive file handling for recurring document packets.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Bannerbear once in the Notis portal.
- 2Create an automation in the portal or tell Notis in plain language.
- 3Describe that each new row with the complete PDF URLs should be merged into one PDF.
- 4Pick New Rows in Google Sheet as the trigger and choose a report channel.
- 5Test with one real row containing valid PDF URLs.
Questions about this workflow
What does the sheet row need to contain?
It needs to include the URLs of the PDFs to merge. Tell Notis where to find those URLs in your prompt.
Does this workflow create a Bannerbear image or video?
No. It uses Bannerbear's Join PDFs action to merge the supplied PDF URLs.
Where can I see whether the merge completed?
Choose a report channel during setup. The Notis run report includes the action result and returned status or URL.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Bannerbear. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Bannerbear actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Get Account Info
This tool allows you to check your bannerbear account status, including quota levels and current usage. the endpoint returns information about your account status, paid plan, api usage, and quota.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Available Fonts
This tool retrieves a list of all available fonts in bannerbear. the fonts are categorized into serif, sans serif, novelty, international, and custom, and can be used to verify font availability prior to creating or modifying images.
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.
Get Signed Bases
This tool retrieves a list of signed bases for a specific template. signed bases are used to generate on-demand images using encrypted url parameters. the endpoint returns a list of base urls that can be used with the signed url feature.
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.
Get Template Set Details
This tool retrieves detailed information about a specific template set using its unique identifier (uid). template sets are sets of templates that you group together in the bannerbear dashboard. it provides comprehensive details about the template set including its name, available modifications, and the list of templates inside the set.
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.
Join PDFs
This tool allows users to merge multiple pdf files into a single pdf document by accepting an array of pdf urls, sending a post request to the bannerbear api, and returning the unique identifier, status, and url of the merged pdf.
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.
List Images
Lists all images inside a bannerbear project. this endpoint allows you to retrieve a paginated list of all images that have been created in your project.
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.
List Templates
This action retrieves a list of all templates available in your bannerbear project. it returns an array of template objects including properties like uid, name, dimensions, creation and update timestamps, template type, preview url, and modifications. the tool is used for listing templates, retrieving template uids for subsequent actions such as image or video creation, and managing project templates.
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.
List Videos
This action retrieves a list of all videos created in your bannerbear account. it returns an array of video objects including properties like uid, status, timestamps, video and preview urls, as well as template and modification details. the tool is used for listing videos, monitoring video status, and managing project videos.
Connect any two apps with Notis in the middle.
Google Sheets and Bannerbear, 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 Bannerbear.