4.1 Overview

The Leads section is the central contact-management area of AIUNIFY Assistant. It stores the individuals and organizations that AI Agents may call through outbound Campaigns or associate with other calling activity.

A Lead can contain:

Name
Telephone number
Company
Custom information fields
Tags
Creation date
Record owner

The Leads page also provides tools for:

Adding one Lead manually
Editing an existing Lead
Searching by name or telephone number
Filtering by Tags
Showing or hiding custom-field columns
Selecting multiple Leads
Adding Tags in bulk
Deleting Leads
Importing CSV files
Connecting Google Sheets
Synchronizing spreadsheet records

The instructions in this chapter are based on the reviewed AIUNIFY Assistant application source bundle.

Understanding Lead Records

4.2 What Is a Lead?

A Lead is a contact record that can be selected for a Campaign and associated with calling activity.

Examples include:

Prospective customer
Existing customer
Appointment prospect
Sales inquiry
Service applicant
Event registrant
Previous caller
Follow-up contact
Member or subscriber

Creating a Lead does not automatically call the person. The Lead must ordinarily be assigned to a Campaign or used during another supported call process.

4.3 Lead Record Structure

The underlying Lead record contains these primary elements:

name
phone
fields
tags
createdBy
createdAt
updatedAt

The fields element supports additional information as name-and-value pairs. The Lead model requires both a name and telephone number and automatically records ownership and timestamps.

4.4 Required Lead Information

The two required pieces of Lead information are:

Name
Phone

A Lead cannot be created through the normal interface without both values.

The application does not require a company, Tag, email address, city, state, or other custom information.

4.5 Lead Name

The Name field identifies the contact in:

The Leads table
Campaign Lead selection
Recent Activity
Call Logs
Appointments
Call analysis

Use a recognizable name whenever possible.

Recommended:

Danielle Carter
Marcus Hill
Northwind Billing Department
ABC Manufacturing Reception

Avoid unclear values such as:

Lead 1
Unknown Person
New Contact
Phone Number
Test

The CSV importer may assign Unknown when a row contains a telephone number but no name. That record can be corrected later.

4.6 Telephone Number

The Phone field is required because AIUNIFY Assistant uses it as the contact destination.

The backend normalizes telephone numbers by removing every character that is not a number.

Example:

Entered: +1 (313) 555-0198
Stored: 13135550198

Example:

Entered: 313-555-0198
Stored: 3135550198

Example:

Entered: +44 20 7946 0958
Stored: 442079460958

Parentheses, spaces, plus signs, and hyphens are removed, while the actual digits remain.

4.7 Country Codes

Store the country code as part of the number when the provider or calling configuration requires international format.

Recommended United States format:

13135550198

Recommended United Kingdom format:

442079460958

Do not rely on the system to determine which country code should be added. It removes formatting characters but does not infer a missing country code.

4.8 Extensions

The Lead model stores one normalized digit string. A telephone extension entered inside the Phone field can become part of that digit string.

Example:

Entered: 313-555-0198 ext. 204
Stored: 3135550198204

That can create an invalid destination number.

Store the direct-dial number in the Phone field. Place extension instructions in a custom field when needed.

4.9 Custom Fields

Custom fields allow Lead records to contain additional information.

Examples:

company
email
city
state
industry
budget
source
account_number
preferred_time
product_interest

Each custom field is stored as:

Field name
Field value

Custom fields are especially useful when importing Leads from CSV or Google Sheets.

4.10 Company Field

The manual Add Lead and Edit Lead forms provide a Company field.

Company is not a separate top-level Lead property. The interface saves it as a custom field similar to:

Name: company
Value: Northwind Industries

This allows Company to appear as an optional column in the Leads table.

4.11 Email Addresses

The inspected Lead model does not contain a dedicated top-level email property.

An email address can still be stored as a custom field:

Name: email
Value: danielle@example.com

Email information is most conveniently imported as an additional CSV or Google Sheets column.

4.12 Lead Status

The Lead record itself does not contain a built-in status field such as:

New
Contacted
Qualified
Converted
Lost

Status-like organization can be created with Tags or a custom field.

Examples:

Tag: qualified
Tag: follow-up
Tag: appointment-booked
Tag: not-interested

A custom field could also be imported:

status,priority
qualified,high

A custom status field does not automatically control Campaign behavior unless a user filters or selects Leads accordingly.

4.13 Tags

Tags are short labels used to organize and identify Leads.

Examples:

new-lead
customer
high-priority
follow-up
detroit
q3-campaign
event-registrant
google-sheets
do-not-call

A Lead can have more than one Tag.

4.14 Record Ownership

Each Lead is associated with the account that created or imported it.

A normal user generally receives only Leads owned by that account. A Super Administrator can retrieve a broader, platform-level Lead list.

Editing, bulk tagging, and deleting by a normal user are also restricted to records owned by that user.

Opening the Leads Section

4.15 Accessing Leads

After signing in:

  1. Locate Leads in the Sidebar.
  2. Select it once.
  3. Wait for the loading indicator to disappear.
  4. Confirm that the page heading displays Leads.
  5. Review the number of contacts shown in the page description.

The page describes itself as centralized management for the account’s contacts and prospects.

4.16 Leads Page Controls

The top area can contain:

Google Sheets
Import CSV
Add Lead
Search by name or phone
Filter by Tags
Visible Fields
Clear

The table below these controls contains the Lead records.

4.17 Empty Lead Account

When the account contains no Leads, the page displays:

No Leads Yet

The user is prompted to add the first Lead or import Leads from CSV.

The empty state provides direct access to:

Import CSV
Add Lead


4.18 Lead Loading Indicator

While the application retrieves Lead records, a rotating loading indicator appears.

During this period:

  1. Allow the request to finish.
  2. Do not repeatedly select Leads.
  3. Do not submit an import twice.
  4. Confirm the login session remains active.
  5. Refresh only after a reasonable wait.

Adding a Lead Manually

4.19 Opening Add Lead

To add one contact manually:

  1. Open Leads.
  2. Select Add Lead.
  3. Complete the form.
  4. Review the number carefully.
  5. Select Save Lead.

The form contains Name, Phone, optional Company, and comma-separated Tags.

4.20 Add Lead Fields

The Add New Lead form contains:

Name
Phone
Company (Optional)
Tags (Comma separated)

Name and Phone are required.

4.21 Entering the Name

Enter the full personal or organizational name.

Example:

Name: Alicia Thompson

For a business contact where the person is unknown:

Name: Thompson Logistics Reception

A meaningful name improves Campaign selection and Call Log review.

4.22 Entering the Phone Number

The form provides an example similar to:

+1234567890

A formatted number may be entered, but the application removes all nonnumeric characters before storing it.

Enter the complete callable destination, including country code where necessary.

4.23 Entering Company

Company is optional.

Example:

Company: Thompson Logistics

When present, it is saved inside the Lead’s custom fields.

4.24 Entering Tags

Separate multiple Tags with commas.

Example:

customer, logistics, high-priority

The interface:

  1. Separates the text at each comma.
  2. Removes extra spaces surrounding each Tag.
  3. Omits empty values.
  4. Sends the resulting Tag list with the Lead.

Example:

Entered:
customer, follow-up, , detroit

Saved:
customer
follow-up
detroit

4.25 Saving the Lead

Select:

Save Lead

While processing, the button displays:

Saving...

After a successful save, the Lead list refreshes.

Do not select the Save button repeatedly.

4.26 Canceling Add Lead

Select:

Cancel

to close the dialog without creating the Lead.

Information typed into the unsaved form may be lost.

4.27 Add Lead Plan Requirements

Creating a Lead requires:

An authenticated account
An active Plan or applicable trial
Available Lead capacity

When the account reaches its Lead allowance, the backend can return:

You have reached your limit of [number] leads.
Please upgrade your plan to add more.


4.28 Lead-Created Automation Event

Creating one Lead manually triggers the platform’s leadCreated webhook event.

When the account has a corresponding webhook enabled, another authorized system may receive information about the new Lead. Bulk imports do not show the same individual webhook trigger in the reviewed bulk route.

Viewing the Leads Table

4.29 Table Columns

The Leads table can display:

Selection checkbox
Name
Phone
Visible custom fields
Tags
Added On
Actions

The custom-field columns change according to the records and the user’s Visible Fields selections.

4.30 Name Column

The Name column displays the stored Lead name.

This name can later appear in:

Campaigns
Call Logs
Appointments
Dashboard activity
Call analysis

4.31 Phone Column

The Phone column displays the normalized telephone digits stored in the Lead record.

The visible number may not contain:

+
Spaces
Parentheses
Hyphens

That is expected because the backend removes nonnumeric characters.

4.32 Custom-Field Columns

Every distinct custom-field name found among the loaded Leads can become an optional column.

Example records:

Lead A fields:
company
email

Lead B fields:
company
city
industry

Available Visible Fields can include:

company
email
city
industry

A Lead without a value for a selected field displays an empty table cell for that column.

4.33 Tags Column

Tags are displayed as labels or badges.

A Lead may show:

customer
follow-up
detroit

Long Tag lists can make the table wider or more visually crowded. Use concise Tags.

4.34 Added On Column

The Added On column represents the Lead record’s creation timestamp.

This is the date the Lead entered AIUNIFY Assistant, not necessarily the date the person first contacted the business.

4.35 Actions Menu

The final column contains a menu for actions such as:

Edit
Delete

Open the menu associated with the correct Lead before making changes.

Searching Leads

4.36 Search Box

The Leads page contains:

Search by name or phone...

Search checks:

Lead name
Telephone number

It does not search Tags or all custom-field values in the inspected interface.

4.37 Searching by Name

Name search is not case-sensitive.

Example:

Stored name: Danielle Carter
Search: danielle
Result: Danielle Carter

Example:

Search: CARTER
Result: Danielle Carter

4.38 Searching by Phone

Telephone search matches digits contained within the stored number.

Example:

Stored: 13135550198
Search: 5550198
Result: Match

Searching with formatting may not match as expected because stored numbers contain digits only.

Recommended:

Search: 3135550198

Instead of:

Search: (313) 555-0198

4.39 Search and Tag Filters Together

Search and Tag filters are applied together.

Example:

Search: Danielle
Selected Tag: follow-up

The page displays only Leads that:

Match the search
AND
Contain the selected Tag

4.40 No Leads Found

When Leads exist but none match the active search or Tag filters, the page displays:

No leads found
No leads match your current search or tag filters.

Select:

Clear all filters

to restore the complete list.

Filtering by Tags

4.41 Opening the Tag Filter

Select the Tag filter control.

The menu displays the distinct Tags discovered among the loaded Lead records.

4.42 Selecting One Tag

Select a Tag such as:

follow-up

Only Leads containing that Tag remain visible.

4.43 Selecting Multiple Tags

When more than one Tag is selected, the inspected page uses all-selected-Tags logic.

Example:

Selected:
customer
high-priority

A Lead must contain both Tags to remain visible.

The logic is:

customer AND high-priority

It is not:

customer OR high-priority


4.44 Tag Filter Count

When Tags are selected, the control can show:

Tags (2)

The number indicates how many Tag filters are active.

4.45 Persistent Tag Filters

The inspected interface stores selected Tag filters in the browser’s local storage.

Consequently, returning to the Leads page on the same browser can restore the previous Tag selection.

A user may believe Leads are missing when an earlier filter is still active.

4.46 Clearing Tag Filters

Use one of these methods:

Deselect each active Tag
Select Clear
Select Clear all filters from the empty search result

The Clear control can also reset custom-column choices.

Managing Visible Fields

4.47 Visible Fields Control

Select:

Visible Fields

to choose which custom fields appear as table columns.

The list is built from the custom-field names contained in the loaded Leads.

4.48 Hiding a Custom Field

To hide a column:

  1. Open Visible Fields.
  2. Find the field.
  3. Clear its checkbox.
  4. Close the menu.

The field remains stored in the Lead record. Only its table column is hidden.

4.49 Showing a Custom Field

To restore a column:

  1. Open Visible Fields.
  2. Select the field.
  3. Close the menu.

4.50 Persistent Column Choices

Visible-column preferences are stored in the current browser’s local storage.

The settings can remain after:

Leaving the Leads page
Signing back in on the same browser
Refreshing the page

Another browser or device may have different choices.

4.51 Resetting Visible Fields

Select:

Clear

to return to the default behavior of displaying all discovered custom fields.

The Clear action also removes selected Tag filters in the inspected page.

4.52 Wide Lead Tables

A CSV or Google Sheets import with many columns can create many available custom fields.

To improve readability:

  1. Open Visible Fields.
  2. Keep only operationally relevant fields.
  3. Hide long notes or rarely used values.
  4. Review detailed information in the source spreadsheet when appropriate.

Editing a Lead

4.53 Opening Edit Lead

To edit:

  1. Locate the Lead.
  2. Open the row’s Actions menu.
  3. Select Edit.
  4. Change the appropriate fields.
  5. Select Save Changes.

4.54 Editable Fields

The inspected Edit Lead form contains:

Name
Phone
Company
Tags

The Tags field uses comma-separated values.

4.55 Editing the Name

Changing the name updates how the Lead appears in future interface views.

Historical Call Logs associated with the Lead may display the updated populated name when reloaded.

4.56 Editing the Phone

The backend normalizes the updated number by removing nonnumeric characters.

After changing a phone number:

  1. Confirm the country code.
  2. Check the total digit count.
  3. Confirm the Lead is not active in a running Campaign.
  4. Perform a controlled test where appropriate.

4.57 Editing Tags

The Edit Lead form sends the complete Tags list shown in the field.

This means editing Tags replaces the Lead’s existing Tag array with the newly submitted list.

Example:

Existing Tags:
customer, q2, follow-up

Edited field:
customer, qualified

Saved Tags:
customer
qualified

The removed Tags q2 and follow-up no longer remain on that Lead.

4.58 Critical Custom-Field Warning

The inspected Edit Lead form submits only:

Company

as its custom-field payload. When Company is blank, it submits an empty custom-fields list.

Therefore, saving a Lead through the current Edit dialog can remove other custom fields that were originally imported from CSV or Google Sheets.

Example before editing:

company: Northwind
email: jane@example.com
city: Detroit
industry: Manufacturing

The user changes only the telephone number and selects Save Changes.

Possible resulting custom fields:

company: Northwind

The email, city, and industry values may be removed because the edit request replaces the fields array with only Company. This behavior is visible in the reviewed frontend implementation.

4.59 Protecting Imported Custom Fields

Before editing an imported Lead:

  1. Note all custom information.
  2. Determine whether the Lead is managed by Google Sheets.
  3. Correct the source spreadsheet when possible.
  4. Synchronize again after making the spreadsheet correction.
  5. Use the Edit dialog only after understanding the custom-field limitation.

For spreadsheet-managed Leads, editing the spreadsheet is generally safer for preserving all mapped fields.

4.60 Canceling an Edit

Select:

Cancel

to close the form without submitting the changes.

4.61 Edit Errors

An edit can fail because:

The Lead no longer exists
The Lead belongs to another user
The authentication token expired
The telephone value is invalid or blank
The server request failed

The dialog displays the backend error when available or:

Failed to update lead

Selecting Leads

4.62 Individual Selection

Each row includes a checkbox.

Select the checkbox to include that Lead in a bulk action.

4.63 Selecting All Visible Leads

The checkbox in the table header selects all Leads currently passed into the visible table.

Because the table receives the filtered result, selecting all while a search or Tag filter is active selects the currently displayed matching Leads rather than every Lead in the account.

4.64 Example of Filtered Selection

Assume the account contains:

Total Leads: 500
Filtered Tag: follow-up
Visible Leads: 42

Selecting the header checkbox selects the 42 visible follow-up Leads.

Always review the active search and Tag filters before using a bulk action.

4.65 Clearing Selection

Clear the header checkbox or clear individual row checkboxes.

After a successful bulk deletion, the inspected interface clears the selected IDs automatically.

Bulk Adding Tags

4.66 Purpose of Bulk Tags

Bulk Tags allow the same organizational labels to be applied to several selected Leads at once.

Common uses include:

campaign-july
priority
event-attendee
follow-up
regional-team-a
product-interest-solar

4.67 Opening Bulk Add Tags

  1. Select the appropriate Leads.
  2. Open the bulk actions control.
  3. Select Add Tags.
  4. Enter one or more comma-separated Tags.
  5. Select Add Tags.

4.68 Tag Entry

Example:

priority, follow-up, q3

At least one nonblank Tag is required.

4.69 How Bulk Tags Are Applied

The backend uses an add-to-set operation.

That means:

  1. New Tags are added.
  2. Existing Tags remain.
  3. An identical Tag is not added to the same Lead twice.

Example:

Existing:
customer, follow-up

Bulk add:
follow-up, high-priority

Result:
customer, follow-up, high-priority


4.70 Bulk Tag Ownership

A normal user can bulk-tag only owned Lead records.

A Super Administrator can perform the operation across the IDs available within the administrative scope.

4.71 Bulk Tags Cannot Remove Tags

The bulk dialog adds Tags. It does not provide a bulk Tag-removal operation in the inspected interface.

Removing a Tag requires editing individual Leads or implementing an authorized administrative data process.

Deleting Leads

4.72 Deleting One Lead

To delete one Lead:

  1. Locate the Lead.
  2. Open the row’s Actions menu.
  3. Select Delete.
  4. Review the confirmation.
  5. Approve the deletion.

4.73 Deleting Multiple Leads

To delete several Leads:

  1. Apply the correct search or Tag filter.
  2. Select the intended records.
  3. Open the bulk action control.
  4. Select Delete.
  5. Review the number shown in the confirmation.
  6. Approve only when correct.

The interface asks:

Are you sure you want to delete [number] lead(s)?


4.74 Permanent Deletion

The inspected Leads interface does not show a Lead recycle bin, archive state, or restoration function.

Treat deletion as permanent.

Before deleting:

Export or preserve required information
Review active Campaign assignments
Review compliance-retention requirements
Confirm the records are not needed for follow-up
Confirm the selected count

4.75 Lead Deletion and Historical Activity

The reviewed bulk-delete route removes Lead records. It does not show a corresponding cascade deletion of Campaigns or Call Logs.

As an operational inference, historical calling records may remain, but their populated Lead information could become unavailable or incomplete after the Lead is deleted.

Preserve Leads associated with required reporting or audit history unless an approved retention policy permits deletion.

4.76 Canceling Deletion

Select Cancel or dismiss the browser confirmation to leave the Leads unchanged.

Preparing a CSV File

4.77 CSV Import Overview

CSV import is appropriate when Leads already exist in:

Microsoft Excel
Apple Numbers
Google Sheets
CRM exports
Registration systems
Survey exports
Contact databases

The source must be saved as a .csv file.

4.78 Required CSV Headers

Use these exact lowercase headers:

name
phone

The importer identifies these properties directly.

Recommended starting structure:


name,phone
Danielle Carter,13135550198
Marcus Hill,12485550147

The reviewed importer separates exact name and phone properties from every other column.

4.79 Header Capitalization

Use:

name
phone

Avoid:

Name
Phone
PHONE NUMBER
Telephone
Contact

The client-side CSV parser expects properties named name and phone. Different capitalization or wording can cause those values not to be recognized.

4.80 Company Column

Company is optional.

Example:


name,phone,company
Danielle Carter,13135550198,Carter Consulting

Because every column other than name and phone becomes a custom field, Company is imported as:

company: Carter Consulting

4.81 Additional Custom Columns

Additional headers become custom fields.

Example:


name,phone,company,email,city,industry
Danielle Carter,13135550198,Carter Consulting,danielle@example.com,Detroit,Consulting

The Lead can receive:

company: Carter Consulting
email: danielle@example.com
city: Detroit
industry: Consulting

4.82 Recommended CSV Example


name,phone,company,email,city,state,source
Danielle Carter,+1 (313) 555-0198,Carter Consulting,danielle@example.com,Detroit,MI,Website
Marcus Hill,12485550147,Hill Services,marcus@example.com,Southfield,MI,Referral
Alicia Thompson,13135550172,Thompson Logistics,alicia@example.com,Dearborn,MI,Event

The telephone formatting is normalized after upload.

4.83 Saving from Excel

In Microsoft Excel:

  1. Confirm Row 1 contains the headers.
  2. Confirm each Lead occupies one row.
  3. Confirm no merged cells exist.
  4. Select File.
  5. Select Save As.
  6. Choose CSV UTF-8 or another compatible CSV format.
  7. Save the file.
  8. Review any compatibility message.
  9. Upload the resulting .csv file.

4.84 Saving from Google Sheets

In Google Sheets:

  1. Open the spreadsheet.
  2. Confirm the active sheet contains the correct data.
  3. Select File.
  4. Select Download.
  5. Select Comma Separated Values (.csv).
  6. Save the file.
  7. Upload it through AIUNIFY Assistant.

Google Sheets direct synchronization is covered later in this chapter.

4.85 One Lead per Row

Each row should represent one Lead.

Correct:


name,phone
Danielle Carter,13135550198
Marcus Hill,12485550147

Incorrect:


name,phone
Danielle Carter and Marcus Hill,13135550198 and 12485550147

4.86 Blank Rows

The CSV parser skips empty lines.

Blank rows do not create Leads.

4.87 Blank Names

When a row contains a telephone number but no Name value, the importer assigns:

Unknown

Example:


name,phone
,13135550198

Result:

Name: Unknown
Phone: 13135550198

Correct missing names before import whenever possible.

4.88 Blank Phone Numbers

Rows without a recognized Phone value are removed from the import list.

When every row lacks a valid recognized phone property, the interface reports:

No valid leads found in CSV


4.89 Commas Inside Values

When a company or other value contains a comma, the CSV application should place the value in quotation marks.

Example:


name,phone,company
Danielle Carter,13135550198,"Carter, Smith & Associates"

Saving through Excel or Google Sheets generally handles this automatically.

4.90 Leading Zeros

Spreadsheet applications can remove leading zeros from telephone numbers stored as numeric cells.

Format telephone-number columns as text before saving.

This is especially important for countries where national numbers begin with zero.

4.91 Scientific Notation

Long numbers can appear as:

1.31356E+10

A telephone number saved in scientific notation can import incorrectly.

Set the column format to plain text and verify the exported CSV in a text editor when necessary.

Importing the CSV

4.92 Opening Import CSV

  1. Open Leads.
  2. Select Import CSV.
  3. Select the CSV File field.
  4. Choose the prepared file.
  5. Optionally enter Tags.
  6. Select Upload.

4.93 File Selection

The dialog accepts:

.csv

After selection, the filename appears below the file control.

Confirm it is the correct file before uploading.

4.94 Applying Tags to the Import

The field:

Add Tags to all (comma separated)

applies the same Tags to every imported Lead.

Example:

new-leads, july-import, website

Every successfully parsed Lead receives those Tags.

4.95 CSV Parsing Process

The importer:

  1. Reads Row 1 as headers.
  2. Skips blank lines.
  3. Extracts name.
  4. Extracts phone.
  5. Converts every remaining column into a custom field.
  6. Applies the entered bulk Tags.
  7. Removes rows without a phone.
  8. Sends the resulting Lead list to the bulk Lead endpoint.


4.96 Upload Status

While processing, the button displays:

Uploading...

Do not close the browser or select Upload again during processing.

4.97 Successful Import

After success, the interface reports:

[number] leads imported successfully!

The Leads page then refreshes.

The displayed count represents the Lead objects produced by the CSV parser and submitted for insertion.

4.98 CSV Imports and Duplicate Leads

The reviewed CSV bulk-import route inserts the submitted Lead list directly.

It does not show a telephone-number uniqueness check or duplicate-prevention process.

Uploading the same file twice can therefore create duplicate Lead records.

4.99 Duplicate Example

First import:

Danielle Carter — 13135550198

Second import of the same file:

Danielle Carter — 13135550198

Possible result:

Two separate Lead records

Both records can later be selected for Campaigns.

4.100 Preventing CSV Duplicates

Before importing:

  1. Sort the source by Phone.
  2. Remove duplicate numbers.
  3. Search AIUNIFY Assistant for existing numbers.
  4. Add a unique import Tag.
  5. Import a small test group.
  6. Confirm the results.
  7. Import the remaining records once.

4.101 CSV Import and Plan Limits

CSV import requires an active Plan and available Lead capacity.

A large import that exceeds the account’s permitted Lead limit can fail.

For large lists:

  1. Review the current Lead count.
  2. Review the Plan limit.
  3. Remove obsolete or duplicate records according to policy.
  4. Divide the file into controlled batches.
  5. Confirm the first batch before continuing.

4.102 Partial CSV Quality

The frontend builds the import list before submitting it.

Rows without Phone are excluded. Rows with a Phone but no Name become Unknown.

Review the Lead count after import because the number of saved Leads may differ from the original spreadsheet row count.

4.103 Import Error

Possible messages include:

Please select a CSV file
No valid leads found in CSV
Error parsing CSV: [details]
Failed to import leads

Possible causes include:

Incorrect file type
Incorrect header names
Corrupt CSV formatting
Blank Phone column
Expired login session
Plan limit reached
Server request failure

Google Sheets Integration

4.104 Google Sheets Overview

The Google Sheets integration allows the user to connect a Google account, select a spreadsheet and sheet tab, map columns, and synchronize Lead information into AIUNIFY Assistant.

The dialog describes the feature as:

Import and keep your leads synced with Google Sheets.


4.105 Advantages of Google Sheets

Google Sheets synchronization can be preferable when:

A team maintains Leads in one spreadsheet
New records are added regularly
Custom fields change over time
The same source must be synchronized again
Duplicate telephone numbers must be controlled
Manual CSV downloads are inconvenient

4.106 Google Account Requirements

The user needs:

An authenticated AIUNIFY Assistant account
A Google account
Access to the intended spreadsheet
An active AIUNIFY Plan or trial
Available Lead capacity

The application requests Google authorization to list and read the necessary spreadsheet information.

Connecting Google Sheets

4.107 Opening Google Sheets

  1. Open Leads.
  2. Select Google Sheets.
  3. Review the connection screen.
  4. Select Connect Now.

4.108 Connect Now

Selecting Connect Now starts the Google Sheets OAuth process.

The application uses the signed-in AIUNIFY Assistant user ID when beginning the connection.

When the browser cannot find the local AIUNIFY user information, it can display:

User not found. Please log in again.

4.109 Google Authorization

During Google authorization:

  1. Select the intended Google account.
  2. Review the requested permissions.
  3. Approve only when the account and application are correct.
  4. Wait for the browser to return to AIUNIFY Assistant.

Do not connect a personal Google account when organizational policy requires a managed business account.

4.110 Successful Connection

After successful authorization, the backend stores the Google connection state and tokens in the user’s Settings record and returns the browser to the Leads page with a connection result.

4.111 Connection Error

When Google authorization fails, the browser returns to the Leads page with an error result.

Possible causes include:

Authorization canceled
Incorrect Google API configuration
Callback URL mismatch
Expired authorization code
Missing Google permissions
Server configuration error

Selecting a Spreadsheet

4.112 Available Spreadsheets

Once connected, the application requests a list of Google spreadsheet files available to the authorized account.

Select the intended spreadsheet.

Do not choose a spreadsheet merely because its name appears familiar. Confirm its owner and data.

4.113 Spreadsheet Permissions

A spreadsheet may not appear when:

The connected account lacks access
The file is not a native Google spreadsheet
Permission was removed
The wrong Google account was connected
The file was deleted

4.114 Selecting the Sheet Tab

A Google spreadsheet can contain multiple sheet tabs.

Example:

New Leads
Qualified Leads
Customers
Archive

After selecting the spreadsheet, choose the specific sheet tab that contains the records to synchronize.

4.115 Row 1 Headers

The integration expects the column names in Row 1.

Example:

A1: Full Name
B1: Phone Number
C1: Company
D1: Email

Do not place a report title or blank row above the headers.

Configuring Column Mapping

4.116 Column Mapping

The mapping step tells AIUNIFY Assistant which spreadsheet columns contain:

Lead name
Telephone number
Additional custom fields

The interface instructs users to type column names exactly as they appear in Row 1.

4.117 Name Column

Enter the exact header containing the Lead name.

Example spreadsheet header:

Full Name

Mapping:

Name Column: Full Name

4.118 Phone Column

Enter the exact header containing the telephone number.

Example spreadsheet header:

Phone Number

Mapping:

Phone Column: Phone Number

Name and Phone mappings are required before the synchronization button becomes available.

4.119 Exact Header Matching

Match:

Spelling
Spaces
Words
Header meaning

Example:

Spreadsheet: Phone Number
Mapping: Phone Number

Avoid:

Spreadsheet: Phone Number
Mapping: Phone

Although the backend performs some lowercase comparison internally, exact visible matching is the safest operational practice.

4.120 Mapping Custom Fields

Additional spreadsheet columns can be mapped into custom Lead fields.

Examples:

Company
Email
City
State
Source
Industry
Budget

Mapped custom fields become available through the Leads table’s Visible Fields control.

4.121 Saving the Configuration

The integration can save:

Spreadsheet ID
Sheet name
Column mapping
Last synchronized date

A saved configuration enables later quick synchronization without selecting and mapping the spreadsheet again.

Synchronizing Google Sheets

4.122 Starting the First Sync

After selecting the spreadsheet, sheet tab, and mappings:

  1. Confirm the Name mapping.
  2. Confirm the Phone mapping.
  3. Review custom-field mappings.
  4. Choose whether to save the configuration.
  5. Select the synchronization button.
  6. Wait for completion.
  7. Review the Leads page.

4.123 Required Source Data

A spreadsheet row is skipped when it does not contain:

A mapped name
A mapped and usable phone number

Correct incomplete rows in Google Sheets before synchronizing again.

4.124 Phone Normalization During Sync

Google Sheets synchronization normalizes telephone numbers into digits.

These values are treated as the same normalized telephone number:

+1 (313) 555-0198
1-313-555-0198
13135550198

They all normalize to:

13135550198

4.125 How Existing Leads Are Matched

The synchronization process matches a Lead using:

Normalized phone number
AND
AIUNIFY Assistant record owner

The same number can therefore exist under different user accounts without being treated as the same owned Lead.

4.126 Insert and Update Behavior

For each valid spreadsheet row, the backend performs an upsert operation.

That means it can:

Create a new Lead when no matching owned phone exists
Update a matching Lead when the phone already exists

The synchronization can update:

Name
Phone
Mapped custom fields

It also adds:

google-sheets

as a Tag without duplicating that Tag.

4.127 Important Interface and Backend Difference

The Google Sheets dialog includes language indicating:

New leads will be added automatically, existing ones will be skipped.

However, the reviewed backend uses an upsert process that can update an existing Lead when its normalized phone matches.

Operationally, users should assume that a Google Sheets sync can change matching Lead names and mapped custom fields, not merely skip them.

4.128 Google Sheets Tag

Synchronized Leads receive:

google-sheets

This makes it possible to filter spreadsheet-managed records.

A Lead can retain other Tags because the Google Sheets Tag is added rather than replacing the complete Tag list.

4.129 Duplicate Rows Within One Sync

The synchronization process tracks normalized telephone numbers already processed during the current operation.

When the source sheet contains the same normalized number more than once, later duplicates in that processing run are skipped.

Maintain one authoritative row per telephone number to avoid unpredictable selection between duplicate source rows.

4.130 Existing Duplicate Cleanup

Before synchronization, the reviewed backend includes logic that normalizes existing Lead telephone numbers and removes duplicate owned records.

Because duplicate cleanup can affect existing data, preserve required information and test with a controlled account or small data set before connecting a large production spreadsheet.

4.131 Source of Truth

When a saved Google Sheets configuration is active, treat the spreadsheet as the primary source for mapped values.

Recommended workflow:

Correct the spreadsheet
Run sync
Confirm the Lead record
Avoid conflicting manual edits

A later sync can overwrite mapped custom fields on matching Leads.

4.132 Sync Result Count

The backend reports the combined impact of:

Newly inserted Leads
Modified matching Leads

A reported result does not necessarily mean every counted record was newly created.

4.133 No New or Changed Records

A first synchronization can return:

All leads already exist or mapping failed. Check column names.

A saved quick synchronization can return:

Already up to date.

A zero result can therefore mean:

No new or changed records
Incorrect mappings
Rows missing required values
Duplicate source numbers


Quick Sync and Saved Configuration

4.134 Sync New Leads Now

When a configuration has been saved, the Google Sheets dialog can provide:

Sync New Leads Now

This reuses the saved spreadsheet, sheet tab, and mappings.

Despite the label, the backend can also update matching records.

4.135 Google Sheets Button Label

After configuration, the Leads-page button may display the saved sheet name instead of the generic Google Sheets label.

This helps identify which sheet is currently connected.

4.136 Syncing Indicator

While synchronization is active, the button can display:

Syncing...

with a rotating indicator.

Do not start another sync while this state is visible.

4.137 Leads-Page Sync Check

The inspected Leads page includes a saved-configuration quick-sync request when Google Sheets is connected and the page initializes under the relevant conditions.

This means opening the Leads page may check the configured sheet and refresh the Lead list when changes are found.

4.138 Last Synchronized Time

When the configuration is saved, the backend stores a lastSynced date.

This records when a successful synchronization with an impact occurred or when configuration was initially saved.

It should not be treated as proof that every source row was valid.

Disconnecting Google Sheets

4.139 When to Disconnect

Disconnect when:

The spreadsheet is no longer authorized
The Google account changed
A staff member left the organization
The wrong Google account was connected
The spreadsheet will no longer be the source of truth
A security review requires revocation

4.140 Disconnect Process

  1. Open Leads.
  2. Select the Google Sheets control.
  3. Select the disconnect option.
  4. Confirm the action.
  5. Wait for the success message.

4.141 What Disconnect Removes

The backend clears:

Google Sheets connected status
Stored access token
Stored refresh token
Saved spreadsheet configuration


4.142 Existing Leads After Disconnect

Disconnecting Google Sheets does not show a process that deletes Leads previously imported or synchronized.

Those Lead records remain until separately edited or deleted.

4.143 Reconnecting

After disconnection, reconnect through Connect Now and repeat:

Google authorization
Spreadsheet selection
Sheet selection
Column mapping
Configuration saving
Synchronization

Comparing Manual, CSV, and Google Sheets Entry

4.144 Manual Entry

Use manual entry when:

Only one or a few Leads are being added
The data has few custom fields
Immediate entry is needed
The contact does not exist in another source

Manual entry supports Name, Phone, Company, and Tags.

4.145 CSV Import

Use CSV when:

A list is being imported once
The source is Excel or another export
No continuing synchronization is needed
The user wants to apply one set of Tags

CSV import can preserve additional columns as custom fields but does not prevent duplicate telephone numbers in the reviewed implementation.

4.146 Google Sheets Sync

Use Google Sheets when:

A spreadsheet remains actively maintained
Repeated synchronization is needed
Existing records should be matched by phone
Source rows contain custom fields
The organization needs a collaborative source

The backend can create or update matching Leads and applies the google-sheets Tag.

4.147 Recommended Source Rule

Choose one primary method for each Lead group.

Example:

Website Leads → Google Sheets
Event Leads → CSV
Individual referrals → Manual

Avoid managing the same group through several competing sources unless a controlled process exists.

Preparing Leads for Campaigns

4.148 Lead Readiness

Before selecting Leads for a Campaign, confirm:

Name is recognizable
Phone contains the correct country code
Phone belongs to the intended contact
Duplicate records have been reviewed
Required Tags are present
Consent has been documented
Calling time zone is known
Suppression rules have been applied

4.149 Consent and Legal Authority

A Lead record does not prove that calling permission exists.

Before outbound calling, verify the organization’s lawful basis, including applicable:

Consent requirements
Do-not-call rules
Permitted calling hours
AI disclosure requirements
Recording requirements
Industry restrictions
State and federal regulations

4.150 Do-Not-Call Records

A Tag such as:

do-not-call

can help identify suppressed records, but a Tag alone does not technically guarantee exclusion from every Campaign.

Users must ensure suppressed Leads are not selected.

A more formal suppression process should be used when legally required.

4.151 Campaign Tags

Use Tags that clearly identify the source or purpose.

Recommended:

source-website
campaign-july-2026
product-solar
region-detroit
follow-up-required

Avoid ambiguous Tags:

list1
new
good
call
misc

4.152 Test Group

Before launching a large Campaign:

  1. Filter the intended Lead group.
  2. Select a small approved test set.
  3. Confirm Agent behavior.
  4. Confirm telephone formatting.
  5. Review Call Logs.
  6. Correct source data.
  7. Proceed with the larger Campaign.

Lead Data Quality

4.153 Duplicate Management

Duplicates can cause:

Repeated calls
Conflicting Tags
Incorrect Dashboard counts
Multiple Campaign assignments
Customer complaints
Compliance risk

Search by telephone number before importing or launching a Campaign.

4.154 Formatting Consistency

Although the backend removes nonnumeric telephone characters, maintain consistent source formatting.

Recommended source style:

Country code plus national number

Example:

13135550198

4.155 Name Consistency

Avoid creating variations such as:

Danielle Carter
D. Carter
Danielle C.
Carter, Danielle

for the same person unless a deliberate naming convention requires it.

Telephone matching is more reliable than name matching for Google Sheets synchronization.

4.156 Tag Consistency

Tags are text values.

These can become separate Tags:

Follow-Up
follow-up
follow up
followup

Choose one standard.

Recommended:

lowercase-with-hyphens

4.157 Custom-Field Consistency

These field names can become separate columns:

company
Company
company_name
Business

Standardize field names before importing.

Recommended:

company
email
city
state
source
industry

4.158 Sensitive Information

Do not place unnecessary sensitive information in Lead custom fields.

Avoid storing:

Passwords
Payment-card details
Government identification numbers
Medical details
Authentication tokens
Private account credentials

Store only information authorized and necessary for the calling purpose.

Troubleshooting Leads

4.159 “Failed to Fetch Leads”

Possible causes include:

Expired authentication
Network interruption
Backend outage
Incorrect API configuration
Server error

Try:

  1. Refresh once.
  2. Open Dashboard to test the session.
  3. Sign out and back in.
  4. Try a private browser window.
  5. Contact Support with the time of the error.

4.160 Leads Appear Missing

Check:

Search text
Selected Tag filters
Record ownership
Signed-in account
Google Sheets source
Whether the Leads were deleted

Tag filters can persist in the browser between visits.

4.161 Custom Columns Appear Missing

  1. Open Visible Fields.
  2. Confirm the field is selected.
  3. Clear the current column preference.
  4. Confirm at least one Lead still contains that field.
  5. Check whether an Edit Lead operation removed imported fields.

4.162 Lead Saves Without Formatting

A number such as:

+1 (313) 555-0198

appearing as:

13135550198

is expected.

The system stores digits only.

4.163 Wrong Number After Import

Check the source for:

Scientific notation
Removed leading zero
Missing country code
Extension combined with number
Spreadsheet formula
Incorrect mapped column

Correct the source and import or synchronize again.

4.164 Duplicate Leads After CSV Import

The CSV route does not deduplicate by phone.

To correct:

  1. Filter using an import Tag.
  2. Search the telephone number.
  3. Compare record dates and custom fields.
  4. Delete only the confirmed duplicate.
  5. Review Campaign assignments.
  6. Correct the CSV process before reimporting.

4.165 Bulk Tag Added to the Wrong Leads

Possible causes include:

An active search filter
Active Tag filters
Header Select All used on visible results
Incorrect manual selection

Bulk Add Tags does not provide bulk removal in the inspected interface. Incorrect Tags may need to be removed through individual edits.

4.166 Lead Limit Reached

When the Plan limit is reached:

  1. Review the current Lead total.
  2. Remove confirmed test or duplicate Leads according to policy.
  3. Upgrade the Plan where appropriate.
  4. Reduce the next import size.
  5. Retry after capacity is available.

4.167 CSV Says No Valid Leads

Check that:

The file is CSV
Row 1 contains name and phone
The headers are lowercase
Phone values are not blank
The correct file was selected

4.168 CSV Imported Unknown Names

The recognized name property was blank or absent.

Check:

Header spelling
Header capitalization
Blank Name cells
Exported CSV structure

4.169 CSV Import Created Too Many Leads

Possible causes include:

File uploaded more than once
Duplicates already existed
Duplicate rows were present
The same person has multiple records

Use the import Tag and Added On date to identify the affected group.

4.170 Google Sheets Button Does Not Connect

Check:

The user session is active
Browser popups or redirects are allowed
Google OAuth is configured
The callback domain is correct
The connected Google account is permitted

4.171 Spreadsheet Does Not Appear

Confirm:

The correct Google account is connected
The account has access
The file is a Google spreadsheet
The file has not been deleted
The organization permits third-party access

4.172 Sheet Tab Does Not Appear

Confirm the spreadsheet contains the intended tab and that the tab still exists.

Refresh the integration dialog after changes.

4.173 Mapping Failed

Check Row 1 and type the exact Name and Phone headers.

Example:

Row 1 header: Mobile Phone
Mapping: Mobile Phone

4.174 Sync Reports All Leads Exist or Mapping Failed

The message can mean:

All normalized phone numbers already exist
No valid mapped rows were found
Headers were mapped incorrectly
Rows lacked names or phone numbers
Duplicate source rows were skipped

Review several source rows and the mapping.

4.175 Google Sheets Changed Existing Leads

This can be expected.

The backend matches by normalized owned Phone and can update the matching record’s:

Name
Phone
Mapped custom fields

Correct the authoritative Google Sheet and synchronize again.

4.176 Google Sheets Removed a Custom Field

The sync operation sets the mapped custom-fields list for matching Leads.

A field omitted from the mapping or missing from the relevant source data may no longer appear as expected.

Keep mappings stable and preserve all required source columns.

4.177 Google Sheets Keeps Reapplying Data

A saved sync configuration treats the spreadsheet as the ongoing source.

Manual Lead edits can be replaced during a later synchronization.

Make the correction in the spreadsheet or disconnect the source before maintaining the record only inside AIUNIFY Assistant.

4.178 Google Sheets Says Already Up to Date

This generally means the sync found no new or modified impact.

Confirm:

New rows contain both Name and Phone
The correct tab is selected
The saved mapping is correct
The new phone is not already present

4.179 Disconnect Did Not Delete Leads

That is expected based on the reviewed implementation.

Disconnection removes the Google authorization and saved configuration, not the synchronized Lead records.

Operational Workflows

4.180 Daily Lead Review

At the beginning of the day:

  1. Open Leads.
  2. Clear unexpected filters.
  3. Review new Google Sheets records.
  4. Search for incomplete or Unknown names.
  5. Review duplicate telephone numbers.
  6. Confirm Tags.
  7. Confirm suppression records.
  8. Prepare the approved Campaign group.

4.181 CSV Import Workflow

Recommended sequence:

  1. Preserve an original copy of the source.
  2. Standardize headers.
  3. Format phones as text.
  4. Remove duplicates.
  5. Add required country codes.
  6. Save as CSV.
  7. Add a unique import Tag.
  8. Import a small test file.
  9. Verify custom fields.
  10. Import the approved remainder once.

4.182 Google Sheets Workflow

Recommended sequence:

  1. Design one authoritative sheet.
  2. Place headers in Row 1.
  3. Use one row per normalized phone.
  4. Standardize required columns.
  5. Connect the authorized Google account.
  6. Map Name and Phone.
  7. Map required custom fields.
  8. Save the configuration.
  9. Run a controlled first sync.
  10. Review inserted and updated Leads.
  11. Maintain changes in the sheet.
  12. Synchronize before Campaign selection.

4.183 Pre-Campaign Workflow

  1. Search or filter the intended Lead group.
  2. Confirm the result count.
  3. Review several records manually.
  4. Check telephone formatting.
  5. Check consent and suppression.
  6. Select a test group.
  7. Launch a controlled test.
  8. Review Call Logs.
  9. Correct source data.
  10. Proceed with the approved Campaign.

Security and Privacy

4.184 Protecting Lead Data

Lead records can contain personal information.

Only authorized users should access:

Names
Telephone numbers
Email addresses
Company information
Location
Call history
Qualification information

4.185 CSV File Security

After importing a CSV:

Store the original securely
Remove temporary desktop copies
Do not email unencrypted files unnecessarily
Do not upload the file to unrelated services
Follow the organization’s retention policy

4.186 Google Sheets Security

Use:

An approved Google account
Minimum necessary sharing
Managed organizational permissions
Regular access reviews
Prompt disconnection when authorization changes

Do not make a Lead spreadsheet publicly accessible.

4.187 Screenshots

Before sharing a Leads screenshot:

  1. Hide names where unnecessary.
  2. Hide telephone numbers.
  3. Hide email addresses.
  4. Avoid exposing Tags containing private information.
  5. Confirm the recipient is authorized.
  6. Include only the area needed to demonstrate the issue.

Lead Management Checklists

4.188 Manual Lead Checklist

Confirm:

Name is correct
Phone is complete
Country code is present
No extension is combined with the destination
Company is correct
Tags follow the naming standard
Duplicate search was completed
Consent was documented

4.189 CSV Preparation Checklist

Confirm:

File is CSV
Row 1 contains headers
name is lowercase
phone is lowercase
One Lead occupies each row
Phone cells are text
No scientific notation exists
Required country codes are present
Duplicate rows were removed
Blank Phone rows were removed
Import Tag was prepared
Original file was preserved

4.190 CSV Post-Import Checklist

Confirm:

Imported count is reasonable
Names are not unexpectedly Unknown
Phones contain the expected digits
Custom fields appear
Visible Fields are configured
Tags were applied
Duplicate search was performed
Test Leads were not mixed with production Leads

4.191 Google Sheets Connection Checklist

Confirm:

Correct Google account
Correct spreadsheet
Correct sheet tab
Headers in Row 1
Correct Name mapping
Correct Phone mapping
Required custom fields mapped
Configuration saved where intended
Test sync reviewed

4.192 Google Sheets Maintenance Checklist

Confirm:

One row per telephone number
Name and Phone remain populated
Country codes remain correct
Mappings have not changed
Source columns have not been renamed
Unauthorized users have been removed
Sync results are reviewed
Manual edits are not conflicting with the source

4.193 Deletion Checklist

Before deleting Leads, confirm:

Correct search and Tag filters
Correct selected count
No active Campaign dependency
No required Call Log history dependency
Retention requirements reviewed
Backup or export completed
Deletion approved

4.194 Campaign-Readiness Checklist

Confirm:

Lead group is correct
Phone data is valid
Duplicates are resolved
Tags are accurate
Consent is documented
Do-not-call records are excluded
Time zones are understood
Agent is tested
Calling resource is active
Plan capacity is available

Chapter Completion

At the end of this chapter, the user should understand how to create, search, filter, edit, Tag, select, and delete Lead records; how telephone numbers are normalized; how custom fields are stored and displayed; why editing a Lead can affect imported custom fields; how bulk Tagging differs from editing Tags; how to prepare and import a CSV file; why repeated CSV imports can create duplicates; how to connect and disconnect Google Sheets; how spreadsheet mapping, matching, upserting, and synchronization work; how to protect Lead data; and how to prepare an approved Lead group for Campaign activity.

Write Your Comment