Google Spreadsheet integration had stopped working, a way to fix it without re-integration

  • Thinkbright
    Asked on April 9, 2015 at 2:07 PM

    Hello Jotform team,

    I need your support. My form http://www.jotform.co/form/43566107084859 was integrated with my google spreadsheet: 

    https://docs.google.com/a/thinkbright.co/spreadsheets/d/1zUW1DJvGoMM-iO_1_8wCFnD4FRMZFPfZKF_ZHw-Q5Pg/edit#gid=1882536991

     

    The integration was somehow lost.

     

    Could you help me re-do it. Please note that I can't integrate with a new spreadsheet since a lot of other automated processes depend on the form being linked to that specific sheet.

     

    Thanks a lot,

     

    Pablo Castellanos

  • Welvin Support Team Lead
    Replied on April 9, 2015 at 4:28 PM

    Hi Pablo,

    Our apologies for the issue. We have some issues about the Google Spreadsheet a while ago, but our developer have just made an update and this update should resolve the problem. I'm sorry, but you need to re-integrate the form to Google Spreadsheet in order to refresh the connection.

    In general, we do not recommend doing any modification to the sheet because that would cause some serious issue in the integration. Modification such as changing the headers (first row) as well as adding columns and custom functions.

    If you want to re-use the current sheet, you can do the integration through Zapier:

    https://zapier.com/zapbook/jotform/google-sheets/

    In Zapier, you will have the option to use an existing sheet rather than creating a new one. 

    Thanks

  • Thinkbright
    Replied on April 9, 2015 at 4:34 PM

    Welvin,

    I'm sorry but this is totally unacceptable. The amount of work that my team would need to do to to reintegrate our >20 forms is a lot. This is a reason enough to shift to another forms service provider.

    Regarding Zapier, the costs for doing what Jotforms has not been able to get right is 50USD/month. Would you cover these fees?

    I'm really unhappy with this answer. And I would like to ask again if you can re-integrate my existing forms.

     

    Thanks,

     

    Pablo

  • Welvin Support Team Lead
    Replied on April 9, 2015 at 5:50 PM

    Hi Pablo,

    I'm sorry, but I though that you have the issue in the single form only. I just checked your account and you only have 17 forms so I'm wondering if you have another account with us. Please let us know the form URL's so we can check it and let our developers know about it.

    As for using Zapier, I'm sorry but it looks like they have changed their pricing sets. I have 1500 tasks per month in Zapier.

    With regards to re-integrating the form to Google Spreadsheet without losing the current sheet, will forward that to our developer to see if there's a way to do that. But let us know first the other forms that have the same issue so we can add it to the report.

    Thanks

  • alp_deniz
    Replied on April 10, 2015 at 2:58 AM

    Hello,

    This issue is prioritized. I will update here very soon.

    Best