Title: Error on Google Spreadsheat Live Data Function
Last modified: August 30, 2016

---

# Error on Google Spreadsheat Live Data Function

 *  [Charlieelcarlino](https://wordpress.org/support/users/charlieelcarlino/)
 * (@charlieelcarlino)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/error-on-google-spreadsheat-live-data-function/)
 * Hi there, Michael!
 * Thank you very much for your awesome plugin. I was trying to sinchronize one 
   form with Google Drive, but I’m facing some issues when the function is too long
   and has to be added as script.
 * 1) Do I have to choose “Complement” (or Addon, I see it in Spanish and I’m not
   sure how is translated) or “Custom function”? This is what I see: [http://prntscr.com/7l82k6](http://prntscr.com/7l82k6)
 * 2) Do I have to save it with any special name?
 * 3) Do I have to replace anything in the code?
 * 4) Is this the correct function (of course with correct values replaced)?
    `=
   cfdbdata("<url>", "<form name>", "<user>", "<password>", "show", "your-name,your-
   email,submit_time", "headers", "your-name=Nombre,your-email=Email,submit_time
   =Hora")`
 * I can’t understand why, but I keep having this #ERROR! thing…
 * Thank you very much for your time!
 * [https://wordpress.org/plugins/contact-form-7-to-database-extension/](https://wordpress.org/plugins/contact-form-7-to-database-extension/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/error-on-google-spreadsheat-live-data-function/#post-6268342)
 * (1) Choose “Custom function”. Then from the File menu, create a new script file.
   Paste the code and save.
 * (2) No
 * (3) Paste the code exactly. No replacements
 * (4) Looks correct
 * to try to debug: go to the code, change line 79
    return JSON.parse(content); 
   to //return JSON.parse(content); return content;
 * Try the function again and see if it give you more information about the error.

Viewing 1 replies (of 1 total)

The topic ‘Error on Google Spreadsheat Live Data Function’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/error-on-google-spreadsheat-live-data-function/#post-6268342)
 * Status: not resolved