Hello
I need your opinion for a need.
I receive excel or csv files from my customers via a form on my website.
These excel or csv files are contact lists, they are all arranged differently.
Some start with name, some first names, some first names last names, some start with email, others with phone number.
In short, I would like to connect my form to “make” so that it makes an automation to reformat all my files under the same column format “first name” then “last name” then “email” then “phone number”
What do you think?
How to start this type of automation?
Thank you for your opinions
Hey, @Domaines_et_Villages
The process will be simple
- Just get the response on make.com, if it google form or your webpage build on Wordpress by using module
- Then map all the values one by one in your excel or Google Sheet which was already structured.
- Now, when new reponse is submitted and it will trigger and update data in spreadsheet.
Thanks,
Sachin Shrivastava
Thank you Sachin,
This is a bit the scenario I was considering,
but chatgpt would need to be able to map fields automatically.
My goal is not to intervene manually,
my website → client file → make → chatgpt (column mapping) → reorganized file → api in my database
Could you know how i can do that ?