Automating new data to single sheet to feedback existing model
I recently used the following video to guide in the construction of the same. High-level below is the workflow.
Google Form –> Google Sheet –> Google Mail Merge –> PDF & note sent
The issue is the Google Form was built and tested twice in order to populate a couple rows of data in the Google Sheet after which the model was built to generate the desired automated output. It all works with old data.
When the link is sent to others for additional testing, the new data does not land in the aforementioned sheet containing the model. The form is linked to the desired Google Sheet, however, it arrives via separate tab by default.
Goal: would like to have new data arrive to the desired tab (where the model is built) in order to continue the data chain built (the subsequent automated Mail Merge and PDF).
Seems like a simple fix, any ideas? Thanks!