How to use Trello, Zapier and Google Sheets to create a simple CRM and Sales Pipeline

If you’re reading this, you’re probably a solopreneur like me looking for a simple, affordable way to manage your current sales process. I’m going to arm you with the tools and tactics needed to make this happen.

For the purpose of this demonstration, I’ll be setting up a CRM for a solopreneur looking to sell digital marketing services to emerging clothing brands.

Tools needed:

1) Trello:

This will be your CRM dashboard, allowing you to intuitively manage your leads through the sales pipeline.

2) Google Sheets:

This is where you or your virtual assistant, will enter new leads.

3) Zapier:

Zapier is the secret sauce here. It will automatically send new leads from your Google Sheet to Trello.

I’m going to guide you through this setup process, step, by step…

Step 1)

Create a Google Sheet for lead entry and include at least one example lead for Zapier to test. After the integration is setup, Zapier will send info over to your Trello CRM Dashboard so you can get to work.

Step 2)

Setup your Trello Board and add boards that will serve to manage your sales pipeline.

I labeled the boards: New Leads, Inbound: Contacted Us, Outbound: Emails Sent, Phone Call Scheduled, Work Contract Sent & Deal Closed

Step 3)

In Zapier, click “Explore” search for and select “Trello” and “Google Sheets”

Step 4)

Select “Create Trello cards from new Google Sheet rows”…if you select the following “Create a Trello card from an updated or new Google Sheets spreadsheet row” Zapier will create a new card everytime you change a field in google sheets. You don’t want this…select the one on the left.

Step 5)

Select “Create this Zap”

Step 6)

Click “continue”

Step 7)

Click “continue”

Step 8)

Click “Save+Continue”

Step 9)

Select the previous google sheet you made, and the worksheet where you will do lead entry, then press “continue”

Step 10)

Zapier will ask you to pick a sample…just select the default “Row A” and press “Continue”

Step 11)

Select “create card” and press “continue”

Step 12)

Link your Trello account and press “Save+Continue”

Step 13)

Select the “Board” that you created earlier in the process, and the list you want your new leads to populate in.

Step 14)

In the name field, select the icon with the plus sign on the right side of the input field. This will give you a drop down field of all of your Google Sheet columns that you linked to previously. This “name” field, will name the Trello card, so I’ll always select the “Brand Name.”

Step 15)

In the description field, I’ll add any other relevant information from the columns on the google sheet I created for lead entry. Again, click on the plus icon on the right side of the field, and it will display your columns from the google sheet.

Step 16) Optional

You can also add custom labels based on entries into your google sheet, as well as asign specific leads to certain team members, add due dates, as well as file and URL attachments. For the sake of this demonstration, I’m going to keep it simple.

Step 17)

Once you’ve established your fields, it’s time to send a test card to trello. Click “Send Test To Trello”

And there it is…Zapier just automatically created a trello card.

Now that you’ve set up the Zap, you can now begin to enter data into your Google Sheet, and have it populate Trello cards.

To Note: Zapier only updates every 5–15 minutes based on the plan your on so leads entered on the google sheet won’t always instantly appear.

Once you’ve set up this Zap, enter all new leads into your google sheet, and use Trello to move leads through the sales process. Simple as that.