We working in the wedding industry. We have several ways of having client data sent to us - either via Typeform or direct connection with a Zap through Honeybook.
When a new Typeform entry comes through, it’s dropped into a Google sheet which triggers some other automations. We have four mirrored Typeforms for different groups of clients.
Because of these multiple Typeforms, each of the four forms has it’s own sheet in the same workbook since Typeform won’t send a response from a different form to a specific Google Sheet.
With the Honeybook integration, each client has their own Google Sheet for the same reason.
Because of the way this all works, I’m having a really difficult time aggregating all of the same answers in one place. At present there are 4 Typeform Google Sheets and 35 individual Google Sheets for each client.
Does anyone have a suggestion on how to make all of the sheets aggregate in one place so all of the data is together and I don’t have to manually copy and paste from sub-sheet to master sheet for each new Typeform or Honeybook entry?
Best answer by jesseView original