---
title: "CRM Integration: Google Sheets + Zapier"
description: "Instructions: Setting up Zapier connection with Google Sheets"
---

[Skip to content](https://knowledge.demand-iq.com/crm-integration-google-sheets-zapier#main-content)

English

Show submenu for translations

[CONTACT SUPPORT](https://knowledge.demand-iq.com/kb-tickets/new?hsLang=en)

![Horizontal DIQ Logo with Wordmark light@3x.png\]](https://knowledge.demand-iq.com/hs-fs/hubfs/Horizontal%20DIQ%20Logo%20with%20Wordmark%20light@3x.png?height=36&name=Horizontal%20DIQ%20Logo%20with%20Wordmark%20light@3x.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [CONTACT SUPPORT](https://knowledge.demand-iq.com/kb-tickets/new)
- [Demand IQ](https://demand-iq.com/)

[Demand IQ](https://demand-iq.com/)

 Search the knowledge base...

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://knowledge.demand-iq.com/?hsLang=en)
2. [Legacy Journeys (Stella)](https://knowledge.demand-iq.com/legacy-journeys-stella?hsLang=en)
3. [Integrations](https://knowledge.demand-iq.com/legacy-journeys-stella?hsLang=en#integrations)

# CRM Integration: Google Sheets + Zapier

## Instructions: Setting up Zapier connection with Google Sheets

We will be connecting Zapier with Demand IQ via your unique API Key and exporting data to Google Sheets. 

1\. **Trigger:** New or Updated Lead in Demand IQ 

**App:** Demand IQ 

**Event:** New or Updated Lead

![](https://knowledge.demand-iq.com/hubfs/Screen%20Shot%202022-08-16%20at%201-30-14%20PM-png.png)

![](https://knowledge.demand-iq.com/hubfs/Screen%20Shot%202022-08-16%20at%2011-49-26%20AM-png.png)

Pull API key from the Demand IQ portal in the **Configurator \> Integration tab \> API Key** and paste into API field.

![](https://knowledge.demand-iq.com/hubfs/Screen%20Shot%202022-08-16%20at%2011-52-17%20AM-png.png)

**2. Google Sheet **

Create a Google Sheet and utilize the row fields [here](https://docs.google.com/spreadsheets/d/1ROo0lL4KaFx1a9WDOYQTGttosKfOnFG-KyJxx5ZTacU/edit?usp=sharing). In order to edit, go to **File \> Make a Copy \> Rename sheet**. 

**Action:** Lookup spreadsheet row in Google Sheets  
**App:** Google Sheet  
**Event:** Lookup spreadsheet row  
**Account & Drive:** Select account & drive the Google Sheet was made in  
**Lookup Value:** Type "Email"   
**Bottom-Up:** True  
**Date Created:** Use [this link](https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field) and can use the "Zap\_meta\_human\_now" field

Then, match the below fields with Demand IQ data fields. They should read as the fields are described. You do NOT need to fill out the following fields:   
\- Date Last Updated  
\- Customer Type  
\- Property Type  
\- Property Ownership  
\- Credit Score  
\- Property Living Period  
\- Property Roof Needed  
\- Household Taxable Income  
\- Timeframe  
\- Estimate URL   
\- kWH Usage  
\- Amt Paid  
\- Battery Name  
\- Battery Description  
\- Battery Price  
\- Charger Name  
\- Charger Description  
\- Charger Price

Once this is done, click **Continue & Test Action**. 

- [Getting Started](https://knowledge.demand-iq.com/getting-started?hsLang=en#main-content)

    - [Configure Your Tool](https://knowledge.demand-iq.com/getting-started?hsLang=en#configure-your-tool)
    - [Integrate Your Website](https://knowledge.demand-iq.com/getting-started?hsLang=en#integrate-your-website)
- [Integrations](https://knowledge.demand-iq.com/integrations?hsLang=en#main-content)

    - [Google](https://knowledge.demand-iq.com/integrations?hsLang=en#google)
    - [Zapier](https://knowledge.demand-iq.com/integrations?hsLang=en#zapier)
- [HERO](https://knowledge.demand-iq.com/hero?hsLang=en#main-content)

    - [Getting Started with Hero](https://knowledge.demand-iq.com/hero?hsLang=en#getting-started-with-hero)
    - [Using the Hero App](https://knowledge.demand-iq.com/hero?hsLang=en#using-the-hero-app)
    - [Hero Admin Portal](https://knowledge.demand-iq.com/hero?hsLang=en#hero-admin-portal)
    - [Hero Integrations](https://knowledge.demand-iq.com/hero?hsLang=en#hero-integrations)
- [Legacy Journeys (Stella)](https://knowledge.demand-iq.com/legacy-journeys-stella?hsLang=en#main-content)

    - [Billing](https://knowledge.demand-iq.com/legacy-journeys-stella?hsLang=en#billing)
    - [Integrations](https://knowledge.demand-iq.com/legacy-journeys-stella?hsLang=en#integrations)
- [Best Practices](https://knowledge.demand-iq.com/best-practices?hsLang=en#main-content)

    - [Performance Marketing Tracking](https://knowledge.demand-iq.com/best-practices?hsLang=en#performance-marketing-tracking)
    - [Demand IQ Landing Page](https://knowledge.demand-iq.com/best-practices?hsLang=en#demand-iq-landing-page)

[![Chill listening crop-3](https://knowledge.demand-iq.com/hs-fs/hubfs/Marketing%20Services/Demand%20IQ%20Wide.png?width=224&height=55&name=Demand%20IQ%20Wide.png "Chill listening crop-3")](https://portal.demand-iq.com)

Demand IQ © 2021. All Rights Reserved.

Copyright © 2026, Demand IQ