Combine Form Submissions with Daily Scheduled Processing

Questions
1

Hi all,

I’m working on a use case where I need to handle form submissions and then process them once a day at 08:30 AM. Specifically:

  • I want to collect data from multiple form submissions .
  • Then, every day at 08:30, I want to process all the submissions collected since the last run.

I was wondering what is the best way to do that and would appreciate your help.

Thank you!

2

Hi there, i think you can use 2 workflows here

1 workflow start with the n8n form submission, and for every submission, keep the data in a google sheet or something similar

the other workflow uses the schedule trigger and to check the submission that happens on that certain time and process it, and after its done processing you need to have like a status field that you can change into like “Done” so it will not be executed again

this google sheet will have the field of the field that you have in your form + the created at/submitted at field for keeping track on when its submitted + the status field “Added” or “Done” to keep track of wether its done processing by the 2nd workflow or no

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.