--- title: HubSpot + Zapier | Solving for CRM Metro Area Data description: CRM users are frequently frustrated by seemingly simple searches that become far too complicated. For many of our clients, filtering by Metro Area has been a persistent nuisance that we solved with HubSpot Workflows. image: https://blog.goodwood-consulting.com/hubfs/2022-World-Series.jpeg --- [![goodwood-consulting-logo-black](https://blog.goodwood-consulting.com/hs-fs/hubfs/goodwood-consulting-logo-black.png?width=200&height=45&name=goodwood-consulting-logo-black.png "goodwood-consulting-logo-black")](http://www.goodwood-consulting.com/) - [What We Do](https://2538241.hs-sites.com/what-we-do) - [Why Us](https://2538241.hs-sites.com/why-us) - [Our Clients](https://2538241.hs-sites.com/our-clients) - [News & Insights](https://blog.goodwood-consulting.com/news-insights) [![Schedule Call](https://no-cache.hubspot.com/cta/default/2538241/5a415db8-d96f-41db-b2c7-6d21402ba5de.png)](https://cta-redirect.hubspot.com/cta/redirect/2538241/5a415db8-d96f-41db-b2c7-6d21402ba5de) [![goodwood-consulting-logo-black](https://blog.goodwood-consulting.com/hs-fs/hubfs/goodwood-consulting-logo-black.png?width=200&height=45&name=goodwood-consulting-logo-black.png "goodwood-consulting-logo-black")](http://www.goodwood-consulting.com/) - [What We Do](https://2538241.hs-sites.com/what-we-do) - [Why Us](https://2538241.hs-sites.com/why-us) - [Our Clients](https://2538241.hs-sites.com/our-clients) - [News & Insights](https://blog.goodwood-consulting.com/news-insights) [![Schedule Call](https://no-cache.hubspot.com/cta/default/2538241/5a415db8-d96f-41db-b2c7-6d21402ba5de.png)](https://cta-redirect.hubspot.com/cta/redirect/2538241/5a415db8-d96f-41db-b2c7-6d21402ba5de) [![Get Pricing Info](https://no-cache.hubspot.com/cta/default/2538241/75b14b31-7021-4d5f-87d1-d0da97ac8e52.png)](https://cta-redirect.hubspot.com/cta/redirect/2538241/75b14b31-7021-4d5f-87d1-d0da97ac8e52) Search **Menu** [![Schedule Call](https://no-cache.hubspot.com/cta/default/2538241/5a415db8-d96f-41db-b2c7-6d21402ba5de.png)](https://cta-redirect.hubspot.com/cta/redirect/2538241/5a415db8-d96f-41db-b2c7-6d21402ba5de) [![Get Pricing Info](https://no-cache.hubspot.com/cta/default/2538241/75b14b31-7021-4d5f-87d1-d0da97ac8e52.png)](https://cta-redirect.hubspot.com/cta/redirect/2538241/75b14b31-7021-4d5f-87d1-d0da97ac8e52) - [What We Do](https://2538241.hs-sites.com/what-we-do) - [Why Us](https://2538241.hs-sites.com/why-us) - [Our Clients](https://2538241.hs-sites.com/our-clients) - [News & Insights](https://blog.goodwood-consulting.com/news-insights) [Insights for Financial Services Leaders: CRM, Marketing & Sales Strategy](https://blog.goodwood-consulting.com/news-insights) # HubSpot + Zapier | Solving for CRM Metro Area Data by [Ryan Thibodeaux](https://blog.goodwood-consulting.com/news-insights/author/ryan-thibodeaux), November 2022 CRM users are frequently frustrated by seemingly simple searches that become far too complicated. All alliteration antics aside, we love solving for these daily challenges with automations that are easy to implement and manage. For many of our clients, filtering by Metro Area has been a persistent nuisance. For example, let's say you want to find all Customers in your CRM in the Houston Metro Area to send them a congratulatory note, as well as send your condolences to those in Philly. Do you filter by City and State? No, that won't work since the Houston Metro Area is over 10,000 square miles, includes nine counties and is the fifth most populous MSA in the country[1](https://www.statista.com/statistics/815178/houston-metro-area-population/). We set out to solve this problem once and for all. Here's how we did it.  1. Acquire Metropolitan Statistical Area source data that includes City, State and Zip Codes[2 ](https://www.zipinfo.com/products/z5ma/z5ma.htm) 2. Prepare your Source Data and your CRM by: 1. Standardizing City and State values in Contact records 2.  Create custom "lookup" properties by concatenating city\_state in Source Data file and CRM Contact records for matching 3. Create custom Contact record properties for Metro Area using "pick-lists", not text fields, comprised of all unique values from Source Data - this will make CRM filtering significantly more user friendly ![create-custom-contact-records](https://blog.goodwood-consulting.com/hs-fs/hubfs/image-png-1.png?width=300&height=413&name=image-png-1.png)   3. Automate the process of finding Metro Area for Contact records across your entire CRM, both current and going forward with Workflows. 4. [HubSpot CRM + Operations Hub Pro ](https://blog.hubspot.com/customers/the-ultimate-guide-to-operations-hub) 1. Using HubSpot Workflows with Operations Hub features enables Contact workflows to [trigger webhooks ](https://knowledge.hubspot.com/workflows/how-do-i-use-webhooks-with-hubspot-workflows) 2. This will allow you to make requests to external data sources using data from your HubSpot CRM.  5. [Webhooks by Zapier Integrations](https://zapier.com/apps/webhook/integrations) 1. Using Zapier webhooks as triggers, you can process the data request that your HubSpot Workflow is making 6. [Google Sheets Zapier Integrations](https://zapier.com/apps/google-sheets/integrations) 1. Using Google Sheets, you can host your MSA Source Data file for your Zapier integrations to access 7. [HubSpot Zapier Integrations](https://zapier.com/apps/hubspot/integrations) 1. Finally, you can send the Metro Area data back to HubSpot to be stored in the Contact records you've requested.  ![hubspot-zapier-integrations](https://blog.goodwood-consulting.com/hs-fs/hubfs/image-png-2.png?width=693&height=169&name=image-png-2.png) Need help? That's what we do, among other things.... [![Schedule a Call](https://no-cache.hubspot.com/cta/default/2538241/3f73daf1-7696-4ab8-927e-cfb6484c4fb1.png)](https://cta-redirect.hubspot.com/cta/redirect/2538241/3f73daf1-7696-4ab8-927e-cfb6484c4fb1) Topics:[HubSpot](https://blog.goodwood-consulting.com/news-insights/topic/hubspot)[Automation](https://blog.goodwood-consulting.com/news-insights/topic/automation)[Workflows](https://blog.goodwood-consulting.com/news-insights/topic/workflows)[Zapier](https://blog.goodwood-consulting.com/news-insights/topic/zapier) - [Recent](https://blog.goodwood-consulting.com/news-insights/hubspot-zapier-solving-for-crm-metro-area-data#recent) - [Topics](https://blog.goodwood-consulting.com/news-insights/hubspot-zapier-solving-for-crm-metro-area-data#topics) - [Archive](https://blog.goodwood-consulting.com/news-insights/hubspot-zapier-solving-for-crm-metro-area-data#archive) - [Assets for Autism (1)](https://blog.goodwood-consulting.com/news-insights/tag/assets-for-autism) - [Automation (9)](https://blog.goodwood-consulting.com/news-insights/tag/automation) - [Compliance (2)](https://blog.goodwood-consulting.com/news-insights/tag/compliance) - [Content Distribution (4)](https://blog.goodwood-consulting.com/news-insights/tag/content-distribution) - [Content Management System (1)](https://blog.goodwood-consulting.com/news-insights/tag/content-management-system) - [CRM (8)](https://blog.goodwood-consulting.com/news-insights/tag/crm) - [Email Marketing (3)](https://blog.goodwood-consulting.com/news-insights/tag/email-marketing) - [HubSpot (18)](https://blog.goodwood-consulting.com/news-insights/tag/hubspot) - [Insycle (1)](https://blog.goodwood-consulting.com/news-insights/tag/insycle) - [Meet the Team (3)](https://blog.goodwood-consulting.com/news-insights/tag/meet-the-team) - [News (4)](https://blog.goodwood-consulting.com/news-insights/tag/news) - [Sequences (4)](https://blog.goodwood-consulting.com/news-insights/tag/sequences) - [Workflows (5)](https://blog.goodwood-consulting.com/news-insights/tag/workflows) - [Zapier (1)](https://blog.goodwood-consulting.com/news-insights/tag/zapier) More... - [January 2025 (6)](https://blog.goodwood-consulting.com/news-insights/archive/2025/01) - [August 2019 (2)](https://blog.goodwood-consulting.com/news-insights/archive/2019/08) - [August 2020 (2)](https://blog.goodwood-consulting.com/news-insights/archive/2020/08) - [August 2024 (2)](https://blog.goodwood-consulting.com/news-insights/archive/2024/08) - [December 2024 (2)](https://blog.goodwood-consulting.com/news-insights/archive/2024/12) - [June 2025 (2)](https://blog.goodwood-consulting.com/news-insights/archive/2025/06) - [July 2025 (2)](https://blog.goodwood-consulting.com/news-insights/archive/2025/07) - [March 2019 (1)](https://blog.goodwood-consulting.com/news-insights/archive/2019/03) - [September 2019 (1)](https://blog.goodwood-consulting.com/news-insights/archive/2019/09) - [October 2019 (1)](https://blog.goodwood-consulting.com/news-insights/archive/2019/10) - [December 2019 (1)](https://blog.goodwood-consulting.com/news-insights/archive/2019/12) - [September 2020 (1)](https://blog.goodwood-consulting.com/news-insights/archive/2020/09) - [March 2021 (1)](https://blog.goodwood-consulting.com/news-insights/archive/2021/03) - [April 2021 (1)](https://blog.goodwood-consulting.com/news-insights/archive/2021/04) - [June 2021 (1)](https://blog.goodwood-consulting.com/news-insights/archive/2021/06) - [October 2021 (1)](https://blog.goodwood-consulting.com/news-insights/archive/2021/10) - [November 2022 (1)](https://blog.goodwood-consulting.com/news-insights/archive/2022/11) - [February 2023 (1)](https://blog.goodwood-consulting.com/news-insights/archive/2023/02) - [December 2023 (1)](https://blog.goodwood-consulting.com/news-insights/archive/2023/12) - [May 2024 (1)](https://blog.goodwood-consulting.com/news-insights/archive/2024/05) - [September 2024 (1)](https://blog.goodwood-consulting.com/news-insights/archive/2024/09) More... ### Subscribe to Updates & Insights ### Goodwood Consulting 4750 Bluebonnet Blvd Suite B Baton Rouge, LA 70809 [info@goodwood-consulting.com](mailto:info@goodwood-consulting.com) (225) 577-5418[tel:2255775418](tel:2255775418) ##### Goodwood Governance  - [Website Privacy Policy](https://info.goodwood-consulting.com/website-privacy-policy) - [Client Privacy Policy](https://info.goodwood-consulting.com/client-privacy-policy) - [Cybersecurity Policy](https://info.goodwood-consulting.com/goodwood-cybersecurity-policy) - [Business Continuity Plan](https://info.goodwood-consulting.com/business-continuity-plan) - [What We Do](https://2538241.hs-sites.com/what-we-do) - [Why Us](https://2538241.hs-sites.com/why-us) - [Our Clients](https://2538241.hs-sites.com/our-clients) - [News & Insights](https://blog.goodwood-consulting.com/news-insights) - [Our Holiday Hours](https://2538241.hs-sites.com/holiday-hours) [![Hubspot-Academy-Accreditation](https://blog.goodwood-consulting.com/hs-fs/hubfs/Accreditations534x534.png?width=170&height=170&name=Accreditations534x534.png "Hubspot-Academy-Accreditation")](https://ecosystem.hubspot.com/marketplace/solutions/goodwood-capital-management) ### Drop us a line Copyright © | Goodwood Consulting | All Rights Reserved. ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Ryan Thibodeaux", "url" : "https://blog.goodwood-consulting.com/news-insights/author/ryan-thibodeaux" }, "dateModified" : "2022-11-14T17:18:45.688Z", "datePublished" : "2022-11-09T13:00:00.000Z", "headline" : "HubSpot + Zapier | Solving for CRM Metro Area Data", "mainEntityOfPage" : { "@id" : "https://blog.goodwood-consulting.com/news-insights/hubspot-zapier-solving-for-crm-metro-area-data", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.goodwood-consulting.com/hubfs/goodwood-consulting-logo-black.png" }, "name" : "Goodwood Consulting" } } ```