ConditionalVisibility

new-products-promo

The BlackTies bill themselves as a boy band of magicians.

Customer stories

customer-story-the-black-ties-00-hero

Google Sheets

Pipedrive

Trello

Running a successful business is magic in its own right. But managing leads and updating spreadsheets wasn't the kind of magic The BlackTies, a Sydney magician group, wanted to be doing.

Zapier helps streamline sales, event planning, and project management

The BlackTies: Making magic with automation

Keep your Pipedrive customers and deals up to date by automatically creating them whenever a new row is added to a Google Sheet. Note: Your Google Sheet will need to include the information Pipedrive requires to create a person or a deal.

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

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)

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.

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).

Find Product(s)

Finds a project or projects by title or other fields.

Find Project(s)

Searches for tasks by title, description, or other criteria.

Find Task

Find User

Finds an activity by subject, or creates one if none is found.

Find or Create Activity

Finds a deal by name, or creates one if none is found.

Find or Create Deal

Finds multiple deals by title, notes or custom fields.

Find Multiple Deals

Finds a lead by name, or creates one if none is found.

Find or Create Lead

Finds an organization by name, or creates one if none is found.

Find or Create Organization

Finds a person by name, or creates one if none is found.

Find or Create Person

Finds a product by name, or creates one if none are found.

Find or Create Product

Finds a project by name, or creates one if none are found.

Find or Create Project

Adds an existing label to an existing person.

Add Label to Person

Add Product to Deal

Create Activity

Create Deal

Uploads a file and attaches it to a deal, person, organization, activity, product or note.

Attach File

Adds a follower to a deal, organization, person or product.

Add Follower

Create Lead

Create Note

Create Organization

Create Person

Create Product

Create Project

Create Task

Update Activity

Update Deal

Update Lead

Update Organization

Update Person

Updates an existing project in Pipedrive.

Update Project

Update Task

New row in Google Sheet creates Person and Deal in Pipedrive

If you're trying to ensure you take all the necessary action for your Pipedrive deals, visual tasks are a helpful aid. Set them up automatically by turning on this Pipedrive-Trello integration: It will trigger with every new deal you add to Pipedrive, adding a new card for each one to any Trello list you want.

Trello is a team collaboration tool that lets you organize anything and everything to keep your projects on task.

New Board

New Card

Triggers when a Card is archived in Trello.

New Card Archived

Triggers when a Comment is added to a Card in Trello.

New Comment in Card

Triggers when there is activity in Trello.

Triggers when a Card is moved to a List in Trello, [inside the same Board](https://zapier.com/apps/trello/help#common-problems-trello#not-triggering-on-card-moved-to-list-when-a-card-is-moved-from-another-board).

Card Moved to List

Triggers at a specified time before a card is due.

Card Due

Triggers when a Card is updated in Trello.

Card Updated

Triggers when a new checklist is created in Trello.

New Checklist

Triggers when a new label is created in Trello.

New Label

Triggers when a label is added in a Trello card.

New Label Added to Card

Triggers when a new list on a board is added.

New List

Triggers when a new member joins a board.

New Member on Board

Triggers when you get a new notification in Trello.

New Notification

Finds a label on a particular board by name.

Find Label on Board

Finds a list on a particular board by name.

Find List on a Board

Finds a checklist on a particular board or card by name.

Find Checklist

Finds a checklist item on a particular checklist by name.

Find Checklist Item

Finds a board in your Trello organization by name.

Find Board

Finds a card in your Trello organization by name, given a specified board and list. Does not search archived cards.

The BlackTies: Making magic with automation

Zapier helps streamline sales, event planning, and project management

Related articles

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