This happens for cases when:
- a Google Sheet is shared between 2 or more users
- the Mail Merge campaign is set to run On Form Submit
- 2 or more users activate the On Form Submit campaign on the same Google Sheet
The above actions set App Script triggers on the accounts that activated On Form Submit on the same spreadsheet. In effect, once a form entry is submitted, all triggers fire off the Mail Merge campaign.
To resolve, first decide which account would run the On Form Submit campaign on the Google Sheet. The next step would be either:
- Link the Google Form to a new spreadsheet and recreate the Mail Merge campaign (easiest and recommended option)
- Remove the App Script triggers for the non-authorized accounts (use this option with caution)
Removing App Script Triggers
Warning: Removing triggers for account/s not authorized to run the On Form Submit campaign makes sure only 1 account would send out the emails. However, the App Script triggers page does not provide clear details as to which email campaign the triggers refer to, as shown:
Removing triggers runs the risk of affecting other On Form Submit campaigns on the account. This means all On Form Submit campaigns would need to be rescheduled. This can be done by simply unscheduling your campaign and rescheduling. More details: My scheduled campaign didn't get sent out. What's the solution?
Once you are aware of the risks and wish to proceed, here are the steps (these are instructions for accounts that DO NOT need to run the On Form Submit campaign):
- Log in to https://script.google.com/home/triggers
- Look for "From spreadsheet - On form submit" triggers and click the 3-dot menu at the end of the row, as shown:
- Click "Delete trigger"
- Repeat Steps 2-3 until all "From spreadsheet - On form submit" triggers are removed