Skip to main content

32 posts tagged with "no-code"

View all tags

SharePoint List to Filled and Signed PDF in Power Automate !!

· 21 min read
SEO and Content Writer

Fill a PDF Form is a Power Automate action that takes a fillable PDF template plus a JSON payload and returns the same PDF with every field pre-populated. Add PDF - Sign and a SharePoint When an item is created trigger and the whole invoice-generation flow becomes hands-free: a colleague adds a row, Power Automate builds the signed PDF, and Dropbox stores it under a timestamped filename.

The painful part of invoice-style workflows is not the PDF, it is the manual step in the middle. Someone opens the template, retypes eight fields from a spreadsheet row, prints, signs, scans back, uploads. Every field is a chance to typo the customer name or drop a zero from the amount. This walkthrough replaces that ritual with seven Power Automate actions: SharePoint fires the trigger, Dropbox supplies the template plus the signature image, PDF4me fills the form and stamps the signature, Dropbox stores the finished file. Real screenshots, exact Compose expression, the SharePoint schema, and the sample signed invoice all downloadable.

The flow at a glance
1. When an item is created
SharePoint trigger on New Customer Invoices list. Fires the flow every time a row is added.
2. Get file content
Dropbox reads sample_fill_form.pdf from /blog data/fill a pdf/. Infer Content Type Yes to keep the binary intact.
3. Get file content 1
Dropbox reads signature.png from the same folder. Same Infer Content Type Yes toggle.
4. Compose
Builds one JSON payload from the SharePoint row: customerName, email, phone, invoiceNumber, invoiceDate, address, amount.
5. Fill a PDF Form
PDF4me action. Template File Data the PDF binary, JSON Data the Compose output, Keep PDF template Editable No.
6. PDF - Sign
PDF4me action. Stamps signature.png right-bottom on page 1, 50 wide by 20 high, margin 15, opacity 100.
7. Create file
Dropbox /blog data/fill a pdf/output. File Name concat(Signed_, invoiceNumber, _, ticks(utcNow()), .pdf).

Split Excel Sheets Into Separate Files in Make: No VBA, Just Dropbox and PDF4me

· 19 min read
SEO and Content Writer

PDF4me Excel - Separate Worksheets is a Make action that splits one .xlsx file into a separate workbook per sheet, without VBA or macros. This four-module scenario reads an Excel file from Dropbox, splits it into per-sheet workbooks, iterates over the returned array, and uploads each new .xlsx back to Dropbox with its own filename.

If you've ever inherited a workbook with twenty tabs and needed each tab as its own file, you've probably reached for VBA, a paid desktop splitter, or a very manual "Move or Copy... to new book" ritual. Every option assumes you're going to sit at a laptop and do it once. This walkthrough replaces all of that with a Make scenario that runs on a schedule, works over Dropbox, and hands you clean per-sheet .xlsx files with zero clicks after the first setup.

The flow at a glance
1. Dropbox - Download a File
Reads the source .xlsx from a fixed Dropbox path.
2. PDF4me Excel - Separate Worksheets
Splits the workbook into one .xlsx per sheet and returns an array.
3. Flow Control - Iterator
Loops over the Splitted Worksheet array so every item runs downstream.
4. Dropbox - Upload a File
Writes each per-sheet .xlsx into your output folder with its worksheet name.

Build a Custom AI Analyzer for Your Own Invoice Format in Power Automate: A 3-Step Dropbox Workflow

· 24 min read
SEO and Content Writer

A Custom AI Analyzer Template is a named JSON schema you define in the PDF4me dev portal that tells the AI which fields to extract from a specific document type. This walkthrough builds an Analyzer for PDF4me's own SaaS subscription invoices (33 fields: vendor address block, Swiss MWST rate, subscription Id, line items, discount details), then calls it from a 3-step Power Automate flow that reads a PDF from Dropbox and returns structured JSON.

The built-in default_invoice_extraction covers generic invoices, but real AP teams have vendor-specific layouts, custom line-item columns, jurisdiction-specific tax fields, and subscription metadata that the generic schema misses. Building a custom Analyzer once gets you exact-match extraction forever, no per-field prompting required, no follow-up logic to clean up the response.

The full workflow at a glance
Setup A. Log in to dev portal
dev.pdf4me.com login. Email plus password or any SSO provider (Microsoft, Google, Facebook, Apple, GitHub).
Setup B. Open AI Document Parser
Dashboard sidebar, AI Document Parser. Lists every Analyzer Template you have already created.
Setup C. Add a Parse Analyzer
Click Add, name it (e.g. Test Invoice), choose Type Parse. The Analyzer Id is what Power Automate references.
Setup D. Paste the JSON schema
Document Schema field. Each schema entry has fieldName, fieldType, fieldDescription. Save Changes.
Flow 1. Manually trigger a flow
Replace later with HTTP / SharePoint / Outlook trigger when ready for production.
Flow 2. Get file content (path)
Dropbox path /pdf4me.pdf, Infer Content Type Yes. Reads the source PDF into the flow.
Flow 3. AI - Document Parser
PDF4me action. File Content from step 2, File Name Test.pdf, Customisation Note Test Invoice (your Analyzer Id). Returns body JSON.

Turn Every Inbound Email Into an Audit-Ready PDF Archive in Power Automate: A 7-Step Outlook Workflow

· 26 min read
SEO and Content Writer

Email-to-PDF archive is a Power Automate flow that fires on every new inbound Outlook email, converts the message body and every attachment to PDF, merges them into one timestamped consolidated PDF, and writes the result to Dropbox for long-term compliance retention. Seven actions. No code. One file per email, body first then attachments in order. The output is named merge-YYYYMMDD-HHmmss.pdf so every archive entry is uniquely sortable.

Audit teams, records-management leads, and compliance officers need email evidence preserved in a tamper-evident, searchable format that survives Exchange retention policies. Native Outlook export is manual, file-by-file, and loses attachments to separate files. This walkthrough builds the no-code alternative: every email that lands becomes a single consolidated PDF, automatically, with the original .eml and attachments still in Outlook for legal hold but the archive PDF as the authoritative records copy.

The flow at a glance
1. When a new email arrives (V3)
Outlook trigger filtered by To address. Include Attachments Yes, Only with Attachments Yes.
2. Initialize variable
Name email, Type Array. Holds every PDF binary in order.
3. Convert to PDF Body
PDF4me action. Reads triggerOutputs body/body (the HTML body), returns the body as a PDF page 1.
4. Append to array (email body)
Pushes base64ToBinary on the converted body PDF onto the email array. Becomes page 1 of the final archive.
5. Apply to each attachment
Loops triggerOutputs body/attachments. Inside, Convert to PDF then Append to array with base64ToBinary on $content.
6. Merge multiple PDFs
PDF4me action. Body/docContent is the email array. Output File Name Email Attachment Merge Output.pdf.
7. Create file
Dropbox /blog data/merge blog template/output. File Name concat(merge-, formatDateTime(utcNow(), yyyyMMdd-HHmmss), .pdf).

Rename Every Vendor Invoice by Supplier Name in Zapier: A 5-Step Dropbox + PDF4me AI Workflow

· 21 min read
SEO and Content Writer

The painful part of accounts payable is not paying invoices, it is finding the right vendor's invoice three weeks later when finance asks. Every supplier names files differently. Half are invoice.pdf. The other half are INV-2089-FINAL-v3.pdf from a vendor who switched naming conventions four times. The fix: let AI read the supplier name off every invoice the moment it lands, then rename the file before it goes into long-term storage. This walkthrough builds that exact pattern in Zapier with PDF4me AI - Document Parser and a 2-line Code by Zapier step. Five Zap steps. Real screenshots. The supplier name becomes the filename. Audit-ready folder. Search just works.

The Zap at a glance
1. Dropbox: New File in Folder
Trigger. Polls /MuneerTrigger every 2 min for any new vendor invoice that lands in the intake folder.
2. Dropbox: Find File
Looks up the matching file in /pdf4metest/sample so the AI parser gets a real binary, not just a Dropbox metadata pointer.
3. PDF4me: AI - Document Parser
Runs the default_invoice_extraction Analyzer. Returns Vendor Name, Invoice Number, Total, Dates, Line Items as JSON.
4. Code by Zapier: Run JavaScript
Two lines. JSON.parse the Doc Text into a real object so step 5 can use Vendor Name as a Zapier token.
5. Dropbox: Upload File
Writes the original file back to /pdf4meoutput with Vendor Name as the filename and the original extension preserved.

Auto-Merge Every PDF Dropped into a Dropbox Folder in Power Automate: A 6-Step Dynamic Workflow

· 23 min read
SEO and Content Writer

The painful part of "merge these PDFs" tickets is not the merging, it is knowing what is in the folder at run time. Names change, files come and go, somebody adds a fifth document at 4:55 pm. This walkthrough builds the exact pattern in Power Automate with PDF4me Merge multiple PDF files, Dropbox, and a single Apply to each loop. Six flow actions. Zero hardcoded filenames. Every PDF currently in the watched folder gets stitched together the moment a new file lands, and the output name carries the file count so each run is uniquely identifiable.

The flow at a glance
1. When a file is created
Dropbox trigger on /blog data/merge files dropbox. Fires the moment any file lands.
2. List files in folder
Dropbox action on the same folder. Returns every current file as an array of metadata objects.
3. Initialize variable
Name Files, Type Array. Buffer for the binary content of every file.
4. Apply to each
Loop body(List_files_in_folder). Inside, Get file content by Id, then Append to array with base64ToBinary on $content.
5. Merge multiple PDFs
PDF4me action. Body/docContent the Files array, Output File Name Output.pdf. One consolidated PDF out.
6. Create file
Dropbox /blog data/merge blog template/output. File Name expression concat(merge-, length(List_files_in_folder), .pdf).

Convert the Email Body and Every Attachment into One Consolidated PDF in Power Automate: A 7-Step Outlook + PDF4me Workflow

· 25 min read
SEO and Content Writer

The painful part of email-driven workflows is not the email, it is everything that comes with it. The body holds the context (who sent it, why, what to do), the attachments hold the artefacts (the invoice, the form, the signed contract), and storing them separately means future-you needs three clicks to reconstruct the message later. This walkthrough builds the exact pattern in Power Automate with PDF4me Convert to PDF, PDF4me Merge multiple PDF files, Outlook, Dropbox, and a single Apply to each loop. Seven flow actions. One incoming email lands. One consolidated PDF goes out, body first then attachment by attachment, timestamped and dropped into your archive folder automatically.

The flow at a glance
1. When a new email arrives (V3)
Outlook trigger on To [email protected]. Include Attachments Yes, Only with Attachments Yes.
2. Initialize variable
Name email, Type Array. Buffer for every PDF binary the flow produces.
3. Convert to PDF Body
PDF4me action. Content triggerOutputs body/body (the HTML body), File Name email-body.html. Returns the body as PDF.
4. Append to array (email body)
Push base64ToBinary on the converted body PDF onto the email array. This is page 1 of the final document.
5. Apply to each attachment
Loop triggerOutputs body/attachments. Convert each to PDF, then Append to array with base64ToBinary.
6. Merge multiple PDFs
PDF4me action. Body/docContent the email array, Output File Name Email Attachment Merge Output.pdf.
7. Create file
Dropbox /blog data/merge blog template/output. File Name concat(merge-, formatDateTime(utcNow(), yyyyMMdd-HHmmss), .pdf).

Generate Personalised Invitations and Merge Them Into One PDF in Power Automate: A 7-Step Dropbox Workflow

· 24 min read
SEO and Content Writer

The painful part of bulk mailouts is not writing the letter, it is stitching the personalised copies together so finance, HR, or operations get one clean PDF instead of fifty attachments. This walkthrough builds the exact pattern in Power Automate with PDF4me Generate Documents (Multiple), Merge multiple PDF files, Dropbox, and a single Apply to each loop. Seven flow actions. One DOCX template. A JSON array of recipients. Out the other end falls one consolidated PDF, one page per recipient, named and uploaded back to Dropbox automatically.

The flow at a glance
1. Manual trigger
Manually trigger a flow. Swap in any business trigger later (HTTP, SharePoint, schedule).
2. Get file content (path)
Dropbox path /blog data/merge blog template/template.docx, Infer Content Type Yes.
3. Generate Documents (Multiple)
PDF4me action. Template DOCX plus JSON array of recipients. Output Type PDF. Returns body/outputDocuments.
4. Initialize variable
Name mergefiles, Type Array. Buffer for the per-recipient PDF binaries.
5. Apply to each
Loop body/outputDocuments. Inside, Append to array variable with base64ToBinary on streamFile.
6. Merge multiple PDFs
PDF4me action. Body/docContent mergefiles, Output File Name Test.pdf. One combined PDF out.
7. Create file
Dropbox /blog data/merge blog template/output, File Name Merged_files.pdf.

AI-Rename Vendor Invoices in Zapier: A 5-Step Dropbox + PDF4me Workflow

· 19 min read
SEO and Content Writer

The painful part of accounts payable is not paying invoices, it is finding the right invoice in storage when somebody asks for it three weeks later. Every vendor names files differently, every scan is untitled (3).pdf, every Dropbox folder turns into a pit. The fix is to let the AI read the invoice the moment it lands, pull out the customer name, and rename the file before it ever hits long-term storage. This walkthrough builds the exact pattern in Zapier with PDF4me AI - Document Parser, Dropbox, and a 2-line Code by Zapier step. Five Zap steps. Real screenshots from a working Zap. The vendor name becomes the filename. Search just works again.

The Zap at a glance
1. Dropbox: New File in Folder
Trigger. Polls /MuneerTrigger every 2 min for new files. Use any inbox folder where vendor invoices land.
2. Dropbox: Find File
Looks up the matching file in /pdf4metest/sample by File Name so we get the binary content into the Zap.
3. PDF4me: AI - Document Parser
Runs the default_invoice_extraction Analyzer against the file. Returns JSON keyed by the Analyzer schema (Customer Name, dates, totals, line items).
4. Code by Zapier: Run JavaScript
Two lines. JSON.parse the Doc Text into a real object so the next step can read its properties as tokens.
5. Dropbox: Upload File
Writes the original file back to /pdf4meoutput with Customer Name as the filename and the original extension.

Create a ZUGFeRD Invoice in Power Automate from a Dropbox PDF + XML: A 5-Action Workflow

· 20 min read
SEO and Content Writer

Germany's Wachstumschancengesetz (Growth Opportunities Act) turned ZUGFeRD-style hybrid e-invoices from a "nice to have" into a B2B requirement. From 1 January 2025 every German business must be able to receive structured e-invoices, with full sending obligations phased in by 2028. The fastest path for any Microsoft 365 team is a five-action Power Automate flow: Manually trigger → Dropbox Get file content (PDF) → Dropbox Get file content (XML) → PDF4me Create ZUGFeRD Invoice → Dropbox Create file. The XML payload is embedded inside a PDF/A-3 archival shell, producing one file that humans open and accounting systems parse. This walkthrough uses the exact screenshots captured in the canvas: /pdf4metest/sample/10 page.pdf for the visual carrier and /pdf4metest/zugfred invoice/version2.xml for the structured data, with the hybrid output landing in /pdf4meoutput under a unique GUID-prefixed name. Production-ready in under 10 minutes.

The flow at a glance
1. Manually trigger a flow
Manual trigger for testing. Swap for SharePoint When a file is created, Dropbox When a file is created, or any storage trigger in production.
2. Dropbox Get file content (PDF)
Reads the visual carrier from /pdf4metest/sample/10 page.pdf with Infer Content Type Yes. This is the PDF the recipient sees.
3. Dropbox Get file content (XML)
Reads the structured ZUGFeRD XML from /pdf4metest/zugfred invoice/version2.xml with Infer Content Type Yes. This is what accounting systems parse.
4. PDF4me Create ZUGFeRD Invoice
Combines both inputs as 2.0-XML format, XmlWithPdf output mode, BASIC conformance, Render Invoice on PDF Yes, Language de. Embeds the XML inside a PDF/A-3.
5. Dropbox Create file
Writes the hybrid file to /pdf4meoutput with guid()+headers/FileName so reruns never collide.

AI-Extract and Smart-Rename Any PDF in Make: A 4-Module Dropbox Workflow with PDF4me AI - Document Parser

· 21 min read
SEO and Content Writer

The hardest part of vendor-invoice automation has always been the file naming. A folder full of 2030703747 (1).pdf and Scan_2026-04-12_invoice.pdf is unsearchable, unsortable, and impossible to audit. PDF4me AI - Document Parser plus a Make Parse JSON module fix that in 4 modules, zero code: the AI extracts the vendor name from the PDF, and the same scenario re-uploads the file as Acme Industries.pdf. The screenshots below walk through the exact run captured in the canvas.

The scenario at a glance
1. Dropbox Download
Pulls /pdf4metest/sample/2030703747 (1).pdf. Scheduled trigger shown.
2. PDF4me AI - Document Parser
Runs the default_invoice_extraction Analyzer Template. Output: Doc Text JSON.
3. JSON Parse JSON
JSON string mapped to 3. Doc Text. Exposes vendorName, invoiceNumber, totalAmount, etc.
4. Dropbox Upload
Writes to /pdf4meoutput/ with File Name = 6. vendorName + .pdf. Smart-rename complete.

Add a Swiss QR Bill to Any Invoice PDF in Power Automate: A 4-Action Dropbox Workflow

· 20 min read
SEO and Content Writer

Every Swiss invoice must carry a Swiss QR Bill so banks and accounting software can scan and process the payment automatically. With Power Automate and PDF4me the addition is a four-action flow: Manually trigger, Dropbox Get file content, PDF4me Barcode - Create SwissQR Bill, Dropbox Create file. The screenshots below walk through the exact run captured in the canvas. A 10-page invoice in /pdf4metest/sample becomes a Swiss-compliant invoice with the payment slip appended and uploaded to /pdf4meoutput with a unique file name. Production-ready in under 10 minutes.

The flow at a glance
1. Manually trigger a flow
Manual trigger for testing. Swap for SharePoint When a file is created or any storage trigger in production.
2. Dropbox Get file content
Reads the 10-page invoice from /pdf4metest/sample/10 page.pdf with Infer Content Type Yes.
3. PDF4me Barcode - Create SwissQR Bill
Appends the QR payment slip with CHF, QRR reference, English labels, custom Paging Options to land on page 3.
4. Dropbox Create file
Writes the populated PDF to /pdf4meoutput with a unique guid()+headers/FileName so re-runs do not collide.

Add a Swiss QR Bill to Any Invoice PDF in Zapier: A 4-Step Dropbox Workflow

· 21 min read
SEO and Content Writer

Every Swiss invoice must carry a Swiss QR Bill so banks and accounting software can scan and process the payment automatically. With Zapier and PDF4me the addition is a four-step Zap: Dropbox New File in Folder, Dropbox Find File, PDF4me Create Swiss QR Bill, Dropbox Upload File. The screenshots below walk through the exact run captured in the canvas: a 10-page invoice in /pdf4metest/Swiss-RP becomes a Swiss-compliant invoice with the payment slip appended and saved to /pdf4meoutput. Production-ready in under 10 minutes.

The Zap at a glance
1. Dropbox New File in Folder
Watches /pdf4metest/Swiss-RP every 2 minutes. Trigger fires when a new invoice PDF lands.
2. Dropbox Find File
Resolves the file by name (10 page.pdf) and pulls the binary, ready for the next step.
3. PDF4me Create Swiss QR Bill
Appends the QR payment slip with all required SPS fields: CHF, QRR reference, English, Line with Scissor separator.
4. Dropbox Upload File
Writes the populated PDF to /pdf4meoutput. File Name and File Extension carried from the PDF4me output.

Insert a Swiss QR Bill on a Custom Page Number in Power Automate (4-Action Dropbox Flow with PDF4me)

· 21 min read
SEO and Content Writer

Most Swiss QR-bill tutorials put the payment slip on page 1 (or append it to the end). Real invoices often need it somewhere in the middle: a 10-page contract pack where the QR-bill belongs right after the summary, or a quarterly statement where the slip should follow the cover page. The PDF4me Power Automate connector handles that in one action via Paging Options = custom plus a Page Number field. This guide walks through the exact run captured in the canvas: /pdf4metest/sample/10 page.pdf becomes a Swiss-compliant file with the QR-bill inserted as page 3, then uploaded to /pdf4meoutput with a guid-prefixed name so re-runs do not collide. 4 actions, zero code, runs in seconds.

The flow at a glance
1. Manually trigger a flow
Manual trigger for testing. Swap for any storage trigger in production.
2. Dropbox Get file content
Reads /pdf4metest/sample/10 page.pdf with Infer Content Type Yes.
3. PDF4me Barcode - Create SwissQR Bill
Output Format Type PNG (try PDF for hybrid). Paging Options custom, Page Number 3. All payment fields filled.
4. Dropbox Create file
Writes to /pdf4meoutput. File Name built from guid() plus headers/FileName so every run lands as a unique file.

Add a Swiss QR Bill to Any Invoice PDF in Make: A 3-Module Dropbox Workflow

· 20 min read
SEO and Content Writer

Every Swiss invoice must carry a Swiss QR Bill so banks and accounting software can scan and process the payment automatically. With Make and PDF4me, the addition is a three-module scenario: Dropbox Download a File, PDF4me Create Swiss QR-bill, Dropbox Upload a File. The screenshots below walk through the exact run shown in the canvas: a 10-page invoice at /pdf4metest/Files/10 page.pdf becomes a Swiss-compliant invoice with the payment slip appended and saved to /pdf4meoutput/. Production-ready in under 10 minutes.

The scenario at a glance
1. Dropbox Download a File
Reads /pdf4metest/Files/10 page.pdf. Scheduled trigger (clock badge) is shown but any trigger works.
2. PDF4me Create Swiss QR-bill
Appends the QR payment slip to the source PDF. Currency, IBAN, creditor + debtor blocks, reference filled out.
3. Dropbox Upload a File
Writes the populated PDF to /pdf4meoutput/. File Name and Data mapped from the prior step.

Create a ZUGFeRD 2.0+ E-Invoice in Make: A 4-Module Dropbox Workflow

· 21 min read
SEO and Content Writer

ZUGFeRD 2.0+ (also known as Factur-X in France and XRechnung in the German public sector) is a hybrid PDF/A-3 invoice with the machine-readable XML embedded inside the PDF. One file that both humans and ERP systems can consume. This guide walks through the exact run shown in the screenshots: a base invoice PDF and a ZUGFeRD 2.0+ XML in Dropbox become an EN16931-compliant hybrid e-invoice in /pdf4meoutput/, in 4 Make modules, zero code.

The scenario at a glance
1. Dropbox Download (PDF)
Pulls the base invoice PDF (/pdf4metest/Zugfred Invoice/SimplePdf.pdf). Scheduled trigger shown.
2. Dropbox Download (XML)
Pulls the ZUGFeRD 2.0+ XML invoice data (/pdf4metest/Zugfred Invoice/version2.xml).
3. PDF4me Create a ZUGFeRD invoice
Input Format XML, Output Mode XML With PDF, ZUGFeRD Version 2+, Conformance EN16931, Render Yes, Language de.
4. Dropbox Upload
Writes the hybrid PDF/A-3 e-invoice to /pdf4meoutput/ using File set to Map.

Populate an Excel Template from JSON in Power Automate: A 4-Step Dropbox Workflow with Aspose Smart Markers

· 17 min read
SEO and Content Writer

Drop an Excel template that uses Aspose Smart Markers (cells written like &=RootData.Items.ItemName) into Dropbox, paste a matching JSON payload into a Power Automate flow, and the populated workbook lands back in Dropbox with totals already calculated. This guide walks through the exact four-action flow shown in the screenshots: Manual trigger, Dropbox Get file content using path, PDF4me Excel - Populate, and Dropbox Create file. Every field value comes from a real run; the input template, JSON payload, and output workbook are all linked at the end.

The flow at a glance
1. Manual trigger
Manually trigger a flow. Replace with any trigger later.
2. Get file content (path)
Dropbox path: /pdf4metest/excel/populate excel/aspose template.xlsx
3. Excel - Populate
PDF4me action. JSON Data with RootData.Items array. Worksheet Indexes: 1 (Invoice sheet).
4. Create file
Dropbox /pdf4metest/excel/populate excel/output, name Excel_populate.xlsx.

Split a Multi-Sheet Excel Workbook into Separate Files in Power Automate (4 Actions, Any Sheet Count)

· 20 min read
SEO and Content Writer

A workbook with 5, 50, or 500 sheets can be split into individual .xlsx files in a single Power Automate flow. PDF4me Excel - Separate Worksheets returns an array with one file per sheet; an Apply to each loop fans the writes out to Dropbox, SharePoint, OneDrive, or Dataverse. This guide walks through the exact run shown in the screenshots: a 5-tab Separate.xlsx in Dropbox becomes Sheet1.xlsx through Sheet5.xlsx in an output folder. Total flow: 4 actions, zero code, runs in ~9 seconds end-to-end.

The flow at a glance
1. Manual trigger
Manually trigger a flow. Swap for any trigger that produces a workbook.
2. Get file content (path)
Dropbox path: /pdf4metest/excel/separate worksheets/Separate.xlsx
3. Excel - Separate Worksheets
PDF4me action. Splits the 5-sheet workbook into 5 single-sheet XLSXes.
4. Apply to each → Create file
Loop outputDocuments. Each iteration writes one sheet as its own .xlsx to Dropbox.

Create Swiss QR Bill in n8n: Two Complete Workflows (With and Without an Existing PDF)

· 25 min read
SEO and Content Writer

Every Swiss invoice must carry a Swiss QR Bill (also called Swiss QR payment slip) so that banks and accounting software can scan and process the payment automatically. n8n and PDF4me make that generation fully automatic. This guide walks through two production-ready workflows: one that overlays the QR slip onto an existing PDF already in Dropbox, and one that generates a standalone QR Bill document from payment data alone with no background PDF required. Both run in under 10 minutes to set up.

Two workflows covered in this guide
Workflow A (4 nodes)
Trigger → Download PDF → Create SwissQR (Binary Data) → Upload. Output: 602 kB. Best when you already have a PDF invoice in Dropbox.
Workflow B (3 nodes)
Trigger → Create SwissQR (None) → Upload. Output: 132 kB. Best when you only have payment data and need a standalone QR slip.

How Do You Extract PDF Form Data in Make? Dropbox Watch Files, Download, Then PDF4me.

· 15 min read
SEO and Content Writer

Teams often automate PDF forms the same way: watch a cloud folder for new files, download the PDF bytes, then extract field names and values into structured data for sheets, CRMs, or databases. This guide builds that path in Make (Make.com): Dropbox, Watch Files on /Blog Data/Extract Form Data From PDF/, Dropbox, Download a File with the path coming from the trigger, and PDF4me, Extract PDF Form Data with File name and Document mapped from Download. The run output shows Form Data such as customer_name, email, item, quantity, and price for sample_form.pdf.

Downloads (sample file)

Upload sample_form.pdf into the watched Dropbox folder (or your own path). The file is a fillable AcroForm PDF, the same type this module expects.

How Do You Convert Excel to PDF in Make? Dropbox, PDF4me, and Three Modules.

· 16 min read
SEO and Content Writer

Make (Make.com) is a common choice when you want visual scenarios: drag modules, connect them, and map fields without writing code. This guide mirrors a working setup: Dropbox fetches an Excel file, PDF4me converts it to PDF, and Dropbox writes the PDF to an Output folder. The screenshots use /Blog Data/Excel to PDF/sample_excel_file.xlsx and /Blog Data/Excel to PDF/Output/. Your paths can differ; keep the same mapping idea: module 1 feeds PDF4me, module 2 feeds the final Upload.

How to read this guide
  • Download the sample files below, then open each step in order (1 → 2 → 3).
  • Run Run once on module 1, then 2, then the whole scenario, so Make shows the correct 1. and 2. pills when you map fields.
  • Wrench icons between circles open the mapping between modules; green checks mean that module succeeded in a test run.
Downloads (sample files)

Upload sample_excel_file.xlsx to Dropbox at /Blog Data/Excel to PDF/sample_excel_file.xlsx (create folders as needed), or change module 1 to point at your own path. The PDF is optional, use it to confirm your conversion matches the expected invoice layout.

How Do You Convert Excel to PDF in n8n? Dropbox Download, PDF4me, Then Upload the PDF.

· 13 min read
SEO and Content Writer

This guide wires a four-node n8n workflow you can test with Execute workflow: pull an .xlsx from Dropbox, run PDF4me, Convert to PDF on the binary payload, then upload the resulting PDF to an output path. The screenshots use /blog data/excel to pdf/new invoice.xlsx as the source and /blog data/excel to pdf/output/Excel to Pdf.pdf as the destination filename. Swap paths and names to match your workspace.

How Do You Extract PDF Form Data in n8n? Dropbox Download, PDF4me, Then Save a Summary File.

· 14 min read
SEO and Content Writer

This walkthrough builds a four-node n8n workflow: you run it manually, download a fillable PDF from Dropbox, extract field values with PDF4me, Extract form data from PDF, then upload a small text file back to Dropbox built from expressions (for example, name, email, and price). The sample paths match the screenshots: PDF at /blog data/extract form data from pdf/sample_form.pdf, text output at /blog data/extract form data from pdf/output/Form data.txt. Adjust paths to match your account.

Word, Swiss QR Bill, and a Base PDF. Make Merges Them Into One. Six Modules, Done!

· 18 min read
SEO and Content Writer

You have a Word file (e.g. 3Page.docx) and a base PDF (e.g. demo_5_page.pdf) in Dropbox, and you need a Swiss QR Bill merged on top so the final PDF is ready to send. Make and PDF4me do it in one scenario: Dropbox, Download a File (Word), PDF4me, Convert to PDF, PDF4me, Create SwissQR Bill with creditor and debtor details, Dropbox, Download a File (base PDF), PDF4me, Merge PDF Overlay (base + Swiss QR layer), then Dropbox, Upload a File. Six modules. One run. No code.

This guide uses authentic screenshots and descriptive image captions so you can follow each step and match the configuration (paths, file source, and parameters) in your own Make scenario.

New File in the Folder? Make Generates a PDF and a Word Doc. Six Steps, Fully Automated!

· 15 min read
SEO and Content Writer

Drop a data file (e.g. JSON) into a Dropbox folder and keep a Google Docs template (e.g. Google Docs Template.docx) in the same place. When a new file appears, Make can run automatically: Find Template File gets the template, PDF4me, Generate Document runs twice, once with Data Text (inline JSON) → PDF, once with Data File (the triggered file) → Word, then Upload File saves both. Six modules. Trigger-based. No manual run.

This guide uses authentic screenshots and descriptive image captions so you can follow each step and match the configuration (folder paths, template name, data format, and output file names) in your own Make scenario.

New File in the Folder? Zapier Generates a PDF and a Word Doc. Six Steps, Fully Automated!

· 14 min read
SEO and Content Writer

Drop a data file (e.g. JSON) into a Dropbox folder and keep a Google Docs template (e.g. Google Docs Template.docx) in the same place. When a new file appears, Zapier can run automatically: a find file step loads the template, PDF4me, Generate Document runs twice, once with Data Text (inline JSON) → PDF, once with Data File (the file from the trigger) → Word, then Upload File saves both. Six steps. Trigger-based. No manual run.

The screenshots below show the same folder paths, template name, and PDF4me settings you use in Zapier; map each Dropbox or PDF4me field from the previous step’s output (trigger → find template → actions) the way you see in the images.

Word, Swiss QR Bill, and a Base PDF. n8n Merges Them Into One. Six Nodes, Done!

· 19 min read
SEO and Content Writer

You have a Word file (e.g. 3page.docx) and a base PDF (e.g. demo_5_page.pdf) in Dropbox, and you need a Swiss QR Bill merged on top so the final PDF is ready to send. n8n and PDF4me do it in one workflow: Download a file (Word), Convert to PDF, Create SwissQR bill with creditor and debtor details, Download Base PDF file, Merge two PDF files one over another as overlay, then Upload a file to Dropbox. Six nodes. One run. No code.

This guide uses authentic screenshots and descriptive image captions so you can follow each step and match the configuration (paths, binary fields, and parameters) in your own n8n workflow.

Word to PDF, Then a Swiss QR Bill on Top. Power Automate Merges It All!

· 17 min read
SEO and Content Writer

You have a Word document (e.g. an invoice or letter) and need a Swiss QR Bill payment slip merged onto it so the final PDF is ready to send. Doing it by hand means converting Word to PDF, generating the QR bill, then combining the two. Power Automate and PDF4me do it in one flow: get the Word file from Dropbox, Convert to PDF, Create SwissQR Bill with your creditor and debtor details, get a base PDF (e.g. your invoice layout), Merge two PDF files one over another as Overlay so the QR bill sits on the base, then Create file in Dropbox. Seven actions. One flow. No code.

This guide uses authentic screenshots and descriptive image captions so you can follow each step and match the configuration (paths, file names, and parameters) in your own flow.

New File in Your Dropbox Folder? Run a Mail Merge in Make. Six Steps, Fully Automated!

· 15 min read
SEO and Content Writer

Drop a Word template (e.g. simple_mail_merge_template.docx) into a Dropbox folder and keep a JSON file (e.g. sample_mail_merge_data.json) in the same place. When a new file appears, Make can run a mail merge automatically: find the JSON, call PDF4me - Generate Document (Template File Type: Mail Merge), then upload the result as Word and again as PDF. Six modules. Trigger-based. No manual run.

Screenshots in this guide match the Make module UI for New File in Folder, Find Json Data File, Generate Document (template plus data file or data text), and Upload File (folder path, file name, and extension).

New File in Your Dropbox Folder? Run a Mail Merge in Zapier. Six Steps, Fully Automated!

· 12 min read
SEO and Content Writer

Drop a Word template (e.g. simple_mail_merge_template.docx) into a Dropbox folder and keep a JSON file (e.g. sample_mail_merge_data.json) in the same place. When a new file appears, Zapier can run a mail merge: find the JSON, call PDF4me, Generate Document (Template File Type: Mail Merge), upload Word, run Generate Document again for PDF, then upload. Six steps. Trigger-based. No manual run.

The screenshots match the folder paths, file names, and PDF4me options you set in Zapier, map trigger → find JSON → PDF4me → upload using the same values shown in each image.

Fill It, Sign It, Ship It. Make.com Automates the Whole Thing!

· 15 min read
SEO and Content Writer

You have a fillable PDF form, data in JSON, and a signature image. Manual flow: fill the fields, place the signature, save, upload. Make plus PDF4me does it in one scenario: download the template, JSON, and signature from Dropbox (or Google Drive); run Fill a PDF Form and Sign PDF; then upload the signed document. No code. Ideal for contracts, agreements, and any form that must be filled and signed before delivery.

Fill the Form, Drop the Signature. Power Automate Does Both: No Code!

· 15 min read
SEO and Content Writer

You have a fillable PDF form, data in JSON, and a signature image. Doing it by hand: fill fields, place the signature, save. Power Automate plus PDF4me automates it: get the template, JSON, and signature from Dropbox or SharePoint; run Fill a PDF Form and Sign PDF; then save the signed document. No code. Perfect for contracts, agreements, and forms that must be filled and signed in one flow.