Automate Facebook Lead Assignment by Location Using Google Sheets

Streamline your sales process by automatically assigning new Facebook leads to sales reps based on location using Google Sheets. This workflow ensures timely and personalized follow-ups by dispatching emails to the appropriate sales representative.

make

This workflow is designed to optimize lead management by integrating Facebook Lead Ads with Google Sheets and email notifications. When a new lead is generated, it is matched with a sales representative based on the lead's location, as stored in a Google Sheet. If a match is found, an email is sent to the sales rep with the lead details. If no match is found, a notification is sent to a default email address.

$3.99
Last updated October 3, 2026
30-day money-back guarantee
Instant download
Lifetime updates included

New buyers can create an account from the cart to unlock a controlled $10 first-purchase credit on eligible orders of $25+.

Secure checkout powered by Stripe

Support

How to import this workflow into Make

  1. 1Purchase or download the workflow to get the Make blueprint JSON file.
  2. 2In Make, create a new scenario, click the three-dots menu, and choose "Import Blueprint".
  3. 3Reconnect each module to your own app connections when prompted.
  4. 4Run the scenario once to verify it, then set your schedule and turn it on.

Related CRM - Sales workflows

More from Jordi Faber

Need this deployed? We'll set it up for you.

Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.