There are tools out there that abstract away the need for specific coding knowledge in order to develop a script. My team uses a proprietary tool called TMX by Critical Logic, but I've also used Cucumber in the past for this sort of thing. The basic idea is to have one person able to develop and automate scrips while another handles writing the required framework methods to support the test.
With Cucumber, the most the automater would have to write is plain English sentences like "When I press submit, then I should be on the Record Submitted page and I should see my new record in the table". Meanwhile, another team member handles writing the code that determines what it means to see a record in the table. That way everyone does what they do best.
Using TMX, the coders would define specific actions or procedures, each with a block of code attached. The automater then uses the GUI to define the sequence of actions a test will perform and presses "Generate", which produces a script file all ready to be executed. We use it to produce Java code, with each action being generally one method call against our framework library.
I'm sure there are more tools out there, but I don't have personal experience with any others.