Create a sales pipeline in Airtable

Become a Pro member to access all content

240+ instructional videos led by professionals
Weekly expert workshops and replays
1-1 consultation with the Makerpad team
Over $50k in discounts for tools
Private peer community
Profile for tracking progress and sharing your work
Yearly pricing
$249/year
Start your 7 day free trial*
Get PRO Yearly
Lifetime pricing
$600billed once
Start your 7 day free trial*
Get PRO Lifetime

In this tutorial I'm going to show you how to build a custom sales pipeline with multiple views using Airtable.

What you'll need

  • Airtable
  • Dummy customer data

Step 1

First of all in Airtable create a new base. Give it a name and open it. Next right click and delete all coloumns apart from Name and Notes. Now add in the following columns with the corresponding field types.

  • Sales Stage - Single Select
  • Priority - Checkbox
  • Expected Deal Date - Date
  • Expected Value - Currency
  • % Chance of Closing - Percentage
  • Last Contacted - Date
  • Completed Deal Value - Currency
  • Notes

Step 2

Now let's input some data. Fill 1-6 rows with data which would represent sales bids that may occur in your business. Make sure you add tags which show the deals at different stages.

Click the arrow in the top left corner located next to the 'Grid View' text and create a new Kanban board view. This allows us to see a good visual of where each deal is at.

Click 'Customise Cards' from the top menu and add in the details you want to see on each card.

Finally, add a 'Calendar' view selecting the 'Expected Deal Date' as the date field.

Step 3

Let's add a new table by clicking the plus sign next to the Sales Deals tab on the top of the screen, call it 'Sales Reps'.

Add the follow columns.

  • Start Date - Date
  • Target - Currency
  • Notes - Text

Add a sales Rep and a target.

Now back inside the Sales Deals tab, add a new Reference Field column next to the Name column and link it to the Sales Rep page. Call it 'Rep'. Add the Rep to a deal. Notice the new column created in the Sales Rep table.

Add a new Roll Up column in the Sales Rep page, call it Done Deals Value and select Sales Deals from the first field drop down and 'Completed Deals Value' from the second. In the final field input =sum(values). This will give each sales rep a total of the deal closed.

That's it! You now have a simple working Sales Pipeline inside of Airtable.

I hope you enjoyed this tutorial, if you have any questions please reach out on Twitter @tomosman or @makerpad.

Join today for free and access 200+ tutorials

Join Makerpad today and you'll get access to hundreds of tutorials and educational content to help you create projects, automate workflows, and build software, without writing code.

Learn alongside 4 thousand professionals, no coding required.

Get Started Free

In this tutorial I'm going to show you how to build a custom sales pipeline with multiple views using Airtable.

What you'll need

  • Airtable
  • Dummy customer data

Step 1

First of all in Airtable create a new base. Give it a name and open it. Next right click and delete all coloumns apart from Name and Notes. Now add in the following columns with the corresponding field types.

  • Sales Stage - Single Select
  • Priority - Checkbox
  • Expected Deal Date - Date
  • Expected Value - Currency
  • % Chance of Closing - Percentage
  • Last Contacted - Date
  • Completed Deal Value - Currency
  • Notes

Step 2

Now let's input some data. Fill 1-6 rows with data which would represent sales bids that may occur in your business. Make sure you add tags which show the deals at different stages.

Click the arrow in the top left corner located next to the 'Grid View' text and create a new Kanban board view. This allows us to see a good visual of where each deal is at.

Click 'Customise Cards' from the top menu and add in the details you want to see on each card.

Finally, add a 'Calendar' view selecting the 'Expected Deal Date' as the date field.

Step 3

Let's add a new table by clicking the plus sign next to the Sales Deals tab on the top of the screen, call it 'Sales Reps'.

Add the follow columns.

  • Start Date - Date
  • Target - Currency
  • Notes - Text

Add a sales Rep and a target.

Now back inside the Sales Deals tab, add a new Reference Field column next to the Name column and link it to the Sales Rep page. Call it 'Rep'. Add the Rep to a deal. Notice the new column created in the Sales Rep table.

Add a new Roll Up column in the Sales Rep page, call it Done Deals Value and select Sales Deals from the first field drop down and 'Completed Deals Value' from the second. In the final field input =sum(values). This will give each sales rep a total of the deal closed.

That's it! You now have a simple working Sales Pipeline inside of Airtable.

I hope you enjoyed this tutorial, if you have any questions please reach out on Twitter @tomosman or @makerpad.

Become a Pro member to access all content

240+ instructional videos led by professionals
Weekly expert workshops and replays
1-1 consultation with the Makerpad team
Over $50k in discounts for tools
Private peer community
Profile for tracking progress and sharing your work
Yearly pricing
$249/year
Start your 7 day free trial*
Get PRO Yearly
Lifetime pricing
$600billed once
Start your 7 day free trial*
Get PRO Lifetime

In this tutorial I'm going to show you how to build a custom sales pipeline with multiple views using Airtable.

What you'll need

  • Airtable
  • Dummy customer data

Step 1

First of all in Airtable create a new base. Give it a name and open it. Next right click and delete all coloumns apart from Name and Notes. Now add in the following columns with the corresponding field types.

  • Sales Stage - Single Select
  • Priority - Checkbox
  • Expected Deal Date - Date
  • Expected Value - Currency
  • % Chance of Closing - Percentage
  • Last Contacted - Date
  • Completed Deal Value - Currency
  • Notes

Step 2

Now let's input some data. Fill 1-6 rows with data which would represent sales bids that may occur in your business. Make sure you add tags which show the deals at different stages.

Click the arrow in the top left corner located next to the 'Grid View' text and create a new Kanban board view. This allows us to see a good visual of where each deal is at.

Click 'Customise Cards' from the top menu and add in the details you want to see on each card.

Finally, add a 'Calendar' view selecting the 'Expected Deal Date' as the date field.

Step 3

Let's add a new table by clicking the plus sign next to the Sales Deals tab on the top of the screen, call it 'Sales Reps'.

Add the follow columns.

  • Start Date - Date
  • Target - Currency
  • Notes - Text

Add a sales Rep and a target.

Now back inside the Sales Deals tab, add a new Reference Field column next to the Name column and link it to the Sales Rep page. Call it 'Rep'. Add the Rep to a deal. Notice the new column created in the Sales Rep table.

Add a new Roll Up column in the Sales Rep page, call it Done Deals Value and select Sales Deals from the first field drop down and 'Completed Deals Value' from the second. In the final field input =sum(values). This will give each sales rep a total of the deal closed.

That's it! You now have a simple working Sales Pipeline inside of Airtable.

I hope you enjoyed this tutorial, if you have any questions please reach out on Twitter @tomosman or @makerpad.

In this tutorial I'm going to show you how to build a custom sales pipeline with multiple views using Airtable.

What you'll need

  • Airtable
  • Dummy customer data

Step 1

First of all in Airtable create a new base. Give it a name and open it. Next right click and delete all coloumns apart from Name and Notes. Now add in the following columns with the corresponding field types.

  • Sales Stage - Single Select
  • Priority - Checkbox
  • Expected Deal Date - Date
  • Expected Value - Currency
  • % Chance of Closing - Percentage
  • Last Contacted - Date
  • Completed Deal Value - Currency
  • Notes

Step 2

Now let's input some data. Fill 1-6 rows with data which would represent sales bids that may occur in your business. Make sure you add tags which show the deals at different stages.

Click the arrow in the top left corner located next to the 'Grid View' text and create a new Kanban board view. This allows us to see a good visual of where each deal is at.

Click 'Customise Cards' from the top menu and add in the details you want to see on each card.

Finally, add a 'Calendar' view selecting the 'Expected Deal Date' as the date field.

Step 3

Let's add a new table by clicking the plus sign next to the Sales Deals tab on the top of the screen, call it 'Sales Reps'.

Add the follow columns.

  • Start Date - Date
  • Target - Currency
  • Notes - Text

Add a sales Rep and a target.

Now back inside the Sales Deals tab, add a new Reference Field column next to the Name column and link it to the Sales Rep page. Call it 'Rep'. Add the Rep to a deal. Notice the new column created in the Sales Rep table.

Add a new Roll Up column in the Sales Rep page, call it Done Deals Value and select Sales Deals from the first field drop down and 'Completed Deals Value' from the second. In the final field input =sum(values). This will give each sales rep a total of the deal closed.

That's it! You now have a simple working Sales Pipeline inside of Airtable.

I hope you enjoyed this tutorial, if you have any questions please reach out on Twitter @tomosman or @makerpad.

Join today for free and access 200+ tutorials

Join Makerpad today and you'll get access to hundreds of tutorials and educational content to help you create projects, automate workflows, and build software, without writing code.

Learn alongside 4 thousand professionals, no coding required.

Get Started Free

In this tutorial I'm going to show you how to build a custom sales pipeline with multiple views using Airtable.

What you'll need

  • Airtable
  • Dummy customer data

Step 1

First of all in Airtable create a new base. Give it a name and open it. Next right click and delete all coloumns apart from Name and Notes. Now add in the following columns with the corresponding field types.

  • Sales Stage - Single Select
  • Priority - Checkbox
  • Expected Deal Date - Date
  • Expected Value - Currency
  • % Chance of Closing - Percentage
  • Last Contacted - Date
  • Completed Deal Value - Currency
  • Notes

Step 2

Now let's input some data. Fill 1-6 rows with data which would represent sales bids that may occur in your business. Make sure you add tags which show the deals at different stages.

Click the arrow in the top left corner located next to the 'Grid View' text and create a new Kanban board view. This allows us to see a good visual of where each deal is at.

Click 'Customise Cards' from the top menu and add in the details you want to see on each card.

Finally, add a 'Calendar' view selecting the 'Expected Deal Date' as the date field.

Step 3

Let's add a new table by clicking the plus sign next to the Sales Deals tab on the top of the screen, call it 'Sales Reps'.

Add the follow columns.

  • Start Date - Date
  • Target - Currency
  • Notes - Text

Add a sales Rep and a target.

Now back inside the Sales Deals tab, add a new Reference Field column next to the Name column and link it to the Sales Rep page. Call it 'Rep'. Add the Rep to a deal. Notice the new column created in the Sales Rep table.

Add a new Roll Up column in the Sales Rep page, call it Done Deals Value and select Sales Deals from the first field drop down and 'Completed Deals Value' from the second. In the final field input =sum(values). This will give each sales rep a total of the deal closed.

That's it! You now have a simple working Sales Pipeline inside of Airtable.

I hope you enjoyed this tutorial, if you have any questions please reach out on Twitter @tomosman or @makerpad.

In this tutorial I'm going to show you how to build a custom sales pipeline with multiple views using Airtable.

What you'll need

  • Airtable
  • Dummy customer data

Step 1

First of all in Airtable create a new base. Give it a name and open it. Next right click and delete all coloumns apart from Name and Notes. Now add in the following columns with the corresponding field types.

  • Sales Stage - Single Select
  • Priority - Checkbox
  • Expected Deal Date - Date
  • Expected Value - Currency
  • % Chance of Closing - Percentage
  • Last Contacted - Date
  • Completed Deal Value - Currency
  • Notes

Step 2

Now let's input some data. Fill 1-6 rows with data which would represent sales bids that may occur in your business. Make sure you add tags which show the deals at different stages.

Click the arrow in the top left corner located next to the 'Grid View' text and create a new Kanban board view. This allows us to see a good visual of where each deal is at.

Click 'Customise Cards' from the top menu and add in the details you want to see on each card.

Finally, add a 'Calendar' view selecting the 'Expected Deal Date' as the date field.

Step 3

Let's add a new table by clicking the plus sign next to the Sales Deals tab on the top of the screen, call it 'Sales Reps'.

Add the follow columns.

  • Start Date - Date
  • Target - Currency
  • Notes - Text

Add a sales Rep and a target.

Now back inside the Sales Deals tab, add a new Reference Field column next to the Name column and link it to the Sales Rep page. Call it 'Rep'. Add the Rep to a deal. Notice the new column created in the Sales Rep table.

Add a new Roll Up column in the Sales Rep page, call it Done Deals Value and select Sales Deals from the first field drop down and 'Completed Deals Value' from the second. In the final field input =sum(values). This will give each sales rep a total of the deal closed.

That's it! You now have a simple working Sales Pipeline inside of Airtable.

I hope you enjoyed this tutorial, if you have any questions please reach out on Twitter @tomosman or @makerpad.

Get help and discuss

Open community forum

More lessons

How to Build a Functional & Responsive Pricing Page like Notion's in Webflow
How to Build a No-code Pricing Page like Dropbox in Webflow
How to Build a Functional & Responsive Pricing Page
Develop a custom CRM using Retool and 8base
Generate a task list for projects in Airtable
Generate pre-filled contracts in Hubspot using PandaDoc
Sync files across Airtable, Hubspot, and Google Drive
Pre-Fill Airtable forms and link forms to existing records
Automate recurring interactions in your deal & project cycle
Connect Hubspot Deals to Airtable
Automate scheduling meetings, calendar invites, and CRM admin work
Sales automation workflow using Typeform / Airtable / Callingly
Capture email metadata and save as an image with Zapier
Find & save competitor info and emails with Hunter
Email outreach & sequencing with Reply.io & Gmail
Source Leads from a Spreadsheet with Dashdash
Send a personalized download link with YAMM
Create a targeted sales list in dashdash
Auto-accept LinkedIn invites
Automate + qualify your lead generation with Standard Library
Generate and send contracts automatically with PandaDoc
Automated Airtable sales notifications in Zapier
Automated sales reporting for Shopify with Integromat
Pull LinkedIn Company info & create a new record in Webflow
Build a Mail Merge with Airtable, Gmail, and Standard Library.
Build a Slack / Airtable / Stripe CRM
Update salesforce opportunities with computed data
Automatically get data from Mailchimp to your CRM
Sales CRM - build a sales pipeline
Fundraising CRM - Startups seeking to raise funding
👨‍👩‍👧‍👦Personal CRM - keep track of people in your life
Segmenting prospects for sales funnels
Browse all →

If you'd like this template, message @bentossell on Slack with your email for the account to send this template.