Workflow google sheets | XM Community
Solved

Workflow google sheets

  • 26 June 2023
  • 2 replies
  • 68 views

Userlevel 1
Badge +1

I need to export the responses (my project is live and already has registered responses) from my surveys to a Sheets table, however the workflow only allows me to export the new responses that are created after the workflow is configured. How can I configure an export automation of all my answers (previously registered) without the need to create an sftp ?

icon

Best answer by cbhavsar 26 June 2023, 17:34

View original

2 replies

Userlevel 4
Badge +26

Not sure about the total number of records collected so far, but one option is opening the retake links for the surveys submitted prior to when the update was made and resubmit. It should trigger the workflows for those respective records.

Userlevel 6
Badge +28

Change your workflow to execute when data is updated via API:

 

And run the update ED API and you will see all your data is written into excel.

This way you need not to individually run the survey link to write data to excel.

Leave a Reply