How to mail merge with Gmail using google sheets

This Gmail bulk sender automation template uses a bot to send emails in bulk from a Google Sheet through Gmail. The bot retrieves data from the Sheet, opens Gmail in Chrome, fills in the "Compose" form with email, subject, and body, and clicks send. After sending, it deletes the processed row and repeats the process with subsequent rows.

Get started: Set up your Google Sheet

Create a new Google Sheet. You can do this in your Chrome browser by entering the shortcut 'sheet.new"**, assuming you already have an account. Name your sheet something like "Gmail Mailer". Add some content to test with email addresses, name, subject, body etc

Install the Gmail bulk sender bot

To install this Gmail bot click "Install template". If you’re a new user, you’ll have to click "Install Chrome extension" and create a free axiom.ai account before you can edit the template.

Once installed, click "Start".

axiom.ai will guide you through the steps you need to configure in the app.

Configure your Gmail bulk sender bot

  • Step 1.0 Read data from a Google Sheet
    • Spreadsheet: Search for the Google Sheet you created. Once found, click to select.
    • Sheet name: Choose the tab with the email information in it.
  • Step 2.0 Go to page: mail.google.com/mail/u/0/#inbox^
  • Step 3.0 Loop through data
    • Step 3.1 Wait: For compose to open^
    • Step 3.2 Enter text: Email
      • Text: Click 'Insert data', select [google-sheet-data].
    • Step 3.3 Press key(s): Tab to Subject^
    • Step 3.4 Enter text: Subject
      • Text: Click 'Insert data', select [google-sheet-data].
    • Step 3.5 – 3.6^
    • Step 3.7 Enter text: Body
      • Text: Click 'Insert data', select [google-sheet-data].
    • Step 3.8 – 3.11^
    • Step 3.12 Delete rows from a Google Sheet
      • Spreadsheet: Search for the Google Sheet you created. Once found, click to select.
      • Sheet name: Choose the tab with the emails in it.

^ Preconfigured

Run your Gmail bulk sender bot

To test the Gmail bot, open Gmail and run the bot using the Desktop app. Monitor its operation to ensure it is configured and functioning correctly. If you wish to schedule the bot add steps to login.

Customize your template

Like all Axiom templates, you can use our no-code bot builder to customize any bot according to your requirements

Troubleshooting

We recommend you watch the video to troubleshoot. If you wish to schedule, the bot you will need to share the Cookie in settings or add steps to login.

  • Email not added?
    In Step 3.2 – Enter text: Email, check the cursor location. By default, it should be in the Email input field.
  • Tab not working?
    In Step 3.3 – Press Key(s): Tab to Subject, make sure the step includes pressing Return to submit the email address, followed by Tab to move to the Subject field.
  • Subject text not added?
    In Step 3.4 – Enter text: Subject, confirm that you clicked Insert data and selected [google-sheet-data].
  • Body entered into subject?
    In Step 3.7 – Enter text: Body, check Step 3.6 to ensure the cursor is correctly placed before the body text is entered.
  • Send key not clicked?
    In Step 3.9 – Press Key(s): Click send, re-record the keystroke sequence and test again.
  • Bot out of sync?
    In Step 3.10 – Wait: For email to send, try extending the wait time to give Gmail more time to process.
  • Compose button not found or visible?
    In Step 3.11 – Click element: Open new Compose window, reselect the compose button.
    If it's not visible, check that the Gmail sidebar is toggled open.

We offer excellent customer support. If you need help, get in touch. To learn more read this full in-depth guide on how to send an email blast using Gmail.

On this page