Articles

Google Spreadsheet Integration

Description

Google Spreadsheets Integration
Google Spreadsheets IntegrationClick to watch
1:52 minute
477 views
Average: 5.00
Votes: 2
You can integrate Contact Enhanced with Google Docs -> Spreadsheets;

Requirement

  1. Contact Enhanced 2.5 OR newer;
  2. Have configured the form and all the custom fields;
  3. Download and install the Zend GData Library using Joomla Installer;
  4. A Google Account;

Usage

  1. Select Components → Contact Enhanced → Contacts from the drop-down menu on the back-end of your Joomla! installation, then Select a Contact the you wish to integrate with Google Spreadsheets;
  2. Set Use Google Spreadsheets to Yes;
  3. Set 'Setup (CSV) file'  to Yes, go to the front-end and submit the contact form; This will prompt a window to download a .csv file;
  4. Set 'Setup (CSV) file'  to No;
  5. Upload that CSV file to Google Spreadsheet;
  6. Get the Key from the URL. Example:
    https://docs.google.com/spreadsheet/ccc?key=0AhFfmwqdmyk4c&hl=en_US#gid=0
    The key is 0AhFfmwqdmyk4c
  7. Get the worksheet name and enter in the Worksheet field;

Newsletter

captcha

Connect with us

We're on Social Networks. Follow us & get in touch.
You are here: Start page