Web Form Update Multiple Sheets
I need help figuring out how to have a web form update multiple sheets based upon location information. Basically I have put together a web form that will do a site survey of hotel rooms for renovation. We are surveying several sites at a time and instead of creating 20 different web forms that update 20 different sheets, I was wondering if there was a way to have that one web form update various sheets depending upon what hotel location is selected in the form?
I have seen other community posts mention that this is possible through third party apps like Zapier, but I am not really sure how to get that started.
Any help would be appreciated.