Making an autoresponder email with a Google Sheet

Emailing your users when they submit a form is a key step in letting them know that you’ve successfully got their data and continuing the conversation from there. Sheet Monkey makes this step simple with our autoresponder feature.

Here’s how you can use Sheet Monkey to send an email any time someone fills out your form. As an example, let’s build a welcome email for when someone signs up for your mailing list.

Here’s how to do that with a Google Sheet:

1. Put sign ups in a Google Sheet.

Build your mailing list sign up form using Sheet Monkey:

<form method="https://api.sheetmonkey.io/form/<form_id>" method="post">
<label>
Your email: <input type="email" name="Email" />
</label>
<label>
Your name: <input type="text" name="Name" />
</label>
<button type="submit">Sign Up</button>
</form>

It’s super simple and there’s no dependencies other than Sheet Monkey.

2. Use a Sheet Monkey autoresponder

In the Sheet Monkey dashboard, turn on the auto responder feature for that form.

Then configure your response message. Here’s the one we use for Sheet Monkey users:

Hey {{split Name 0}}!

Welcome to my mailing list! If you want to read my blog, you can visit here: https://myblog.substack.com or you can follow me on Twitter at https://twitter.com/socialz

Glad to have you here!

Save your autoresponder and you’re good to go.

This is just one way that Sheet Monkey saves you development time. All you need is a little bit of HTML and you can start sending auto response emails. Let us know if there’s anything else we could be doing better with our notifications.