# Sheets Automation

Sheets Automation brings three new ways to automatically send emails from your Google Sheets:

* **⚡️** [**On form submission**](https://mailmeteor.com/docs/sheets-automation/new-form-response): link your Google Forms and send emails automatically. Extremely useful for contact forms, feedback forms, etc.
* **⚡️** [**On spreadsheet edition**](https://mailmeteor.com/docs/sheets-automation/sheet-is-edited): send emails in reaction to changes in your spreadsheet. Use cases: sales pipelines, payment confirmation, etc.
* **⚡️** [**On schedule**](https://mailmeteor.com/docs/sheets-automation/on-schedule): send an email to your list every day, every Monday, or on special occasions like a new blog post, happy birthday emails, license renewal, etc.

Here's how it looks like:

<figure><img src="https://mailmeteor.com/assets/docs/sheets-automation-overview.png" loading="lazy" alt=""><figcaption><p>Create a new automation from Mailmeteor for Google Sheets</p></figcaption></figure>

### Automation cheat sheet

| Trigger                  | Execute                 | Rows concerned        |
| ------------------------ | ----------------------- | --------------------- |
| 📃 New form response     | On each form submission | New submission row    |
| ✍️ Spreadsheet is edited | On each edition         | Edited row(s)         |
| ⏰ On schedule            | Once per day            | All rows in the sheet |

### Videos tutorial

{% embed url="https://www.youtube.com/watch?list=PLsZLp_pMhGGWe2rnssBQPzR-lrHd52H9i&v=nC8eoIZbc2U" %}

### Automation limitations

The following table details the automation limits. Provided that you stay within the [daily email quota](https://mailmeteor.com/docs/get-started/email-quota), there's no limit to the number of emails that you can send per day.

<table><thead><tr><th width="399">Quotas</th><th></th></tr></thead><tbody><tr><td>Simultaneous automations per user</td><td>20</td></tr><tr><td>Simultaneous automations per sheet</td><td>20</td></tr><tr><td>On schedule executions</td><td>1 execution per day</td></tr><tr><td>On edit executions</td><td>Limited to when a user manually edits the spreadsheet. Requests to the Google Sheets API do not trigger the automation.</td></tr></tbody></table>

If you have feedback on these limits, please [contact us](https://mailmeteor.com/contact).