Hi
My website collects contact info and sends them to me via gmail
the Contact Details are in the body of the gmail
I want to save the Contact Details to a google sheet
Sounds easy but I'm having problems
Hi
My website collects contact info and sends them to me via gmail
the Contact Details are in the body of the gmail
I want to save the Contact Details to a google sheet
Sounds easy but I'm having problems
Hi
The 'Work Offered' category is for folks who would like to hire a Zapier Expert to help them with their Zaps. If you'd like to ask a question to the community as a whole, to get some tips on how you can do this yourself, then 'Ask the Community' is the best category.
Thanks!
What type of form are you using?
It may have a direct webhook tie in, but if not, does it come through in the same format every time:
Q1: answer 1....
Q2: answer 2....
etc... ?
or is it more of a comma separated list?
Hi
Thanks!
Hey
From: form-submission@squarespace.com
________
Body:
Name: example name
Email: example email
Subject: Love your site!
Message: Just wanted to tell you how much your site means to me.
_________
Otherwise it wouldn't be a very good contact form by my standards!
So basically, to achieve your goal you need two things:
Fortunately, Zapier has an awesome tool for just such a Step 1, called Email Parser
Parse Emails by Zapier And Step 2 is handled quite seamlessly with "Create Spreadsheet Row" for Google Sheets as an Action Step.
Following the awesome tutorial pasted below, your flow will be as follows:
The Email Parser Guide: How to Automatically Copy Data From Your Emails
Just keep in mind this tutorial sets up the parsing robot first, then gets into Gmail. And of course, your last part, the action step, will be different:
Google Sheets "Create New Spreadsheet Row" step...
...with how those fields and values then show up in my sheet
Hope that makes sense and helps, good luck!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.