Campaign Sheet & Google Sheets file

Here you'll learn some Mergo best practices to manage and maintain your campaign sheets.

In this article

Can I use multiple campaign sheets in a single Google Sheets file?

The ideal setup would be 1 campaign sheet (sheet or tab) for 1 Google Sheets file.  But you can use multiple sheets or tabs in a single Google Sheets file as well (like in our example below).


If you're going to use multiple sheets, you need to Refresh the Mergo sidebar each time you run a campaign on another sheet/tab. This ensures that Mergo is referencing the correct campaign sheet (datasource). To do this, just click the relevant sheet/tab > Mergo actions > Refresh.

Note: By default, Mergo will always reference the 1st sheet/tab of a Google Sheets file as the datasource. This is why it's important to Refresh the Mergo sidebar each time you move to a different sheet/tab.

Caution: Do not hide a sheet/tab in your Google Sheets file. This may disrupt Mergo's ability to reference the correct datasource and fields (header labels).


Will my campaign keep running if I delete my Sheets?

Your campaign will continue to run only if you removed it (put the campaign sheet file in Google Drive's Trash).  But your campaign will stop running when:

  • Campaign sheets that have been in your Drive's Trash for more than 30 days are automatically & permanently deleted by Google. 
  • You click the Empty trash button

💡 Tip: If you only need to stop an ongoing campaign, just click the ABORT button.

Note:  If you've only removed the campaign sheet, you can restore it from the Trash. Then open Mergo > click ABORT to stop the campaign.


Can I set several scheduled campaigns from the same spreadsheet?

Yes, you can. You can set up one campaign per sheet! You can learn more about this here