What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Import contact information to Google ContactsAsked by LBCTruth on August 29, 2012 at 05:22 PM
I am trying to collect visitor contact information with my jotform and transfer it to my Google contacts. Is there a way to get my jotform contact list into my Google contacts? Or, am I able to setup the Google docs spreadsheet created from my jotform to import cleanly into my Google contacts? I used the created Google docs spreadsheet and exported to a .csv file then imported to my Google contacts. It got the first & last names and emails in the correct fields but it dumped just about everything else into the "notes" field in my Google contacts?!?
This is a re-post of a comment on Google Docs Integration: Send Responses to Google Spreadsheets. Instantly.
An easy solution would be to delete the other unnecessary columns from the exported CSV file so that when you import the file to your Google Contacts, only the Full Name and Email fields are saved.
Hope you find this informative.
You may also check the following article to find out how to format your CSV file for Google Contacts:
Answered by NeilVicente on August 29, 2012 An easy solution would be to delete the other unnecessary columns from the exported CSV file so that when you import the file to your Google Contacts, only the Full Name and Email fields are saved. Hope you find this informative.
Thanks, but the issue is that I want all of the rest of the information and am trying to figure out if I can set up the jotform (maybe in the properties or something) to correctly name the headings in the spreadsheet it creates so that they are regognized by google when I import (without having to do this manually everytime). For instance, putting the name, email addresses, addresses, phone numbers, birthdays, etc. into the proper fields then leaving other information to fill up the "notes" section. It seams that the headings are taken directly from the title of each input field in the form... I suppose I could change the field titles but it looks like google contacts is looking for something like, for instance, "address 1 - formatted" which would just look wierd on my contact info form. I guess what I'm asking is can my jotform field title say "Address" yet put "address 1 - formatted" as the address title on the spreadsheet?
@Mike T, I have yet to check the article, I will look into that next. If I can figure out how to define the headings that the jotform places on the spreadsheet, this will come in handy as I will set each field to the proper heading!
For ref. here is the form I am referencing: http://form.jotform.us/form/21935093931153
You are completely right, spreadsheet headings are being generated based on the labels of inputs.
Unfortunately, we do not have any settings to set custom headings for reports, so you will have to change them manually.
With Zapier, integration jotform and zapier and ready
Thank you for sharing that information. We do have an integration with Zapier, please check this article: https://www.jotform.com/blog/164-Automating-Your-Forms-with-Zapier.
If you need any help, let us know by opening a new thread.