Workflow google sheets | XM Community
Skip to main content
Solved

Workflow google sheets


sofiadavila02
Level 1 ●
Forum|alt.badge.img+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 ?

Best answer by cbhavsar

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.

View original

2 replies

cbhavsar
QPN Level 4 ●●●●
Forum|alt.badge.img+26
  • QPN Level 4 ●●●●
  • 78 replies
  • Answer
  • June 26, 2023

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.


Appzk
QPN Level 5 ●●●●●
Forum|alt.badge.img+34
  • QPN Level 5 ●●●●●
  • 277 replies
  • June 27, 2023

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