But NOW, I want to take a file upload (response) and save the file uploaded to Google Drive. Any ideas? has anyone done such a thing? Can it be done?
Best answer by mklubeck
View originalBest answer by mklubeck
View originalConnecting with Google Sheets and Google Driverondev Could you please explain how to store the uploaded file URL in a Google Sheets column? Thank you!
Any help would be greatly appreciated!! We get a failed action status with the following output:
{
"needRetry": false,
"name": "TaskHandlerError",
"message": "Exceeded max limit of redirects"
}
Any suggestions?
Not sure if this is causing your issue belahm but I did find an improvement (revision) to the process. DO NOT open the script editor in the Google Sheet.
Steps 8, 9, and 10 above. INSTEAD do this:
Eight: NOW go back to DRIVE, (recommend in the same folder as your Google Sheet), and use NEW, --> more... --> Google Apps Script. If you don't see this option, you may need to "enable" Google App Scripts so it's an option for you to create.
Nine: Select Google Apps Script
Ten: Copy and Paste the text into the editor window
All of the other instructions stay the same (from 11 on)... This is BETTER because it removes the needs to do some serious sharing / permission changes to the Google Sheet. BTW, it will work even if you move the app script to a different folder (or even user's drive) as it links to the URL that doesn't change.
https://www.qualtrics.com/community/discussion/comment/26021#Comment_26021I'm also having this problem, and doing what @mklubeck suggested above didn't seem to help. Has anyone else been able to resolve this problem?
hi spurl ,
Did you ensure that the settings are to "public" on the sheet? It can't be to your organization since Qualtrics isn't part of the organization. I have a user with the same error I plan to work with directly so I'll let you know what I find out.
I'm continuing to get the same error as above. I have done the suggestions, but no luck. Any solutions to this? Thanks in advance.
I followed the directions above and it works splendidly. However, it appears that every instance of the invocation generates a 'failed' error in the Actions / Reporting tab (even though it does successfully append the record to the Google Sheet). When I view the error, it says:
Task Output
{
"name": "ACTIONS.ERROR_CODES.USER_CONFIGURATION_ERROR",
"message": "Exceeded max limit of redirects",
"needRetry": false
}
Seems a little different than the error mentioned above.
Thx!
JRoyal not surprised...it seems to be a Google error that we can ignore. BTW, I have found that IF you have a LOT of these going out and you have simultaneous responses the Google Sheet may not get all of them. So I include a disclaimer that the data captured in the Google Sheet is accurate but "may not be complete." For a complete listing of responses, use a report. You can build one that mirrors what you are getting in Google Sheets, it can be "live" (like Sheets) by making it a public report and sharing the link. This is fully reliable (it won't matter if there are simultaneous submissions).
mklubeck Thanks for clarifying - Will keep an eye out when next survey launches and responses are coming in fast and furious. Sadly, I find Qualtrics reports generally lacking. I have a live Google Data Studio dashboard linked up to my live GSheet (fed by Qualtrics) which meets my clients' needs perfectly. I wonder if something could be added to the script to handle the simultaneous access problem. Perhaps I'll look into that if I come across some time Cheers!
JRoyal Let me know if you find a solution for the simultaneous submissions! It would be very helpful.
mklubeck this is a fabulous resource. Thank you for sharing with the community! I'm excited to implement this for some automated certificate generation.
Did anyone ever figure out a work-around for this error? I can't seem to get past this point:
"name": "ACTIONS.ERROR_CODES.USER_CONFIGURATION_ERROR",
"message": "Exceeded max limit of redirects",
"needRetry": false
https://www.qualtrics.com/community/discussion/comment/31337#Comment_31337make sure your google sheets headers match that of the variables your are sending
I did always get the same error message until a week ago - now I have:
"name": "ACTIONS.ERROR_CODES.USER_CONFIGURATION_ERROR",
"message": "Exceeded max limit of redirects",
"needRetry": null
and it seems as needRerty is now null, qualtrics keep calling the script... so the data is now published 4 times...
Hi!
I just answered the same question here
https://www.qualtrics.com/community/discussion/13328/google-sheets-integration-currently-getting-x4-entries-per-qualtrics-response
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.