Enable sheet automations to include option to request weekly updates via a form
I want to use a form to capture weekly status updates from multiple users where each weekly update is entered into the sheet as a new row. I can create the form but there is only an option to send it out to user as a one time email. I'd like to set up that email with an embedded form link to send out to users at a specified time weekly. The sheet automations only work in this manner to have a person overwrite an existing row of data, not to add a new row. There should be a sheet automation approach that enables me to use the form to pull in these updates.
