ConditionalVisibility

new-products-promo

Automation inspiration

automation-for-tracking-leads-00-hero

When you're growing a business, getting leads is one of the most critical things you can do. And you've got a lot of ways to do that.

3 ways to automatically keep track of your leads

Easily track and manage important email data  with this integration by Zapier. Set it up and this Zap will automatically trigger with every new email you label in Gmail, adding its data to a new row on Google Sheets to build a per-label index of your messages.

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.

Gmail

Triggers when you receive a new attachment.

New Attachment

New Label

Triggers when you receive a new email and label it within two days.

New Labeled Email

Triggers when a new email appears in the specified mailbox.

New Email

Triggers when you receive a new email that matches a search string you provide.

New Email Matching Search

Triggers when you receive a new email and star it within two days.

New Starred Email

New Thread

Find Email

Find or Send Email

Add Label to Email

Delete Email

Create Draft

Create a draft reply to an existing email.

Create Draft Reply

Create Label

Send Email

Remove Label From Email

Reply to Email

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

Google Sheets

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

Triggers when a new row is added to the bottom of a spreadsheet.

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

Create one or more new rows in a specific spreadsheet (with line item support).

Create Multiple Spreadsheet Rows

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

Update one or more rows in a specific spreadsheet (with line item support).

Update Spreadsheet Row(s)

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Add new labeled Gmail emails to rows in Google Sheets

Want a quick way to keep track of your most important emails? This Gmail-Airtable integration can help. Set it up, and whenever you label a new email in Gmail, Zapier will automatically copy the email's details and log it to your Airtable database. Set up your Gmail filters to automatically label emails (

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Airtable

Triggers when a new record is created or new or existing records when first added to a selected view.

New Record

Triggers when a record is created or updated.

New or Updated Record

Find Many Records (Advanced)

Find Record

Find or Create Record(s) (With Line Item Support)

Find or Create Record

Creates a new record with auto-populating fields.

Create Record

Create up to 10 new records (supports line items).

Create Records (Advanced)

Find and update an existing record, or create a new one.

Create or Update Record

Delete Record

Update Record

Add new labeled Gmail messages to Airtable

There's a better way to store emails than copying each one yourself: Set up this Zap and all your important messages will always end up on your spreadsheet. It will trigger whenever a new labeled email is detected on Gmail, adding its contents to a new row on Excel without taking up any of your precious time.

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. 

Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Microsoft Excel

Triggers when a new row is added to a worksheet in a spreadsheet.

New Row

Triggers when a new row is added to a table in a spreadsheet.

New Row in Table

Triggers when a new worksheet is added to a spreadsheet.

Triggers when a row is added or updated in a worksheet.

Updated Row

Finds a row by a column and value. Returns the entire row if one is found.

Find Row

Finds any rows that match a specific value in a given column.

Find Row(s)

Adds a new row to the end of a worksheet.

Add Row

Adds one or more rows to the end of a worksheet (with line item support).

Add Row(s)

Adds a new row to the end of a specific table.

Add Row to Table

Update Row

Add new labeled emails from Gmail to Excel [Business Gmail Accounts Only]

Want to spend less of your workday toggling between apps? That's where this integration comes in. Automatically create a new row in a specified Google Sheets spreadsheet whenever a new email is received in your Microsoft Outlook inbox. Keep your Google Sheets spreadsheets organized and up-to-date without ever needing to leave Outlook.

Microsoft Outlook is a web-based suite of webmail, contacts, tasks, and calendaring services.

Microsoft Outlook

Triggers at a specified time before an event in your calendar starts.

Calendar Event Start

Cancelled Calendar Event

Triggers when a new event is created in your calendar.

New Calendar Event

Triggers when a new contact is added to your account

New Contact

Triggers when a new e-mail is received in your inbox.

Triggers when a new e-mail is received in your inbox that matches a search.

New Flagged Email

Triggers when a new new message in folder is created.

New Message in Folder

Updated Calendar Event

Find Calendar Event

Find a Contact

Find or Create Contact

Add Attendees to Calendar Event

Create an event in the calendar of your choice.

Create Event

Create Contact

Creates a draft of an email that can then be reviewed and sent out.

Create Draft Email

Delete Event

Creates a new reply to email, probably with input from previous steps.

Update Calendar Event

Update Contact

Add rows to Google Sheets with new Microsoft Outlook emails

You won't always have time to copy or forward those important emails. Save yourself the hassle by setting up this Gmail-Pipedrive integration. From then on, new emails you receive on Gmail will trigger this Zap. In response, Zapier will automatically create a new deal on Pipedrive with all the details from each message. This Zap can optionally be set up to trigger only for new emails within certain labels; this lets you filter exactly what you want sent to Pipedrive.

Pipedrive is sales pipeline and CRM software for deal makers. Get super-organized. Close deals in less time. iOS and Android apps let you take your pipeline with you anywhere.

Pipedrive

New Activity

Triggers when an activity newly matches a Pipedrive filter for the first time.

Activity Matching Filter

New Deal

Triggers when a deal newly matches a Pipedrive filter for the first time.

Deal Matching Filter

New Lead

New Note

Triggers when a new organization is created.

New Organization

Triggers when an organization newly matches a Pipedrive filter for the first time.

Organization Matching Filter

New Person

Triggers when a person newly matches a Pipedrive filter for the first time.

Person Matching Filter

New Project

Updated Deal Stage

Triggers when an existing deal is updated.

Updated Deal

Triggers when an existing organization is updated.

Updated Organization

Triggers when an existing person is updated.

Updated Person

Find Activity

Find Deal

 Finds multiple deals related to a specific person (with line item support).

Find deals associated with a person

Finds multiple Deals associated with a Person (with line item support). 

Find Deals Associated with a Person

Find Lead

Finds multiple leads based on your search criteria, only returns the Lead IDs.

Find Multiple Leads

Find notes by deal, lead, person, user, or organization, up to 500 notes.

Retrieve Note

Finds notes by Deal, Lead, Person, User, or Organization, up to 500 notes.

Find Notes

Find Organization

Find Person

Find Product

Finds a product or products by name, ID, or product code (with line item support).

3 ways to automatically keep track of your leads

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.