The Scenario
It's 11:45 AM on a Tuesday. Your telesales team starts calling at 1 PM, and the 600 warm leads from last week's webinar are still sitting in a Google Sheet — name, phone, email, policy interest — not yet in GoDial. Your ops person who usually handles imports is at a dentist appointment. You've done this before, but the column mapping screen always trips you up.
The bad version:
- Download the sheet as CSV, discover that column B has a mixed-format phone field with some +1 prefixes and some without, spend fifteen minutes normalizing it in Excel before GoDial will accept the file.
- Upload the CSV, map each field by hand in the import modal, realize you've assigned "email" to the "company" field, start over.
- Verify the import succeeded by spot-checking five contacts by name in GoDial's contact list, because the import confirmation screen just says "600 contacts added" without any failure detail.
The session starts in an hour and your team is already logged in and waiting. A manual import that should have been done yesterday is now the single thing blocking forty calls.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your data directly and uses its built-in GoDial integration to create lists and add contacts on your behalf — no downloads, no column mapping screens, no CSV formatting.
Open the SheetXAI sidebar and paste this prompt:
Create a new GoDial list called 'Webinar Leads June 2025', then add every contact from this sheet using phone in column A, name in column B, and email in column C — write the returned contact ID into column D
What You Get
- A new GoDial list named exactly as specified, created before any contacts are added.
- Every row in the sheet submitted to GoDial as a contact record, with phone, name, and email mapped from the columns you specified.
- The GoDial-assigned contact ID written back into column D for each successful row — so you have a permanent reference linking your sheet to GoDial.
- Any rows that fail (malformed phone, missing required field) flagged in column D with an error note rather than silently skipped.
What If the Data Is Not Quite Ready
Phone numbers have mixed formats — some with +1, some without, some with parentheses
Before importing, normalize column A so all phone numbers follow E.164 format (+1XXXXXXXXXX), then create a new GoDial list called 'Webinar Leads June 2025' and add every contact using the normalized phone, name in column B, and email in column C — write the contact ID into column D
The sheet has a header row and a mix of active and inactive leads
Skip row 1 (header) and only import rows where column E is 'Active'. Create a new GoDial list called 'Active Webinar Leads', add each qualifying contact with phone from column A, name from column B, and email from column C, and write the returned contact ID into column D
Lead data is split across two tabs — 'Webinar A' and 'Webinar B'
Combine all rows from the 'Webinar A' and 'Webinar B' tabs, deduplicate by column A (phone number), then create a single GoDial list called 'Combined June Leads' and import every unique contact — phone from column A, name from column B, email from column C — writing the contact ID into column D on whichever tab each row came from
Format, filter, dedup, and import in one shot
Normalize all phone numbers in column A to E.164 format, remove any duplicate phone numbers keeping the first occurrence, skip any row where column C (email) is blank, then create a GoDial list called 'Clean Webinar Leads June 2025' and import every remaining contact — phone from column A, name from column B, email from column C — writing the returned GoDial contact ID into column D and a FAILED note for any row that didn't import
One prompt handles the cleanup and the import together. You don't need to run a separate cleaning pass first.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where your next lead batch is sitting. Ask SheetXAI to create the GoDial list and import the contacts — your team can be dialing before you finish your coffee. You can also look at how to export call dispositions back to a sheet or the full GoDial integration overview.