Automatically send emails when a row is populated

This site is now deprecated.

๐Ÿ‘‰ Visit our NEW Mergo Help Center

Mergo's For each new row feature makes it possible to automatically send a notification email when a blank row is populated in your campaign sheet. Data can be populated either:

  • manually (entered by you) or

  • programmatically (combined with the power of automation tools like Zapier or IFTTT).

Mergo works its magic in the background by checking your campaign sheet every hour and sends an email if it sees newly populated rows with email addresses.

๐Ÿ“Š This feature is available in our Mergo add-on for Sheets.

โ˜Prerequisite: You must have an existing campaign sheet before you can use our For each new row feature. Follow this tutorial to learn how.

A. Set up using Google Sheets (for manual entries)

1. Build your campaign sheet & your email draft first.


2. In your Mergo sidebar, click the Mail Merge menu:

3. Click More actions (1) > Schedule delivery (2):

4. Select For each new row (Zapier):

5. You will now see a confirmation that: An email will be sent if a row is added to the sheet:

6. Time to test our setup. Manually enter your campaign record/s.

Mergo will check your campaign sheet every hour and will send an email if it sees newly populated rows with email addresses:

The record on row 10 was manually entered @ 3:49 PM.

Then the email was automatically sent @ 4:20 PM.

๐Ÿ›ˆ๏ธ Info: Know what our Merge statuses mean? Read all about them here.

โ˜Remember: You can manually enter your records (or copy-paste) daily, weekly, monthly, or as infrequent as you need. Mergoโ€™s For each new row feature will always be running in the background checking your campaign sheet every hour and will send an email if it sees newly populated rows with email addresses.

๐Ÿ“ŒNote: Emails may have a delay of up to 1 hour after a new row of record is entered. This delay is due to Google's trigger events.

๐Ÿ’กTip: Make sure that your Spreadsheet's Time zone is configured properly since delivery times are based on this specification. To do this in Google Sheets, go to File > Spreadsheet settings > choose the relevant Time zone (1) > click Save settings (2).



B. Set up with Zapier or IFTTT

In this tutorial, we will create a workflow that will create a new row of record in Google Sheets for each event created in Google Calendar. Mergo will then process this new event and send an email to the recipient/s.


1. Configure your preferred automation tool (like Zapier or IFTTT).

This will create a new Google Sheets file for all your calendar events (this will serve as your campaign sheet).

๐Ÿ“ŒDisclaimer: There are certain topics that are beyond Mergo's scope of support. For example, we can't assist you with configuring Zapier or IFTTT. We can, however, help to confirm whether all of our Mergo systems are functioning normally to help you isolate the problem.

And if ever we offer assistance beyond our scope of support, please know that this is only a "best-effort" approach and we cannot guarantee expertise or efficacy on the tools.

Here are links to the support help desks:

Zapier Support

IFTTT Support

2. Open the File created by Zapier or IFTTT, then follow our tutorial on how to set up your campaign sheet.


3. Create your email draft and insert the relevant {{markers}} based on the header labels generated by the automation tool:

4. In your Mergo sidebar, click the Mail Merge menu:

5. Click More actions (1) > Schedule delivery (2):

6. Select For each new row (Zapier):

7. You will now see a confirmation that: An email will be sent if a row is added to the sheet:

8. Time to test our workflow.

a) Create an event in your Google Calendar.
Add guests as needed (we have 1 guest in this example).
Once you click the Save button, your automated workflow will instruct Zapier or IFTTT to send the calendar event details to the linked Google Sheets file.

b) In a few minutes, your Google Sheets file will be populated with the newly created calendar event.

๐Ÿ“ŒNote: he transfer of data from Zapier or IFTTT to Google Sheets is not instantaneous as compared to Mergoโ€™s onForm Submit feature. Thereโ€™s a delay and it varies.

c) Mergoโ€™s For each new row feature will always be running in the background checking your campaign sheet every hour and will send an email if it sees newly populated rows with email addresses.

๐Ÿ›ˆ๏ธ Info: Know what our Merge statuses mean? Read all about them here.

๐Ÿ“ŒNote: Emails may have a delay of up to 1 hour after a new row of record is entered. This delay is due to Google's trigger events.

๐Ÿ’กTip: Make sure that your Spreadsheet's Time zone is configured properly since delivery times are based on this specification. To do this in Google Sheets, go to File > Spreadsheet settings > choose the relevant Time zone (1) > click Save settings (2).