I need to get some data from a partner every month. I have set up an update request to be automatically sent for that time frame, but I'm wondering ...does it add another row every time they respond to the update request? Or, when they respond to the automated request, does it overrun what was they had previously submitted and only keeps the most recent update?
I want to have a year's worth of monthly data readings at the end of this, so I want the data from each month's update request to be stored in my sheet. Can I do this by just having the one update request that automatically repeats monthly? Or do I have to do separate update requests for each month?