- LBCTruthAsked 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.
- JotForm SupportNeilVicenteAnswered 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.
- JotForm SupportMike_TAnswered 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:
- LBCTruthAnswered 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
- JotForm SupportMike_TAnswered 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.
- eridamegaAnswered on January 31, 2017 at 11:21 AM
With Zapier, integration jotform and zapier and ready
- JotForm SupportJanAnswered on January 31, 2017 at 12:33 PM
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.