From Google Form to Gmail Draft

From Google Form to Gmail Draft

Insight from Corbin Brown

Another customer just filled out your feedback survey via Google Form. Instead of scrambling to craft a response, you lean back and smile. 

Why? Because you've got a secret weapon – a Zapier automation that's already whipping up a personalized email draft. 

Let's dive into how you can build out a V1 👇

First thing’s first, hop into Zapier and create a new Zap. This is where the magic begins. You'll want to connect your Google Forms as the trigger – the spark that sets your automation in motion. 

Choose the form that's pulling in those responses and give it a test run. If you see sample data flowing in, you're golden.

Now, instead of settling for a cookie-cutter response, we're calling in the big guns – ChatGPT’s 4o model. 

Add a ChatGPT action to your Zap. Tell it about your business, your tone, and what you want to achieve. Sprinkle in some placeholders for the lead's name, email, and whatever else they shared in the form.

Now it's time for a little formatting. We need to separate the subject line from the body (nobody wants "Subject: " showing up in their inbox, right?). A couple of steps will do the trick.

We’ll use Zapier’s “Formatter” action to isolate the subject line…

And use it again to find/replace the “Subject: “ from that line.

The final act? Bringing Gmail into the mix. Set up a "Create Draft" action and plug in all the pieces. The lead's email, your shiny new subject line, and that personalized body text – it all comes together here.

Before you hit that "On" switch, give your Zap a test drive. 

From now on, every form submission will trigger a tailored response, waiting patiently in your drafts folder for your final approval.

Remember, the beauty of this setup is in its flexibility. Keep tweaking that AI prompt. 

Who knew turning survey responses into conversations could be this smooth?

Your future self (and your customers) will thank you.

Learn more: See the full video walkthrough for setting up this automation