How to automatically send a drafted email in Gmail every time a Google spreadsheet is added to a folder

A playbook always starts with a trigger, which is responsible for detecting changes in your connected applications and responding accordingly.

Add the Google Sheets trigger to initiate your playbook's actions every time a spreadsheet is added to a folder. Click "Add trigger" in your playbook and choose "Spreadsheet added to folder" from the dropdown menu under Google Sheets.

If you still need to connect your Google Sheets account to Relay.app yet, a prompt will guide you through the process.

Integrate the Gmail automation into your playbook to ensure the prompt sending of a drafted email in Gmail every time a spreadsheet is added to a folder.

Click the "Add step" button, locate the “Send draft” automation for Gmail, and input the mandatory and relevant details.

If your Gmail account still needs to be connected to Relay.app, you will be prompted to complete that connection. Make sure to allow the necessary permissions for Relay.app to sync with your Gmail account.

Activating your playbook is the last step in the process. Once you turn it on, it will automatically send a drafted email in Gmail every time a spreadsheet is added to a folder without requiring manual intervention.

To activate your playbook, click the toggle button at the header. Before activating, we recommend performing a test run of your playbook to ensure all the steps work seamlessly together.