This guide shows you two ways to get your Facebook Lead Ads data out of Meta’s system: a one-time manual export (CSV download) and an ongoing automatic delivery to your email, Google Sheets, or CRM. You’ll need a Facebook Page with access to the Leads Center or the Meta Business Suite, and admin or advertiser permissions on the ad account that owns the lead form.
What You’ll Need
- A Facebook Page connected to an ad account with Lead Ads running (or at least paused).
- Admin or advertiser access to that ad account in Meta Business Suite.
- For ongoing delivery, a destination that can receive data: an email address, a Google Sheet, or a CRM that supports Facebook Lead Ads integration (e.g., HubSpot, Salesforce, Zapier).
Step-by-Step
Option A: Manual Export (One-Time)
- Log in to Meta Business Suite (business.facebook.com) with the account that has access to your ad account.
- In the left menu, click Ad Center (or Ads Manager if you’re in the older interface).
- Click Leads in the left sidebar. This opens the Leads Center.
- Use the date range filter in the top right to select the period you want (e.g., Last 30 days).
- To export all leads from all forms, click the Export button at the top right. Choose CSV or Excel format. The file will download immediately.
- If you only want leads from a specific ad or form, click on that ad in the list first, then click Export.
- Open the downloaded file in a spreadsheet program. The columns include name, email, phone, and any custom questions you added to the form.
Option B: Ongoing Delivery (Automatic)
This sends new leads to your chosen destination as soon as they come in. The easiest method is using a third-party integration like Zapier, but Meta also offers native options for email and Google Sheets.
Method 1: Email Notifications (Built-in)
- In the Leads Center, click the Settings gear icon in the top right.
- Scroll to Instant Notifications.
- Enter the email address where you want to receive each new lead. You can add multiple emails.
- Click Save. You’ll get an email each time someone submits your lead form.
Method 2: Google Sheets (via Zapier)
- Go to zapier.com and create a free account (or log in).
- Click Create Zap.
- Choose Facebook Lead Ads as the trigger app. Select the trigger event New Lead.
- Connect your Facebook account and select the specific Page and Form you want to monitor.
- For the action app, choose Google Sheets. Select the event Create Spreadsheet Row.
- Connect your Google account, then select the spreadsheet and worksheet where you want leads added.
- Map the Facebook lead fields (Name, Email, Phone) to the corresponding columns in your sheet.
- Turn on the Zap. It will now add a new row for every lead.
Method 3: CRM Integration
- Most CRMs (HubSpot, Salesforce, Zoho) have built-in Facebook Lead Ads integrations. Go to your CRM’s marketplace or integrations page.
- Search for “Facebook Lead Ads” and follow the setup wizard.
- Connect your Facebook account, choose the Page and Form, and map the lead fields to your CRM’s contact fields.
- Test the connection by submitting a test lead (you can do this from the Leads Center).
Common Mistakes
- Exporting from the wrong place: The Leads Center is under Ad Center, not the regular Business Suite home. If you don’t see “Leads”, you might not have Lead Ads running.
- Forgetting the date range: The export only includes leads from the selected date range. If you see fewer leads than expected, check the filter.
- Using a personal Facebook account: You must use a business account with admin access. Personal accounts often lack permission.
- Not mapping fields in Zapier: If you skip the field mapping step, your spreadsheet will have empty columns. Always test with a real lead.
- Assuming instant delivery: Email notifications can take a few minutes. Google Sheets via Zapier typically updates within 1-5 minutes.
Tips
- Set up a test lead before going live with any integration. You can do this by clicking the Test button in the Leads Center for a specific form.
- Regularly download a backup CSV even if you have ongoing delivery. This protects against integration failures.
- Use the same email for notifications as your CRM’s inbox so you don’t miss a lead if the integration breaks.
- If you’re using Zapier, consider upgrading to a paid plan if you get more than 100 leads per month (the free tier is limited).
- For high-volume accounts, use a CRM integration rather than email – it’s more reliable and easier to manage duplicates.
Troubleshooting
- Export button is grayed out: You don’t have permission. Ask the Page admin to grant you advertiser or admin access in Business Settings.
- CSV file is empty: No leads in the selected date range. Widen the date range or check if your ad is actually running.
- Email notifications not arriving: Check your spam folder. Also, make sure the email address is correctly spelled in Settings. You can only add emails associated with a Facebook user.
- Zapier not sending new leads: Check the Zap’s activity log. Common issues: the Facebook connection expired (reconnect), or the form ID changed (update the Zap).
- Leads appear in Facebook but not in Google Sheets: The field mapping might be wrong. Edit the Zap, re-map the fields, and turn on the Zap again.
- Duplicate leads: This can happen if you have both email notifications and a Zapier integration. It’s normal – just dedupe in your CRM or sheet.
Frequently Asked Questions
Can I export leads from the Facebook mobile app?
No, the Leads Center is only available in the desktop version of Meta Business Suite. You can view leads on mobile, but exporting requires a computer.
How often can I export leads?
As often as you like. There’s no limit on manual exports. For ongoing delivery, the frequency depends on your integration – email is near real-time, while Zapier checks every 1-5 minutes on free plans.
What information is included in the export?
All the fields you added to your lead form: name, email, phone, city, and any custom questions. It also includes the ad name, form name, and the timestamp of the submission.
Can I export leads from multiple ad accounts at once?
No, the Leads Center shows leads from one ad account at a time. You’ll need to switch accounts in the top right dropdown and export separately.
Do I need to pay for ongoing delivery?
Email notifications are free. Zapier has a free tier (up to 100 tasks/month), after which you’ll need a paid plan. CRM integrations are usually free, but some CRMs charge for advanced features.
What happens to leads if I delete the lead form?
You lose access to the leads in the Leads Center. Always export a backup before deleting a form. If you have an integration, it will stop receiving new leads.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this bed
- Fix Unfortunately App Has Stopped: Step-by-Step
- Restart a Frozen Samsung Galaxy A12
- HomePod Stereo Pair with AirPlay 2 from iPhone
- Fix 0x8e5e0247 Error on Windows
- Pixel & Pixel XL No Sound: Solved?
- How to Edit Playlists on iPhone