company logo

Help center

Go to Seleqt
Powered by
All collectionsIntegrations - CRM, Slack & MoreGoogle Sheets Integration

Google Sheets Integration

Learn how to connect Google Sheets to Seleqt, map fields, and export campaign leads into a spreadsheet in real time.

Overview

The Google Sheets integration allows you to export campaign leads directly into a spreadsheet.

This is useful for:

  • Sharing leads with clients

  • Building live reporting dashboards

  • Internal review and QA

  • Handoff to external teams

Google Sheets integration works at the workspace level, but field mapping is configured during each export.


Step 1: Connect Google Sheets

To connect Google Sheets:

  1. Click your username (bottom-left).

  2. Go to Settings.

  3. Open the Integrations tab.

  4. Click Connect next to Google Sheets.


Google Authentication Flow

You will be redirected to Google.

  1. Select the Google account you want to connect.

  2. If prompted, review permissions.

  3. Click Continue to grant access.

After authorization, you will be returned to Seleqt.
Google Sheets will now appear under Connected Integrations.


Temporary “App Not Verified” Warning (May Appear)

If the app has not yet been verified by Google, you may see a message stating:

“Google hasn’t verified this app.”

To proceed:

  1. Click Advanced.

  2. Select Go to Seleqt (unsafe).

  3. Continue if you trust the developer ([email protected]).

This warning is temporary and will be removed once the app is verified by Google.


Step 2: Export Leads from a Campaign

Once connected:

  1. Open a campaign.

  2. Go to the Leads tab.

  3. Select one or more leads.

  4. Click More actions.

  5. Under Push to CRM, select Google Sheets.

This opens the Export to Google Sheets modal.


Step 3: Select Spreadsheet and Sheet

Inside the export modal:

  1. Select a spreadsheet from your connected Google account.

  2. Select a specific sheet (tab) within that spreadsheet.

You must select both before proceeding.


Step 4: Map Columns

After selecting a sheet, Seleqt displays the existing columns in that sheet.

For each sheet column:

  • Choose a corresponding Seleqt lead field from the dropdown.

  • Or select Skip this column if it should remain empty.

Important Notes

  • Only standard lead fields appear in the dropdown.

  • Custom Lead Qualification columns are not currently available for export.

  • Mapping is configured per export and per sheet.

  • There is no global Google Sheets mapping in Settings.


Step 5: Complete the Export

Once mapping is confirmed:

  • Leads are exported immediately.

  • Each selected lead is added as a new row.

  • Data is appended to the sheet.

If you export additional leads later, new rows will be appended.


How Google Sheets Export Works

  • Data is added as new rows.

  • Existing rows are not updated automatically.

  • Mapping applies only to the selected spreadsheet and sheet.

  • Disconnecting the integration removes access but does not delete exported data.


Best Practices

  • Create a dedicated sheet template before exporting.

  • Name your columns clearly in Google Sheets for easier mapping.

  • Test with a small selection of leads before exporting large batches.

  • Use Google Sheets for reporting and collaboration workflows.

Did this answer your question?
😞
😐
😁