So, I had a coworker help me set up a Google Sheet App Script (really easy) per the information I found and have responses going into the Google Sheet (using Actions). One thing I can't find how to do is pulll in the Recorded Date (or End Date or Start Date) - but I have just been using "today's date" from the response...as that is essentially the same. 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?

If you'd like to see it with the images, try following this link https://nd.service-now.com/kb_view.do?sysparm_article=KB0018743

AnswerWe'll use a Google Script (this feature is part of the suite) and Qualtrics Actions. See attached video for a walkthroughMy internal knowledge base article has pictures that go with it...that unfortunately did not come through here. 1. Create the Google Sheet.2. Name the Google Sheet3. Name the specific tab (sheet) for your data ("results" is often a good choice).4. Grab the Google Sheet URL5. In the browser window, you'll see the Sheet ID.6. Copy the code after ".../d/" and before "/edit..."7. Copy this code to a Google Doc or another text editor.8. Open the Script Editor in Google Sheets9. On the Google Seet, top line menu select Tools10. Under Tools, select <> Script Editor11. Copy and Paste the following text into the editor window: function doPost(e){ try { var ss = SpreadsheetApp.openById("YOUR GOOGLE SHEET URL HERE"); var sheet = ss.getSheetByName("results"); Logger.log(e); var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0]; var holderArray = []; for (var x = 0; x < headers.length; x++) { var tempValue = !e.parameter[headers[x]] ? ' ' : e.parameter[headers[x]]; holderArray.push(tempValue); } sheet.appendRow(holderArray); var results = { "data": e.parameter , "holder": holderArray } var jsonData = JSON.stringify(results) return ContentService.createTextOutput(jsonData).setMimeType(ContentService.MimeType.JSON) } catch (e) { var error = { "error": e } var jsonError = JSON.stringify(error) return ContentService.createTextOutput(jsonError).setMimeType(ContentService.MimeType.JSON) }}function doGet(e){ try { var ss = SpreadsheetApp.openById("YOUR GOOGLE SHEET URL HERE"); var sheet = ss.getSheetByName("results"); Logger.log(e); var data = sheet.getRange(2, 1, sheet.getLastRow() - 1, sheet.getLastColumn()).getValues(); var jsonData = JSON.stringify(data) return ContentService.createTextOutput(jsonData).setMimeType(ContentService.MimeType.JSON) } catch (e) { var error = { "error": e } var jsonError = JSON.stringify(error) return ContentService.createTextOutput(jsonError).setMimeType(ContentService.MimeType.JSON) }} 12. Rename the Script to something recognizable13. Change the text in the above script "YOUR GOOGLE SHEET URL HERE" to be your Sheet ID (you copied it into a text editor). Leave the quotation marks in.14. Ensure you CHANGE Line 4, "results" to whatever name you gave to the tab (sheet). If you used "results" then you won't have to change the code.15. You need to make these changes in two locations in the code above16. Save the Script17. Click Pubish, choose Deploy as web app...18. In the dialog box;19. Give the Version a title,20. Set it to execute as "Me" - your name, 21. Allow "Anyone, even anonymous" to access the app,22. Click on Deploy23. Click on "Review Permissions"24. Choose your account 25. Click on Allow26. Copy the "Current web app URL:" into your text editor27. We're going to put this value into Qualtrics (under Actions) 28. Open your project in Qualtrics29. Go to Actions30. Add Action31. Name the Action32. Click on Event33. Choose "Survey Response"34. You CAN add a condition so that the push to Google Sheet only happens if a condition is met. Or you can move all responses.35. Click on Add Task 36. Choose Web Services37. Paste in the URL you copied last38. Under Request - Choose POST39. Under Content - Choose URL Encoded40. NOT using "Headers" - but are using Specify Data fields41. on the left side, put in the exact headers in your google sheet (capitalization matters)42. on the right side, grab via the drop down the information you want in your google sheet43. Click Save44. Publish your surveyYou are now ready to test your form! Preview or Distribute the survey and try it out.Note: the order of the headers (fields) does not have to match the order passed in...whatever order you put them in, in the google sheet will be how it’s saved.Not sure how I would use the Specify Headers portion (perhaps to define the headers in google sheets? Not sure - if you find out, let me know).NOTE: my users always want the Date/Time that the form was completed - and I can't seem to pull in any via the embedded data (piped text) - RecordedDate, EndDate, StartDate, none of these seem to work. So we end up using Current Date and Time (since they will essentially be the same thing). BUT, if anyone knows how to get the RecordedDate I'd love to know.

Connecting with Google Sheets and Google Drive

Connecting with Google Sheets and Google Drive | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded