What are you trying to achieve?
Website form details need to go automatically go into a Google Sheet (seems impossible for anyone to figure out)
Steps taken so far
I think it’s pretty simple for a seasoned Make builder… (but Im a newbie). I have a website, with a form that captures Name, Email, Business Name, Location, Message, Phone. I have a Google Sheet with the same headings and want this info to go into that Google Sheet - pretty hard right? Nobody can provide me with an easy fix so far.
I started with Microsoft 365 email module to a Text Parser (not sure if thats needed), then Google Sheet. Maybe I can use something else to grab the info and send to Google Sheets with the email module. I dont know.
Ive spent 2 days on something that I think a good Make creator could set up in 10 minutes. My frustration has hit it’s upper limits.
The Make staff have sent 5 replies, each time giving me one little suggestion or hint which doesnt help, so they have been pretty terrible in fixing this, even when I gave them full access to my account.
I am concerned there could be an issue with my email as I only set up a new email account as part of the website set up (so the domain would be the same name as my website rather than a Gmail which is less professional.
I would be ideal to sort it out in real time over zoom but Make has no option for this.
if nobody can help with a scenario with 2 or 3 modules, i doubt I will use make for bigger CRM and Social Media set ups with 1 dozen modules.
So if ANYONE in the world can make sense of this issue I would appreciate it. … or does eveyone here end up paying ‘Make Experts’ to actually get anything done. So much for AI automation.
Sorry for the frustrating tone, but deadlines have passed and Im running out of time and money trying to start an online review management business to support my family so everyone is stressed by the lack of progress.
I dont post any screenshot of what I have because there is no point as it doesnt work and its only 3 modules. Might as well start from scratch if anyone can suggest the best modules to do this seemingly impossible process. Any advice appreciated but Im close to giving up on Make.
1 Like
Hi @David_Martin
If you could share a sample email from which you’d like to extract the data, we can assist you further.
Best regards,
Msquare Automation
Gold Partner of Make
@Msquare_Automation
Hi, Thanks for your reply.
This is the form set up on my website managed by GoDaddy.
These are the emails that autromatically arrive in my Microsoft 365 set up by GoDaddy and accessible through Outlook:
I only set up the Microsoft 365 email account due to recommendation of GoDaddy, and it allows my emails to have my domain:
So a client would email david@FiveStarReviewguy.com rather than just a Gmail address.
Im am unsure if setting up this Microsoft 365 email is part of the problem or not , but it basically came with the website (when I was creating the website).
The first module of Microsoft 365 returns zero information and does not communicate with the Text Parser module or the Google Sheets module.
1 Like
How are you getting the content? I mean in what format is it in html or is it plain text ? I assume it would be in plain text as most of the website forms pass just the text when sending the data to email unless they are using html editor.
If it is plain text here is how you can do it
lets assume you added the etxt from email to a set variable
you need to use text parser match pattern module to separate each unique field
here is the regex for it Business Name\s*(.+)
for best mail it would be Business Name\s*(.+)
which will give you the value for the corresponding field line this
and if you are getting the text in exact same pattern you can split it by new line and access it by the keys
Hi,
Thanks for your reply.
Im really sorry but your information is over my head and I didnt understand it.
I’m a newbie with zero tech experience and zero coding experience which does make things harder for me. Most of the terms you used I am confused over.
Im on Day 4 or 5 , taking 4 to 6 hours a day to fix this issue and nothing is actually working. Not your fault but all my fault. Frustration levels are at an all-time high. : (
I do not know if the form is passing on info via HTML or not. As I said, I may have selected the wrong Modules from the very start.
Put it this way…if YOU wanted to grab the Name, email , etc from a form and put it into a Google Sheet, what Modules would you use and what steps would you take.
If someone can provide an example of what a scenario looks like that takes key words from a form and adds them to a Google Sheet, then I could swap out my details for their details and may then it would work.
As a zero coding guy I thought Make.com would be easy but the process is not making much sense for someone whose had a career in customer service rather than tech.
if nobody can provide an example then maybe someone can recommend an expert that I can pay to get something simple set up within the next few days (as this is the most simple of about 4 different scenarios that I need to start my business).
All help is appreciated.
David
1 Like
Hi @David_Martin
You can setup custom webhook in your GoDaddy form. Also, you can setup mailhook from your email to forward the emails to make. Then easily can parse the details from email body as the headings are always same and through a form.
Webhooks or Google Sheet integration in GoDaddy
Automatic email forwarding from outlook
Best regards,
Msquare Automation
Gold Partner of Make
@Msquare_Automation
Have a look in the hire a pro category if you need someone to help to directly.
