MergelineWhy can’t Gmail mail merge open my Google Sheet?
Updated October 29, 2026
Gmail’s mail merge reads data only from the first tab of the sheet, and only as plain text. If your list sits on another tab, uses formulas or formatting the merge cannot read, or lives in a sheet your account cannot open, the import fails or comes in blank. Move the list to the first tab, paste it as values, and check sharing.
Fix list
- Move the list to the first tab, or reorder tabs so it comes first.
- Copy the data and use Paste special, then Values only, so formulas become plain text.
- Put headers in row 1 and remove empty rows above them.
- Make sure there is an email column with real addresses.
- Check you are signed in with an account that can open the sheet.
Small things that break imports
- Merged cells in the header row.
- Two columns with the same name.
- Hidden rows you forgot about. They still import.
- Dates and numbers formatted in a way that reads oddly once turned into text. Format them as you want them to appear.
In Mergeline
Paste the Google Sheets link on the recipients step. The first time, Mergeline asks for permission to read docs.google.com, then downloads the sheet as a CSV. Open the sheet in the same browser first to make sure your account can see it. You can also download it as CSV yourself and drop the file in.
With Pro, Mergeline can watch the linked sheet and email new rows as they are added, which is handy for sign-up forms. More in the Google Sheets guide.
A clean sheet template
Keep a master tab for your full contact list and copy only the rows you need into a fresh first tab for each campaign. That keeps the first tab small, simple and easy for any mail merge tool to read.
Check the email column
An email column with names mixed in, like “Jane Doe
Read the full guide: Mail merge from Google Sheets
Related answers
Sources
- Google: Send personalized emails with mail merge in Gmail
- Quora: mail merge using Google Sheets and Gmail
Facts checked October 29, 2026. Google and other vendors change their limits and prices, so check the source before you rely on a number.
Mergeline does this from your own Gmail. Free for 60 emails a day with merge tags and no branding. Pro is $12 a month or $99 a year for follow-ups, scheduling and attachments.