• Home

  • Automation with Zapier

  • Zapier tutorials

Zapier tutorials

2 min read

How to automatically keep track of your contacts for easier reporting

By Krystina Martinez · September 3, 2021
Hero image with an icon of three people with a chart showing metrics going up

Whether you're managing leads or newsletter contacts, you've worked hard to earn that contact information. But how often do you sit down and analyze it? 

While email platforms and CRM (customer relationship management) tools give you some insight on your contacts, sometimes the easiest way to crunch the data is in an old-fashioned spreadsheet. But who has the time to export the data, fix the CSV file, and build your database? 

Luckily, automation can help you track and manage a database of contact information—and you don't have to be a spreadsheet wizard.

Read more: The best automations to get more out of your spreadsheets 

Create automatic workflows to log contacts & leads

With Zapier, you can automate recurring tasks—giving you back valuable time to focus on higher priority items. The workflows you build in Zapier—we call them Zaps—can automate many common tasks, such as copying contact information to a spreadsheet or database.

Every Zap follows the same structure: When this happens, do that.

A Zap always consists of two parts: 

  1. The trigger, which is an event that starts a Zap. For example, when someone subscribes to your email newsletter. (Think of this as the when.)

  2. The action, which is an event a Zap performs after it's triggered. For example: Create a new row in a spreadsheet. (This is the do.)

A graphic flowchart explains the functionality of triggers and actions in a Zap. The trigger is "new subscriber" and the action is "create a spreadsheet row."

To help you get started, we rounded up a few popular Zaps that log contact information to a spreadsheet. Just click on the button below to get started. 

Add newsletter contacts to a spreadsheet

Add new Mailchimp subscribers to Excel spreadsheet rows

Add new Mailchimp subscribers to Excel spreadsheet rows
  • Mailchimp logo
  • Microsoft Excel logo
Mailchimp + Microsoft Excel

Add new ActiveCampaign subscribers added to lists to Google Sheets rows

Add new ActiveCampaign subscribers added to lists to Google Sheets rows
  • ActiveCampaign logo
  • Google Sheets logo
ActiveCampaign + Google Sheets

Add new contacts from Constant Contact to Microsoft Excel

Add new contacts from Constant Contact to Microsoft Excel
  • Constant Contact logo
  • Microsoft Excel logo
Constant Contact + Microsoft Excel

Add new Campaign Monitor subscribers to Airtable

Add new Campaign Monitor subscribers to Airtable
  • Campaign Monitor logo
  • Airtable logo
Campaign Monitor + Airtable

Add CRM leads to a spreadsheet

Create Google Sheets rows from new Salesforce leads

Create Google Sheets rows from new Salesforce leads
  • Salesforce logo
  • Google Sheets logo
Salesforce + Google Sheets

Add new HubSpot contacts to Airtable as records

Add new HubSpot contacts to Airtable as records
  • HubSpot logo
  • Airtable logo
HubSpot + Airtable

Add new Pipedrive leads to a Microsoft Excel spreadsheet

Add new Pipedrive leads to a Microsoft Excel spreadsheet
  • Pipedrive logo
  • Microsoft Excel logo
Pipedrive + Microsoft Excel

Capture new ClickFunnels Classic contact activities in Airtable

Capture new ClickFunnels Classic contact activities in Airtable
  • ClickFunnels Classic logo
  • Airtable logo
ClickFunnels Classic + Airtable

Need your contact information to do double- or triple-duty? You can create your own Zap from scratch. This is best if you'd like your Zap to perform more than one action, such as logging your newsletter subscribers to a spreadsheet and sending a message in a team chat app.  

Here's how to do it: 
  1. Create your spreadsheet or database and make sure your columns are labeled. 

  2. Create a new Zap in your Zapier account.

  3. Select the platform you use for capturing contact information as your trigger app and choose the event that corresponds with a new contact. (For example, this could be a CRM solution, contact management app, or email newsletter platform. Look for something like "new contact" or "new subscriber.")

  4. Then, select your spreadsheet or database app and select Create or update a row as the action event. 

  5. At this point, you'll put the finishing touches on how you want your contact information to look in your spreadsheet. You can map contact information to the appropriate columns and even add text that will appear the same each time your Zap runs. (If you'd like to add more actions, this is where you'd click the plus sign (+) and repeat steps 4-5 as needed.) 

  6. Test your Zap, and if all looks good, turn it on and watch your spreadsheet fill itself out!

Note: When you test your Zap it will add information to a new row in your spreadsheet. Zapier cannot retroactively add past information to a spreadsheet.

Need help with more complex automation? Zapier Experts are certified consultants, freelancers, and agencies that can help you do more with automation. Visit our Experts directory to help you find the right Expert to work with.

Maintain a Rolodex with automation

With thousands of integrations, there's no shortage of what you can automate to cut down on routine tasks. With automation, you can cut down the time you spend building a spreadsheet and spend more time finding insights about your contacts. 

New to Zapier? It's workflow automation software that lets you focus on what matters. Combine user interfaces, data tables, and logic with thousands of apps to build and automate anything you can imagine. Sign up for free.

Related reading:
  • 4 ways to use contact management automation

  • 7 ways to automate common newsletter tasks

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags

Related articles

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

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'