Why isn't my data arriving in Google Docs/Drive?

There can be multiple reasons why submitted data isn't arriving in a Google Drive connection. Oftentimes, the data is arriving, but in a different sheet as in the screenshot below:

Google_Docs_Connector_Multiple_Sheets.png

 We deliver data to a new sheet when your form schema is changed, typically by editing the form in our designer.

 

In all other cases you will see a Delivery Error reported on your dashboard like so:

The reasons behind such a delivery error to a Google Doc are beyond the scope of this FAQ, but some common causes are:

  • Spreadsheet has exceeded the cell-limit set by Google Docs.
  • Spreadsheet has exceeded the number of columns (based on the number of fields defined in your form).
The delivery error may contain information that points to the causes above. You can attempt to resolve the issue by adding a second Google Doc connection in parallel to your existing one. It doesn't matter if the the spreadsheet name is a duplicate of the original.

 

Have more questions? Submit a request

Comments

  • Avatar
    Romel Palacpac

    Hello, Dusan.

    I read the article above because I am having the same problem. However, I didn't encounter any of the possible reasons that you have mentioned. In my test device, I performed a form submission three (3) times  and only one (1) record came through -- both in the email and Google Spreadsheets connections. However, in the event log of the device,  the three form submissions were there. How is it that two of the records didn't come through? I didn't receive any error message and the Google spreadsheet is almost empty; save for that one record that successfully made it. 

     

    Thanks in advance,

    Romel

     

     

  • Avatar
    dusanb

    Romel - so you can definitely confirm that all three left the device? I think you will need to open a support ticket with us because I will need to know the particular form name to check our logs. Can you open a ticket by e-mailing support@devicemagic.com with the details of the device and form?

    Thanks,

    Dusan

  • Avatar
    Romel Palacpac

    Hello again. I have sent an email just as you have instructed.

    Thank you,

    Romel

  • Avatar
    Amy Brown

    I would be interested in finding out the answer to this question. My problem is that there is a severe delay when there didn't used to be. I am wondering if it might be a matter of my location or time of submission. I work all over a busy city and my submissions usually are immediate but lately some of them are taking almost 24 hours! I use this to turn in my documentation each day and it's really important that I am able to get it in at least by the end of the business day. (i tend to forget details...so, I love this product!)

  • Avatar
    dusanb

    Hi Amy, sorry that you're experiencing a delay. Yesterday we did have a backlog of form deliveries that took us several hours to get back to normal. We have made our architecture more flexible so we can meet the fluctuating demand. If it happens again or you continue to have delays, please mail us on support?

  • Avatar
    Visual Vendor

    We started to use DeviceMagic for a Proof of Concept. Data was populating within seconds of form submission during testing, and I just assumed this to always be the case. During a presentation of your product to our sales team yesterday, the data never showed up until this morning. My question is this, what is the SLA for Enterprise customers to receive form data. Are different backends handled differently for form submissions? This will be crucial in product evaluation as we determine how quickly we can process the data to resell our services. Thank you.

  • Avatar
    dusanb

    Visual Vendor -

    Sorry about this! Typically we deliver data within 5-25 seconds. It sounds like something went wrong for it to take multiple hours - could you open a support ticket so we can take a look and be sure to mention your organization key and form name?

    We can also discuss some SLA options which aren't available and published on devicemagic.com.

  • Avatar
    private

    Referring to the Google Sheet version update when changing the Form:

    We deliver data to a new sheet when your form schema is changed, typically by editing the form in our designer.

    I have an automation problem with this in that when I expand for example the choices of One Question in a form, it already creates a new version.

    I can understand one creates a new version TAB in Sheets when the number of fields / entries are changed, but it is in my view not a good idea to be honest that adding options with One specific field of the questionaire that we get a new version.

    Example can be: a technician reports repair on a device from the dropdown menu, over time another device is added... then a new TAB is Sheets is created and we have to changed the script in Sheets.... do you understand this is an issue? Do you have a solution or workaround please?

    Many thanks, your product is professional and reliable, providing good control.

    Kris.

     

  • Avatar
    private

    Hello, Could it be that my question related to the version control got lost?

     

    Kindly review my ask: Can we avoid GoogleSheet version updates when minor changes (expanding the choices from a box) have been made to a Form?

     

    Thanks, Kris.

  • Avatar
    mikew

    Kris,

    My apologies for not getting back to you.

    I think the best way to work around this issue is to use our resources feature for the options in your select lists. (You can upload an Excel spreadsheet with the options, and in the forms designer pick the resource and column you'd like to use, rather than the static options list within the form.)

    You can update the resource spreadsheet at any time, the devices will sync it, adopt the new options, and there won't be a form version change so you'll keep the same sheet.

    If you need any help getting it set up, please reach out to support at devicemagic dot com and we'll get you up and running.

    Mike

Powered by Zendesk