Gmail + Google Sheets + PDF-app + Looping by Zapier

Convert, split, and extract data from new Gmail attachments with PDF-app and add Google Sheets rows

Convert DOCX Word documents to PDF from new Gmail attachments, then split the PDF and extract data from each part. This integration allows you to easily convert DOCX files attached to your Gmail emails into PDF format, split the resulting PDF into separate files, and extract data from each file. The end result will be added to a Google Sheets row.

When this happens...
New Attachment
Triggers when you receive a new attachment.
TriggerScheduled
automatically do this...
Convert Docx or Excel to PDF
Convert Word or Excel document into a PDF file.
ActionWrite
then do this...
Split PDF
Split PDF in a required number of pages
ActionWrite
then do this...
Create Loop From Line Items
Creates a new Loop from line item(s). This is an advanced action!
ActionWrite
then do this...
Extract Data From PDF
Extract data from your PDF through templates
ActionWrite
then do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

- Label or mailbox
- Search keywords
Trigger
Scheduled
Try It
- Label or mailboxRequired
Trigger
Scheduled
Try It
- Search keywordsRequired
Trigger
Scheduled
Try It
- Label/Mailbox
Trigger
Scheduled
Try It
- Email message to be DeletedRequired
Action
Write

- Trigger Instructions
- ThreadRequired
- To
- Cc
- Bcc
- From
- From Name
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Write
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- SubjectRequired
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Write

- Trigger Instructions
- ThreadRequired
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- Body type
- BodyRequired
- Label or mailbox
- Attachments
Action
Write
- Search StringRequired
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- SubjectRequired
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Search or write
- File URLRequired
- Asyncron processingRequired
- Filename
- Password protection
- Encrypt PDF Algorithm
- Encrypt PDF Key
- Encrypt PDF IV
Action
Write
- PDF URLRequired
- Add Texts
- Add Images
- Remove Elements
- Search & Replace text
- Filename
- Delete pages
- Asyncron processingRequired
Action
Write
- PDF URLRequired
- Asyncron processingRequired
- Template IDRequired
Action
Write
- Image URL(s)Required
- Asyncron processingRequired
- Filename
- Password protection
- Encrypt PDF Algorithm
- Encrypt PDF Key
- Encrypt PDF IV
Action
Write
- PDF URLsRequired
- Asyncron processingRequired
- Filename
- Password protection
- Encrypt PDF Algorithm
- Encrypt PDF Key
- Encrypt PDF IV
Action
Write
- PDF File URLRequired
- Filename
- Add or removeRequired
- PasswordRequired
Action
Write
- File URLRequired
- Asyncron processingRequired
- Filename
Action
Write
- PDF file URLRequired
- Pages per splitRequired
- Asyncron processingRequired
- Filename
- Password protection
- Encrypt PDF Algorithm
- Encrypt PDF Key
- Encrypt PDF IV
Action
Write
- Help Warning
- Values to LoopRequired
- Trim Whitespace
- Loop iteration counter start
- Maximum number of Loop iterations
Action
Write
- Help Warning
- Values to LoopRequired
- Text Delimiter
- Trim Whitespace
- Loop iteration counter start
- Maximum number of Loop iterations
Action
Write
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Search or write

New Label
Triggers when you add a new label.
Trigger
Scheduled
Try It
- Label or mailbox
Trigger
Scheduled
Try It
New Starred Email
Triggers when you receive a new email and star it within two days.
Trigger
Scheduled
Try It
- Label
- MessageRequired
Action
Write
- Recipient Instructions
- To
- Cc
- Bcc
- SubjectRequired
- From
- From Name
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Write
- Name of labelRequired
Action
Write
- MessageRequired
- Label(s) to removeRequired
Action
Write
- Search StringRequired
Action
Search
- Barcode textsRequired
- Filename
- WidthRequired
- HeightRequired
- Include textRequired
- Text placementRequired
- Text PaddingRequired
Action
Write
- File URLRequired
- Asyncron processingRequired
- Filename
- Password protection
- Encrypt PDF Algorithm
- Encrypt PDF Key
- Encrypt PDF IV
Action
Write
- File URLRequired
- Filename
- Encrypt File AlgorithmRequired
- Encrypt File KeyRequired
- Encrypt File IVRequired
- Encrypt or decryptRequired
Action
Write
- Content Data
- Header Template
- Footer Template
- PDF page formatRequired
- Display Header & FooterRequired
- Page marginsRequired
- OrientationRequired
- Show background
- Asyncron processingRequired
- HTML Template ID
- Filename
- Password protection
- Encrypt PDF Algorithm
- Encrypt PDF Key
- Encrypt PDF IV
Action
Write
- JobIDRequired
Action
Write
- Image or PDF URL(s)Required
- Asyncron processingRequired
- Language
- Regions
Action
Write
- PDF URL(s)Required
- Filename
- Image Type
- Image Quality
- Asyncron processingRequired
Action
Write
- QR textsRequired
- Filename
- SizeRequired
- MarginRequired
- ColorRequired
- Background colorRequired
- FormatRequired
Action
Write
- File URLs
- Operation Type
- File Type
- File Path
Action
Write
- Help Warning
- Loop iteration counter start
- Loop iteration counter end
- Loop iteration counter increment amount
- Maximum number of Loop iterations
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write

About Gmail

One of the most popular email services, Gmail keeps track of all your emails with threaded conversations, tags, and Google-powered search to find any message you need.

Learn more