Articles

Google Spreadsheet Integration

Details

Hits: 1168

Description

Google Spreadsheets Integration

Click to watch

2:0 minutes

335 views

Average: 5.00
Votes: 2

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;