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.


  • Profile Image

    Import contact information to Google Contacts

    Asked 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.

    Page URL:
    http://form.jotform.us/form/21935093931153

  • Profile Image
    JotForm Support

    Answered by NeilVicente on August 29, 2012 at 06:20 PM

    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.

  • Profile Image
    JotForm Support

    Answered by Mike_T on August 29, 2012 at 06:33 PM

    You may also check the following article to find out how to format your CSV file for Google Contacts:

    Creating or editing CSV files

    Thank you.

  • Profile Image

    Answered by LBCTruth on August 30, 2012 at 11:27 AM

    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

  • Profile Image
    JotForm Support

    Answered by Mike_T on August 30, 2012 at 06:32 PM

    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.

  • Profile Image

    Answered by eridamega on January 31, 2017 at 11:21 AM

    With Zapier, integration jotform and zapier and ready 

    https://zapier.com

  • Profile Image
    JotForm Support

    Answered by Jan on January 31, 2017 at 12:33 PM

    @eridamega

    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.