How to Upload Leads with Google Sheets

You can easily import leads into your Mailgo campaign using a Google Sheet. Follow the steps below:

Step 1: Open the Leads Section

• Go to the Leads section of your campaign.
• Click Add Leads.

Step 2: Select Google Sheets

Step 3: Prepare Your Google Sheet

• Make your sheet accessible: set sharing permissions to “Anyone with the link”.

• Format your sheet properly
  • Select all rows and columns using Ctrl/Cmd + A.
  • Go to Format → Number → Plain Text.
  • Save your changes before importing.

This ensures Mailgo can read the data without formatting issues.

Step 4: Import the Google Sheet

Copy and paste your Google Sheet URL into Mailgo. Mailgo will automatically detect the columns and assign fields.

Mapping your columns:

• Use the dropdown menu to assign the correct variable for each column.
• The Email column must be mapped to the predefined Email field.

• For personalization fields, map them as Custom Field and customize the field names.

• For columns you don’t need, select Do Not Import.

Step 5: Upload Your Leads

• Click Upload All to complete the import.
• Ensure every contact in your sheet has a valid email address (required).
• If any leads are missing emails or contain incorrectly formatted emails, Mailgo will prompt you.

Troubleshooting Checklist

If you encounter issues when importing leads, check the following:

• ✅ The Email column is not empty.
• ✅ All columns have headers, and header names start with a capital letter (important for mapping).
• ✅ The sheet contains no more than 30 columns.
• ✅ Remove any extra empty columns.
• ✅ Do not group or merge cells.
• ✅ Remove Boolean values (true/false), as Google Sheets may export them as Boolean instead of text.