Skip to main content

How to Automatically Send SuperProfile Leads to Google Sheets (With Zapier)

Automatically store every new lead from SuperProfile in a Google Sheet so you can track, analyze, and manage your audience in one place.

Updated yesterday

What is Zapier?

Zapier is a tool that lets you connect SuperProfile with other apps like Google Sheets, HubSpot, MailerLite, and more.

It allows you to automate workflows so that data moves between apps without manual effort.


How This Workflow Works

This automation (called a Zap) has two parts:

  • Trigger → The event that starts the automation

  • Action → The step Zapier takes automatically after the trigger happens

In this example:

  • Trigger: A new lead is created in SuperProfile

  • Action: A new row is added in Google Sheets


What You’ll Achieve

Once set up, every new lead will automatically appear in your Google Sheet, giving you a real-time lead tracker.


When You Should Use This

  • When you want a simple way to store all your leads

  • When you don’t use a CRM yet

  • When you want to track performance across campaigns or content


Before You Start

Make sure you have:

  • A SuperProfile account with leads coming in

  • A Zapier account

  • A Google Sheet created with columns like:

    • Name

    • Email

    • Source (optional)


Step 1: Connect Zapier to SuperProfile

1. Log in to your SuperProfile dashboard

2. Click your profile (bottom-left corner)

3. Go to Account Settings

4. Open the Integrations tab

5. Click Connect next to Zapier

You’ll be redirected to Zapier to log in or sign up.


Step 2: Create a New Zap

After connecting Zapier, you can create your first automation.

  1. Go to Zapier

  2. Click on Create → Zaps
    OR
    Use the Copilot box to describe your workflow

This will open the Zap builder.


Step 3: Setting Up the Trigger (SuperProfile)

Here, again, you can choose to type your prompt into Copilot (and it pretty much handles the rest for you)

OR

You can manually build your zap using the steps below:

Step 1: Set Up the Trigger (SuperProfile)

The trigger is the event that starts your automation.

  1. Click on Trigger

2. Search for and select SuperProfile

3. Choose the trigger event

Here’s what each option means:

  • New Lead → Someone shares their details (email, phone, etc.)

  • Auto DM Lead → A lead comes through your AutoDM funnel

  • New Purchase → Someone buys a product

  • New Follower → Someone follows you on Instagram via SuperProfile

  • Purchase Abandon → Someone starts the checkout process but does not complete the purchase.

  • Subscription Expired → Triggered when a user’s active subscription ends or is not renewed.

In this case, select "New Lead"

4. Select/Login to your SuperProfile account

5. Click Test Trigger

Zapier will pull recent data from your account.

6. Select a sample record and click Continue


Step 2: Set Up the Action (Google Sheets)

The action is what happens after the trigger, and where you tell Zapier how to send data from SuperProfile to the other app.

Example:

  • Email (SuperProfile) → Email (HubSpot)

  • Name (SuperProfile) → Name (MailerLite)

After setting up your Trigger, you should automatically be redirected to the next step (Action), but in the case this doesn't happen:

1. Click on Action

2. Search for and select Google Sheets

3.Choose Create Spreadsheet Row as the action event

4. Connect your Google account and enable all permissions


Step 5: Choose Your Spreadsheet

Fill in the configuration:

  1. Select the spreadsheet you want to use

  2. Select the worksheet (tab inside the sheet)

Make sure your sheet already has column headers (e.g., Name, Email, Source).


Step 6: Map Your Fields

Field mapping is where you match data from SuperProfile to your Google Sheet.

Example:

  • Name → Name column

  • Email → Email column

  • Source/Keyword → Source column

This ensures each lead is added correctly to your sheet.


Step 7: Test Your Zap

  1. Click Test Step

  2. Zapier will send a sample lead to your Google Sheet

Check your sheet to confirm:

  • A new row has been added

  • The data is correct


Step 8: Publish Your Zap

  1. Click Publish

  2. Your Zap is now live


Final Outcome

Every time a new lead is captured in SuperProfile, it will automatically be added to your Google Sheet.

You now have a live, auto-updating database of your leads.


Tips

  • Add a Source column to track where leads come from

  • Use filters in Google Sheets to analyze performance

  • You can later connect this sheet to other tools if needed


Common Issues

  • No data in sheet → Check if the Zap is published

  • Missing fields → Recheck field mapping

  • Duplicate rows → Ensure leads are not being triggered multiple times

Did this answer your question?