This guide explains how to connect Facebook Lead Ads to Google Sheets using Outfunnel, so every lead form submission automatically creates a new row in your spreadsheet.
How to connect Facebook Lead Ads to Google Sheets
1. Go to App Connector. Head to Outfunnel > App Connector and select Facebook Lead Ads as the source and Google Sheets as the destination.
2. Authenticate your apps. Connect your Facebook account and select the Facebook Page and ad account to use. Then authenticate Google Sheets via OAuth.
3. Select the lead form you want to track. If the form does not appear, click "Refresh fields".
4. Select your spreadsheet and sheet where lead submissions should be recorded. Column headers should already exist in your sheet before mapping.
5. Map the fields. Map your Facebook lead form fields to the columns in your sheet. Email is required as a minimum. If a column is missing, add it to the sheet first then click "Refresh list".
6. Activate the connection. Submit a test lead to confirm a new row appears in your spreadsheet.
💡 If leads are not appearing in Google Sheets, see here for common reasons why syncing may not be working.