Gmail + Slack + Filter by Zapier + PDF Vector + AI by Zapier + Code by Zapier + Google Sheets

Parse new Gmail attachments with PDF Vector, run Javascript, and add to Google Sheets rows

This integration automatically extracts key data from new PDF invoices (vendor info, amounts, dates, line items) in new Gmail attachments and populates a Google Sheets spreadsheet. This integration uses AI to understand different invoice formats and layouts.

When this happens...
New Attachment
Triggers when you receive a new attachment.
TriggerPolling
automatically do this...
Only continue if...
Set up rules to specify when this Zap can continue running.
ActionFilter
then do this...
Parse Document
Extract content from a PDF or Word document (DOC/DOCX) and convert it to markdown format. Supports both URLs and file uploads.
ActionWrite
then do this...
Analyze and Return Data
Extract data, analyze information, generate content — and more
ActionWrite
then do this...
Run Javascript code This is an advanced action! Uses the latest supported version of Node.
ActionWrite
then do this...
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite
then do this!
Send Channel Message
Triggers when a new message is posted to a specific #channel you choose.
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

- Label or mailbox
- Search keywords
Trigger
Polling
Try It
- Label or mailboxRequired
Trigger
Polling
Try It
- Label or mailbox
Trigger
Polling
Try It
New Starred Email
Triggers when you receive a new email and star it within two days.
Trigger
Polling
Try It
- LabelRequired
- MessageRequired
Action
Write

- 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
- Send message to Google Contacts Group/Label
- Cc
- Bcc
- From
- From Name
- Reply To
- SubjectRequired
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Write
- ThreadRequired
- Label(s) to removeRequired
Action
Write
- Search StringRequired
Action
Search
- Only continue if...Required
Action
Filter
- Search QueryRequired
- Databases to Search
- Publication Year From
- Publication Year To
- Number of Results
- Fields to Include
Action
Write
- Document URL
- Document File
- Extraction InstructionsRequired
- JSON SchemaRequired
Action
Write
- URL to Extract Content FromRequired
Action
Write
- URLs to Search AcrossRequired
- What to Search ForRequired
- Number of Results
Action
Write
- Zap Id
- Zap Step Id
- CodeRequired
Trigger
Polling
Try It
- Zap Id
- Zap Step Id
- Input Data
- CodeRequired
Action
Write
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
Action
Write
- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
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
- A1 RangeRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
New Channel
Triggers when a new #channel is created.
Trigger
Instant
Try It
- Include Alias
Trigger
Instant
Try It
- Username
- Highlight Word
- Trigger for Bot Messages?
- Only Public Channels?
Trigger
Instant
Try It
- ChannelRequired
Trigger
Instant
Try It
- ChannelRequired
- Trigger for Bot Messages?
Trigger
Instant
Try It
New Saved Message
Triggers when you save a message.
Trigger
Instant
Try It
- TextRequired
- Remind when?Required
- Remind who?
Action
Write
- Conversation IDRequired
- Scheduled AsRequired
- Scheduled Message IDRequired
Action
Write
- ChannelRequired
- Add Zapier app to channel automatically?
- Message TextRequired
- Send as a bot?
- Bot Name
- Bot Icon
- Include a link to this Zap?
- Attach Image by URL
- Auto-Expand Links?
- Link Usernames and Channel Names?
- Schedule At
- File
- Thread
- Send Channel Message?
- Zap Id
Action
Write
- Send Multi Message
- Message TextRequired
- Send as a bot?
- Include a link to this Zap?
- Attach Image by URL
- Auto-Expand Links?
- Link Usernames and Channel Names?
- Schedule At
- Zap Id
Action
Write
- Channel NameRequired
Action
Write
- Status Copy
- Approval request messageRequired
- Send message asRequired
- Approval typeRequired
- Zap Id
- Include a link to this Zap?
- Approve button URL
- Approve button label
- Add decline button
- Add details button
- Require confirmation
Action
Write
- First Name
- Last Name
- Title
- Email
- Display Name
- User
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
Get Message by Timestamp
This action retrieves a specific message from a conversation history in Slack using the message's timestamp.
Action
Write
Retrieve Thread Messages
This action retrieves all the messages sent to a specific thread in a selected channel.
Action
Write
Create Private Channel
This action creates a private channel in Slack.
Action
Write
- Conversation IDRequired
Action
Search
- Conversation IDRequired
- Message ID (ts)Required
Action
Search
- Conversation IDRequired
- Message TS (ID)Required
Action
Search
- EmailRequired
- Return Raw Results?
Action
Search
- Full NameRequired
- Return Raw Results?
Action
Search

New Label
Triggers when you add a new label.
Trigger
Polling
Try It
- Label or mailboxRequired
Trigger
Polling
Try It
- Search keywordsRequired
Trigger
Polling
Try It
- Label/Mailbox
Trigger
Polling
Try It
- 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
- Trigger Instructions
- ThreadRequired
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- Subject
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Write
- Search StringRequired
- To
- Send message to Google Contacts Group/Label
- Cc
- Bcc
- From
- From Name
- Reply To
- SubjectRequired
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Search or write
- Publication IDsRequired
- Fields to Include
Action
Write
- Document URL
- Document File
- Question/PromptRequired
Action
Write
- Document URL
- Document File
- Use AI Enhancement
Action
Write
- ProviderRequired
- AuthenticationRequired
- ModelRequired
- PromptRequired
- Input fields
- Knowledge Sources
- Output fields
- Return as an array of objects?
Action
Write
- Zap Id
- Zap Step Id
- CodeRequired
Trigger
Polling
Try It
- Zap Id
- Zap Step Id
- Input Data
- CodeRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
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
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Spreadsheet IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
- Trigger for Bot Messages?
- Optimized data
Trigger
Instant
Try It
- ChannelRequired
- Trigger for Bot Messages?
- Optimized data
Trigger
Instant
Try It
- Channel
- User Name
- Shared
Trigger
Instant
Try It
- Search QueryRequired
- Optimized data
Trigger
Polling
Try It
- Conversation ID
- Reaction
- Member ID
- Message Author ID
Trigger
Instant
Try It
- Zap Identifier
- Access type
Trigger
Instant
Try It
New User
Triggers when a new Slack user is created / first joins your org.
Trigger
Instant
Try It
- Conversation IDRequired
Action
Write
- ChannelRequired
- UsersRequired
Action
Write
- Allowed Delete Copy
- Conversation IDRequired
- Message TS (ID)Required
- Posted By
Action
Write
- Allowed Edit Copy
- Conversation IDRequired
- Message TS (ID)Required
- Posted By
- Content Type
- Reply Broadcast
Action
Write
- ChannelRequired
- Add Zapier app to channel automatically?
- Message TextRequired
- Send as a bot?
- Bot Name
- Bot Icon
- Include a link to this Zap?
- Attach Image by URL
- Auto-Expand Links?
- Link Usernames and Channel Names?
- Schedule At
- Zap Id
- File
- Thread
- Send Channel Message?
Action
Write
- ChannelRequired
- TopicRequired
- Topic set by
Action
Write
- Status Text
- Status Emoji
- Expiration Time
Action
Write
Remove User from Channel
This action removes a specified user from a specified channel in Slack.
Action
Write
Edit Message
This action updates a specific message sent by the same Authenticated user on Slack. You need to provide the Channel ID, the Timestamp of the message to be edited, and the new text for the message.
Action
Write
Find Public Channel
This action will find a public channel in Slack using either the channel's ID or name.
Action
Write
Delete Message
This action deletes an existing message in a specific channel on Slack. You need to provide the channel ID and the message timestamp as inputs.
Action
Write
- Conversation IDRequired
Action
Search
- Conversation IDRequired
- Message ID (ts)Required
Action
Search
- Search QueryRequired
- Sort By
- Sort Direction
Action
Search
- IDRequired
- Return Raw Results?
Action
Search
- UsernameRequired
- Return Raw Results?
Action
Search

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

Related categories

Similar apps

About Slack

Slack is a platform for team communication: everything in one place, instantly searchable, available wherever you go. Offering instant messaging, document sharing and knowledge search for modern teams.

Learn more

Related categories

Team Chat

Similar apps

Chatwork

Team Chat

Microsoft Teams

Microsoft, Team Chat

Twist

Team Chat

About Filter by Zapier

Only allow a Zap to proceed when a certain condition is met. For example, if you're sending a text message when you receive a new email, you could use a Filter that only sends a text message when the email received is from a certain address.

Learn more

Related categories

About PDF Vector

PDF Vector is a tool that extracts content from PDFs to Markdown and searches academic publications across multiple databases.

Related categories

Developer Tools

About AI by Zapier

Smart task and text handling powered by a flexible AI. Create text prompts to perform standard tasks like extracting lead (or other) data or answer discrete questions like "where should this message be routed?". Or, create your own!

Learn more

Related categories

About Code by Zapier

Write custom Python or Javascript code in response to any data from any service! Transform, mutate, customize or even do custom HTTP in a native and familiar environment.

Learn more

Related categories

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Gmail + Slack + Filter by Zapier + PDF Vector + AI by Zapier + Code by Zapier + Google Sheets

Parse new Gmail attachments with PDF Vector, run Javascript, and add to Google Sheets rows

New Attachment

New Labeled Conversation

New Email

New Starred Email

Add Label to Email

Delete Email

Create Draft Reply

Send Email

Remove Label From Conversation

Find Email

Only continue if...

Search Academic Publications

Extract Structured Document

Extract Content From URL (Beta)

Search Content Across URLs (Beta)

Run Javascript

Run Javascript

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Conditional Formatting Rule

Copy Worksheet

Create Worksheet

Delete Sheet

Format Cell Range

Rename Sheet

Sort Range

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Data Range

Get Row by ID

Lookup Spreadsheet Row

Find or Create Row

New Channel

New Team Custom Emoji

New Mention

New Channel Member

New Message Posted to Private Channel

New Saved Message

Add Reminder

Cancel Scheduled Message

Send Channel Message

Send Direct Message

Create Channel

Request Approval

Update Profile

API Request (Beta)

Get Message by Timestamp

Retrieve Thread Messages

Create Private Channel

Get Conversation

Get Message

Get Message Reactions

Find User by Email

Find User by Name

New Label

New Labeled Email

New Email Matching Search

New Conversation

Archive Email

Create Draft

Create Label

Remove Label From Email

Reply to Email

Find or Send Email

Fetch Academic Publications by ID

Ask Document

Parse Document

Analyze and Return Data

Run Python

Run Python

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows