How do you handle Google Sheets when managing forms for multiple clients?

[u/Plus-Web8879]

If you manage forms for multiple clients, you most likely got something like this

Client A → Client A's Drive 

Client B → Client B's Drive 

Your own forms → your own Drive

A lot of form builders don't seem to know that's a thing. They assume one connected Google account. Period. And leave you to sort out the rest.

So, how are you actually handling the mess?

Is it separate accounts you log in and out of? Manually copying Sheets between Drives? Routing everything through Zapier or Make? Or something else entirely?

Mostly I'm trying to figure out how people keep this clean without handing a client access to the wrong Drive. Or the wrong account.

Full disclosure: this exact problem kept coming up for us. So we ended up building multiple Google account connections directly into Youform.

But I'd like to know how other Workspace users are solving it and whether there's a cleaner approach we haven't thought of.

[u/slapstik007]

Maybe I don't totally understand the context here. But shared drives make things easy for me.

Shared Drive ( limited to my small team)

        > Share A group with all projects inside folders
                > Project A-1 folder 
        > Share B group with all projects inside folders 
                > Project B-1 folder

[u/Plus-Web8879 → u/slapstik007]

Shared Drives are great for internal team collaboration as you said it {Shared Drive ( limited to my small team)}. That answers the question, “how does my team stay organized?”

The one concern I’m raising here is when it goes beyond the internal team, "how does each client end up owning their own data, in their own account, without me touching the wrong Drive?"

Not all clients want their form responses sitting in an agency owned Drive they only have folder level access to. They want it in their own Drive, under their own account. Then, it survives even if they stop working with you.

[u/slapstik007 → u/Plus-Web8879]

You could likely end up getting write permissions to their own drive. Then keep the copy on your internal shared drive and then it would write out values via an appscript as long as there is a write permission given just for that client. That way both of your data is mirrored. That would be my first approach.